query condition didn't get logged in slow query log


In slow query log query condition didn’t logged. Only query with table name omitting condition get logged. What is the reason. How to log the entire query.

The following query takes 2s to execute and is logged in slow query log. The original query is :

Select count(*) from markingqc where persondate between ‘2007-07-09 00:00:00.000’ and ‘2007-07-09 23:59:59.999’ and PersonName=‘admin’

Logged query is:

SELECT * FROM markingqc;

How to get the condition in the log?

I think you’re mixing something

Queries should be full in slow query log

Plus if queries are exactly as you’ve written them they must be different queries because they are even differently capitalized.