[MDEV-32616] Temporary file space monitoring Created: 2023-10-29  Updated: 2024-01-24  Resolved: 2024-01-24

Status: Closed
Project: MariaDB Server
Component/s: Admin statements, Server
Fix Version/s: None

Type: New Feature Priority: Major
Reporter: Michael Widenius Assignee: Michael Widenius
Resolution: Duplicate Votes: 1
Labels: None

Issue Links:
Relates
relates to MDEV-9101 Limit size of created disk temporary ... In Testing

 Description   

Add monitoring of temporary disk usage.

This includes:

  • All temporary files created as part of query / analyze processing
  • All internal temporary tables (Aria/MyISAM) created as part of query processing.
  • Space used by REPAIR TABLE (for Aria/MyISAM at least).

It will not include:

  • Space used by CREATE TEMPORARY TABLE.

The used temporary space will be stored 'live' in local and global status.
It will also be shown in information_schema.processlist, performance_schema and in the slow query log.
In the slow query log, we will store the largest temp usage during the logged query execution.



 Comments   
Comment by Michael Widenius [ 2024-01-24 ]

MDEV-9101 Limit size of created disk temporary files and tables
This includes tmp space monitoring

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