For fast Forums?

[Descend]

Hi to all people
today I started my forum on a hard'n'heavy metal website of which I deal with technical problems and other maintenance
(here's the url: http://www.eutk.net/forums)
Unfortunately I noticed that is a little bit slow, probably due to mysql
My server runs on win 2000 with php 4.2.3 and mysql 4.0.5
The machine has 128MB Ram
Can you suggest me what to modify on the settings to quick the scripts?

[bahbah]

Originally posted by Descend
Hi to all people
today I started my forum on a hard'n'heavy metal website of which I deal with technical problems and other maintenance
(here's the url: http://www.eutk.net/forums)
Unfortunately I noticed that is a little bit slow, probably due to mysql
My server runs on win 2000 with php 4.2.3 and mysql 4.0.5
The machine has 128MB Ram
Can you suggest me what to modify on the settings to quick the scripts? The best thing you could do would be to up your memory to 512MB or higher.

What CPU does the server have ?

[walter]

Originally posted by Descend
Hi to all people
today I started my forum on a hard'n'heavy metal website of which I deal with technical problems and other maintenance
(here's the url: http://www.eutk.net/forums)
Unfortunately I noticed that is a little bit slow, probably due to mysql
My server runs on win 2000 with php 4.2.3 and mysql 4.0.5
The machine has 128MB Ram
Can you suggest me what to modify on the settings to quick the scripts? Agreed, you definitely need RAM most! Win2000 on a server needs more than 128 MB to get it fly.

[locja]

seems preety fast for me, what is the connection speed to the internet?

[eva2000]

Originally posted by Descend
Hi to all people
today I started my forum on a hard'n'heavy metal website of which I deal with technical problems and other maintenance
(here's the url: http://www.eutk.net/forums)
Unfortunately I noticed that is a little bit slow, probably due to mysql
My server runs on win 2000 with php 4.2.3 and mysql 4.0.5
The machine has 128MB Ram
Can you suggest me what to modify on the settings to quick the scripts? 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 ?