I need to get all queries that are made in last hour on my wordpress database.
Get number of all queries on my mysql database in last hour?
Leave a Reply
You must be logged in to post a comment.
I need to get all queries that are made in last hour on my wordpress database.
You must be logged in to post a comment.
You can enabled general log on mysql
details :
After that, you can parse/digest the log or simply do a
grep(linux).If you not familiar with
grep, you can look for log analyzer for mysql(I sure there is, but doing a
grepis much easier)You can check the update queries (only queries which did a modification to the data) with Binary log or update log (You will need to enable them)
Slow queries are again logged to the slow query logs.
I am not aware if mysql logs read only queries.
Hope this is of some help.