[MDEV-14254] Add variable to define where to store temporary files created while collecting engine-independent statistics Created: 2017-11-02  Updated: 2018-09-10

Status: Open
Project: MariaDB Server
Component/s: Optimizer, Variables
Fix Version/s: None

Type: Task Priority: Major
Reporter: Valerii Kravchuk Assignee: Ralf Gebhardt
Resolution: Unresolved Votes: 0
Labels: statistics


 Description   

When engine-independent table statistcis is estimated by ANALYZE like this:

ANALYZE TABLE t FOR COLUMNS (c1, c2, ...) INDEXES(i1,i2, ...);

huge temporary files may be created in tmpdir that is used for other temporary objects as well:

lsof -p 25338 | grep "/mysql_tmp"
...
mysqld 25338 mysql 742u REG 253,7 8819310592 51 /mysql_tmp/MYUxFeMC (deleted)

InnoDB already provide a variable to store its temporary files separately (innodb_tmpdir), but surely it is ignored when engine-independent statistcis is estimated.

I think it makes sense to add new variable, like stats_tmpdir, that let to define separate place for temporary files created during ANALYZE.


Generated at Thu Feb 08 08:12:07 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.