Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0.10
-
None
-
None
Description
Hi,
While testing the EIST feature, I tried to analyze a 24GB table with use_stat_tables='preferably'. It ended up with a full tmpdir without any warnings from MariaDB. (and a stuck ANALYZE TABLE command).
I would have expected MariaDB to respect the tmp_table_size value while trying to compute the statistics ?
Thanks and regards,
Jocelyn Fournier
Attachments
Issue Links
- relates to
-
MDEV-6529 optimize VARCHAR temp storage during EITS ANALYZE
-
- Stalled
-
-
MDEV-21580 Allow packed sort keys in sort buffer
-
- Closed
-
-
MDEV-21829 Use packed sort keys in Unique objects
-
- Stalled
-
So, with MyISAM I got similar results. The machine is not benchmark-tuned, so not only is it slow, but results can deviate a lot, on different reasons. But the trend still holds:
Same 64 errors in each case on the small tmpdir.