The best conference in Ottawa….in my opinion! Check it out, it is very UNIXy and Linuxy: BSDCan 2016.
I see this: [!!] Temporary tables created on disk: 65% (274 on disk / 416 total)
and this: Variables to adjust:
tmp_table_size (> 16M)
And with some reading at the MySQL handbook, I agree with mysqltuner’s recommendations. Based on the number of tables that were written to disk and the system’s memory usage, we are safe to increase the tmp_table_size to 32MB. Let’s adjust that and check back in a few days! Now my tuning settings become:
# My Tuning
thread_cache_size = 4
query-cache-type = 1
query-cache-size = 16M
tmp-table-size=32M
See you in a few days!