Load problems on a 3 server deal, I really need help
I have 2 servers behind load balancing that do nothing but http requests.
Server #1: DUAL XEON - 2.0Ghz - Redhat Enterprise - (2)73GBHD - 4GB
Server #2: DUAL XEON - 2.0Ghz - Redhat Enterprise - (2)73GBHD - 1GB
Also, my MySQL is handled by a third server. It does nothing but MySQL
Server #3: Dual Xeon - 2.4Ghz - FreeBSD - 2-73GBHD - 2GB RAM
All I'm running on those servers is a very busy phpadsnew (www.phpadsnew.com) banner ads system that shows around 3.2 millions impressions per day and an online store using a heavily modified source of the X-Cart shopping system (www.x-cart.com).
The problem is that everything is so freaking slow... I mean, granted they do serve a lot, it's still unexplainable that 3 servers can't hold that much load. Can anybody recommand anything? I've tried to include as much information as I could.
---------------------------------
Server #1 version info:
Server version: Apache/2.0.46
Server built: Nov 5 2004 10:58:21
PHP 4.3.10 (cgi) (built: Dec 22 2004 13:36:20)
Copyright (c) 1997-2004 The PHP Group
Zend Engine v1.3.0, Copyright (c) 1998-2004 Zend Technologies
with Zend Extension Manager v1.0.6, Copyright (c) 2003-2004, by Zend Technologies
with Zend Optimizer v2.5.7, Copyright (c) 1998-2004, by Zend Technologies
Server #2 version info:
Server version: Apache/2.0.46
Server built: Nov 5 2004 10:58:21
PHP 4.3.10 (cgi) (built: Dec 22 2004 13:36:20)
Copyright (c) 1997-2004 The PHP Group
Zend Engine v1.3.0, Copyright (c) 1998-2004 Zend Technologies
with Zend Extension Manager v1.0.6, Copyright (c) 2003-2004, by Zend Technologies
with Zend Optimizer v2.5.7, Copyright (c) 1998-2004, by Zend Technologies
Server #3 version info:
mysql Ver 14.7 Distrib 4.1.10a, for portbld-freebsd4.9 (i386)
Server #1 TOP: http://www.91420042quebecinc.com/terra-top.gif
Server #2 TOP: http://www.91420042quebecinc.com/celes-top.gif
Server #3 TOP: http://www.91420042quebecinc.com/strago-top.gif
Server #1 php config: http://67.15.114.26/inf.php
Server #2 php config: http://67.15.114.30/inf.php
General apache configs (same for server #1 and #2)
ServerTokens OS
Timeout 60
KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 10
ServerLimit 500
<IfModule prefork.c>
StartServers 8
MinSpareServers 8
MaxSpareServers 30
MaxClients 500
MaxRequestsPerChild 1000
</IfModule>
Server #3 my.cnf
[mysqld]
datadir=/var/db/mysql
connect_timeout=10
interactive_timeout=100
join_buffer_size=1M
key_buffer=256M
max_allowed_packet=16M
max_connections=800
max_connect_errors=10
myisam_sort_buffer_size=128M
read_buffer_size=1M
read_rnd_buffer_size=768K
sort_buffer_size=1M
table_cache=1024
thread_cache_size=100
thread_concurrency=4
wait_timeout=60
query_cache_size=512M
query_cache_limit=4M
query_cache_type=1
skip-innodb
skip-name-resolve
