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. Link to comment https://forums.phpfreaks.com/topic/12857-how-to-measure-mysql-performance/ 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. Link to comment https://forums.phpfreaks.com/topic/12857-how-to-measure-mysql-performance/#findComment-49550 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.