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?