IPB using mass mysql , cause to over load @ 25. +

[irocracer]

top - 14:59:59 up 9:07, 1 user, load average: 18.01, 10.46, 8.00
Tasks: 231 total, 3 running, 228 sleeping, 0 stopped, 0 zombie
Cpu(s): 12.8% us, 5.8% sy, 0.0% ni, 1.5% id, 79.8% wa, 0.2% hi, 0.0% si
Mem: 1026500k total, 533824k used, 492676k free, 2232k buffers
Swap: 1028152k total, 9216k used, 1018936k free, 174272k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
6302 apache 15 0 93904 20m 11m R 4.3 2.0 0:00.13 httpd
30777 apache 16 0 93388 29m 21m S 2.7 3.0 0:05.83 httpd
30736 apache 15 0 93632 30m 22m S 2.0 3.1 0:05.48 httpd
6307 apache 17 0 93152 21m 13m S 1.3 2.1 0:00.09 httpd
6352 apache 17 0 93124 18m 11m S 1.3 1.9 0:00.04 httpd
39 root 15 0 0 0 0 D 0.7 0.0 1:20.71 kswapd0
25609 mysql 15 0 286m 75m 1992 D 0.7 7.5 0:08.75 mysqld
25814 mysql 15 0 286m 75m 1992 D 0.7 7.5 0:13.42 mysqld
30798 apache 15 0 93720 29m 20m S 0.7 2.9 0:05.82 httpd
2334 mysql 15 0 286m 75m 1992 D 0.7 7.5 0:04.61 mysqld
3262 mysql 15 0 286m 75m 1992 D 0.7 7.5 0:01.41 mysqld
3587 mysql 15 0 286m 75m 1992 D 0.7 7.5 0:02.31 mysqld
3599 mysql 15 0 286m 75m 1992 D 0.7 7.5 0:03.71 mysqld
4504 root 17 0 8648 1924 1528 S 0.7 0.2 0:00.28 exim
22432 mysql 15 0 286m 75m 1992 D 0.3 7.5 0:10.82 mysqld
25785 mysql 15 0 286m 75m 1992 D 0.3 7.5 0:08.62 mysqld
25863 mysql 15 0 286m 75m 1992 S 0.3 7.5 0:11.65 mysqld
2325 mysql 15 0 286m 75m 1992 D 0.3 7.5 0:02.09 mysqld
2802 mysql 15 0 286m 75m 1992 D 0.3 7.5 0:02.45 mysqld
2831 mysql 15 0 286m 75m 1992 D 0.3 7.5 0:02.52 mysqld
3003 mysql 18 0 286m 75m 1992 D 0.3 7.5 0:02.69 mysqld
3180 mysql 15 0 286m 75m 1992 D 0.3 7.5 0:06.77 mysqld
3594 mysql 15 0 286m 75m 1992 D 0.3 7.5 0:02.92 mysqld
3604 mysql 16 0 286m 75m 1992 S 0.3 7.5 0:04.62 mysqld
4056 root 16 0 2740 1052 744 R 0.3 0.1 0:02.47 top
4427 apache 15 0 93100 26m 18m S 0.3 2.6 0:01.40 httpd
5145 apache 16 0 93080 22m 14m S 0.3 2.2 0:00.68 httpd
5681 apache 16 0 93540 22m 13m S 0.3 2.2 0:00.29 httpd
6273 apache 16 0 91276 16m 10m S 0.3 1.6 0:00.01 httpd


Server Spec
Intel D 820
Dual Drive [ 120 WD 7200RPM:web | 80GB 7200 Hti 7200RPM: mysql ] both sata2 3.0gps
1 Gig Ram @ 533 DDr2 dual Channel


my.cnf file

[mysqld]
skip-locking
skip-innodb
query_cache_limit=400K
query_cache_size=8M
query_cache_type=1
max_connections=700
interactive_timeout=80
wait_timeout=100
connect_timeout=10
thread_cache_size=60
key_buffer=150M
join_buffer=1M
max_allowed_packet=14M
table_cache=384
record_buffer=700K
sort_buffer_size=400K
read_buffer_size=400K
max_connect_errors=10
# Try number of CPU's*2 for thread_concurrency
thread_concurrency=2
myisam_sort_buffer_size=54M
log-bin
server-id=1

[safe_mysqld]
err-log=/var/log/mysqld.log
open_files_limit=8192

[mysqldump]
quick
max_allowed_packet=16M

[mysql]
no-auto-rehash
#safe-updates

[isamchk]
key_buffer=40M
sort_buffer=40M
read_buffer=10M
write_buffer=10M

[myisamchk]
key_buffer=40M
sort_buffer=40M
read_buffer=10M
write_buffer=10M

[mysqlhotcopy]
interactive-timeout



httpd.conf

Timeout 10
KeepAlive on
MaxKeepAliveRequests 500
KeepAliveTimeout 1
MinSpareServers 5
MaxSpareServers 13
StartServers 8
MaxClients 450
MaxRequestsPerChild 1000


php.ini Output

This program makes use of the Zend Scripting Language Engine:
Zend Engine v1.3.0, Copyright © 1998-2004 Zend Technologies with eAccelerator v0.9.3, Copyright © 2004-2005 eAccelerator, by eAccelerator with Zend Extension Manager v1.0.8, Copyright © 2003-2005, by Zend Technologies with Zend Optimizer v2.5.10, Copyright © 1998-2005, by Zend Technologies


Can Someone help ?

[bfarber]

While those specs are quite technical, they don't really detail what your problem is...

From the topic title I'm assuming your MySQL usage is causing a high server load. Run the query SHOW PROCESSLIST in your mysql command line when the server load starts spiking to find out what query is causing you problems. That would allow someone to give you a better idea of how to rectify the issue.