6/13/2023 0 Comments Jet profiler for mysql![]() Upgrade to the professional or enterprise version to get all features. Free / Professional / Enterprise Version – The free version doesn’t cost anything and isn’t time limited.Supports all MySQL Versions – Works on 3.x (!), 4.0, 4.1, 5.0, 5.1 and 6.0, Enterprise and Community editions.Low Overhead – Running the tool against your database typically costs around 1%.Multiple instances – Monitor multiple MySQL instances simultaneously.Command line scheduling – Automate repeated recording.SSH Tunneling – Connect to remote databases using SSH tunneling.HTML reports – Generate html reports for later viewing.Save / Load Support – Save profiling data for later use, compare week to week or normal load vs high load situations.50+ metrics are recorded from the server. General Server Metrics – Such as threads connected, network I/O, command statistics, handler statistics and more.Zoomable GUI – You can easily zoom in on spikes in your load and see the corresponding queries for that time interval.Slow Queries – See the slowest queries per time interval.A diagram shows the table lookups involved, the rating and join size. Query Visualization – The query execution plan can be visualized using EXPLAIN.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. ![]() This can be used to minimize replication lag and lock contention on busy tables. ![]()
0 Comments
Leave a Reply. |