Thanks for all the information. Benaiad: I will try adding in the hosts file and try it once again, also one more that I was in regards to the harddrive, so I thought of replacing with a SSD with high read and write speeds just to check whether its going to reduce the dealy...
Regards Sandesh On Thu, Oct 22, 2009 at 6:20 PM, Benaiad <bena...@gmail.com> wrote: > > Abdulmnem Benaiad > Almontaha CTO > Almontaha IT Co. > cell: +218 92 5200025 > fax: +218 21 4835263 > www.almontaha.com.ly > > > On Wed, Oct 21, 2009 at 11:57 PM, das sandesh <sandesh...@gmail.com>wrote: > >> Hi Matt, >> >> I already used the tuning-primer.sh script to enhance the values for the >> parameters, but still it was being slow to connect when there are lot of >> calls (calls around 150-200 calls). Also I reduced mysql queries in the code >> as well as many other steps, but only problem coming is with repect to the >> connection from asterisk to mysql (also I am using <direct ip address> and >> not the dns name).....is it better to use any additional mysql server apart >> from this application server? or adding additional hardware would help (like >> dual quad core)? >> >> Thanks >> Sandesh >> >> >> On Wed, Oct 21, 2009 at 3:57 PM, Matt Riddell <li...@venturevoip.com>wrote: >> >>> On 22/10/09 7:30 AM, das sandesh wrote: >>> > Hi, >>> > >>> > I tried getting our server setup for 400-500 simultaneous calls, calls >>> > were going through properly but at around 200-250 calls, mysql (connect >>> > ...) statement was taking at least 5-10 sec to connect to the database. >>> > I optimized all possible parameters in my.cnf: >>> >>> Without knowing what you're optimising you're unlikely to have much luck >>> just setting values. >>> >>> We have had quite good success with the tunish-primer.sh script: >>> >>> http://www.day32.com/MySQL/ >>> http://www.day32.com/MySQL/tuning-primer.sh >>> >>> We run with MySQL at about 500 queries per second with no problems - we >>> don't however use Asterisk's MySQL libraries. >>> >>> -- >>> Cheers, >>> >>> Matt Riddell >>> Director >>> _______________________________________________ >>> >>> http://www.venturevoip.com/news.php (Daily Asterisk News) >>> http://www.venturevoip.com/st.php (SmoothTorque Predictive Dialer) >>> http://www.venturevoip.com/c3.php (ConduIT3 PABX Systems) >>> >>> > > Regarding Mysql delay, I've faced this problem before in my local network > and this problem has been solved by adding all of my servers IP's and names > in the "/etc/hosts" file. > even when connecting locally, I think , asterisk will use a real IP instead > of 127.0.0.1 when connecting to mysql and mysql will try to resolve it's > name, and this step will take some time. > > Regards. > > -- > Benaiad > > > > _______________________________________________ > -- Bandwidth and Colocation Provided by http://www.api-digital.com -- > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users >
_______________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users