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.
Th
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, wrote:
> Hi Milan,
>
> I can see many ways of accomplish what you want:
> * I'm almost sure
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 w
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 my
On Fri, Jul 31, 2009 at 8:14 PM, Milan Andric 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 to determine if th
Entries in the slow log have a timestamp. You can read the file directly, but
it's much easier to use a tool like maatkit for parsing the results of the log.
Try this:
http://www.maatkit.org/doc/mk-query-digest.html
Regards,
Gavin Towey
-Original Message-
From: Milan Andric [mailto:ma