Support A2Billing :

provided by Star2Billing S.L.

Support A2Billing :
It is currently Sat Oct 19, 2019 11:53 am
Predictive Dialer


All times are UTC




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: Agent Interface incredibly slow
PostPosted: Sat Sep 12, 2015 5:28 am 
Offline

Joined: Sat Sep 12, 2015 5:24 am
Posts: 2
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?


Top
 Profile  
 
 Post subject: Re: Agent Interface incredibly slow
PostPosted: Sat Sep 12, 2015 9:19 am 
Offline

Joined: Fri Jun 23, 2006 3:56 pm
Posts: 4065
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


Top
 Profile  
 
 Post subject: Re: Agent Interface incredibly slow
PostPosted: Sat Sep 12, 2015 7:29 pm 
Offline

Joined: Sat Sep 12, 2015 5:24 am
Posts: 2
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


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 
Hosted Voice Broadcast


All times are UTC


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group