bigbigsavings
Mon 12th Feb '01, 7:46pm
Please help us learn more about improving the speed of the forum software on our servers by taking the time to answer the following questions.
Doing so may help others facing similar circumstances, and we may all learn from the results.
Server / Box / Machine
---------------------------------
What operating system and version are you using?
Note: You can do
uname -sr
at your server login prompt to get the operating system and version on most Unix systems.
Did you install any operating system patches with the goal to increase performance of your BBS software? If so, what patches in particular?
How much physical RAM do you have on the server?
How much SWAP drive space do you have on the server?
What type of CPU do you have installed on the server (ie. dual PIII 700 Mhz, Sun Sparc 450Mhz, etc.)?
MySQL
------------
What version of mySQL are you using?
Are you using a pre-complied binary or did you compile mySQL?
If you compiled mySQL, what configure settings did you use?
If you compiled mySQL, did you use make or gmake? Did you use any special make settings? If so, what settings?
If you compiled mySQL, what version of cc/gcc did you use?
Are you using pconnect or connect for your PHP to mySQL connection string?
Are you using any "my.cnf" settings (/etc/my.cnf or /usr/local/mysql/var/my.cnf) to tell mySQL how to deal with connections et all? If so, what are your my.cnf settings?
Forum Software
-----------------------
Did you make any changes to improve speed / optimization? If so, what are those changes?
Did you make any changes to the mySQL databases the forum software uses in terms of keys, indices, etc.? If so, what changes did you make?
PHP
-------
What version of PHP are you using?
Are you using the CGI version of PHP or the Apache (mod_php) Version?
What configure line did you use prior to making PHP?
Do you have any special php.ini settings for the forum software? If so, what are they?
Are you using any PHP caching or PHP optimization software? If so, what software?
Web Server
-----------------
What Web Server software are you using (Apache, Microsoft IIS, Other)?
What version of Web server software are you using?
If you are using Apache, what modules are compiled into Apache
At the server prompt, do
httpd -l
Infrastructure
-------------------
Are you running the forum software on one box (server)?
Are you load balancing the forum software? If so, on how many servers?
Are you using a separate database server for the database?
If you have multiple servers, are you using a private IP address (10.whatever) as part of your connection string to connect from PHP to mySQL or are you using the actual (browsable / routable) IP address of the database server?
Thank you for your time and help!!!
Doing so may help others facing similar circumstances, and we may all learn from the results.
Server / Box / Machine
---------------------------------
What operating system and version are you using?
Note: You can do
uname -sr
at your server login prompt to get the operating system and version on most Unix systems.
Did you install any operating system patches with the goal to increase performance of your BBS software? If so, what patches in particular?
How much physical RAM do you have on the server?
How much SWAP drive space do you have on the server?
What type of CPU do you have installed on the server (ie. dual PIII 700 Mhz, Sun Sparc 450Mhz, etc.)?
MySQL
------------
What version of mySQL are you using?
Are you using a pre-complied binary or did you compile mySQL?
If you compiled mySQL, what configure settings did you use?
If you compiled mySQL, did you use make or gmake? Did you use any special make settings? If so, what settings?
If you compiled mySQL, what version of cc/gcc did you use?
Are you using pconnect or connect for your PHP to mySQL connection string?
Are you using any "my.cnf" settings (/etc/my.cnf or /usr/local/mysql/var/my.cnf) to tell mySQL how to deal with connections et all? If so, what are your my.cnf settings?
Forum Software
-----------------------
Did you make any changes to improve speed / optimization? If so, what are those changes?
Did you make any changes to the mySQL databases the forum software uses in terms of keys, indices, etc.? If so, what changes did you make?
PHP
-------
What version of PHP are you using?
Are you using the CGI version of PHP or the Apache (mod_php) Version?
What configure line did you use prior to making PHP?
Do you have any special php.ini settings for the forum software? If so, what are they?
Are you using any PHP caching or PHP optimization software? If so, what software?
Web Server
-----------------
What Web Server software are you using (Apache, Microsoft IIS, Other)?
What version of Web server software are you using?
If you are using Apache, what modules are compiled into Apache
At the server prompt, do
httpd -l
Infrastructure
-------------------
Are you running the forum software on one box (server)?
Are you load balancing the forum software? If so, on how many servers?
Are you using a separate database server for the database?
If you have multiple servers, are you using a private IP address (10.whatever) as part of your connection string to connect from PHP to mySQL or are you using the actual (browsable / routable) IP address of the database server?
Thank you for your time and help!!!