Delete With JSON Filling /tmp Space
Posted by:
Sam Beard
Date: August 07, 2024 04:10PM
MySQL 8.0.37
statement: DELETE FROM table WHERE datefield<'date';
table has 6 int, date, timestamp, and short (<32) varchar fields and 1 LARGE JSON field. Deleting 2500 records is filling 800M of /tmp space.
Is the select part saving the JSON field? My estimate of the record space is just over the available /tmp space.
If so, why? Is this part of the problem/documentation issue I have seen reported for blobs filling the sort buffers?
Subject
Views
Written By
Posted
Delete With JSON Filling /tmp Space
289
August 07, 2024 04:10PM
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.