Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    25

    Unanswered: Log Slow Queries

    How do I log slow queries by using --log-slow-queries?

    Where do i go to change value of long_query_time to 2 sec vs default value of 10 sec

  2. #2
    Join Date
    Oct 2003
    Location
    Denver, Colorado
    Posts
    137

    Re: Log Slow Queries

    Add the following to the [mysqld] section of your my.cnf (or my.ini if you are using Windows):
    Code:
    log-slow-queries
    set-variable = long_query_time=2
    http://www.mysql.com/doc/en/Option_files.html

  3. #3
    Join Date
    Jan 2004
    Posts
    25
    Thankyou, will try

Posting Permissions

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