Ron DiPaola
Wed 4th Aug '04, 12:08pm
Just moved to a new server and even though I am the only user right now, vB seems very slow. Looking for advice on optimizing the server.
1. is this on dedicated or shared virtual server
Virtual
2. your server specs.
Processor Info
Processor #1 Vendor: GenuineIntel
Processor #1 Name: Intel(R) Xeon(TM) CPU 2.66GHz
Processor #1 speed: 2665.969 MHz
Processor #1 cache size: 512 KB
Processor #2 Vendor: GenuineIntel
Processor #2 Name: Intel(R) Xeon(TM) CPU 2.66GHz
Processor #2 speed: 2665.969 MHz
Processor #2 cache size: 512 KB
Processor #3 Vendor: GenuineIntel
Processor #3 Name: Intel(R) Xeon(TM) CPU 2.66GHz
Processor #3 speed: 2665.969 MHz
Processor #3 cache size: 512 KB
Processor #4 Vendor: GenuineIntel
Processor #4 Name: Intel(R) Xeon(TM) CPU 2.66GHz
Processor #4 speed: 2665.969 MHz
Processor #4 cache size: 512 KB
Burstable RAM: 4GB
Minimum RAM: 512MB
Physical Drives
Current Memory Usage
total used free shared buffers cached
Mem: 4134976 3942692 192284 0 367496 1972128
-/+ buffers/cache: 1603068 2531908
Swap: 8385920 566388 7819532
Total: 12520896 4509080 8011816
Current Disk Usage
Filesystem Size Used Avail Use% Mounted on
/dev/vzfs 20G 4.7G 16G 24% /
Linux 2.4.20-021stab022.1.777-enterprise #1 SMP Sat Jun 26 16:35:28 MSD 2004 i686 i686 i386 GNU/Linux
Server Version: Apache/1.3.31 (Unix) mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 PHP/4.3.8 FrontPage/5.0.2.2634a mod_ssl/2.8.19 OpenSSL/0.9.7a
Server Built: Jul 20 2004 15:57:20
Mysql: 4.0.20
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
by hosting provider
5. your top stats
up 13 days, 15:34, 1 user, load average: 0.01, 0.02, 0.01
71 processes: 70 sleeping, 1 running, 0 zombie, 0 stopped
6. your mysql configuration variables located at /etc/my.cnf
[mysqld]
set-variable = max_connections=500
safe-show-database
7. your mysql extended-status output which shows entire server's mysql activity status
mysqladmin -u root -p extended-status
+--------------------------+------------+
| Variable_name | Value |
+--------------------------+------------+
| Aborted_clients | 38 |
| Aborted_connects | 30 |
| Bytes_received | 3488716815 |
| Bytes_sent | 24351541 |
| Com_admin_commands | 75 |
| Com_alter_table | 679 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 342 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_commit | 0 |
| Com_create_db | 8 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 351 |
| Com_delete | 4232 |
| Com_delete_multi | 0 |
| Com_drop_db | 5 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 329 |
| Com_flush | 85 |
| Com_grant | 71 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_insert | 83076 |
| Com_insert_select | 0 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 2453 |
| Com_optimize | 0 |
| Com_purge | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 92 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 1171 |
| Com_set_option | 0 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_create | 0 |
| Com_show_databases | 161 |
| Com_show_fields | 100 |
| Com_show_grants | 29 |
| Com_show_keys | 10 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_processlist | 3935 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 3 |
| Com_show_innodb_status | 0 |
| Com_show_tables | 212 |
| Com_show_variables | 76 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 2446 |
| Com_update | 318 |
| Connections | 6548 |
| Created_tmp_disk_tables | 5 |
| Created_tmp_tables | 25 |
| Created_tmp_files | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 15377 |
| Handler_read_first | 4867 |
| Handler_read_key | 7497 |
| Handler_read_next | 67694 |
| Handler_read_prev | 30 |
| Handler_read_rnd | 14890 |
| Handler_read_rnd_next | 2219134 |
| Handler_rollback | 3 |
| Handler_update | 15010 |
| Handler_write | 25289884 |
| Key_blocks_used | 7793 |
| Key_read_requests | 98427818 |
| Key_reads | 1894819 |
| Key_write_requests | 30323019 |
| Key_writes | 2403174 |
| Max_used_connections | 10 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 64 |
| Open_files | 124 |
| Open_streams | 0 |
| Opened_tables | 2231 |
| Questions | 106673 |
| Qcache_queries_in_cache | 0 |
| Qcache_inserts | 0 |
| Qcache_hits | 0 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 0 |
| Qcache_free_memory | 0 |
| Qcache_free_blocks | 0 |
| Qcache_total_blocks | 0 |
| Rpl_status | NULL |
| Select_full_join | 5 |
| Select_full_range_join | 11 |
| Select_range | 129 |
| Select_range_check | 0 |
| Select_scan | 540 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 165 |
| Sort_merge_passes | 0 |
| Sort_range | 5 |
| Sort_rows | 14839 |
| Sort_scan | 95 |
| Table_locks_immediate | 87551 |
| Table_locks_waited | 0 |
| Threads_cached | 0 |
| Threads_created | 6547 |
| Threads_connected | 10 |
| Threads_running | 1 |
| Uptime | 1180364 |
+--------------------------+------------+
8. is your vB the only thing on the server? or other scripts & sites which utilise php and mysql?
other scripts that use php/mysql are tiny, insignificant
9. how many average and max concurrent users on your vB forum ? and what your cookie timeout is ?
80 on average, max was 173
cookie timeout: 900
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://66.232.156.209/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 :
the httpd.conf file i have access to does not contain any of these values
KeepAlive
MaxKeepAliveRequests
KeepAliveTimeout
MinSpareServers
MaxSpareServers
StartServers
MaxClients
12. what version of vB are you running ?
3.03
Thanks very much in advance.
1. is this on dedicated or shared virtual server
Virtual
2. your server specs.
Processor Info
Processor #1 Vendor: GenuineIntel
Processor #1 Name: Intel(R) Xeon(TM) CPU 2.66GHz
Processor #1 speed: 2665.969 MHz
Processor #1 cache size: 512 KB
Processor #2 Vendor: GenuineIntel
Processor #2 Name: Intel(R) Xeon(TM) CPU 2.66GHz
Processor #2 speed: 2665.969 MHz
Processor #2 cache size: 512 KB
Processor #3 Vendor: GenuineIntel
Processor #3 Name: Intel(R) Xeon(TM) CPU 2.66GHz
Processor #3 speed: 2665.969 MHz
Processor #3 cache size: 512 KB
Processor #4 Vendor: GenuineIntel
Processor #4 Name: Intel(R) Xeon(TM) CPU 2.66GHz
Processor #4 speed: 2665.969 MHz
Processor #4 cache size: 512 KB
Burstable RAM: 4GB
Minimum RAM: 512MB
Physical Drives
Current Memory Usage
total used free shared buffers cached
Mem: 4134976 3942692 192284 0 367496 1972128
-/+ buffers/cache: 1603068 2531908
Swap: 8385920 566388 7819532
Total: 12520896 4509080 8011816
Current Disk Usage
Filesystem Size Used Avail Use% Mounted on
/dev/vzfs 20G 4.7G 16G 24% /
Linux 2.4.20-021stab022.1.777-enterprise #1 SMP Sat Jun 26 16:35:28 MSD 2004 i686 i686 i386 GNU/Linux
Server Version: Apache/1.3.31 (Unix) mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 PHP/4.3.8 FrontPage/5.0.2.2634a mod_ssl/2.8.19 OpenSSL/0.9.7a
Server Built: Jul 20 2004 15:57:20
Mysql: 4.0.20
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
by hosting provider
5. your top stats
up 13 days, 15:34, 1 user, load average: 0.01, 0.02, 0.01
71 processes: 70 sleeping, 1 running, 0 zombie, 0 stopped
6. your mysql configuration variables located at /etc/my.cnf
[mysqld]
set-variable = max_connections=500
safe-show-database
7. your mysql extended-status output which shows entire server's mysql activity status
mysqladmin -u root -p extended-status
+--------------------------+------------+
| Variable_name | Value |
+--------------------------+------------+
| Aborted_clients | 38 |
| Aborted_connects | 30 |
| Bytes_received | 3488716815 |
| Bytes_sent | 24351541 |
| Com_admin_commands | 75 |
| Com_alter_table | 679 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 342 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_commit | 0 |
| Com_create_db | 8 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 351 |
| Com_delete | 4232 |
| Com_delete_multi | 0 |
| Com_drop_db | 5 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 329 |
| Com_flush | 85 |
| Com_grant | 71 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_insert | 83076 |
| Com_insert_select | 0 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 2453 |
| Com_optimize | 0 |
| Com_purge | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 92 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 1171 |
| Com_set_option | 0 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_create | 0 |
| Com_show_databases | 161 |
| Com_show_fields | 100 |
| Com_show_grants | 29 |
| Com_show_keys | 10 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_processlist | 3935 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 3 |
| Com_show_innodb_status | 0 |
| Com_show_tables | 212 |
| Com_show_variables | 76 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 2446 |
| Com_update | 318 |
| Connections | 6548 |
| Created_tmp_disk_tables | 5 |
| Created_tmp_tables | 25 |
| Created_tmp_files | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 15377 |
| Handler_read_first | 4867 |
| Handler_read_key | 7497 |
| Handler_read_next | 67694 |
| Handler_read_prev | 30 |
| Handler_read_rnd | 14890 |
| Handler_read_rnd_next | 2219134 |
| Handler_rollback | 3 |
| Handler_update | 15010 |
| Handler_write | 25289884 |
| Key_blocks_used | 7793 |
| Key_read_requests | 98427818 |
| Key_reads | 1894819 |
| Key_write_requests | 30323019 |
| Key_writes | 2403174 |
| Max_used_connections | 10 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 64 |
| Open_files | 124 |
| Open_streams | 0 |
| Opened_tables | 2231 |
| Questions | 106673 |
| Qcache_queries_in_cache | 0 |
| Qcache_inserts | 0 |
| Qcache_hits | 0 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 0 |
| Qcache_free_memory | 0 |
| Qcache_free_blocks | 0 |
| Qcache_total_blocks | 0 |
| Rpl_status | NULL |
| Select_full_join | 5 |
| Select_full_range_join | 11 |
| Select_range | 129 |
| Select_range_check | 0 |
| Select_scan | 540 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 165 |
| Sort_merge_passes | 0 |
| Sort_range | 5 |
| Sort_rows | 14839 |
| Sort_scan | 95 |
| Table_locks_immediate | 87551 |
| Table_locks_waited | 0 |
| Threads_cached | 0 |
| Threads_created | 6547 |
| Threads_connected | 10 |
| Threads_running | 1 |
| Uptime | 1180364 |
+--------------------------+------------+
8. is your vB the only thing on the server? or other scripts & sites which utilise php and mysql?
other scripts that use php/mysql are tiny, insignificant
9. how many average and max concurrent users on your vB forum ? and what your cookie timeout is ?
80 on average, max was 173
cookie timeout: 900
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://66.232.156.209/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 :
the httpd.conf file i have access to does not contain any of these values
KeepAlive
MaxKeepAliveRequests
KeepAliveTimeout
MinSpareServers
MaxSpareServers
StartServers
MaxClients
12. what version of vB are you running ?
3.03
Thanks very much in advance.