Operation Based Query Analysis
Posted 11 April 2012 - 12:27 PM
I am new to the MONyog. I have installed Monyog trail version and trying to analyzing the my php application performance based queries and i need some more help
like query analysis for based on operation(if i running create operation i want which operation and background query in query analysis).
I am not good in english..
Any Help greatly Appreciated ...'
Posted 11 April 2012 - 07:37 PM
Posted 12 April 2012 - 05:52 AM
log on MySQL server and while registering a server you can give Slow/General log file path also there is an option
for Sniffer which supports two methods via PROCESSLIST and PROXY.
Now in QA page you can see Slow queries, Further you can optimize those queries by adding proper INDEX and by optimizing table structure etc...
We recommend to use SQLyog- MySQL GUI which has SQL Profiler feature this will help you in tuning query performance.
Note: Slow log will log queries which runs more than certain period specified in my.cnf/my.ini
whereas General log will log all queries you execute on server.
Posted 12 April 2012 - 11:58 AM
Thank you very much for your prompt reply...
In my application doing operations like (login/ x item create /logout/etc).i want to know report like the following way
avg | max | min | operation | query |
12:345 14.567 10.267 login select username,pass...
Is it possible to get the report like this way? ... it will give better understanding of operation vs background query analysis...
Hope this time i am not confused you...
Sorry if i am going out of scope...
Posted 12 April 2012 - 12:17 PM
MONyog slow log output can give you details like
Total, avg, Max and Avg. rows sent, Avg. rows examined, count etc... (see attached screenshot)
Similarly for sniffer output as well except rows related stuff.
I hope this helps.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users