Author Topic: Mysql's slow queries log  (Read 2622 times)

coolname

  • Full Member
  • ***
  • Posts: 163
  • Karma: 0
    • View Profile
Mysql's slow queries log
« 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

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: Mysql's slow queries log
« Reply #1 on: June 28, 2010, 10:31:15 »
Is that the EXACT query? :-)

coolname

  • Full Member
  • ***
  • Posts: 163
  • Karma: 0
    • View Profile
Re: Mysql's slow queries log
« Reply #2 on: July 10, 2010, 09:56:25 »
i don't know what you mean?

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: Mysql's slow queries log
« Reply #3 on: July 12, 2010, 10:41:06 »
Is that a copy-and-paste of an actual query or did you modify it?

coolname

  • Full Member
  • ***
  • Posts: 163
  • Karma: 0
    • View Profile
Re: Mysql's slow queries log
« Reply #4 on: July 13, 2010, 03:55:44 »
I do a count sql query

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: Mysql's slow queries log
« Reply #5 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'