joins

Events happening in the community are now at Drupal community events on www.drupal.org.
socialnicheguru's picture

Recommendations and Best Practices for making MySQL DB changes per tuning-primer.sh and mysql slow table log.

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)

Read more
Subscribe with RSS Syndicate content