GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Need HELP setting up Cluster !!!!

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • #16
    The long query time means the server will log queries that take over that amount of time, i.e. queries that take over 10 seconds to run by default. Not sure if that's what you meant, but it is slightly different than what you said so wanted to clarify. =)

    You do not really need to monitor the slow query log itself; just use pt-query-digest to process it after you have the sample you want (i.e. 24 hours worth of slow queries). Then just start at the top of the list that pt-query-digest gives you and see if you can optimize the queries by adding indexes or re-writing the queries when possible.

    Comment


    • #17
      Thank you once again Scott, for assisting me and i shall revert back with the any further queries if any, and also with the output of the slow logs for suggestions

      Thank you so much

      Comment

      Working...
      X