Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
Home » Performance » MySQL » query condition didn't get logged in slow query log
query condition didn't get logged in slow query log [message #1525] Mon, 09 July 2007 06:01 Go to previous message
julian is currently offline julian
Messages: 13
Registered: March 2007
Junior Member
Hi


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?
Report message to a moderator
[Message index]

Read Message
Read Message
Previous Topic:Import Issue from 4.1 to 5.0
Next Topic:Slow page load - seeking to hire server assistance asap
Goto Forum:

  

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [ ]

Current Time: Mon Jul 6 21:28:05 EDT 2009

Total time taken to generate the page: 0.01428 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 2.7.7.
Copyright ©2001-2007 FUD Forum Bulletin Board Software

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.