Jet Profiler for MySQL
Jet Profiler for MySQL is real-time query performance and diagnostics tool for PC, Mac and Linux. It provides top lists of:
- the most frequent queries
- most used tables and schemas
- busiest users
- slowest queries
- most lock-prone queries
Such top lists help you identify bottlenecks and fix the worst performing parts of your application. They eliminate a lot of guess-work that might otherwise be necessary in order to find the particular queries or tables that are causing the bottleneck.
[edit] How it works
Jet Profiler is a desktop app which connects to a running MySQL server as a normal client. It regularly checks MySQL's internal process list using SHOW PROCESSLIST to gather information about which users are running which queries. The data is analysed and presented in graphs, charts and tables for easy browsing.
[edit] Current status (Feb 2009)
Jet Profiler is available in two versions, a free version and a professional version. The professional version has more features and costs $99/year.
Jet Profiler for MySQL (website)