VPS MySQL Problem but Where?
We have a VPS with around 40 databases and 1 of th开发者_StackOverflow中文版em is getting very high traffic (selects)... is there any tool that i can install to keep a record or visualize what database is getting the most traffic/hits???
Thanks
MySQL Enterprise Monitor
Advanced Query Analyzer - Provides multiple options for quickly finding worst offenders. Collected queries can be sorted and filtered by server, database, query type, query content. Analysis can be done by current time intervals or by historical date/time range.
MySQL and OS Metric Graphs - Allows DBA to monitor and correlate these metrics: Database Activity (Selects, Inserts, Updates, Deletes)
I believe it has a free trial.
精彩评论