Jet Profiler for MySQL is real-time query performance and diagnostics tool for the MySQLdatabase server.
Core features:
* Query, table and user performance
* Graphical visualisation
* Low overhead
* Easy to use
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, 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.
More Info:
http://www.jetprofiler.com
Download:
http://hotfile.com/dl/19090553/05ca879/Jet.Profiler.for.MySQL.v1.0.7-iNViSiBLE.rar.html
http://hotfile.com/dl/19090650/695257e/Jet.Profiler.for.MySQL.v1.0.7.Linux-iNViSiBLE.rar.html
http://hotfile.com/dl/19090671/630e226/Jet.Profiler.for.MySQL.v1.0.7.MacOSX-iNViSiBLE.rar.html
Post a Comment