Getting the slow query data in the database was a breeze with
mk-query-digest, but now does anyone happen to know of scripts out
there that will generate an html page to view the output? This is
probably a better question for the maatkit mailing list but figure
someone here might have a link.
Hi Milan,
I can see many ways of accomplish what you want:
* I'm almost sure mk-query-digest will allow you to do so;
* Either crop the slow query log for the desired timespan (that's a couple of
shell scripting commands) and run mk-query-digest against it;
* Set the query log file to a filename
Nuno, thanks for the tips. I think I will work on getting
mk-query-digest to log to a db table and run it periodically. Sounds
like a very useful thing to have.
--
Milan
On Sun, Aug 2, 2009 at 10:02 AM, nuno.tava...@dri.pt wrote:
Hi Milan,
I can see many ways of accomplish what you want:
*
Thanks for the quick replies guys. I won't be pulling queries our of
Drupal anytime soon. The optimizations I will do are minimal. Sounds
like we might just have to live with mediocre performance for now.
I will definitely looks further at maatkit though. I actually ran it
mk-query-digest on
Hello,
I'm serving a burly Drupal install and at some points throughout the
day the mysql threads go way up and iowait peaks. I'm not sure which
is causing which but during this time the server is unresponsive. I
would like to determine if there is a poorly optimized query causing
this. I'm
[mailto:mand...@gmail.com]
Sent: Friday, July 31, 2009 11:15 AM
To: mysql@lists.mysql.com
Subject: logging slow queries with time
Hello,
I'm serving a burly Drupal install and at some points throughout the
day the mysql threads go way up and iowait peaks. I'm not sure which
is causing which but during
On Fri, Jul 31, 2009 at 8:14 PM, Milan Andric mand...@gmail.com wrote:
Hello,
I'm serving a burly Drupal install and at some points throughout the
day the mysql threads go way up and iowait peaks. I'm not sure which
is causing which but during this time the server is unresponsive. I
would like