tracing queue miner queries, there is one that take a lot of time and in machines with a lot of calls can slow down the task so much that they keep going even the morning after when the customer started working.
The query is
UPDATE report_queue SET cid = (SELECT cid FROM report_queue_callers WHERE report_queue_callers.timestamp_in = report_queue.timestamp_in LIMIT 1) WHERE cid IS NULL AND timestamp_in > $start_ts
And on my test machine takes ~3 hours
Steps to reproduce
launch /opt/nethvoice-report/scripts/queue-miner.php miner manually or with cron
check mysql show full processlist to see wich query is executed
Expected behavior
This query is quite simple and only updates the calls of the current day, shouldn't take too much time
Actual behavior
On my test machine, this query takes more than 3 hours
nethbot
commented
2 years ago
tracing queue miner queries, there is one that take a lot of time and in machines with a lot of calls can slow down the task so much that they keep going even the morning after when the customer started working.
The query is
And on my test machine takes ~3 hours
Steps to reproduce
/opt/nethvoice-report/scripts/queue-miner.phpminer manually or with cronshow full processlistto see wich query is executedExpected behavior
This query is quite simple and only updates the calls of the current day, shouldn't take too much time
Actual behavior
On my test machine, this query takes more than 3 hours