Tim: So you actually have mod_callcenter running on more than FS instance with a shared DB ? On Mon, Feb 13, 2012 at 8:33 PM, Tim St. Pierre <fs-list@communicatefreely.net> wrote:
I had a similar problem with MySQL not being able to keep up.
I changed the engine from innoDB to MEMORY and my CPU load went from 99% to 4%, and my disk IO had a similar drop.
alter table XXX engine='MEMORY';
Do you really need the calls in your queue to persist? The only caveat - if you are running a multi-master mysql setup, restarting a server will propagate a "delete from XXX" query that flushes the tables, so keep that in mind.
-Tim
Vik Killa wrote:
It is bogging down my MySQL server.
On Mon, Feb 13, 2012 at 3:07 PM, Peter Olsson <peter.olsson@visionutveckling.se> wrote:
I don't see much about an overload here, a few queries per second should be hardly noticable on the MySQL instance?
<snip>