QueueMetrics professional call center suite for the Asterisk PBX
Welcome,
Guest
. Please
login
or
register
.
1 Hour
1 Day
1 Week
1 Month
Forever
Login with username, password and session length
News:
Welcome to the new forum!
Home
Help
Search
Login
Register
QueueMetrics forum
»
QueueMetrics
»
Running QueueMetrics
»
Mysql's slow queries log
« previous
next »
Print
Pages: [
1
]
Author
Topic: Mysql's slow queries log (Read 2623 times)
coolname
Full Member
Posts: 163
Karma: 0
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
Logged
QueueMetrics
Loway
Hero Member
Posts: 2999
Karma: 39
Re: Mysql's slow queries log
«
Reply #1 on:
June 28, 2010, 10:31:15 »
Is that the EXACT query? :-)
Logged
coolname
Full Member
Posts: 163
Karma: 0
Re: Mysql's slow queries log
«
Reply #2 on:
July 10, 2010, 09:56:25 »
i don't know what you mean?
Logged
QueueMetrics
Loway
Hero Member
Posts: 2999
Karma: 39
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?
Logged
coolname
Full Member
Posts: 163
Karma: 0
Re: Mysql's slow queries log
«
Reply #4 on:
July 13, 2010, 03:55:44 »
I do a count sql query
Logged
QueueMetrics
Loway
Hero Member
Posts: 2999
Karma: 39
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'
Logged
Print
Pages: [
1
]
« previous
next »
QueueMetrics forum
»
QueueMetrics
»
Running QueueMetrics
»
Mysql's slow queries log