Server optimization request
 

<div>Hi,

I'd like to ask you to take a look at my configuration because I have a huge load sometimes (once per hour between 5 to 10) and randomly slowness.

1. Is this on dedicated or shared virual server. If shared, how many sites share this server (ask web host if needed):

It is a dedicated server. I have two identical servers one for the database and one for the files.

2. your server specs:

R200 Xeon X3350 / 4096Mb / 2x150Gb Raptor / RAID1

Information from DirectAdmin:

Code:
Processor Name Intel(R) Xeon(R) CPU X3350 @ 2.66GHz
Vendor ID GenuineIntel
Processor Speed (MHz) 2000.000
Processor Name Intel(R) Xeon(R) CPU X3350 @ 2.66GHz
Vendor ID GenuineIntel
Processor Speed (MHz) 2000.000
Processor Name Intel(R) Xeon(R) CPU X3350 @ 2.66GHz
Vendor ID GenuineIntel
Processor Speed (MHz) 2000.000
Processor Name Intel(R) Xeon(R) CPU X3350 @ 2.66GHz
Vendor ID GenuineIntel
Processor Speed (MHz) 2000.000
Total Memory 4047008 kB
Free Memory 29084 kB
Total Swap Memory 4192956 kB
Free Swap Memory 4192864 kB
System Uptime 82 Days, 23 Hours and 25 Minutes
Apache 2.0.63 Server Running
DirectAdmin 1.32.3 Running
Exim 4.69 Running
MySQL 5.0.51a Running
Named 9.3.3rc2 Running
ProFTPd 1.3.1 Running
sshd Running
vm-Pop3d 1.1.7f-DA-2 Running
3. what version of vB are you running ?

vBulletin 3.8.3

4. if you use mysql 4.x instead of mysql 3.23.x, do you have any innodb type databases/tables on your server ?

No InnoDB in use, InnoDB engine is setup though

5. if possible how mysql was compiled/installed:

No information

6. your top stats:

Code:
top - 15:53:56 up 84 days, 16:45, 1 user, load average: 0.10, 0.15, 0.10Tasks: 122 total, 1 running, 121 sleeping, 0 stopped, 0 zombieCpu0 : 1.0%us, 0.7%sy, 0.0%ni, 98.3%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%stCpu1 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%stCpu2 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%stCpu3 : 9.6%us, 7.3%sy, 0.0%ni, 82.1%id, 0.3%wa, 0.0%hi, 0.7%si, 0.0%stMem: 4047008k total, 3981948k used, 65060k free, 52416k buffers
Swap: 4192956k total, 92k used, 4192864k free, 2742428k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 24229 mysql 15 0 3420m 1.0g 4932 S 19 25.8 232:39.25 mysqld
14056 root 15 0 12716 1088 804 R 0 0.0 0:00.05 top 1 root 15 0 10328 700 588 S 0 0.0 0:15.94 init
2 root RT -5 0 0 0 S 0 0.0 0:00.24 migration/0 3 root 34 19 0 0 0 S 0 0.0 0:00.00 ksoftirqd/0
4 root RT -5 0 0 0 S 0 0.0 0:00.00 watchdog/0 5 root RT -5 0 0 0 S 0 0.0 0:00.52 migration/1
6 root 34 19 0 0 0 S 0 0.0 0:00.00 ksoftirqd/1 7 root RT -5 0 0 0 S 0 0.0 0:00.00 watchdog/1
7. Your mysql configuration.

<div style="margin:20px; margin-top:5px"> Code:
+---------------------------------+-----------------------------------------------------+
| Variable_name | Value |
+---------------------------------+-----------------------------------------------------+
| auto_increment_increment | 1 |
| auto_increment_offset | 1 |
| automatic_sp_privileges | ON |
| back_log | 50 |
| basedir | /usr/ |
| 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 | + ->