> The timestamp is when the query was written to the log. You will have to
> subtract the query time to get when the query began. Unless you have
queries
> that are running for long durations the timestamp and actual time should
be
> close.
OK, so, slow query shouldn´t be my problem, because there
captured or
monitored the CPU and memory usage during this time?
-Original Message-
From: Ronan Lucio
To: Victor Pendleton; [EMAIL PROTECTED]
Sent: 4/20/04 3:34 PM
Subject: Re: Process Monitoring
Victor,
> Do you have any around the approximate time?
I know the time that the problem occur
On Tue, Apr 20, 2004 at 01:13:14PM -0700, Eric wrote:
> Hi,
>
> The mysql administrator tool is a lot better for this. They still
> seem to be working out some bugs, but there is a lot of flexibility
> with the graphs. I have been able to see peaks in bandwidth and
> queries that I never noticed
Victor,
> Do you have any around the approximate time?
I know the time that the problem occurred.
In the slow-log, it shows the line "Time".
Is it line the hour the query ran?
> The timestamp will be will the
> query was written to the slow log and how long it took. What are the
> symptoms that
]
Sent: 4/20/04 3:20 PM
Subject: Re: Process Monitoring
Victor,
> Are you logging slow queries? If so, have you looked in the slow query
log?
Yes, I am.
But, it shows many of them and no one at this time.
Or, it doesn´t show slow queries when the problem is occurring.
I restarted the server 1 h
Victor,
> Are you logging slow queries? If so, have you looked in the slow query
log?
Yes, I am.
But, it shows many of them and no one at this time.
Or, it doesn´t show slow queries when the problem is occurring.
I restarted the server 1 hour ago and after I did it, the server seems
to be OK.
I
Hi,
The mysql administrator tool is a lot better for this. They still seem to be working
out some bugs,
but there is a lot of flexibility with the graphs. I have been able to see peaks in
bandwidth and queries that I never noticed before..
Thanks,
Eric
At 12:35 PM 4/20/2004, Peter J Mila
Are you logging slow queries? If so, have you looked in the slow query log?
-Original Message-
From: Ronan Lucio
To: [EMAIL PROTECTED]
Sent: 4/20/04 1:58 PM
Subject: Process Monitoring
Hi,
We have a MySQL-Server-4.0.17 installed in our enterprise
working fine... :-)
Some times our appl
try getting 'mytop'.
Do a google on it... It's like the 'top' utility, but displays information
regarding mysql procs.
P
"Ronan Lucio" <[EMAIL PROTECTED]>
04/20/2004 06:58 PM
To: <[EMAIL PROTECTED]>
cc:
Subject:Process Monitoring
Hi,
We have a MySQL
