Jump to content


Photo

Operation Based Query Analysis


  • Please log in to reply
5 replies to this topic

#1 blrboy

blrboy

    Newbie

  • Members
  • Pip
  • 3 posts

Posted 11 April 2012 - 12:27 PM

Hi Monyog Team & users


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 ...'


Thanks,
Blr Boy

#2 peterlaursen

peterlaursen

    Advanced Member

  • Admin
  • PipPipPip
  • 7,869 posts
  • Gender:Male
  • Location:Skagen, Denmark
  • Interests:well ... jazz/folk music, photography, chess, nature, ecology, history, bicycling, Highland Malts ... well, Lowland Malts and Cognac too actually :-) just wonder how I get the time to touch a computer! SQLyog and MONyog? no that's not interest, that's BASIC NEEDS simply!

Posted 11 April 2012 - 07:37 PM

I am afraid nobody here really understands what information you are asking for. 'query analysis for based on operation' - please elaborate (and don't wory about English skills).
Computers make your grey hair come off ....

Peter Laursen
Webyog

#3 Mahesh

Mahesh

    Advanced Member

  • Admin
  • PipPipPip
  • 492 posts
  • Gender:Male
  • Location:Bangalore,India
  • Interests:MySQL, Cricket, Music..

Posted 12 April 2012 - 05:52 AM

MONyog's Query Analyzer feature can be useful to you only thing you need is to enable SLOW and GENERAL
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.
http://dev.mysql.com...-query-log.html
http://dev.mysql.com.../query-log.html

#4 blrboy

blrboy

    Newbie

  • Members
  • Pip
  • 3 posts

Posted 12 April 2012 - 11:58 AM

Hi All


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...


Thanks,
blr boy..

#5 Mahesh

Mahesh

    Advanced Member

  • Admin
  • PipPipPip
  • 492 posts
  • Gender:Male
  • Location:Bangalore,India
  • Interests:MySQL, Cricket, Music..

Posted 12 April 2012 - 12:17 PM

MONyog can show you detail analysis apart from which operation a user does Like Login, searching etc...

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.

Attached Files



#6 blrboy

blrboy

    Newbie

  • Members
  • Pip
  • 3 posts

Posted 13 April 2012 - 05:07 AM

Thanks mahesh...




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users