Jet Profiler for MySQL 1.0 released

Posted February 10th by Bjorn, Jet Profiler team
Top queries 500
This is the first public release. 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 MyISAM lock analysis will help discover any locks associated with replication, as well as lock-prone queries in general.
  • Query Ratings and Visualization - You can get your queries rated using EXPLAIN and see which queries are most likely to cause load due to missing indices etc. The execution plan can be visualized in a diagram, which shows the table lookups involved, the join size and any bad indicators.
  • Zoomable GUI - You can easily zoom in on spikes in your load and see the corresponding queries for that time interval.
  • Low Overhead - Running the tool against MySQL typically costs around 1%. Recording granularity customizable 100ms - 10s.
  • Works on Windows, Linux and Mac


Download the free version, try it and let us know what you think is good and what isn't. It doesn't cost anything and isn't time limited. Read more...

0 comments

Add your own



Post a comment


(required)

(will not be published) (required)





Notify me of followup comments via e-mail



Subscribe without commenting