Profiler for MySQL tool
Profiler for MySQL is a real-time query performance and diagnostics tool for the MySQL database server.It's core features:
- Query, table and user performance
- Graphical visualisation
- Low overhead
- User friendly
Query, table and user performance
Graphical visualisation
Low overhead
Most of the profiling work is done in the Jet Profiler application, not in the database server. Therefore, the performance hit is normally negligible, around 1%.
User friendly
It supports all MySQL versions. No database server changes are necessary. No agents or separate services are needed. Jet Profiler is a desktop application which runs on your computer. You start it, connect to a server, hit the record button and you can review the results in minutes. Jet Profiler runs on Windows, Mac and Linux.
Jet Profiler is a great tool to pinpoint performance problems in MySQL databases. It shows the heaviest queries and helps you optimize performance.
Screenshots
Top Queries
The screenshot shows a sequence of 8 minutes of test load, with peaks every 90 seconds. The upper line chart diagram shows Threads, number of total connected threads in light blue and number of running threads (executing queries) in dark blue. The red area indicates how many slow queries are running. The Top Queries table shows which queries are most frequently observed along with a rating based on EXPLAIN. This view is the most important tool to find the worst performing queries.
Top Users
This screenshot shows a comparison of the different users. Both the line chart and pie chart diagrams indicate that the heavybid user is the most frequent user. If running in a multi-user environment, this can be a quick way to determine if a particular user is overrepresented.
Top Tables
This view, Top Tables, shows what tables are used most frequently. The tableheavybidder.user from our test application causes about 40% of the load. Sometimes, this can be the best way to determine which parts of the database are worst performing - tables lacking proper indices.
Query ratings
The Explain Dialog shows a visualization of the query execution plan. A query rating shows if the query is well written and uses indices correctly. You can edit the query and rerun the EXPLAIN command to see if you can improve it.
