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. Command to generate a top of most used queries:
pt-query-digest --group-by distill --type genlog general.log > general_group.log