Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
  • How to enable slow query logs

    • 0
    • 1
    • 1
    • 1
    • 0
    • 0
    • 0
    • 0
    • 203
    Comment on it

    For this we need to edit my.cnf file (This should be in /etc directory)

    we need to enter following lines :-

    log-slow-queries=/logs/mysql/slowQueries.log
    
    long_query_time=30
    

    This time is in seconds , so if any query will take more than 30 seconds to execute then the query will get logged in the

    /logs/mysql/slowQueries.log file

 0 Comment(s)

Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: