MySql Query Optimizationzalam
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 <Execute your query here>
MySQL Explain has different row count than slow query log. Try the below command to get more stats.
FLUSH STATUS; <Execute your query here> SHOW STATUS like 'Hand%';