Maybe it is somethign that I am doing wrong, but the "least connections" setting in the load balancer does not seem to work. I have two boxes taking all the connections and another one taking about 30.
Here are the details (from my ticket 646543PLNT):
QUOTE
I have spent the past 48 hours trying different configurations (round robin, least connections, preceptive, etc). But each of those options seem to do nothing.
On the three servers main.MYDOMAINNAME.com always has 3 times as many connections as the other two servers.
Right now these are the apache connections (using the LEAST CONNECTIONS) settings on the load balancer:
main.MYDOMAINNAME.com
Current Time: Wednesday, 23-Mar-2005 18:11:33 CST
Restart Time: Tuesday, 22-Mar-2005 18:43:09 CST
Parent Server Generation: 0
Server uptime: 23 hours 28 minutes 24 seconds
Total accesses: 2783748 - Total Traffic: 825.3 MB
CPU Usage: u2462.07 s796.48 cu0 cs.02 - 3.86% CPU load
32.9 requests/sec - 10.0 kB/second - 310 B/request
643 requests currently being processed, 33 idle servers
main2.MYDOMAINNAME.com:
Current Time: Wednesday, 23-Mar-2005 18:11:35 CST
Restart Time: Wednesday, 23-Mar-2005 17:40:31 CST
Parent Server Generation: 0
Server uptime: 31 minutes 4 seconds
Total accesses: 34 - Total Traffic: 1.3 MB
CPU Usage: u.06 s.04 cu0 cs0 - .00536% CPU load
.0182 requests/sec - 755 B/second - 40.4 kB/request
244 requests currently being processed, 0 idle servers
main3.MYDOMAINNAME.com:
Current Time: Wednesday, 23-Mar-2005 18:11:31 CST
Restart Time: Sunday, 20-Mar-2005 04:02:19 CST
Parent Server Generation: 11
Server uptime: 3 days 14 hours 9 minutes 12 seconds
Total accesses: 11293477 - Total Traffic: 3.0 GB
CPU Usage: u337.24 s130.88 cu.02 cs0 - .151% CPU load
36.4 requests/sec - 10.3 kB/second - 289 B/request
327 requests currently being processed, 68 idle servers
How on earth can the connections be: 643, 244, 327 when it is set on least connections?
This is causing terrible interruption to our service, please advise.
Gordon
------------------------------------------
(jhodge-03/23/2005 18:48:25):
I am sending this to be investigated further. Your patience is appreciated.
--------------------------------------
(MYUSERNAME-03/24/2005 16:03:46):
Again tonight, site down due to incorrect balancing:
main:
Current Time: Thursday, 24-Mar-2005 16:02:25 CST
Restart Time: Sunday, 20-Mar-2005 04:02:19 CST
Parent Server Generation: 11
Server uptime: 4 days 12 hours 6 seconds
Total accesses: 14135568 - Total Traffic: 3.9 GB
CPU Usage: u359.64 s146.37 cu.01 cs.02 - .13% CPU load
36.4 requests/sec - 10.4 kB/second - 293 B/request
850 requests currently being processed, 70 idle servers
main2:
Current Time: Thursday, 24-Mar-2005 16:02:15 CST
Restart Time: Wednesday, 23-Mar-2005 21:45:04 CST
Parent Server Generation: 1
Server uptime: 18 hours 17 minutes 11 seconds
Total accesses: 355 - Total Traffic: 8.3 MB
CPU Usage: u.23 s.03 cu0 cs0 - .000395% CPU load
.00539 requests/sec - 132 B/second - 24.1 kB/request
34 requests currently being processed, 45 idle servers
main3:
Current Time: Thursday, 24-Mar-2005 16:02:35 CST
Restart Time: Thursday, 24-Mar-2005 15:28:31 CST
Parent Server Generation: 0
Server uptime: 34 minutes 4 seconds
Total accesses: 81762 - Total Traffic: 24.1 MB
CPU Usage: u136.57 s44.31 cu.01 cs0 - 8.85% CPU load
40 requests/sec - 12.1 kB/second - 308 B/request
999 requests currently being processed, 0 idle servers
Thats 850, 34, 999.
On the three servers main.MYDOMAINNAME.com always has 3 times as many connections as the other two servers.
Right now these are the apache connections (using the LEAST CONNECTIONS) settings on the load balancer:
main.MYDOMAINNAME.com
Current Time: Wednesday, 23-Mar-2005 18:11:33 CST
Restart Time: Tuesday, 22-Mar-2005 18:43:09 CST
Parent Server Generation: 0
Server uptime: 23 hours 28 minutes 24 seconds
Total accesses: 2783748 - Total Traffic: 825.3 MB
CPU Usage: u2462.07 s796.48 cu0 cs.02 - 3.86% CPU load
32.9 requests/sec - 10.0 kB/second - 310 B/request
643 requests currently being processed, 33 idle servers
main2.MYDOMAINNAME.com:
Current Time: Wednesday, 23-Mar-2005 18:11:35 CST
Restart Time: Wednesday, 23-Mar-2005 17:40:31 CST
Parent Server Generation: 0
Server uptime: 31 minutes 4 seconds
Total accesses: 34 - Total Traffic: 1.3 MB
CPU Usage: u.06 s.04 cu0 cs0 - .00536% CPU load
.0182 requests/sec - 755 B/second - 40.4 kB/request
244 requests currently being processed, 0 idle servers
main3.MYDOMAINNAME.com:
Current Time: Wednesday, 23-Mar-2005 18:11:31 CST
Restart Time: Sunday, 20-Mar-2005 04:02:19 CST
Parent Server Generation: 11
Server uptime: 3 days 14 hours 9 minutes 12 seconds
Total accesses: 11293477 - Total Traffic: 3.0 GB
CPU Usage: u337.24 s130.88 cu.02 cs0 - .151% CPU load
36.4 requests/sec - 10.3 kB/second - 289 B/request
327 requests currently being processed, 68 idle servers
How on earth can the connections be: 643, 244, 327 when it is set on least connections?
This is causing terrible interruption to our service, please advise.
Gordon
------------------------------------------
(jhodge-03/23/2005 18:48:25):
I am sending this to be investigated further. Your patience is appreciated.
--------------------------------------
(MYUSERNAME-03/24/2005 16:03:46):
Again tonight, site down due to incorrect balancing:
main:
Current Time: Thursday, 24-Mar-2005 16:02:25 CST
Restart Time: Sunday, 20-Mar-2005 04:02:19 CST
Parent Server Generation: 11
Server uptime: 4 days 12 hours 6 seconds
Total accesses: 14135568 - Total Traffic: 3.9 GB
CPU Usage: u359.64 s146.37 cu.01 cs.02 - .13% CPU load
36.4 requests/sec - 10.4 kB/second - 293 B/request
850 requests currently being processed, 70 idle servers
main2:
Current Time: Thursday, 24-Mar-2005 16:02:15 CST
Restart Time: Wednesday, 23-Mar-2005 21:45:04 CST
Parent Server Generation: 1
Server uptime: 18 hours 17 minutes 11 seconds
Total accesses: 355 - Total Traffic: 8.3 MB
CPU Usage: u.23 s.03 cu0 cs0 - .000395% CPU load
.00539 requests/sec - 132 B/second - 24.1 kB/request
34 requests currently being processed, 45 idle servers
main3:
Current Time: Thursday, 24-Mar-2005 16:02:35 CST
Restart Time: Thursday, 24-Mar-2005 15:28:31 CST
Parent Server Generation: 0
Server uptime: 34 minutes 4 seconds
Total accesses: 81762 - Total Traffic: 24.1 MB
CPU Usage: u136.57 s44.31 cu.01 cs0 - 8.85% CPU load
40 requests/sec - 12.1 kB/second - 308 B/request
999 requests currently being processed, 0 idle servers
Thats 850, 34, 999.
Anyone have any ideas?
tia
gp