[MDEV-32955] increase size of tmp directory when execute delete query Created: 2023-12-06  Updated: 2023-12-12  Resolved: 2023-12-12

Status: Closed
Project: MariaDB Server
Component/s: Admin statements
Fix Version/s: N/A

Type: Task Priority: Major
Reporter: Youn Hyun Assignee: Unassigned
Resolution: Not a Bug Votes: 0
Labels: None


 Description   

Query to delete data from a table of about 15 GB.
SQL> delete from test_log_hist where SEQ < 8302000;

/tmp size increased to 21% when performing delete query.
/dev/sda7 20961280 4367932 16593348 21% /MARIA_TMP

I wonder why you use/tmp area
Please tell me how to process the delete query

 Comments   
Comment by Sergei Golubchik [ 2023-12-12 ]

Sorry, but this is neither a bug nor a feature request. If you need help with MariaDB,
please use Zulip or mailing lists. You will get a faster a better answer if you'll include the output of EXPLAIN <your statement> into your question.

Generated at Thu Feb 08 10:35:17 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.