MySQL profiler tools

Contains tips for configurators working with Aware IM
Post Reply
hpl123
Posts: 2382
Joined: Fri Feb 01, 2013 1:13 pm
Location: Scandinavia

MySQL profiler tools

Post by hpl123 »

Hi all,
A couple of MySQL profiler tools:
http://www.profilesql.com/
https://www.jetprofiler.com/
Henrik (V8 Developer Ed. - Windows)
tford
Posts: 4199
Joined: Sat Mar 10, 2007 6:44 pm

Re: MySQL profiler tools

Post by tford »

Would you mind sharing some examples of how you would use these?
Tom - V8.5 build 2830 - MySql
hpl123
Posts: 2382
Joined: Fri Feb 01, 2013 1:13 pm
Location: Scandinavia

Re: MySQL profiler tools

Post by hpl123 »

Well, it´s a learning process thing for me as I don´t really know much about SQL etc. but discussing performance and other things with Jaymer in another post, he spoke about things that affect performance, load etc. of an application and was mainly related to using LIRU and SystemSettings as part of app modules e.g having a lot of attributes and things that are used in temp parameter data, layouts and other things. With a tool like this it is possible to look at what´s happening in the background when the various parts of our apps are "run", for one example see this analysis thread: https://www.awareim.com/forum/viewtopic ... 222#p55222 . This means we would look at how many DB reads Aware does when using SystemSettings, when running a query, when having many rules compared to many subprocesses etc. etc.. We can also use a tool like this to find bottlenecks and instead look at implementing stored procedures for the real load intensive stuff.

The main objective for me is learning more about the internals of Aware to be able to build better, higher performing apps + in the same vein improve/optimize apps and multi server setups.
Henrik (V8 Developer Ed. - Windows)
Post Reply