Bug #30523 Log create_myisam_from_heap
Submitted: 20 Aug 2007 22:02 Modified: 27 Aug 2007 11:32
Reporter: Franz Hänel Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: Logging Severity:S4 (Feature request)
Version:* OS:Any
Assigned to: CPU Architecture:Any

[20 Aug 2007 22:02] Franz Hänel
If the log_queries_not_using_indexes is set, queries not using indexes are written to the slow-query-log. If there was a similar option to log queries that caused create_myisam_from_heap() to be called, users could find candidates for SQL_BIG_RESULT or a way to find optimal values for max_heap_table_size/tmp_table_size.

How to repeat:
[27 Aug 2007 11:32] Valeriy Kravchuk
Thank you for a reasonable feature request.