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 using for each query, for once, it would be different on each
OS MySQL can run (there are a lot), also, it would take CPU time to
check that ;-). I can't see any advantage of knowing this... Depending
on your OS, you can check the whole MySQL process resources with
specific commands like "top" on *ix or CTRL+ALT+DEL on windows.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
