jblessing
Wed 28th Jul '04, 12:01am
1. is this on dedicated or shared virual server
Dedicated server
2. your server specs.
2.4Ghz Dual Xeon, 2 GB ram
Redhad Linux 7.3
72GB Raid Hard drive
PHP: 4.3.7
MySQL: 4.0.20
Apache: 1.3.31
3. if you use mysql 4.x instead of mysql 3.23.x, do you have any innodb type databases/tables on your server ?
No
4. if possible how mysql was compiled/installed
Not Sure
5. your top stats
User Domain %CPU %MEM Mysql Processes
mysql 19.66 340.85 0.0
Top Process %CPU 99.8 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/access.velegant.com.pid --skip-locking
Top Process %CPU 99.0 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/access.velegant.com.pid --skip-locking
Top Process %CPU 66.0 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/access.velegant.com.pid --skip-locking
theotaku theotaku.com 13.65 42.82 118.2
Top Process %CPU 48.0 httpd [myotaku.com] [/]
Top Process %CPU 30.0 httpd [www.theotaku.com] (http://www.theotaku.com]/) [/bg.gif]
Top Process %CPU 12.4 httpd [www.theotaku.com] (http://www.theotaku.com]/) [/buds.shtml]
boards otakuboards.com 1.51 2.58 17.2
Top Process %CPU 28.0 httpd [www.otakuboards.com] (http://www.otakuboards.com]/) [/usercp.php?]
Top Process %CPU 15.0 httpd [www.otakuboards.com] (http://www.otakuboards.com]/) [/index.php?]
Top Process %CPU 11.5 httpd [www.otakuboards.com] (http://www.otakuboards.com]/) [/forumdisplay.php?f48]
nobody 0.23 0.02 0.0
Top Process %CPU 58.5 gzip
Top Process %CPU 48.0 /usr/local/apache/bin/httpd -DSSL
Top Process %CPU 30.0 /usr/local/apache/bin/httpd -DSSL
6. your mysql configuration variables located at /etc/my.cnf or c:\my.cnf so post the contents inside of my.cnf (minus any passwords of course). If on Windows server if you don't have that file you need to log into telnet and as root user type
set-variable = max_connections=500
safe-show-database
7. your mysql extended-status output which shows entire server's mysql activity status (preferably with a day or 2 worth of mysql uptime for better indication of real activity) either:
http://www.otakuboards.com/mysqlinfo.php (http://www.otakuboards.com/mysqlinfo.php)
8. is your vB the only thing on the server? or other scripts & sites which utilise php and mysql?
vBulletin located at www.otakuboards.com (http://www.otakuboards.com/), custom script located at www.myotaku.com (http://www.myotaku.com/) along with a few others. Its a custom blogging service that allows users to submit art, wallpapers, greeting cards, etc. Over 30k users, approximatly 200 sign up a day. Extremly popular... puts most strain on server. The amount of queries it pushes are approximatly 6-8 per page. Also, all scripts (vBulletin and custom) use pconnect.
9. how many average and max concurrent users on your vB forum ? and what your cookie timeout is ?
Approximatly 100-130, 900 second timeout.
10. create a file named phpinfo.php and place this code in it and post the url/link to it from your web site
http://www.otakuboards.com/index.php?do=phpinfo (http://www.otakuboards.com/index.php?do=phpinfo)
11. 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 - On
MaxKeepAliveRequests - 100
KeepAliveTimeout - 15
MinSpareServers - 5
MaxSpareServers - 10
StartServers - 5
MaxClients - 160
Timeout - 300
12. what version of vB are you running ?
3.0.3
Dedicated server
2. your server specs.
2.4Ghz Dual Xeon, 2 GB ram
Redhad Linux 7.3
72GB Raid Hard drive
PHP: 4.3.7
MySQL: 4.0.20
Apache: 1.3.31
3. if you use mysql 4.x instead of mysql 3.23.x, do you have any innodb type databases/tables on your server ?
No
4. if possible how mysql was compiled/installed
Not Sure
5. your top stats
User Domain %CPU %MEM Mysql Processes
mysql 19.66 340.85 0.0
Top Process %CPU 99.8 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/access.velegant.com.pid --skip-locking
Top Process %CPU 99.0 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/access.velegant.com.pid --skip-locking
Top Process %CPU 66.0 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/access.velegant.com.pid --skip-locking
theotaku theotaku.com 13.65 42.82 118.2
Top Process %CPU 48.0 httpd [myotaku.com] [/]
Top Process %CPU 30.0 httpd [www.theotaku.com] (http://www.theotaku.com]/) [/bg.gif]
Top Process %CPU 12.4 httpd [www.theotaku.com] (http://www.theotaku.com]/) [/buds.shtml]
boards otakuboards.com 1.51 2.58 17.2
Top Process %CPU 28.0 httpd [www.otakuboards.com] (http://www.otakuboards.com]/) [/usercp.php?]
Top Process %CPU 15.0 httpd [www.otakuboards.com] (http://www.otakuboards.com]/) [/index.php?]
Top Process %CPU 11.5 httpd [www.otakuboards.com] (http://www.otakuboards.com]/) [/forumdisplay.php?f48]
nobody 0.23 0.02 0.0
Top Process %CPU 58.5 gzip
Top Process %CPU 48.0 /usr/local/apache/bin/httpd -DSSL
Top Process %CPU 30.0 /usr/local/apache/bin/httpd -DSSL
6. your mysql configuration variables located at /etc/my.cnf or c:\my.cnf so post the contents inside of my.cnf (minus any passwords of course). If on Windows server if you don't have that file you need to log into telnet and as root user type
set-variable = max_connections=500
safe-show-database
7. your mysql extended-status output which shows entire server's mysql activity status (preferably with a day or 2 worth of mysql uptime for better indication of real activity) either:
http://www.otakuboards.com/mysqlinfo.php (http://www.otakuboards.com/mysqlinfo.php)
8. is your vB the only thing on the server? or other scripts & sites which utilise php and mysql?
vBulletin located at www.otakuboards.com (http://www.otakuboards.com/), custom script located at www.myotaku.com (http://www.myotaku.com/) along with a few others. Its a custom blogging service that allows users to submit art, wallpapers, greeting cards, etc. Over 30k users, approximatly 200 sign up a day. Extremly popular... puts most strain on server. The amount of queries it pushes are approximatly 6-8 per page. Also, all scripts (vBulletin and custom) use pconnect.
9. how many average and max concurrent users on your vB forum ? and what your cookie timeout is ?
Approximatly 100-130, 900 second timeout.
10. create a file named phpinfo.php and place this code in it and post the url/link to it from your web site
http://www.otakuboards.com/index.php?do=phpinfo (http://www.otakuboards.com/index.php?do=phpinfo)
11. 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 - On
MaxKeepAliveRequests - 100
KeepAliveTimeout - 15
MinSpareServers - 5
MaxSpareServers - 10
StartServers - 5
MaxClients - 160
Timeout - 300
12. what version of vB are you running ?
3.0.3