Request for server optimizaiton
 

<div>Could you please optimize my server:

Thanks

--------------

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

Dedicated Server.

2. your server specs. For example:

cpu speed/type single or dual cpus): dual core daul Xeon 2.33GHz (5148) Cache size 4096
how much memory installed: 4Gb ram
hard drive type/configuration: 3 Hard Drive Sata 250 GB each.
linux distributor or windows version: Linux Redhat Enterprise 4 i686.
apache/IIS version: apache Apache/2.2.11
PHP version: PHP/5.2.10
MySQL version: MySQL 4.1.22
3. what version of vB are you running ?
3.83
4. if you use mysql 4.x instead of mysql 3.23.x, do you have any innodb type databases/tables on your server ?
A. No.
5. if possible how mysql was compiled/installed
Compiled by easyapache on Cpanel
6. your top stats. So log into your server via ssh telnet as root user and type the command in bold - top
top - 12:52:31 up 33 days, 11:18, 2 users, load average: 0.50, 1.21, 1.41
Mem: 4148828k total, 3665992k used, 482836k free, 140556k buffers
Swap: 2096440k total, 512k used, 2095928k free, 1593988k cached

after hitting 1
top - 12:55:03 up 33 days, 11:20, 2 users, load average: 0.81, 1.03, 1.31
Tasks: 199 total, 1 running, 197 sleeping, 0 stopped, 1 zombie
Cpu0 : 0.0% us, 3.3% sy, 16.3% ni, 80.3% id, 0.0% wa, 0.0% hi, 0.0% si
Cpu1 : 0.0% us, 0.3% sy, 0.7% ni, 98.7% id, 0.3% wa, 0.0% hi, 0.0% si
Cpu2 : 1.3% us, 1.3% sy, 0.3% ni, 97.0% id, 0.0% wa, 0.0% hi, 0.0% si
Cpu3 : 0.3% us, 2.0% sy, 2.7% ni, 94.4% id, 0.7% wa, 0.0% hi, 0.0% si
Mem: 4148828k total, 3633656k used, 515172k free, 144932k buffers
Swap: 2096440k total, 512k used, 2095928k free, 1602612k cached
7.
[mysqld]
datadir=/home3/mysql/
safe-show-database
back_log = 75
skip-innodb
max_connections = 500
key_buffer = 512M
myisam_sort_buffer_size = 64M
join_buffer_size = 2M
read_buffer_size = 16M
sort_buffer_size = 16M
table_cache = 10000
thread_cache_size = 256
wait_timeout = 100
connect_timeout = 10
tmp_table_size = 128M
max_heap_table_size = 128M
max_allowed_packet = 64M
net_buffer_length = 16384
max_connect_errors = 100000
thread_concurrency = 8
read_rnd_buffer_size = 786432
bulk_insert_buffer_size = 8M
query_cache_limit = 8M
query_cache_size = 192M
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 = 8

#log-slow-queries = /var/log/mysql-slow.log
#long_query_time = 1
[mysqld_safe]
nice = -5
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 256M
sort_buffer = 16M
read_buffer = 16M
write_buffer = 16M
[mysqlhotcopy]
interactive-timeout

8. Mysql process
+---------------------------------+--------------------------------------+
| Variable_name | Value |
+---------------------------------+--------------------------------------+
| auto_increment_increment | 1 |
| auto_increment_offset | 1 |
| automatic_sp_privileges | ON |
| back_log | 75 |
| 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 | /home3/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 | + ->