[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:
huge temporary files may be created in tmpdir that is used for other temporary objects as well:
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. |