For the first time since the beginning of my long long career, I decided today to use an advice tool to check my MySQL configuration.
I decided to launch pt-variable-advisor and
mysqltuner V2 on one of my MySQL server.
Here are the result outputs :
Then I ask myself what to do with these results, just raw results without much explanations, these tools are supposed to be done for beginners…
Just one example from mysqltuner : Too many
temporary tables are being written to disk. Increase
max_heap_table_size and tmp_table_size
If I set the size of my temporary tables at 16Mb, what that’s means, I have to increase to 32Mb, 64Mb or more ?