Server Optimization Request
 

<div>1. Dedicated server

2. Server specs:
Quote:
Dell Intel 3.2 GHz Dual Xeon
2gig ram
2 250GB SATA drives
Redhat Enterprise Linux OS ES 5.0
Apache 2.2.11
PHP 5.2.9
MySQL 5.0.81
3. what version of vB are you running ?
Quote:
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?
Quote:
No innodb databases
5. if possible how mysql was compiled/installed
Quote:
Default MySQL install via EasyApache / cPanel / WHM.
6. your top stats
Quote:
top - 13:46:10 up 17 days, 1:55, 1 user, load average: 0.16, 0.13, 0.09
Tasks: 178 total, 1 running, 176 sleeping, 0 stopped, 1 zombie
Cpu0 : 3.0%us, 0.7%sy, 0.0%ni, 96.3%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu1 : 5.0%us, 1.0%sy, 0.0%ni, 93.4%id, 0.0%wa, 0.0%hi, 0.7%si, 0.0%st
Cpu2 : 0.3%us, 0.3%sy, 0.0%ni, 99.3%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu3 : 0.3%us, 0.0%sy, 0.0%ni, 99.7%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 2075308k total, 2010900k used, 64408k free, 293396k buffers
Swap: 2040212k total, 13796k used, 2026416k free, 1413320k cached
7. your mysql configuration variables located at /etc/my.cnf or c:\my.cnf or my.ini.
Quote:
[mysqld]
set-variable = max_connections=500
safe-show-database
8. MySQL stats from ssh telnet as root user type:
<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 | / |
| 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 | + ->