Support A2Billing :

provided by Star2Billing S.L.

Support A2Billing :
It is currently Thu Mar 28, 2024 11:28 am
Voice Broadcast System


All times are UTC




Post new topic Reply to topic  [ 6 posts ] 
Author Message
 Post subject: Database slow down
PostPosted: Wed Mar 09, 2011 6:01 pm 
Offline

Joined: Wed Jun 10, 2009 7:46 am
Posts: 16
Im using a2billing from 2010 nov1 constantly got 12-30 paralel calls.
From last month when I ask CDr report its take around 10 min to give the result and this braking the calls.
Before 2 days everything is start to slow down.
I take a look on asterisk cli and I see the a2billing.php process is so slow and sometime its stop simply starts calls but cant get to end and I see on freepbx status the active calls just raise and its equal with active channels.
When I restart the server than for some time its ok but after a time its start again!

Im using server with 4gb memory.

But I nead to save records for more years.

Is there a solution for this?

there is installed version Asterisk2Billing - Version 1.3.0
What can I do?


Top
 Profile  
 
 Post subject: Re: Database slow down
PostPosted: Thu Mar 10, 2011 9:03 am 
Offline

Joined: Fri Jun 23, 2006 3:56 pm
Posts: 4065
Hi

In version 1.4 and above, there were some optimisations to the CDR records and other areas, I would recommend against using anything but the latest version in production.

Upgrade, and see how you get on.

How many CDR and customers do you have.

Joe


Top
 Profile  
 
 Post subject: Re: Database slow down
PostPosted: Thu Mar 10, 2011 9:37 am 
Offline

Joined: Wed Jun 10, 2009 7:46 am
Posts: 16
Its around 20 users and around 20 CC.

I will set up on new server 1.4 and test it.
Can I import 1.3 to 1.4 directly?

Ervin


Top
 Profile  
 
 Post subject: Re: Database slow down
PostPosted: Thu Mar 10, 2011 9:39 am 
Offline

Joined: Fri Jun 23, 2006 3:56 pm
Posts: 4065
Better to use 1.9.3

There is an upgrade path from all versions of A2Billing.

Joe


Top
 Profile  
 
 Post subject: Re: Database slow down
PostPosted: Thu Mar 10, 2011 10:02 am 
Offline

Joined: Wed Jun 10, 2009 7:46 am
Posts: 16
Do you know some doc to update 1.3 to 1.9?

And many thanks for helping me!


Top
 Profile  
 
 Post subject: Re: Database slow down
PostPosted: Thu Mar 10, 2011 10:35 am 
Offline

Joined: Fri Jun 23, 2006 3:56 pm
Posts: 4065
Hi

there is a guide here :- viewtopic.php?f=33&t=8650

The main difference with an upgrade is that you will have to apply each MySQL upgrade script in turn from the version you are on.

Joe


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


All times are UTC


Who is online

Users browsing this forum: No registered users and 7 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:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group