IPB using mass mysql , cause to over load @ 25. + Options
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
Can Someone help ?
Thanks very much
TnTWebhostingCo.Com
