What can be used to track heavy queries in the mysql database?

Question

PHP

Good afternoon!
What (preferably free) tool can track heavy queries in the mysql database. The site takes a long time to load when loading the ad list page. It is necessary to find out on what request time is spent. The site is written in php(yii).
I will be very grateful.

Answer 1

toolbar

Answer 2

In my.cnf you need to add:

[mysqld]
...
slow_query_log = 1
slow_query_log_file = /var/log/mysql/slow.log
long_query_time = 10
log_queries_not_using_indexes = YES
log_slow_admin_statements = YES

• long_query_time - casting time in seconds
  
• log_queries_not_using_indexes - queries on columns without indexes
  
• log_slow_filter - additional filter by types of slow requests (not always and not available everywhere)
  
• log_slow_admin_statements - log administrative requests
  

mysqldumpslow is a utility for convenient viewing of logs, it runs locally in the same place where mysql is installed (parameters in the request are replaced with the 'S' character, if you run it with the -a key, everything will be like in the original request)

Answer 3

slow log
show processlist;

Answer 4

to the heap:
mysqltop
utility for linux like top|atop}apachetop