tthmaz Posted June 25, 2006 Share Posted June 25, 2006 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. Quote Link to comment Share on other sites More sharing options...
fenway Posted June 26, 2006 Share Posted June 26, 2006 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.