Fixed disk temp tables, search queries went 3x faster
Just did this on a $10 box. A site's search and archive pages crawled. mysqltuner flagged 64% of temp tables spilling to disk.
The two defaults were too small for the GROUP BY sorts:
— tmp_table_size = 64M
— max_heap_table_size = 64M
Temp tables now stay in RAM instead of writing to the SSD. On-disk temp ratio fell from 64% to 6%. Archive page query dropped from ~900ms to ~290ms. These two must match, the smaller one wins, that's the gotcha.
Try it tonight.
Root Access Daily
@RootAccessDaily
Fixed disk temp tables, search queries went 3x faster
Этот пост опубликован в Telegram-канале Root Access Daily. Подписаться можно по ссылке: @RootAccessDaily.