.
Thanks,
Milan
On Sun, Aug 2, 2009 at 11:16 PM, Milan Andric wrote:
> 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,
ow I was using
> for some time, explained here:
> http://gpshumano.blogs.dri.pt/2009/07/04/analysing-mysql-slow-queries/
>
> In the last two options you'll be logging to a table, so it will be easy to
> select a timed range of queries for consideration.
>
> Hope that helps,
&g
09 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
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 log
On Tue, Apr 21, 2009 at 2:52 PM, Milan Andric wrote:
> Hello,
>
> I have a rather burly Drupal based site that seems to be causing some
> problems, today we had a major outage. There are many slow queries
> and also mysql related iowait that causes server processes to hang, at
Hello,
I have a rather burly Drupal based site that seems to be causing some
problems, today we had a major outage. There are many slow queries
and also mysql related iowait that causes server processes to hang, at
least that is the theory.
Here you can examine some of the stats on the server:
h