New Configuration help needed!

[drumsy]

Well, my server admin tells me we're maxed out software wise and need more hardware. I know we've had no problems before with a large amount of users online on our current server. I'm turning to you guys for help once again!

1. Dedicated server
2. Athlon XP 1900
512MB RAM
60 GB Hard Drive / 7200 RPM
RedHat Linux 7.3
Apache 1.3.27
PHP 4.3.2
MySQL 3.23.49
3. N/A
4. Not sure on how MySQL was compiled/installed
5. 4.77, 3.66, 4.24 with 242 users online
6.-7. http://www.honda-acura.net/forums/admin/mysqlinfo.php
8. Our site is the only site on this server. It is the only thing running vBulletin
9. Average: 150-300/Max: 577 (Found via online.php)
10. www.honda-acura.net/forums/phpinfo.php
11. KeepAlive - On
MaxKeepAliveRequests - 100
KeepAliveTimeout - 15
MinSpareServers - 5
MaxSpareServers - 15
StartServers - 5
MaxClients - 130
12. Version 2.3.2

Can someone please tell me what I can change to make things work like butter again. Whether it be MySQL improperly configured or Apache...

Also, we use the Plesk 6 control panel.

[eva2000]

1. upgrade to apache 1.3.29
2. upgrade to mysql 4.0.17 and then use my.cnf like below


[mysqld]
max_connections = 600
key_buffer = 32M
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


but your cpu and ide hdd is your bottleneck it seems

[drumsy]

1. upgrade to apache 1.3.29
2. upgrade to mysql 4.0.17 and then use my.cnf like below



but your cpu and ide hdd is your bottleneck it seems

Tell me what you think about this my.cnf with our current setup:


[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
set-variable = max_connections=500
set-variable = key_buffer = 16M
set-variable = myisam_sort_buffer_size=64M
set-variable = join_buffer_size=1M
set-variable = record_buffer=1M
set-variable = sort_buffer=2M
set-variable = table_cache=1024
set-variable = thread_cache=256
set-variable = wait_timeout=7200
set-variable = connect_timeout=10
set-variable = max_allowed_packet=16M
#set-variable = query_cache_limit = 2M
#set-variable = query_cache_size = 64M
#set-variable = query_cache_type = 1

[safe_mysqld]
open_files_limit=8192

[mysqldump]
quick
set-variable = max_allowed_packet=16M

[myisamchk]
set-variable = key_buffer=128M
set-variable = sort_buffer=128M
set-variable = read_buffer=16M
set-variable = write_buffer=16M

[eva2000]

i'd used the one i recommended ;) for one thing the syntax for mysql 4.0.x is correct in mine although yours is backwards compatible except for a few settings.