MikeyCarter
Joined: 02 Jan 2006
Posts: 8
Location: Orangeville, ON
|
 Posted: Thu Aug 17, 2006 8:04 am Post subject: MySQL Tuning |
 |
|
In Oracle RDBMS there is a way of pulling the top 10 worst queries (as far as resource usage)
Does anyone know how to get this from mysql... (if it's possible)
Now that I've got a larger volume of data I'm going tuning crazy on my web applications. I've thought of writing a script to poll the processlist command for any queries taking longer than a threshold. This just tells me length of time. Not resource consumption.
Thanks,
Michael |
|
FAQ
Search
Register
Profile
Log in to check your private messages
Log in
