QueueMetrics > Running QueueMetrics

Mysql's slow queries log

(1/2) > >>

coolname:
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:
Is that the EXACT query? :-)

coolname:
i don't know what you mean?

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

coolname:
I do a count sql query

Navigation

[0] Message Index

[#] Next page