MySQL Tuning
Posted: Thu Aug 17, 2006 9:04 am
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
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