MySQL Performance: MySQL => query condition didn't get logged in slow query log

Members

Help

Home

Home » Performance » MySQL » query condition didn't get logged in slow query log

Show: Today's Messages :: Show Polls :: Message Navigator

query condition didn't get logged in slow query log [message #1525]

Mon, 09 July 2007 06:01

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

Re: query condition didn't get logged in slow query log [message #1620 is a reply to message #1525 ]

Thu, 16 August 2007 11:14

Peter
Messages: 405
Registered: August 2006

Senior Member
Super Guru

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.

Peter Zaitsev, MySQL Performance Expert
MySQL Performance Blog - http://www.mysqlperformanceblog.com
MySQL Consulting http://www.mysqlperformanceblog.com/mysql-consulting/

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

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

]

Current Time: Mon Jul 6 19:51:09 EDT 2009

Total time taken to generate the page: 0.02402 seconds

.:: Contact :: Home ::.

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.