On 8/7/06, 古雷 <[EMAIL PROTECTED]> wrote:
Thanks a lot for your reply.
I need know SQLs that consume most resources(CPU time, disk IO etc.) of
database server.
If its an application, you can use EXPLAIN to find out how MySQL is
processing the most used queries, and use this knowledge to optim
Oracle for MySQL.
Regards,
Gu Lei
- Original Message -
From: "Daniel da Veiga" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, August 08, 2006 12:43 AM
Subject: Re: MySQL SQL statistics
> On 8/7/06, 古雷 <[EMAIL PROTECTED]> wrote:
>> Hello everyone:
>>
>>
On 8/7/06, 古雷 <[EMAIL PROTECTED]> wrote:
Hello everyone:
I want to get some SQL statistics including executions, CPU time for each SQL
Statement.
The number of each type of query can be found using the "show status
like 'Com%';", I don't believe there's a way to know how much CPU time
MySQL i
Hello everyone:
I want to get some SQL statistics including executions, CPU time for each SQL
Statement.
How can I get it from MySQL?
regards,
Gu Lei
