QueueMetrics forum

QueueMetrics => Running QueueMetrics => Topic started by: coolname on March 14, 2012, 03:16:52

Title: update data may cost a long time
Post by: coolname on March 14, 2012, 03:16:52

today i found qm can't show the report.After debug,i found it was a problem with mysql.A update query take a long time and update statement is ' update queuemetrics.queue_log set data1='12' where call_id='******' and verb='CONNECT' limit 1 '.But this statement usually execute very quick,what may cause it? *** was my call id

Title: Re: update data may cost a long time
Post by: QueueMetrics on March 22, 2012, 11:38:51

Why do you do that? as this query does not run by index, it may take a long time indeed if the table is large.

Title: Re: update data may cost a long time
Post by: coolname on March 24, 2012, 16:07:35

because i found i can't open qm report, so i want to debug it out

Title: Re: update data may cost a long time
Post by: QueueMetrics on March 30, 2012, 18:08:40

Ok but then it is normal that it takes a long time :-)