aspen
Fri 24th Feb '06, 10:12am
1. Is this on dedicated or shared virual server. Dedicated
2. your server specs. For example:
cpu speed/type single or dual cpus): p4 3.06 ghz w/ ht
how much memory installed: 2gb
hard drive type/configuration: 2 80GB EIDE non raid
linux distributor or windows version: redhat linux with cpanel
apache/IIS version: apache 2.X
PHP version: php 4.3.11
MySQL version: 4.0.22
3. if you use mysql 4.x instead of mysql 3.23.x, do you have any innodb type databases/tables on your server ?
4. if possible how mysql was compiled/installed
5. your top stats
07:48:28 up 2 days, 19:12, 1 user, load average: 6.51, 7.24, 6.30
240 processes: 233 sleeping, 6 running, 1 zombie, 0 stopped
CPU states: cpu user nice system irq softirq iowait idle
total 153.2% 0.0% 3.6% 0.0% 2.8% 0.0% 40.0%
cpu00 69.3% 0.0% 2.1% 0.0% 2.9% 0.0% 25.4%
cpu01 83.8% 0.0% 1.5% 0.0% 0.0% 0.0% 14.5%
Mem: 2061616k av, 2041084k used, 20532k free, 0k shrd, 20080k buff
1393644k actv, 83988k in_d, 30988k in_c
Swap: 2048276k av, 97076k used, 1951200k free 887656k cached
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
1771 root 15 0 2176 912 812 S 150.2 0.0 22:15 1 httpd
3845 mysql 15 0 78816 76M 1388 S 1.5 3.8 161:20 0 mysqld
23861 root 15 0 1424 1424 912 R 0.7 0.0 0:00 0 top
7 root 15 0 0 0 0 SW 0.3 0.0 0:33 1 kswapd
15 root 15 0 0 0 0 SW 0.1 0.0 1:00 1 kjournald
23674 admin 15 0 2112 2112 1700 S 0.1 0.1 0:00 1 sshd
1 root 15 0 468 436 412 S 0.0 0.0 0:07 1 init
6. your mysql configuration variables located at /etc/my.cnf or c:\my.cnf or my.ini so post the contents inside of my.cnf (minus any passwords of course).
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
set-variable = max_connections=500
set-variable = key_buffer=16M
set-variable = myisam_sort_buffer_size=64M
set-variable = join_buffer=1M
set-variable = record_buffer=1M
set-variable = sort_buffer=2M
set-variable = table_cache=1024
set-variable = thread_cache_size=128
set-variable = wait_timeout=3600
set-variable = connect_timeout=10
set-variable = max_allowed_packet=16M
set-variable = max_connect_errors=10
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
7. MySQL stats from ssh telnet as root user type:
(this is long)
+---------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Variable_name | Value |
+---------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| back_log | 50 |
| basedir | / |
| binlog_cache_size | 32768 |
| bulk_insert_buffer_size | 8388608 |
| character_set | latin1 |
| character_sets | latin1 big5 czech euc_kr gb2312 gbk latin1_de sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 |
| concurrent_insert | ON |
| connect_timeout | 10 |
| convert_character_set | |
| datadir | /var/lib/mysql/ |
| default_week_format | 0 |
| delay_key_write | ON |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| flush | OFF |
| flush_time | 0 |
| ft_boolean_syntax | + -><()~*:""&| |
| ft_min_word_len | 4 |
| ft_max_word_len | 254 |
| ft_max_word_len_for_sort | 20 |
| ft_stopword_file | (built-in) |
| have_bdb | NO |
| have_crypt | YES |
| have_innodb | YES |
| have_isam | YES |
| have_raid | NO |
| have_symlink | YES |
| have_openssl | NO |
| have_query_cache | YES |
| init_file | |
| innodb_additional_mem_pool_size | 1048576 |
| innodb_buffer_pool_size | 8388608 |
| innodb_data_file_path | ibdata1:10M:autoextend |
| innodb_data_home_dir | |
| innodb_file_io_threads | 4 |
| innodb_force_recovery | 0 |
| innodb_thread_concurrency | 8 |
| innodb_flush_log_at_trx_commit | 1 |
| innodb_fast_shutdown | ON |
| innodb_flush_method | |
| innodb_lock_wait_timeout | 50 |
| innodb_log_arch_dir | ./ |
| innodb_log_archive | OFF |
| innodb_log_buffer_size | 1048576 |
| innodb_log_file_size | 5242880 |
| innodb_log_files_in_group | 2 |
| innodb_log_group_home_dir | ./ |
| innodb_mirrored_log_groups | 1 |
| innodb_max_dirty_pages_pct | 90 |
| innodb_max_purge_lag | 0 |
| innodb_table_locks | ON |
| interactive_timeout | 28800 |
| join_buffer_size | 1044480 |
| key_buffer_size | 16777216 |
| language | /usr/share/mysql/english/ |
| large_files_support | ON |
| license | GPL |
| local_infile | ON |
| locked_in_memory | OFF |
| log | OFF |
| log_update | OFF |
| log_bin | OFF |
| log_slave_updates | OFF |
| log_slow_queries | OFF |
| log_warnings | 1 |
| long_query_time | 10 |
| low_priority_updates | OFF |
| lower_case_file_system | OFF |
| lower_case_table_names | 0 |
| max_allowed_packet | 16776192 |
| max_binlog_cache_size | 4294967295 |
| max_binlog_size | 1073741824 |
| max_connections | 500 |
| max_connect_errors | 10 |
| max_delayed_threads | 20 |
| max_insert_delayed_threads | 20 |
| max_heap_table_size | 16777216 |
| max_join_size | 4294967295 |
| max_relay_log_size | 0 |
| max_seeks_for_key | 4294967295 |
| max_sort_length | 1024 |
| max_user_connections | 0 |
| max_tmp_tables | 32 |
| max_write_lock_count | 4294967295 |
| myisam_max_extra_sort_file_size | 268435456 |
| myisam_max_sort_file_size | 2147483647 |
| myisam_repair_threads | 1 |
| myisam_recover_options | OFF |
| myisam_sort_buffer_size | 67108864 |
| net_buffer_length | 16384 |
| net_read_timeout | 30 |
| net_retry_count | 10 |
| net_write_timeout | 60 |
| new | OFF |
| open_files_limit | 4096 |
| pid_file | /var/lib/mysql/book1.online-literature.com.pid |
| log_error | |
| port | 3306 |
| protocol_version | 10 |
| query_alloc_block_size | 8192 |
| query_cache_limit | 1048576 |
| query_cache_size | 33554432 |
| query_cache_type | ON |
| query_prealloc_size | 8192 |
| range_alloc_block_size | 2048 |
| read_buffer_size | 1044480 |
| read_only | OFF |
| read_rnd_buffer_size | 262144 |
| rpl_recovery_rank | 0 |
| server_id | 0 |
| slave_net_timeout | 3600 |
| skip_external_locking | ON |
| skip_networking | OFF |
| skip_show_database | OFF |
| slow_launch_time | 2 |
| socket | /var/lib/mysql/mysql.sock |
| sort_buffer_size | 2097144 |
| sql_mode | 0 |
| table_cache | 1024 |
| table_type | MYISAM |
| thread_cache_size | 128 |
| thread_stack | 126976 |
| tx_isolation | REPEATABLE-READ |
| timezone | CST |
| tmp_table_size | 33554432 |
| tmpdir | /tmp/ |
| transaction_alloc_block_size | 8192 |
| transaction_prealloc_size | 4096 |
| version | 4.0.22-standard |
| version_comment | Official MySQL RPM |
| version_compile_os | pc-linux |
| wait_timeout | 3600 |
+---------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+--------------------------+------------+
| Variable_name | Value |
+--------------------------+------------+
| Aborted_clients | 60 |
| Aborted_connects | 153 |
| Bytes_received | 1415136738 |
| Bytes_sent | 266876877 |
| Com_admin_commands | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 1295213 |
| 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 | 9799 |
| Com_delete_multi | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_flush | 0 |
| Com_grant | 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_insert | 173026 |
| Com_insert_select | 758 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 2306 |
| Com_optimize | 0 |
| Com_purge | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 20669 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 1669474 |
| Com_set_option | 2048 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 2 |
| Com_show_create | 1221 |
| Com_show_databases | 9 |
| Com_show_fields | 1221 |
| Com_show_grants | 0 |
| Com_show_keys | 0 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_processlist | 811 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 4 |
| Com_show_innodb_status | 0 |
| Com_show_tables | 1364 |
| Com_show_variables | 3 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 2306 |
| Com_update | 346673 |
| Connections | 776401 |
| Created_tmp_disk_tables | 7809 |
| Created_tmp_tables | 51737 |
| Created_tmp_files | 3 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 99716 |
| Handler_read_first | 261722 |
| Handler_read_key | 168537821 |
| Handler_read_next | 195071232 |
| Handler_read_prev | 292891 |
| Handler_read_rnd | 57007228 |
| Handler_read_rnd_next | 838532090 |
| Handler_rollback | 0 |
| Handler_update | 27926104 |
| Handler_write | 6523149 |
| Key_blocks_used | 15586 |
| Key_read_requests | 388651095 |
| Key_reads | 235452 |
| Key_write_requests | 707539 |
| Key_writes | 273027 |
| Max_used_connections | 69 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 797 |
| Open_files | 1177 |
| Open_streams | 0 |
| Opened_tables | 803 |
| Questions | 6635178 |
| Qcache_queries_in_cache | 3439 |
| Qcache_inserts | 1665902 |
| Qcache_hits | 2331974 |
| Qcache_lowmem_prunes | 500847 |
| Qcache_not_cached | 3571 |
| Qcache_free_memory | 2708744 |
| Qcache_free_blocks | 617 |
| Qcache_total_blocks | 9595 |
| Rpl_status | NULL |
| Select_full_join | 4211 |
| Select_full_range_join | 146 |
| Select_range | 510562 |
| Select_range_check | 0 |
| Select_scan | 315159 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 301 |
| Sort_merge_passes | 0 |
| Sort_range | 320640 |
| Sort_rows | 211408723 |
| Sort_scan | 114215 |
| Table_locks_immediate | 4609774 |
| Table_locks_waited | 2587 |
| Threads_cached | 58 |
| Threads_created | 70 |
| Threads_connected | 12 |
| Threads_running | 1 |
| Uptime | 241880 |
+--------------------------+------------+
Uptime: 241880 Threads: 12 Questions: 6635179 Slow queries: 301 Opens: 803 Flush tables: 1 Open tables: 797 Queries per second avg: 27.432
mysqladmin Ver 8.40 Distrib 4.0.22, for pc-linux on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 4.0.22-standard
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 2 days 19 hours 11 min 20 sec
Threads: 12 Questions: 6635179 Slow queries: 301 Opens: 803 Flush tables: 1 Open tables: 797 Queries per second avg: 27.432
8. is your vB the only thing on the server? or other scripts & sites which utilise php and mysql?
4 sites on the server. 3 vbulletin installations, 2 of which are small, all other sites on the server are really small too. Its really the one site that is massively popular and busy. Last night hit a new record, 526 people on at once. The main site (250k page views per day) is all cached other than the search feature (8000 queries a day or so). It uses a smidgen of php on each page view to set a cookie, but that is it. No MySQL is used for the main site other than searching or setting the cache to begin with.
9. how many average and max concurrent users on your vB forum ? and what your cookie timeout is ? average, 250, max 526. Cookie timeout is 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://www.online-literature.com/forums/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 2
MinSpareServers 5
MaxSpareServers 10
StartServers 5
MaxClients 150
AND Maxrequestsperchild value = 300
12. what version of vB are you running ?
3.0.6 Ya ya... I should upgrade.
13. check to see if any files i.e. apache log files are hitting 2GB or 4GB max file size limits i.e. see if you have max file size exceeded messages in apache error log
nothing found.
I found a post at theadminzone the other day about doing things like turning off the http nocache headers, editing the member's list, and other admincp optimizations. I did all those.
I was looking for a way to cache the indexpage of the forums though (I have an ungodly amount of subforums... all required for site functionality. Probably nearly 2000 in total. )
2. your server specs. For example:
cpu speed/type single or dual cpus): p4 3.06 ghz w/ ht
how much memory installed: 2gb
hard drive type/configuration: 2 80GB EIDE non raid
linux distributor or windows version: redhat linux with cpanel
apache/IIS version: apache 2.X
PHP version: php 4.3.11
MySQL version: 4.0.22
3. if you use mysql 4.x instead of mysql 3.23.x, do you have any innodb type databases/tables on your server ?
4. if possible how mysql was compiled/installed
5. your top stats
07:48:28 up 2 days, 19:12, 1 user, load average: 6.51, 7.24, 6.30
240 processes: 233 sleeping, 6 running, 1 zombie, 0 stopped
CPU states: cpu user nice system irq softirq iowait idle
total 153.2% 0.0% 3.6% 0.0% 2.8% 0.0% 40.0%
cpu00 69.3% 0.0% 2.1% 0.0% 2.9% 0.0% 25.4%
cpu01 83.8% 0.0% 1.5% 0.0% 0.0% 0.0% 14.5%
Mem: 2061616k av, 2041084k used, 20532k free, 0k shrd, 20080k buff
1393644k actv, 83988k in_d, 30988k in_c
Swap: 2048276k av, 97076k used, 1951200k free 887656k cached
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
1771 root 15 0 2176 912 812 S 150.2 0.0 22:15 1 httpd
3845 mysql 15 0 78816 76M 1388 S 1.5 3.8 161:20 0 mysqld
23861 root 15 0 1424 1424 912 R 0.7 0.0 0:00 0 top
7 root 15 0 0 0 0 SW 0.3 0.0 0:33 1 kswapd
15 root 15 0 0 0 0 SW 0.1 0.0 1:00 1 kjournald
23674 admin 15 0 2112 2112 1700 S 0.1 0.1 0:00 1 sshd
1 root 15 0 468 436 412 S 0.0 0.0 0:07 1 init
6. your mysql configuration variables located at /etc/my.cnf or c:\my.cnf or my.ini so post the contents inside of my.cnf (minus any passwords of course).
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
set-variable = max_connections=500
set-variable = key_buffer=16M
set-variable = myisam_sort_buffer_size=64M
set-variable = join_buffer=1M
set-variable = record_buffer=1M
set-variable = sort_buffer=2M
set-variable = table_cache=1024
set-variable = thread_cache_size=128
set-variable = wait_timeout=3600
set-variable = connect_timeout=10
set-variable = max_allowed_packet=16M
set-variable = max_connect_errors=10
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
7. MySQL stats from ssh telnet as root user type:
(this is long)
+---------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Variable_name | Value |
+---------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| back_log | 50 |
| basedir | / |
| binlog_cache_size | 32768 |
| bulk_insert_buffer_size | 8388608 |
| character_set | latin1 |
| character_sets | latin1 big5 czech euc_kr gb2312 gbk latin1_de sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 |
| concurrent_insert | ON |
| connect_timeout | 10 |
| convert_character_set | |
| datadir | /var/lib/mysql/ |
| default_week_format | 0 |
| delay_key_write | ON |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| flush | OFF |
| flush_time | 0 |
| ft_boolean_syntax | + -><()~*:""&| |
| ft_min_word_len | 4 |
| ft_max_word_len | 254 |
| ft_max_word_len_for_sort | 20 |
| ft_stopword_file | (built-in) |
| have_bdb | NO |
| have_crypt | YES |
| have_innodb | YES |
| have_isam | YES |
| have_raid | NO |
| have_symlink | YES |
| have_openssl | NO |
| have_query_cache | YES |
| init_file | |
| innodb_additional_mem_pool_size | 1048576 |
| innodb_buffer_pool_size | 8388608 |
| innodb_data_file_path | ibdata1:10M:autoextend |
| innodb_data_home_dir | |
| innodb_file_io_threads | 4 |
| innodb_force_recovery | 0 |
| innodb_thread_concurrency | 8 |
| innodb_flush_log_at_trx_commit | 1 |
| innodb_fast_shutdown | ON |
| innodb_flush_method | |
| innodb_lock_wait_timeout | 50 |
| innodb_log_arch_dir | ./ |
| innodb_log_archive | OFF |
| innodb_log_buffer_size | 1048576 |
| innodb_log_file_size | 5242880 |
| innodb_log_files_in_group | 2 |
| innodb_log_group_home_dir | ./ |
| innodb_mirrored_log_groups | 1 |
| innodb_max_dirty_pages_pct | 90 |
| innodb_max_purge_lag | 0 |
| innodb_table_locks | ON |
| interactive_timeout | 28800 |
| join_buffer_size | 1044480 |
| key_buffer_size | 16777216 |
| language | /usr/share/mysql/english/ |
| large_files_support | ON |
| license | GPL |
| local_infile | ON |
| locked_in_memory | OFF |
| log | OFF |
| log_update | OFF |
| log_bin | OFF |
| log_slave_updates | OFF |
| log_slow_queries | OFF |
| log_warnings | 1 |
| long_query_time | 10 |
| low_priority_updates | OFF |
| lower_case_file_system | OFF |
| lower_case_table_names | 0 |
| max_allowed_packet | 16776192 |
| max_binlog_cache_size | 4294967295 |
| max_binlog_size | 1073741824 |
| max_connections | 500 |
| max_connect_errors | 10 |
| max_delayed_threads | 20 |
| max_insert_delayed_threads | 20 |
| max_heap_table_size | 16777216 |
| max_join_size | 4294967295 |
| max_relay_log_size | 0 |
| max_seeks_for_key | 4294967295 |
| max_sort_length | 1024 |
| max_user_connections | 0 |
| max_tmp_tables | 32 |
| max_write_lock_count | 4294967295 |
| myisam_max_extra_sort_file_size | 268435456 |
| myisam_max_sort_file_size | 2147483647 |
| myisam_repair_threads | 1 |
| myisam_recover_options | OFF |
| myisam_sort_buffer_size | 67108864 |
| net_buffer_length | 16384 |
| net_read_timeout | 30 |
| net_retry_count | 10 |
| net_write_timeout | 60 |
| new | OFF |
| open_files_limit | 4096 |
| pid_file | /var/lib/mysql/book1.online-literature.com.pid |
| log_error | |
| port | 3306 |
| protocol_version | 10 |
| query_alloc_block_size | 8192 |
| query_cache_limit | 1048576 |
| query_cache_size | 33554432 |
| query_cache_type | ON |
| query_prealloc_size | 8192 |
| range_alloc_block_size | 2048 |
| read_buffer_size | 1044480 |
| read_only | OFF |
| read_rnd_buffer_size | 262144 |
| rpl_recovery_rank | 0 |
| server_id | 0 |
| slave_net_timeout | 3600 |
| skip_external_locking | ON |
| skip_networking | OFF |
| skip_show_database | OFF |
| slow_launch_time | 2 |
| socket | /var/lib/mysql/mysql.sock |
| sort_buffer_size | 2097144 |
| sql_mode | 0 |
| table_cache | 1024 |
| table_type | MYISAM |
| thread_cache_size | 128 |
| thread_stack | 126976 |
| tx_isolation | REPEATABLE-READ |
| timezone | CST |
| tmp_table_size | 33554432 |
| tmpdir | /tmp/ |
| transaction_alloc_block_size | 8192 |
| transaction_prealloc_size | 4096 |
| version | 4.0.22-standard |
| version_comment | Official MySQL RPM |
| version_compile_os | pc-linux |
| wait_timeout | 3600 |
+---------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+--------------------------+------------+
| Variable_name | Value |
+--------------------------+------------+
| Aborted_clients | 60 |
| Aborted_connects | 153 |
| Bytes_received | 1415136738 |
| Bytes_sent | 266876877 |
| Com_admin_commands | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 1295213 |
| 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 | 9799 |
| Com_delete_multi | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_flush | 0 |
| Com_grant | 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_insert | 173026 |
| Com_insert_select | 758 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 2306 |
| Com_optimize | 0 |
| Com_purge | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 20669 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 1669474 |
| Com_set_option | 2048 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 2 |
| Com_show_create | 1221 |
| Com_show_databases | 9 |
| Com_show_fields | 1221 |
| Com_show_grants | 0 |
| Com_show_keys | 0 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_processlist | 811 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 4 |
| Com_show_innodb_status | 0 |
| Com_show_tables | 1364 |
| Com_show_variables | 3 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 2306 |
| Com_update | 346673 |
| Connections | 776401 |
| Created_tmp_disk_tables | 7809 |
| Created_tmp_tables | 51737 |
| Created_tmp_files | 3 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 99716 |
| Handler_read_first | 261722 |
| Handler_read_key | 168537821 |
| Handler_read_next | 195071232 |
| Handler_read_prev | 292891 |
| Handler_read_rnd | 57007228 |
| Handler_read_rnd_next | 838532090 |
| Handler_rollback | 0 |
| Handler_update | 27926104 |
| Handler_write | 6523149 |
| Key_blocks_used | 15586 |
| Key_read_requests | 388651095 |
| Key_reads | 235452 |
| Key_write_requests | 707539 |
| Key_writes | 273027 |
| Max_used_connections | 69 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 797 |
| Open_files | 1177 |
| Open_streams | 0 |
| Opened_tables | 803 |
| Questions | 6635178 |
| Qcache_queries_in_cache | 3439 |
| Qcache_inserts | 1665902 |
| Qcache_hits | 2331974 |
| Qcache_lowmem_prunes | 500847 |
| Qcache_not_cached | 3571 |
| Qcache_free_memory | 2708744 |
| Qcache_free_blocks | 617 |
| Qcache_total_blocks | 9595 |
| Rpl_status | NULL |
| Select_full_join | 4211 |
| Select_full_range_join | 146 |
| Select_range | 510562 |
| Select_range_check | 0 |
| Select_scan | 315159 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 301 |
| Sort_merge_passes | 0 |
| Sort_range | 320640 |
| Sort_rows | 211408723 |
| Sort_scan | 114215 |
| Table_locks_immediate | 4609774 |
| Table_locks_waited | 2587 |
| Threads_cached | 58 |
| Threads_created | 70 |
| Threads_connected | 12 |
| Threads_running | 1 |
| Uptime | 241880 |
+--------------------------+------------+
Uptime: 241880 Threads: 12 Questions: 6635179 Slow queries: 301 Opens: 803 Flush tables: 1 Open tables: 797 Queries per second avg: 27.432
mysqladmin Ver 8.40 Distrib 4.0.22, for pc-linux on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 4.0.22-standard
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 2 days 19 hours 11 min 20 sec
Threads: 12 Questions: 6635179 Slow queries: 301 Opens: 803 Flush tables: 1 Open tables: 797 Queries per second avg: 27.432
8. is your vB the only thing on the server? or other scripts & sites which utilise php and mysql?
4 sites on the server. 3 vbulletin installations, 2 of which are small, all other sites on the server are really small too. Its really the one site that is massively popular and busy. Last night hit a new record, 526 people on at once. The main site (250k page views per day) is all cached other than the search feature (8000 queries a day or so). It uses a smidgen of php on each page view to set a cookie, but that is it. No MySQL is used for the main site other than searching or setting the cache to begin with.
9. how many average and max concurrent users on your vB forum ? and what your cookie timeout is ? average, 250, max 526. Cookie timeout is 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://www.online-literature.com/forums/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 2
MinSpareServers 5
MaxSpareServers 10
StartServers 5
MaxClients 150
AND Maxrequestsperchild value = 300
12. what version of vB are you running ?
3.0.6 Ya ya... I should upgrade.
13. check to see if any files i.e. apache log files are hitting 2GB or 4GB max file size limits i.e. see if you have max file size exceeded messages in apache error log
nothing found.
I found a post at theadminzone the other day about doing things like turning off the http nocache headers, editing the member's list, and other admincp optimizations. I did all those.
I was looking for a way to cache the indexpage of the forums though (I have an ungodly amount of subforums... all required for site functionality. Probably nearly 2000 in total. )