How to analyze SQL queries on a MySQL server with Percona Toolkit
June 11, 2014
1 min read
If you need to see what queries are performed by a MySQL database you can use New Relic service or use MySQL tools like Percona Toolkit. For general queries they’ll make a top of most used queries.
1. First step is to activate general queries log with mysql command:
SET GLOBAL general_log = ‘ON;
Attention: enable general queries log only for a couple of minutes, this can affect performance on a production server.
2. Process log with pt-query-digest from Percona Toolkit[1]. Command to generate a top of most used queries:
pt-query-digest --group-by distill --type genlog general.log > general_group.log
