MySQL Tuning

General help with installation, scripts, etc....

MySQL Tuning

Postby MikeyCarter » 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.

Going to or having a Garage Sale?
Try to help you plot your route.

Have a joke or story to share?
Try (The Shadow Writing Centre) to post your work.
Posts: 8
Joined: Mon Jan 02, 2006 8:16 pm
Location: Orangeville, ON

Return to General Help

Who is online

Users browsing this forum: No registered users and 0 guests