Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 10.0.10
-
Fix Version/s: 10.0.13
-
Component/s: None
-
Labels: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
Gliffy Diagrams
Attachments
Issue Links
- relates to
-
MDEV-6529 EITS ANALYZE uses disk space inefficiently for VARCHAR columns
-
- Open
-
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
So far I don't see that ANALYZE TABLE with enabled statistics creates temporary tables, according to status, it creates a temporary file:
But it's with relatively tables, I will try a bigger one, maybe it makes the difference.
However, even if it does create a table in tmpdir, how does it mean that it ignored tmp_table_size?
So, on the contrary, it would mean it respects tmp_table_size. Could you please clarify your point?