Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1

    Unanswered: Slow query logging performance impact.

    MySQL 5.x

    Currently running slow query logging to catch anything taking longer than 10 seconds. Not much is showing up, but we are still seeing performance issues and are concerned that our problems may be caused by a flood of relatively fast queries.
    If we drop this threshold down from 10 seconds to 5, could this itself impact performance? What if we dropped it down to 1, or zero?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  2. #2
    Join Date
    Aug 2002
    Location
    Germany
    Posts
    17
    Logging will definitly come at some cost.

    But if you are not shure about the number of querys, you could first check the status information where every query is counted.

    You can use "MySql Administrater" which gives you the details in graphs which allow to easily observe usage peaks.


    Andreas

  3. #3
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    I'm sure you've covered these things but are you sure it's not a locking issue? Has anything changed recently? Would it be worth mentioning what storage engine you use and whether you use replication.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •