Server Optimization - Dual Xeon

[WebmasterAJ]

Hello,

I just got a new server for the upcoming season... it's a nice one from ThePlanet.





This is a dedicated server
cpu speed/type single or dual cpus): dual xeon 2.8 processor
how much memory installed: 1GB registered ecc Ram
hard drive type/configuration: 73GB SCSI
linux distributor or windows version: redhat enterprise 3
apache/IIS version: apache 2.0.46
PHP version: php 4.3.10
MySQL version: mysql 4.0.23a
NA
By the people at ThePlanet
http://www.finheaven.com/topstats.jpg (http://www.finheaven.com/topstats.jpg)
MySQL conf:

[mysqld]
innodb_data_file_path=ibdata1:10M:autoextend
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid



http://www.finheaven.com/boardvb2/mysqlinfo.php (http://www.finheaven.com/boardvb2/mysqlinfo.php)
There are several other smaller scripts that use the server; however, vB is of main concern.
Average... there are usually 500 users on at once. Our max is 1426. Our cookie timeout is 900.
http://www.finheaven.com/phpinfo.php (http://www.finheaven.com/phpinfo.php)
httpd.conf information
KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 15
MinSpareServers 5
MaxSpareServers 20
StartServers 8
MaxClients 150
We are running on 3.0.2, we plan to upgrade shortly.
Nope
Thank you once again for all your time and energy! I really appreciate all that you do for myself and the vBulletin community.

Sincerely,
Andrew Tatum

[WebmasterAJ]

Just wanted to let you know that I upgraded to vB 3.0.7 and installed eAccelerator for caching.

Thanks again for all your help!

- AJ

[BamaStangGuy]

Just wanted to let you know that I upgraded to vB 3.0.7 and installed eAccelerator for caching.

Thanks again for all your help!

- AJ
Change eaccelerator.compress_level 9 to eaccelerator.compress_level 1
upgrade mysql to 4.0.23
upgrade php to 4.3.10
upgrade apache to 2.0.53


You should notice a huge improvement after upgrading mysql apache and php :)

[WebmasterAJ]

I'll try and get to that tonight. The good thing about eAccelerator being in the php.d folder is that I don't have to recompile it every time now... w00t

[BamaStangGuy]

I'll try and get to that tonight. The good thing about eAccelerator being in the php.d folder is that I don't have to recompile it every time now... w00t
After you upgrade all those I am sure someone will give you a nice my.conf to try out

[WebmasterAJ]

Alright... so I updated MySQL to 4.0.23a and PHP 4.3.10... I couldn't find an update for Apache through Plesk. Not to mention that vBulletin has been updated... Finally, eAccelerator was installed and compression level is set at 1. Dang, that's a lot of work.

So, all said and done... could I get a server optimization? Hopefully I can get this server really kickin... :cool:

Thanks a ton for all your help!

- AJ

[eva2000]

change my.cnf to below and you'd notice instant improvment


[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-innodb
max_connections = 650
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 = 10800
connect_timeout = 10
tmp_table_size = 32M
max_allowed_packet = 16M
max_connect_errors = 10
query_cache_limit = 2M
query_cache_size = 64M
query_cache_type = 1

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16M

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


restart mysql after

[WebmasterAJ]

Thanks George for all your help. I updates the my.cnf and vB is very, very quick. It's so amazing to see the difference. Thanks once again for all your time!

[eva2000]

no probs that's what I'm here for :D

[WebmasterAJ]

Hey George...

Just updated to MySQL 4.11... is there anything new I shold be aware of?

Once again, thanks for all your help!

[eva2000]

i hope you mean MySQL 4.0.24 and PHP 4.3.11 ?

[WebmasterAJ]

Eva,

We are currently running MySQL 4.1.11 and PHP 4.3.10. Sorry.

[WebmasterAJ]

I know we're running PHP 4.3.10... and there have been some people talking about slower running vB, but we really haven't noticed that change. So we haven't upgraded that yet...

[Zachery]

Upgrade to php 4.3.11 for php preformance increases.

[eva2000]

yeah upgrade PHP 4.3.11 should see lower cpu load a bit