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
265
August 07, 2024 04:10PM
Sorry, only registered users may post in this forum.
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.