> 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
Milanese wrote:
>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
>
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
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:
Subj
Hi,
We have a MySQL-Server-4.0.17 installed in our enterprise
working fine... :-)
Some times our application takes too bandwidth from the
database server.
So, I´m trying to figure out what (perhaps what select) is taking
so manu bandwidth.
SHOW FULL PROCESSLIST shows me the follow:
mysql> show
10 matches
Mail list logo
