QueueMetrics forum

QueueMetrics => Running QueueMetrics => Topic started by: coolname on June 26, 2010, 07:28:09

Title: Mysql's slow queries log
Post by: coolname on June 26, 2010, 07:28:09

Count: 45  Time=12.29s (553s)  Lock=0.04s (2s)  Rows=1.0 (45), queuemetrics[queuemetrics]@localhost
  SELECT max(time_id) FROM queue_log WHERE partition='S' AND verb != 'S'

and the queue_logs has 3814568 records.

How can i optimization

Title: Re: Mysql's slow queries log
Post by: QueueMetrics on June 28, 2010, 10:31:15

Is that the EXACT query? :-)

Title: Re: Mysql's slow queries log
Post by: coolname on July 10, 2010, 09:56:25

i don't know what you mean?

Title: Re: Mysql's slow queries log
Post by: QueueMetrics on July 12, 2010, 10:41:06

Is that a copy-and-paste of an actual query or did you modify it?

Title: Re: Mysql's slow queries log
Post by: coolname on July 13, 2010, 03:55:44

I do a count sql query

Title: Re: Mysql's slow queries log
Post by: QueueMetrics on July 13, 2010, 14:10:57

The question is that I'm not recognizing the query....

SELECT max(time_id) FROM queue_log WHERE partition='S' AND verb != 'S'