Jet Profiler for MySQL v1.0.7 | 34.9 MB
Jet Profiler for MySQL is real-time query performance and diagnostics tool for the MySQLdatabase server.
* Query, table and user performance
* Graphical visualisation
* Low overhead
* Easy to use
* 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, Linux and Mac
* 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.
Homepage - www.jetprofiler.com