Mike Warner
Wed 3rd Sep '03, 2:00pm
I have just moved my largish site to a dedicated server. This is my first experience with dedicated hosting and this is really a very steep learning curve. I'm after the optimum settings for my site - but have no idea what most of the settings mean. I'll have to rely on your experience to guide me on this one.
One thing I have noticed is that when clicking on a link, it can sometimes take a while before anything happens. Saying that, once it does start "happening" it is extremely quick. This pause is only really noticeable with 150+ users online, but can be anything from 2 seconds to 20 seconds. Many users have experienced this.
In the vBulletin CP I do not have server loads showing up. I know this is a server setting, but I don't know what. Does anyone know how to enable this feature on my server?
Many thanks in advance for your help. My server details are as follows:
1. Is this on dedicated or shared virtual server?
Dedicated with Rackshack
2. Your server specs. For example:
Single P4 2GHz
1GB DDR RAM
2x 80GB EIDE non raid
Redhat Linux 7.3 (running Ensim pro)
Apache/IIS version: Apache 1.3.27
PHP version: Php 4.2.2
MySQL version: Mysql 3.23.56
3. If you use mysql 4.x instead of mysql 3.23.x, do you have any innodb type databases/tables on your server?
Not applicable.
4. If possible how mysql was compiled/installed
Not sure - was already installed with server
5. Top stats
5:38pm up 7 days, 23:58, 1 user, load average: 0.71, 0.95, 1.16
179 processes: 178 sleeping, 1 running, 0 zombie, 0 stopped
CPU states: 13.0% user, 7.8% system, 0.5% nice, 78.5% idle
Mem: 1023104K av, 968412K used, 54692K free, 0K shrd, 30756K buff
Swap: 2048276K av, 8988K used, 2039288K free 799644K cached
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND
30466 admin 16 0 1136 1136 836 R 4.9 0.1 0:02 top
4178 mysql 26 10 37332 36M 2232 S N 0.7 3.6 1:40 mysqld
30022 apache 15 0 8840 8840 8424 S 0.5 0.8 0:00 httpd
9220 mysql 25 10 37332 36M 2232 S N 0.2 3.6 0:10 mysqld
9762 mysql 25 10 37332 36M 2232 S N 0.2 3.6 2:50 mysqld
9957 mysql 25 10 37332 36M 2232 S N 0.2 3.6 2:49 mysqld
30148 apache 15 0 8840 8840 8424 S 0.2 0.8 0:00 httpd
30654 apache 15 0 8840 8840 8452 S 0.2 0.8 0:00 httpd
1 root 15 0 480 432 416 S 0.0 0.0 0:06 init
2 root 15 0 0 0 0 SW 0.0 0.0 0:00 keventd
3 root 15 0 0 0 0 SW 0.0 0.0 0:00 kapmd
4 root 34 19 0 0 0 SWN 0.0 0.0 0:00 ksoftirqd_CPU0
5 root 15 0 0 0 0 SW 0.0 0.0 0:11 kswapd
6 root 25 0 0 0 0 SW 0.0 0.0 0:00 bdflush
7 root 15 0 0 0 0 SW 0.0 0.0 0:00 kupdated
8 root 25 0 0 0 0 SW 0.0 0.0 0:00 mdrecoveryd
12 root 15 0 0 0 0 SW 0.0 0.0 1:32 kjournald
94 root 15 0 0 0 0 SW 0.0 0.0 0:00 khubd
290 root 15 0 0 0 0 SW 0.0 0.0 0:00 kjournald
291 root 15 0 0 0 0 SW 0.0 0.0 0:00 kjournald
627 root 15 0 0 0 0 SW 0.0 0.0 0:00 eth0
827 root 15 0 540 512 452 S 0.0 0.0 0:02 syslogd
836 root 15 0 1068 408 408 S 0.0 0.0 0:00 klogd
900 named 15 0 2728 2444 1888 S 0.0 0.2 0:00 named
902 named 15 0 2728 2444 1888 S 0.0 0.2 0:00 named
904 named 15 0 2728 2444 1888 S 0.0 0.2 0:00 named
905 named 15 0 2728 2444 1888 S 0.0 0.2 0:00 named
906 named 15 0 2728 2444 1888 S 0.0 0.2 0:00 named
923 root 16 0 1340 1156 1076 S 0.0 0.1 0:00 sshd
943 root 15 0 1160 1040 960 S 0.0 0.1 0:01 sshd
978 root 15 0 876 768 684 S 0.0 0.0 0:00 xinetd
1188 postgres 15 0 1768 1536 1480 S 0.0 0.1 0:00 postmaster
1198 postgres 15 0 1784 1488 1460 S 0.0 0.1 0:00 postmaster
6. Your Mysql configuration variables located at /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
7. Your Mysql extended-status output either still telnet as root user type
+--------------------------+------------+
| Variable_name | Value |
+--------------------------+------------+
| Aborted_clients | 2 |
| Aborted_connects | 1 |
| Bytes_received | 291532949 |
| Bytes_sent | 3960394021 |
| Com_admin_commands | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 47038 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_commit | 0 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 0 |
| Com_delete | 5242 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_flush | 0 |
| Com_grant | 0 |
| Com_insert | 6909 |
| Com_insert_select | 211 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 4 |
| Com_optimize | 0 |
| Com_purge | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 2476 |
| Com_replace_select | 6 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 0 |
| Com_select | 1067112 |
| Com_set_option | 91 |
| Com_show_binlogs | 0 |
| Com_show_create | 91 |
| Com_show_databases | 0 |
| Com_show_fields | 91 |
| Com_show_grants | 0 |
| Com_show_keys | 0 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_open_tables | 0 |
| Com_show_processlist | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 1 |
| Com_show_innodb_status | 0 |
| Com_show_tables | 5 |
| Com_show_variables | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 0 |
| Com_update | 159190 |
| Connections | 94280 |
| Created_tmp_disk_tables | 400 |
| Created_tmp_tables | 35870 |
| Created_tmp_files | 0 |
| Delayed_insert_threads | 1 |
| Delayed_writes | 275 |
| Delayed_errors | 2 |
| Flush_commands | 1 |
| Handler_delete | 7115 |
| Handler_read_first | 19698 |
| Handler_read_key | 12124507 |
| Handler_read_next | 731651612 |
| Handler_read_prev | 0 |
| Handler_read_rnd | 23150986 |
| Handler_read_rnd_next | 367939460 |
| Handler_update | 163863 |
| Handler_write | 2590656 |
| Key_blocks_used | 15582 |
| Key_read_requests | 92827791 |
| Key_reads | 145483 |
| Key_write_requests | 75771 |
| Key_writes | 72994 |
| Max_used_connections | 69 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 482 |
| Open_files | 507 |
| Open_streams | 0 |
| Opened_tables | 488 |
| Questions | 1382748 |
| Select_full_join | 399 |
| Select_full_range_join | 0 |
| Select_range | 253129 |
| Select_range_check | 0 |
| Select_scan | 211169 |
| Slave_running | OFF |
| Slave_open_temp_tables | 0 |
| Slow_launch_threads | 1 |
| Slow_queries | 288 |
| Sort_merge_passes | 0 |
| Sort_range | 227787 |
| Sort_rows | 28784760 |
| Sort_scan | 121990 |
| Table_locks_immediate | 1491954 |
| Table_locks_waited | 12616 |
| Threads_cached | 69 |
| Threads_created | 70 |
| Threads_connected | 2 |
| Threads_running | 1 |
| Uptime | 74741 |
+--------------------------+------------+
8. Oh and is your vB the only thing on the server? Or other scripts? Sites?
The only items on the server are the vBulletin forums, PhotoPost Pro and a few static pages.
9. How many average and maximum concurrent users are on your vB forums?
In the evening (GMT) there are usually 150+ users. During the day it is rarely below 70. The peek is around 270. During winter months, the forums are busier with over 200 being a daily occurrence.
10. Upload phpinfo.php and a link to it from your web site
http://www.migweb.co.uk/forums/admin/phpinfo.php
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 150
12. Which version of vB are you running?
2.3.2
One thing I have noticed is that when clicking on a link, it can sometimes take a while before anything happens. Saying that, once it does start "happening" it is extremely quick. This pause is only really noticeable with 150+ users online, but can be anything from 2 seconds to 20 seconds. Many users have experienced this.
In the vBulletin CP I do not have server loads showing up. I know this is a server setting, but I don't know what. Does anyone know how to enable this feature on my server?
Many thanks in advance for your help. My server details are as follows:
1. Is this on dedicated or shared virtual server?
Dedicated with Rackshack
2. Your server specs. For example:
Single P4 2GHz
1GB DDR RAM
2x 80GB EIDE non raid
Redhat Linux 7.3 (running Ensim pro)
Apache/IIS version: Apache 1.3.27
PHP version: Php 4.2.2
MySQL version: Mysql 3.23.56
3. If you use mysql 4.x instead of mysql 3.23.x, do you have any innodb type databases/tables on your server?
Not applicable.
4. If possible how mysql was compiled/installed
Not sure - was already installed with server
5. Top stats
5:38pm up 7 days, 23:58, 1 user, load average: 0.71, 0.95, 1.16
179 processes: 178 sleeping, 1 running, 0 zombie, 0 stopped
CPU states: 13.0% user, 7.8% system, 0.5% nice, 78.5% idle
Mem: 1023104K av, 968412K used, 54692K free, 0K shrd, 30756K buff
Swap: 2048276K av, 8988K used, 2039288K free 799644K cached
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND
30466 admin 16 0 1136 1136 836 R 4.9 0.1 0:02 top
4178 mysql 26 10 37332 36M 2232 S N 0.7 3.6 1:40 mysqld
30022 apache 15 0 8840 8840 8424 S 0.5 0.8 0:00 httpd
9220 mysql 25 10 37332 36M 2232 S N 0.2 3.6 0:10 mysqld
9762 mysql 25 10 37332 36M 2232 S N 0.2 3.6 2:50 mysqld
9957 mysql 25 10 37332 36M 2232 S N 0.2 3.6 2:49 mysqld
30148 apache 15 0 8840 8840 8424 S 0.2 0.8 0:00 httpd
30654 apache 15 0 8840 8840 8452 S 0.2 0.8 0:00 httpd
1 root 15 0 480 432 416 S 0.0 0.0 0:06 init
2 root 15 0 0 0 0 SW 0.0 0.0 0:00 keventd
3 root 15 0 0 0 0 SW 0.0 0.0 0:00 kapmd
4 root 34 19 0 0 0 SWN 0.0 0.0 0:00 ksoftirqd_CPU0
5 root 15 0 0 0 0 SW 0.0 0.0 0:11 kswapd
6 root 25 0 0 0 0 SW 0.0 0.0 0:00 bdflush
7 root 15 0 0 0 0 SW 0.0 0.0 0:00 kupdated
8 root 25 0 0 0 0 SW 0.0 0.0 0:00 mdrecoveryd
12 root 15 0 0 0 0 SW 0.0 0.0 1:32 kjournald
94 root 15 0 0 0 0 SW 0.0 0.0 0:00 khubd
290 root 15 0 0 0 0 SW 0.0 0.0 0:00 kjournald
291 root 15 0 0 0 0 SW 0.0 0.0 0:00 kjournald
627 root 15 0 0 0 0 SW 0.0 0.0 0:00 eth0
827 root 15 0 540 512 452 S 0.0 0.0 0:02 syslogd
836 root 15 0 1068 408 408 S 0.0 0.0 0:00 klogd
900 named 15 0 2728 2444 1888 S 0.0 0.2 0:00 named
902 named 15 0 2728 2444 1888 S 0.0 0.2 0:00 named
904 named 15 0 2728 2444 1888 S 0.0 0.2 0:00 named
905 named 15 0 2728 2444 1888 S 0.0 0.2 0:00 named
906 named 15 0 2728 2444 1888 S 0.0 0.2 0:00 named
923 root 16 0 1340 1156 1076 S 0.0 0.1 0:00 sshd
943 root 15 0 1160 1040 960 S 0.0 0.1 0:01 sshd
978 root 15 0 876 768 684 S 0.0 0.0 0:00 xinetd
1188 postgres 15 0 1768 1536 1480 S 0.0 0.1 0:00 postmaster
1198 postgres 15 0 1784 1488 1460 S 0.0 0.1 0:00 postmaster
6. Your Mysql configuration variables located at /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
7. Your Mysql extended-status output either still telnet as root user type
+--------------------------+------------+
| Variable_name | Value |
+--------------------------+------------+
| Aborted_clients | 2 |
| Aborted_connects | 1 |
| Bytes_received | 291532949 |
| Bytes_sent | 3960394021 |
| Com_admin_commands | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 47038 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_commit | 0 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 0 |
| Com_delete | 5242 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_flush | 0 |
| Com_grant | 0 |
| Com_insert | 6909 |
| Com_insert_select | 211 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 4 |
| Com_optimize | 0 |
| Com_purge | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 2476 |
| Com_replace_select | 6 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 0 |
| Com_select | 1067112 |
| Com_set_option | 91 |
| Com_show_binlogs | 0 |
| Com_show_create | 91 |
| Com_show_databases | 0 |
| Com_show_fields | 91 |
| Com_show_grants | 0 |
| Com_show_keys | 0 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_open_tables | 0 |
| Com_show_processlist | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 1 |
| Com_show_innodb_status | 0 |
| Com_show_tables | 5 |
| Com_show_variables | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 0 |
| Com_update | 159190 |
| Connections | 94280 |
| Created_tmp_disk_tables | 400 |
| Created_tmp_tables | 35870 |
| Created_tmp_files | 0 |
| Delayed_insert_threads | 1 |
| Delayed_writes | 275 |
| Delayed_errors | 2 |
| Flush_commands | 1 |
| Handler_delete | 7115 |
| Handler_read_first | 19698 |
| Handler_read_key | 12124507 |
| Handler_read_next | 731651612 |
| Handler_read_prev | 0 |
| Handler_read_rnd | 23150986 |
| Handler_read_rnd_next | 367939460 |
| Handler_update | 163863 |
| Handler_write | 2590656 |
| Key_blocks_used | 15582 |
| Key_read_requests | 92827791 |
| Key_reads | 145483 |
| Key_write_requests | 75771 |
| Key_writes | 72994 |
| Max_used_connections | 69 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 482 |
| Open_files | 507 |
| Open_streams | 0 |
| Opened_tables | 488 |
| Questions | 1382748 |
| Select_full_join | 399 |
| Select_full_range_join | 0 |
| Select_range | 253129 |
| Select_range_check | 0 |
| Select_scan | 211169 |
| Slave_running | OFF |
| Slave_open_temp_tables | 0 |
| Slow_launch_threads | 1 |
| Slow_queries | 288 |
| Sort_merge_passes | 0 |
| Sort_range | 227787 |
| Sort_rows | 28784760 |
| Sort_scan | 121990 |
| Table_locks_immediate | 1491954 |
| Table_locks_waited | 12616 |
| Threads_cached | 69 |
| Threads_created | 70 |
| Threads_connected | 2 |
| Threads_running | 1 |
| Uptime | 74741 |
+--------------------------+------------+
8. Oh and is your vB the only thing on the server? Or other scripts? Sites?
The only items on the server are the vBulletin forums, PhotoPost Pro and a few static pages.
9. How many average and maximum concurrent users are on your vB forums?
In the evening (GMT) there are usually 150+ users. During the day it is rarely below 70. The peek is around 270. During winter months, the forums are busier with over 200 being a daily occurrence.
10. Upload phpinfo.php and a link to it from your web site
http://www.migweb.co.uk/forums/admin/phpinfo.php
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 150
12. Which version of vB are you running?
2.3.2