An interesting article we found which has numerous aspects to learn from. You may choose to check it out and find if you agree.
Jet Profiler focuses on queries, tables and users. This gives you the information you need in order to quickly fix performance problems in your code, such as most frequent queries, most used tables or the busiest users.
Data is collected, analyzed and displayed in real-time in diagrams, pie charts and tables. The graphical layout allows you to easily drill down and navigate your way through the vital data.
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%.
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.
What are the system requirements?
Jet Profiler is guaranteed to work on Windows (Windows XP, Windows Vista, Windows 7, Windows 2000, Windows 2003), Mac (Intel 64-bit Mac OS X 10.5+ or Intel 32-bit Mac OS X 10.6) and Linux (Ubuntu 8 or higher). It should generally run on any platform capable of running Java SE 6. You install it as a normal application on your own computer (e.g laptop). System requirements:
1 GB of computer memory or more
200 MB of available hard drive space or more
500+ MHz Pentium processor or better
1024 x 768 pixels screen resolution or better
Internet access recommended (for license registration and software updates)
How much load does Jet Profiler add to the target database?Jet Profiler typically causes very little overhead. We normally see Jet Profiler adding an overhead of about 1% of the total db resources. This can be adjusted by changing hte polling interval in recording settings. You can expect a linear increase / decrease, so if polling once per second costs 1%, and you change to poll 10 times per second, the overhead should be around 10%.
You can monitor how much the profiling costs by clicking the COST button. The cost is estimated by measuring the total roundtrip time for all queries issued during one second, excluding network round-trip time. A mysql ping command is used as baseline for the network round-trip time.
Stop by and read about Jet Profiler
I thought that was interesting. Feel free to leave your comments below.