Page 1 of 1
Database Server keepalives = X
Posted:
Sun Sep 30, 2012 10:17 pmby optimusvoice2012
Hi Guys,
Is it right to configure Database Server keepalives = X?
We are using 3 Web/Asterisk at the same server.
And separate DB Server.
vicidial 2.6
asterisk 1.4.39
Thanks!
Re: Database Server keepalives = X
Posted:
Mon Oct 01, 2012 8:21 amby mflorell
yes that is allright
Re: Database Server keepalives = X
Posted:
Wed Oct 24, 2012 11:21 amby optimusvoice2012
Thanks for the reply matt!
Right now we are encountering a different issue. All of a sudden we are encountering database overload issues in the middle of the shift. We already transfer our database to different server but still doing it. Our servers are all configured EST -5.00.. On our analysis, this things happen during 8AM to 930AM EST time. . then it continues to have issues until the end of the shift. We are looking on crontab -e.. We don't see any script running at those times..
Hope you could help us shed some light on this. It is causing us our production to go low.
Thanks!
Re: Database Server keepalives = X
Posted:
Thu Oct 25, 2012 2:07 pmby mflorell
I would suggest using mtop or enabling slow query logging in mysql to take a look at what queries are causing this, then it should be easy to see what's causing it.
Re: Database Server keepalives = X
Posted:
Sun Oct 28, 2012 8:00 pmby williamconley
It may also be a very good idea to "describe" these database overload issues.
And "show processlist" is a good tool to quickly observe the situation while it is happening (same command issued by mtop ...).
Also: Post your installation method and the cluster method as these can have a huge impact on these situations (and Matt can often "guess" at your problem based on those facts alone! LOL)