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
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 is
of Oracle for MySQL.
Regards,
Gu Lei
- Original Message -
From: Daniel da Veiga [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, August 08, 2006 12:43 AM
Subject: Re: MySQL SQL statistics
On 8/7/06, 古雷 [EMAIL PROTECTED] wrote:
Hello everyone:
I want to get some SQL statistics
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