Upgrade Suggestions Please

[replicon]

Here's my server configuration :

Windows 2000 Server
IIS5
AMD Thunderbird 850Mhz
512MB RAM
MySQL 3.23.53
VBulletin 2.2.8
PHP 4.2.3
~80 concurrent users during peak.

Problems I'm experiencing :

- During peak, sometimes it's fairly quick (usable quick), but at times it takes up to 1 minute to pull up a thread. I think it depends on how many people are posting at one time?

- CGI error pops up randomly (see below)
CGI Error
The specified CGI application misbehaved by not returning a complete set of HTTP headers. The headers it did return are:


I'm curious what I should upgrade with my current configuration. Should I upgrade the server to a 2.53Ghz P4? Should I upgrade mySQL to use InnoDB or BerkeleyDB tables? Or should I upgrade to MySQL 4.0? If I upgrade to MySQL 4.0, is it stable enough?

Thanks for your help.

[walter]

I would try upgrading memory first before trying to swap the whole server. Windows likes memory a lot. Are your mySql settings already optimized?

[eva2000]

cheapest and most effective upgrade is to change over to Red Hat 7.3 linux ;)

[replicon]

Originally posted by walter
I would try upgrading memory first before trying to swap the whole server. Windows likes memory a lot. Are your mySql settings already optimized?

Memory is not an issue, I've been hitting about 380mb usage, nothing is getting swapped. CPU is pretty high, mostly on the mySQL side and IIS side (PHP parsing). mySQL settings have been tweaked/optimized twice now, when I hit limits using the default configuration.

Originally posted by eva2000
cheapest and most effective upgrade is to change over to Red Hat 7.3 linux ;)

The server originally ran slackware, and was upgraded/downgraded to Windows 2000 due to company policy. I did not see any performance degradation moving OS's other than the rare CGI errors during peak (I blame MS IIS's crappy CGI support).

OK Let me rephrase my question... is it worthwhile to move to MySQL 4 or enable InnoDB/Berkeley transaction support? Will that improve the lag time during peak?

[eva2000]

Originally posted by replicon
Memory is not an issue, I've been hitting about 380mb usage, nothing is getting swapped. CPU is pretty high, mostly on the mySQL side and IIS side (PHP parsing). mySQL settings have been tweaked/optimized twice now, when I hit limits using the default configuration.



The server originally ran slackware, and was upgraded/downgraded to Windows 2000 due to company policy. I did not see any performance degradation moving OS's other than the rare CGI errors during peak (I blame MS IIS's crappy CGI support).

OK Let me rephrase my question... is it worthwhile to move to MySQL 4 or enable InnoDB/Berkeley transaction support? Will that improve the lag time during peak? mysql 4 or innodb will no help with your errors

your server probably needs retweaking as optimising mysql is a ongoing process

let me see what i can do :)

please provide the following

1. your server specs, such as mysql and php version
2. if possible how mysql was compiled/installed
3. your top stats
4. your mysql configuration variables located at /etc/my.cnf or c:\my.cnf if on Windows server if you don't have that file you need to log into telnet and as root user type

mysqladmin -u root -p variables

copy and paste output here

5. your mysql extended-status output either still telnet as root user type

mysqladmin -u root -p extended-status

copy and paste output here

or preferred is to installed extended-status output script which is either located

- in your vB 2.2.6 or higher vB version's zip file extra's folder, upload mysqlinfo.php script to your site or if you're on an pre vB 2.2.6 install go to
- http://vbulletin.com/forum/showthread.php?threadid=3477 and install that scrip making sure to edit $mysqllogin line with your own mysqlusername and password

and post url to that here

6. oh and is your vB the only thing on the server? or other scripts? sites?

7. how many average and max concurrent users on your vB forum ?

8. create a file named phpinfo.php and place this code in it and post the url/link to it from your web site

<?
phpinfo();
?>

i.e. yourdomain.com/phpinfo.php

9. if you run Apache and you have your own dedicated server or access to your httpd.conf (apache configuration file) can you post the values you have set for the following :

KeepAlive
MaxKeepAliveRequests
KeepAliveTimeout
MinSpareServers
MaxSpareServers
StartServers
MaxClients

10. what version of vB are you running ?