MySql Query Optimization

05OctOctober 5, 2017

You can turn on the slow query logs in configrations and then see logs by mysqldumpslow command

mysqldumpslow -s c -t 30 /var/log/mysql/mysql-slow.log

You can optimize your queries with explain command

explain extended

&lt;Execute your query here&gt;

MySQL Explain has different row count than slow query log. Try the below command to get more stats.

FLUSH STATUS;

&lt;Execute your query here&gt;

SHOW STATUS like 'Hand%';