Hi all,
A couple of MySQL profiler tools:
http://www.profilesql.com/
https://www.jetprofiler.com/
MySQL profiler tools
MySQL profiler tools
Henrik (V8 Developer Ed. - Windows)
Re: MySQL profiler tools
Would you mind sharing some examples of how you would use these?
Tom - V8.8 build 3137 - MySql / PostGres
Re: MySQL profiler tools
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.
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)