asterisk2billing.org
http://forum.asterisk2billing.org/

Agent Interface incredibly slow
http://forum.asterisk2billing.org/viewtopic.php?f=33&t=11836		 Page 1 of 1
Author:  mlungu69 [ Sat Sep 12, 2015 5:28 am ]
Post subject:  Agent Interface incredibly slow
Hi All

I have been using a2billing for a good few years without any major issues. We haven't really used agents before which is why I didn't pick this up sooner I guess, but the the agent interface is unworkably slow. Running a CDR report can easily take 3 minutes, whereas it is virtually instant on the admin interface. MYSQL shoots up to well over 100% cpu at that time and has caused a few crashes so we switched it off for the moment.

This is across various installs with various versions of both a2billing and asterisk so it seems to be a general issue. Any ideas about this?
Author:  jroper [ Sat Sep 12, 2015 9:19 am ]
Post subject:  Re: Agent Interface incredibly slow
Hi

You need to understand where the issue is occurring.

In MySQL CLI, do SHOW PROCESSLIST; and see if tables are locked while doing the query.


Joe
Author:  mlungu69 [ Sat Sep 12, 2015 7:29 pm ]
Post subject:  Re: Agent Interface incredibly slow
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
Page 1 of 1 All times are UTC
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/