Multiple vicidials, one DB. laggy response

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Multiple vicidials, one DB. laggy response

Postby rcphq » Thu Jul 24, 2008 1:43 pm

We're trying to grow the infrastructure of our call center by switching from a 2-vicidials in paralel setup to a 1 DB, 2 vicidials running on it scheme.
we've done some initial tests and found the response time somewhat laggy, has this happened to anyone? any ideas?

(where is a good place to read up on this, i figure it's somewhere in the docs, but im not in charge of that infrastructure project so i havent looked yet, any guidance would be most welcomed).

thanks!
rcphq
 
Posts: 42
Joined: Fri Nov 02, 2007 8:54 am

Postby mflorell » Thu Jul 24, 2008 1:47 pm

What CPU specs and RAM specs are on your DB server?

Have you optimized your /etc/my.cnf file for these parameters?
mflorell
Site Admin
 
Posts: 18339
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby rcphq » Thu Jul 24, 2008 2:05 pm

the my.cnf hasn't been touched for special settings, where could i see where to better adapt it for this conditions?

the DB is currently setup on a old server we had lying around for testing, the servers it could end up on would be more powerfull, but we we're amazed by the noticeable lag in response
rcphq
 
Posts: 42
Joined: Fri Nov 02, 2007 8:54 am

Postby mflorell » Thu Jul 24, 2008 4:14 pm

Your database needs to be the FASTEST server in the cluster.

I cannot give you any suggestions unless you tell me about the machine:

What CPU specs and RAM specs are on your DB server?
mflorell
Site Admin
 
Posts: 18339
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby rortizde » Fri Jul 25, 2008 9:36 am

It's a dual Xeon 2.8GHz 533MHz FSB 512KB L2 Cache with 2GB RAM and two 73GB 7,200 RPM SCSI Disks using RAID 1
rortizde
 
Posts: 11
Joined: Mon Jun 09, 2008 11:29 am
Location: Dominican Republic

Postby mflorell » Fri Jul 25, 2008 10:50 am

You should start with the huge-my.cnf file that is included by default with MySQL.

Make sure that hostname lookups are diasbled(as sp3ecified in the SCRATCH_INSTALL doc).
mflorell
Site Admin
 
Posts: 18339
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida


Return to Support

Who is online

Users browsing this forum: Google [Bot] and 253 guests