Database Server keepalives = X

[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!

[mflorell]

yes that is allright

[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!

[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.

[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)