Hi Joe
All I see is:
| 146027 | a2billinguser | localhost | mya2billing | Query | 9 | Sending data | SELECT t1.starttime, t1.dnid, t1.calledstation, t1.destination
for at least 2 minutes. This was just running a cdr query without specifying any dates.
I have tested this on 8 different installation - all of them do it to some extent - the ones with a larger database take a bit longer but in general it just crawls. On the one with the largest database it causes major headaches with mysql crashing sometimes and asterisk not processing anything during the query. I am busy setting up a slave as a replica to avoid interfering with a live box, so agents and customers will log into that one. But should that be necessary?
Cheers
|