2012-11-02 19:30:01 |
Perrin Harkins |
description |
I've been using this from cron to send a daily report of slow queries:
pt-query-digest --processlist h=dbhost,u=root,p=mypassword --run-time 24h --limit=10 | mutt -s "Daily Top 10 Queries" perrin@elem.com
This works great except that it sends hundreds of queries, not just 10. If I use a lower --run-time, like 24m, everything works as expected.
My tool version is 2.1.5, MySQL version 5.0.91-community-log. |
I've been using this from cron to send a daily report of slow queries:
pt-query-digest --processlist h=dbhost,u=root,p=mypassword --run-time 24h --limit=10 | mutt -s "Daily Top 10 Queries" perrin@example.com
This works great except that it sends hundreds of queries, not just 10. If I use a lower --run-time, like 24m, everything works as expected.
My tool version is 2.1.5, MySQL version 5.0.91-community-log. |
|