Jump to content

Archived

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

tthmaz

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.