Jump to content


Photo

How to measure MySQL Performance?


  • Please log in to reply
1 reply to this topic

#1 tthmaz

tthmaz
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 25 June 2006 - 08:06 AM

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.

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 26 June 2006 - 06:44 AM

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.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users