Features
- Top Queries - See which queries are being run the most on your server.
- Top Users - See which users are using your server the most.
- Top Tables - See which database tables are opened the most.
- Top States - See which states your database is most busy doing, such as creating temp tables.
- Replication Profiling - You can measure how much capacity you have left on the replication SQL thread on slaves. If you are using MyISAM a lot, a lock analysis will help discover any locks associated with replication.
- Master and Slave statistics - See how many threads are working on your masters and slaves. Find I/O or SQL bottlenecks.
- MyISAM Lock Analysis - You can view which queries cause the most amount of MyISAM locking. This can be used to minimize replication lag and lock contention on busy tables.
- Query Ratings - You can get your queries rated and see which queries are most likely to cause load due to missing indices, big tables and more.
- Query Visualization - The query execution plan can be visualized using EXPLAIN. A diagram shows the table lookups involved, the rating and join size.
- Slow Queries - See the slowest queries per time interval.
- Zoomable GUI - You can easily zoom in on spikes in your load and see the corresponding queries for that time interval.
- General Server Metrics - Such as threads connected, network I/O, command statistics, handler statistics and more. 50+ metrics are recorded from the server.
- Save / Load Support - Save profiling data for later use, compare week to week or normal load vs high load situations.
- Low Overhead - Running the tool against your database typically costs around 1%. Recording granularity customizable.
- Supports all MySQL Versions - Works on 3.x (!), 4.0, 4.1, 5.0, 5.1 and 6.0, Enterprise and Community editions.
- Works on Windows, Mac and Linux
- No Server Changes
- Simple Setup
- Free / Professional Version - The free version doesn't cost anything and isn't time limited. Upgrade to the professional version to get all features.
Read what our customers say »
