Recommendations and Best Practices for making MySQL DB changes per tuning-primer.sh and mysql slow table log.
Posted by socialnicheguru on March 15, 2011 at 2:18pm
I am running tuning-primer.sh and mysqltuner.pl
mysqltuner.pl says:
General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance
Adjust your join queries to always utilize indexes
When making adjustments, make tmp_table_size/max_heap_table_size equal
Reduce your SELECT DISTINCT queries without LIMIT clauses
Increase table_cache gradually to avoid file descriptor limits
Variables to adjust:
join_buffer_size (> 128.0K, or always use indexes with joins)
tmp_table_size (> 50M)
max_heap_table_size (> 50M)
