vps optimization for high load
 

<div>hi, I have been running my forums fine for a couple of years, but recently my loads have been going through the roof and I can't figure out why.

1- on a vps with 1gb ram

2-

xcache 1.2
apache 2.2.11

php 5.2.9
mysql 5.0.67-community

cpanel 11.24

CENTOS 5.3 x86_64 virtuozzo on server

3- vb 3.7.3 pl1

4- no innodb

5- mysql came with cpanel

6-

top - 15:00:22 up 22:31, 1 user, load average: 6.63, 4.17, 3.15
Tasks: 81 total, 1 running, 79 sleeping, 0 stopped, 1 zombie
Cpu0 : 0.3%us, 0.3%sy, 0.0%ni, 52.6%id, 46.7%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu1 : 2.7%us, 0.3%sy, 0.0%ni, 54.7%id, 42.2%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu2 : 0.3%us, 0.0%sy, 0.0%ni, 53.0%id, 46.7%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu3 : 0.0%us, 0.7%sy, 0.0%ni, 99.3%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu4 : 4.3%us, 0.3%sy, 0.0%ni, 95.3%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu5 : 0.3%us, 0.0%sy, 0.0%ni, 99.7%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu6 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu7 : 4.0%us, 0.7%sy, 0.0%ni, 37.6%id, 57.7%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 1048576k total, 290208k used, 758368k free, 0k buffers
Swap: 0k total, 0k used, 0k free, 0k cached
Unknown command - try 'h' for help
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
26288 nobody 15 0 120m 10m 3860 S 4.3 1.0 0:00.15 httpd
4035 nobody 16 0 122m 12m 4156 D 3.7 1.2 0:00.58 httpd
20128 nobody 15 0 125m 15m 4508 S 2.7 1.5 0:01.12 httpd
8094 root 15 0 12604 1260 928 R 0.7 0.1 0:00.70 top
27688 mysql 5 -10 266m 97m 4472 S 0.7 9.5 4:32.21 mysqld
5176 nobody 15 0 123m 13m 3956 D 0.3 1.3 0:00.36 httpd
26584 nobody 15 0 127m 16m 4064 D 0.3 1.6 0:01.04 httpd
27823 nobody 15 0 120m 8856 3476 D 0.3 0.8 0:00.02 httpd
27877 nobody 16 0 121m 10m 3912 D 0.3 1.1 0:00.20 httpd
1 root 15 0 10344 724 608 S 0.0 0.1 0:01.65 init
1497 nobody 15 0 120m 9940 3988 S 0.0 0.9 0:00.19 httpd
1513 nobody 16 0 121m 10m 3856 D 0.0 1.0 0:00.13 httpd
3459 root 16 -4 12600 644 356 S 0.0 0.1 0:00.00 udevd
4077 nobody 15 0 120m 10m 3768 S 0.0 1.0 0:00.12 httpd
5151 root 18 0 0 0 0 Z 0.0 0.0 0:00.02 cpsrvd-ssl
5175 nobody 18 0 121m 10m 3704 D 0.0 1.0 0:00.09 httpd
7212 named 18 0 6544 684 440 S 0.0 0.1 0:00.00 nsd
7213 named 24 0 13408 708 244 S 0.0 0.1 0:00.00 nsd
7214 named 18 0 6848 764 408 S 0.0 0.1 0:02.31 nsd
7273 named 18 0 284m 4528 1904 S 0.0 0.4 0:00.38 named
7979 root 19 0 46896 1480 804 S 0.0 0.1 0:00.00 crond
7986 root 18 0 46896 1480 804 S 0.0 0.1 0:00.00 crond
7998 root 18 0 8664 1160 940 S 0.0 0.1 0:00.00 bfd
8025 root 18 0 3840 648 552 D 0.0 0.1 0:00.01 sadc
8050 root 18 0 8672 1200 952 S 0.0 0.1 0:00.00 bfd
11269 root 15 0 60672 1192 640 S 0.0 0.1 0:00.40 sshd
11603 root 18 0 21644 888 684 S 0.0 0.1 0:00.00 xinetd
14298 root 15 0 10892 1556 1132 S 0.0 0.1 0:00.05 bash
14310 root 15 0 6064 628 472 S 0.0 0.1 0:00.90 dovecot
14311 root 15 0 14744 1008 796 S 0.0 0.1 0:00.52 dovecot-auth


7-
[mysqld]
#skip-name-resolve
safe-show-database
old_passwords
back_log = 50
skip-innodb
max_connections = 500
key_buffer_size = 24M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 4000
thread_cache_size = 128
wait_timeout = 20
connect_timeout = 10
tmp_table_size = 32M
max_heap_table_size = 32M
max_allowed_packet = 32M
net_buffer_length = 16384
max_connect_errors = 10
thread_concurrency = 8
concurrent_insert = 2
table_lock_wait_timeout = 30
read_rnd_buffer_size = 786432
bulk_insert_buffer_size = 8M
query_cache_limit = 1M
query_cache_size = 16M
query_cache_type = 1
query_prealloc_size = 262144
query_alloc_block_size = 65536
transaction_alloc_block_size = 8192
transaction_prealloc_size = 4096
default-storage-engine = MyISAM
max_write_lock_count = 16

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
nice = -10
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16M

[myisamchk]
key_buffer = 64M
sort_buffer = 16M
read_buffer = 16M
write_buffer = 16M

8-

+---------------------------------+----------------------------------------------+
| Variable_name | Value |
+---------------------------------+----------------------------------------------+
| auto_increment_increment | 1 |
| auto_increment_offset | 1 |
| automatic_sp_privileges | ON |
| back_log | 50 |
| basedir | / |
| binlog_cache_size | 32768 |
| bulk_insert_buffer_size | 8388608 |
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
| completion_type | 0 |
| concurrent_insert | 2 |
| connect_timeout | 10 |
| datadir | /var/lib/mysql/ |
| date_format | %Y-%m-%d |
| datetime_format | %Y-%m-%d %H:%i:%s |
| default_week_format | 0 |
| delay_key_write | ON |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| div_precision_increment | 4 |
| keep_files_on_create | OFF |
| engine_condition_pushdown | OFF |
| expire_logs_days | 0 |
| flush | OFF |
| flush_time | 0 |
| ft_boolean_syntax | + ->