Server optimization request
 

<div>Hello. I'm running a music portal, where vBulletin is part of the whole site. Although i have moved to a new dedicated server with stronger cpu (intel core 2 duo 2.8GHZ) and a good amount of RAM (3,5 GB), the server is oftenly down because of high usage of cpu and ram, caused by the forum scripts.

Here is what I can provide to help me optimize my server. Thanks in advance.

1. Dedicated server

2. Server specs:
CPU: Intel Core 2 Duo CPU E7400 @ 2.80GHz
RAM: 3,5 GB
Hard Drive: 80GB, ST380815AS, ATA DISK drive
Linux Distributor: CentOS
Apache version: Apache v2.0.63 (cgi)
PHP version: 4.4.7
MySQL version: 5.0.77-community

3. vB version: 3.8.2

4. No innodb databases/tables on my server.

6. Top stats:
Quote:
top - 03:34:19 up 11:33, 1 user, load average: 0.61, 0.50, 0.74
Tasks: 122 total, 1 running, 120 sleeping, 0 stopped, 1 zombie
Cpu0 : 4.0% us, 1.0% sy, 0.0% ni, 88.4% id, 6.6% wa, 0.0% hi, 0.0% si
Cpu1 : 13.7% us, 2.3% sy, 0.0% ni, 74.7% id, 9.3% wa, 0.0% hi, 0.0% si
Mem: 3523544k total, 3297220k used, 226324k free, 55244k buffers
Swap: 2096472k total, 0k used, 2096472k free, 2996116k cached
7. my.cnf contents:
Quote:
[mysqld]
key_buffer_size = 16M
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
thread_cache_size = 24
set-variable = max_connections=500
safe-show-database
old-passwords = 1
8. MySQL stats:
<div style="margin:20px; margin-top:5px; "> Quote:
+---------------------------------+--------------------------------------+
| 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 | 1 |
| 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 | + ->