Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2006
    Posts
    2

    Unanswered: long_query_time is 5 then after i get slow-query of 0 and 1 seconds

    Hi,
    I have set long_query_time = 5
    although i am getting query in slow-query-logs which take time 0, 1, 2 seconds for execution.
    Can anyone suggest me where is the issue and how can i solve?

    Thanks in advance
    Nilnandan joshi

  2. #2
    Join Date
    Sep 2002
    Location
    Montreal, Canada
    Posts
    224
    Provided Answers: 1

    Slow Query Log

    It logs those "fast" queries because they are not using indexes.

    You can control this.

    Have a look at:

    http://dev.mysql.com/doc/refman/4.1/...query-log.html

Posting Permissions

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