mySQL Probme & Load Balancing
Dual 2.4 Xeon's
Dual 36 SCSI Hard Drives
2 Gig Ram
10 Gig Port connection
Started having high load problems today. Any recommendations on how to fix this? Should the mySQL be configured differently? Not sure how to pull up the setup for that so if someone can tell me how I will and post it.
Next question is would Load Balancing solve this problem?
12:22:27 up 27 days, 9:07, 2 users, load average: 161.17, 158.96, 139.90
869 processes: 717 sleeping, 151 running, 1 zombie, 0 stopped
CPU states: cpu user nice system irq softirq iowait idle
total 95.7% 0.0% 4.0% 0.0% 0.2% 0.0% 0.0%
cpu00 96.3% 0.0% 2.7% 0.1% 0.8% 0.0% 0.0%
cpu01 94.5% 0.0% 5.4% 0.0% 0.0% 0.0% 0.0%
cpu02 96.1% 0.0% 3.8% 0.0% 0.0% 0.0% 0.0%
cpu03 95.9% 0.0% 4.0% 0.0% 0.0% 0.0% 0.0%
Mem: 2061124k av, 2011384k used, 49740k free, 0k shrd, 63420k buff
1384996k actv, 259508k in_d, 26592k in_c
Swap: 2040244k av, 118088k used, 1922156k free 783584k cached
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
31846 nobody 18 0 6164 6056 2580 R 10.3 0.2 1:11 1 httpd
29721 nobody 18 0 5956 5852 2512 R 8.6 0.2 0:48 2 httpd
30777 nobody 18 0 6156 6048 2548 R 8.3 0.2 0:59 0 httpd
21861 nobody 18 0 7944 7748 2416 R 5.2 0.3 1:31 1 httpd
29433 nobody 17 0 6080 5972 2520 R 4.8 0.2 0:45 3 httpd
31572 nobody 18 0 6144 6036 2584 R 3.6 0.2 0:44 2 httpd
28803 nobody 16 0 5716 5608 2468 S 2.6 0.2 0:45 1 httpd
25842 nobody 17 0 5752 5616 2448 R 1.4 0.2 1:23 0 httpd
32044 nobody 18 0 6344 6236 2580 R 1.4 0.3 0:46 0 httpd
26788 nobody 15 0 5568 5444 2392 S 1.3 0.2 1:13 1 httpd
30523 mysql 16 0 50524 48M 1148 S 1.3 2.3 0:08 2 mysqld
23670 mysql 15 0 50380 47M 1148 S 1.2 2.3 0:14 2 mysqld
25752 nobody 16 0 5872 5748 2400 R 1.2 0.2 1:20 3 httpd
26540 mysql 16 0 50380 47M 1148 S 1.2 2.3 0:14 1 mysqld
28965 mysql 16 0 50380 47M 1148 R 1.2 2.3 0:09 3 mysqld
29106 mysql 16 0 50524 48M 1148 R 1.2 2.3 0:07 1 mysqld
31891 nobody 16 0 5920 5812 2556 R 1.2 0.2 0:45 1 httpd
32038 nobody 18 0 6024 5916 2564 R 1.2 0.2 0:43 2 httpd
1030 nobody 18 0 6080 5972 2608 R 1.2 0.2 0:24 0 httpd
32054 nobody 16 0 5812 5708 2548 R 1.0 0.2 0:45 1 httpd
23675 nobody 17 0 5848 5740 2440 S 0.9 0.2 1:53 2 httpd
