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

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