Optimization Request Please :)

[SaintDog]

Eva, when you have the time, any help you could aid would be of great help :). I have provided the below information as needed and have attached the required files to the post :).

1). Dedicated
2). Dual 2.4GHz Xeons / 1GB RAM / Dual 80GB 7200RPM Drives (non-raid). Apache 1.3.29 / PHP 4.3.3 / 4.0.15

3). MySQL 4.0 Used on standard CPanel installation
4). CPanel standard installation
5). Standard MySQL variables on install, nothing new added or modified
6). See attachment mysqlextended.txt

7).

KeepAlive => On
MaxKeepAliveRequests => 100
KeepAliveTimeout =>
MinSpareServers => 5
MaxSpareServers => 10
StartServers => 5
MaxClients => 150


8). vBulletin 2.x.x and vBulletin 3.0, though I would guess at more 3.0 than 2.x.x.




Thanks as always eva!!!

[eva2000]

just use this my.cnf below and restart mysql


[mysqld]
max_connections = 500
key_buffer = 16M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1024
thread_cache_size = 64
wait_timeout = 1800
connect_timeout = 10
max_allowed_packet = 16M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
skip-innodb

[mysqld_safe]
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16M

[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M

[SaintDog]

Thanks much as always :)