PDA

View Full Version : Server Configuration Help

pulsorock
Wed 2nd Mar '05, 11:45am
Hello,
Recently I been having problems on my board reaching database connection time outs and getting a lot of these emails (http://www.vbulletin.com/forum/showthread.php?t=130839). So I've come here to see how to optimize my server. Any help Would be appreciated.

1. Dedicated Server

2. System Configuration

CPU: Single Pentium 4 - 2.4Ghz / 533Mhz System Bus / 1MB L2 Advanced Transfer Cache
RAM: 1GB DDR 333Mhz (2/ 512MB)
Hard Disk: 80GB 7,200 RPM SATA
MotherBoard: ASUS P4C800 Deluxe / Intel 875P Chipset
OS: Gentoo Linux
Apache/2.0.51
PHP Version 4.3.9
MySQL version 4.0.20


3. No innodb type databases/tables

4. I believe it was compiled using Gentoo's emerge package system.

5. See attachment (top_stats.txt) and also see this post: http://www.vbulletin.com/forum/showthread.php?t=130839

6. See attachment (mysql_var.txt)

7. See attachment (mysql_ext-stat.txt)

8. Other Scripts, like phpAdsNew and custom php for templates and simple db access for content.

9. Average users on vB3: ~150 - Max Users once: ~564

10. PHP Info: http://www.pulsorock.com/phpinfo.php

11. httpd config

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

12. vBulletin Version 3.0.3 (with latest security patch available)

13. No large apache log. Cleared daily with cron job.
eva2000
Fri 4th Mar '05, 12:06pm
woah severely unoptimised there mate ;)

in this order

1. upgrade MySQL to 4.0.23
2. upgrade to PHP 4.3.10
3. change /etc/my.cnf or create my.cnf at /etc/my.cnf with new settings listed below and restart mysql server


[mysqld]
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 = 7200
connect_timeout = 10
tmp_table_size = 32M
max_allowed_packet = 16M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 16M
query_cache_type = 1

[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


4. install eaccelerator from http://eaccelerator.net/InstallEacceleratorUk read http://www.vbulletin.com/forum/showpost.php?p=805040&postcount=441
pulsorock
Fri 4th Mar '05, 12:34pm
woah severely unoptimised there mate ;)

in this order

1. upgrade MySQL to 4.0.23
2. upgrade to PHP 4.3.10
3. change /etc/my.cnf or create my.cnf at /etc/my.cnf with new settings listed below and restart mysql server



4. install eaccelerator from http://eaccelerator.net/InstallEacceleratorUk read http://www.vbulletin.com/forum/showpost.php?p=805040&postcount=441
Thanks a lot... I read someplace (maybe this same forum) that the update on PHP 4.3.10 slowed down some applications. Was that fixed?
eva2000
Fri 4th Mar '05, 12:38pm
should be fine for most folks but the fix is at PHP's end and i believe latest CVS 4.3.x snapshot has it fixed
pulsorock
Fri 4th Mar '05, 12:46pm
should be fine for most folks but the fix is at PHP's end and i believe latest CVS 4.3.x snapshot has it fixed
Ok, thanks... so there should be no problem when using vB, right?

Also, looking at the website of eAccelerator, the latest version is available for Gentoo's Portage System.
2005/02/20 - Update: Getting eAccelerator 0.9.2a on Gentoo
Now, on Gentoo eaccelerator is part of the Portage.

Since my Lunix is running Gentoo, could be fine to update MySQL, PHP and installing eAccelerator using Portage?
eva2000
Sun 6th Mar '05, 1:37am
haven't used Gentoo but should be fine and should be fine for PHP 4.3.10 too
pulsorock
Thu 21st Apr '05, 1:54am
Hi eve, just the make sure I did the correct changes to the my.conf file, here are the files attached. Please note I haven't updated mysql/php yet, I'm waiting that the latest versions become stable on x86 on Gentoo's emerge system to finally upgrade them :(
Hopefully in the next few weeks... thanks for your help :)
eva2000
Fri 22nd Apr '05, 1:58am
who's eve ;) and took your time in getting back to me huh ? :)

looks fine just now PHP 4.3.11 and MySQL 4.0.24 are the versions you need to uprgade to
pulsorock
Fri 22nd Apr '05, 2:11am
who's eve ;) and took your time in getting back to me huh ? :)

looks fine just now PHP 4.3.11 and MySQL 4.0.24 are the versions you need to uprgade to
my bad.. that's what happen when I type sleepy :o
Sorry it took me some time, I was working on the redesign of the page. (www.pulsorock.com) :D
I hope to do the rest of the updates before the month ends :cool: ;)