Jump to content


This topic is now archived and is closed to further replies.


How to measure MySQL Performance?

Recommended Posts

I guess m question is quite general and doesn't target only the MySQL:

How is MySQL performance meausred?
What metrices are used to determine the efficiency of a database structure?
Are there any tools out there that measure database performance?

Thank you.

Share this post

Link to post
Share on other sites
So many possible answers... ultimately, it's a combination of query performance and optimal resource utilization. There are many such metrics too (buffer hits, cache sizes, queries/sec, open tables, locks, etc.), all of which need to be examined as a whole. To be sure, there a few that are dead giveaways, but it's rarely that simple. I ran across a tool call "mysqlreport" a while back which does a pretty good job of giving you a handle on things.

Feel free to ask anything more specific, and maybe I can be more helpful.

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.