Server Performance

[enrique.vidal]

Hi, I currently have one Dual Xeon Server working with 23 agents, but its pausing all agents and maxing out the mysql connections, I can barely work with it, do you have any advise? these are the server specs:

# cpuinfo
processor : 0
vendor_id : GenuineIntel
cpu family : 15
model : 2
model name : Intel(R) Xeon(TM) CPU 2.40GHz
stepping : 7
cpu MHz : 1063.332
cache size : 512 KB
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 2
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe cid
bogomips : 2128.46

processor : 1
vendor_id : GenuineIntel
cpu family : 15
model : 2
model name : Intel(R) Xeon(TM) CPU 2.40GHz
stepping : 7
cpu MHz : 1063.332
cache size : 512 KB
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 2
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe cid
bogomips : 2126.34


# meminfo
MemTotal: 2075412 kB
MemFree: 432832 kB
Buffers: 34964 kB
Cached: 1182524 kB
SwapCached: 0 kB
Active: 1052904 kB
Inactive: 535396 kB
HighTotal: 1179392 kB
HighFree: 1624 kB
LowTotal: 896020 kB
LowFree: 431208 kB
SwapTotal: 1044216 kB
SwapFree: 1044216 kB
Dirty: 9352 kB
Writeback: 0 kB
AnonPages: 370644 kB
Mapped: 27040 kB
Slab: 39528 kB
PageTables: 8288 kB
NFS_Unstable: 0 kB
Bounce: 0 kB
CommitLimit: 2081920 kB
Committed_AS: 1022104 kB
VmallocTotal: 114680 kB
VmallocUsed: 3604 kB
VmallocChunk: 110916 kB
HugePages_Total: 0
HugePages_Free: 0
HugePages_Rsvd: 0
Hugepagesize: 4096 kB

# loadavg
23.81 22.50 20.07 17/303 29393

# vicidial
VERSION: 2.2.0-235
BUILD: 100319-1708

Hope this info helps you determine the cause of my server failure.

[gardo]

Output of "top -c" or load average when this happens. Running "mtop --dbuser=root --seconds=3" will show you which mysql process are running and doing something nasty.