Very High Server Load || Optimization Request!
 

<div>Hello Sir,

I have been using Vbulletin for my forum, from an year around and didn't had any problem. But from last month after the upgrade to latest version, i am facing serious problems of HIGH SERVER LOAD. I had to shift my site from a VPS to a dedicated server and still the load is very HIGH which causes the site to run very slow.

So its a request for EVA to help me please optimize the site. Here are the details :


1. Its a dedicated server.

2. Server specs:

Intel Xeon Quad CPU X3210 2.13GHz
2GB RAM
100 GB SataII
CentOS release 5.2 (Final)
Apache 2.0.63
MySQL 5.0.67
PHP 5.2.5

3. I use Vbulletin 3.8.2 ( from last month )

4. MySQL 5.0.67, InnoDB disabled.

5. Installed using RPM's.

6. Output of top.

----------------------------------------
top - 05:22:37 up 18 min, 0 users, load average: 10.59, 7.19, 4.22
Tasks: 94 total, 1 running, 89 sleeping, 0 stopped, 4 zombie
Cpu0 : 8.1%us, 1.6%sy, 0.0%ni, 90.3%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu1 : 11.4%us, 2.4%sy, 0.0%ni, 86.3%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu2 : 1.5%us, 0.7%sy, 0.0%ni, 97.8%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu3 : 7.3%us, 1.1%sy, 0.0%ni, 91.6%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 2097152k total, 190680k used, 1906472k free, 0k buffers
Swap: 0k total, 0k used, 0k free, 0k cached
----------------------------------------

7.

[root@server /]# cat /root/.my.cnf
[client]
user="root"

[root@server /]# cat /etc/my.cnf

[mysqld]
skip-bdb
skip-innodb

8.

[root@server ~]# mysqladmin -u root -p var ext stat ver proc
Enter password:
+---------------------------------+-----------------------------------------------+
| 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 | + ->