tomisak
Mon 21st Aug '06, 3:56pm
My forum starts responding slow when the number of users reaches 250. I appreciate all help to find the bottlenecks. Thank you!
1. Dedicated Server
2. Server specs:
cpu speed/type single or dual cpus): Pentium 4 (3 Ghz)/1 MB cache
how much memory installed: 2 GB ram
hard drive type/configuration: 80 GB SATA
linux distributor: Linux Slackware 10.2
apache version: apache 1.3.33
PHP version: php 4.4.0
MySQL version: mysql 4.1.14
3. No
4. if possible how mysql was compiled/installed
Slackware install pkg
5. Top stats
top - 20:44:22 up 13 days, 5:30, 1 user, load average: 2.04, 1.62, 1.37
Tasks: 97 total, 2 running, 95 sleeping, 0 stopped, 0 zombie
Cpu(s): 23.5% user, 2.3% system, 0.0% nice, 74.2% idle
Mem: 904452k total, 860272k used, 44180k free, 41356k buffers
Swap: 2097136k total, 8600k used, 2088536k free, 415680k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
505 nobody 18 0 12884 12m 9068 R 16.5 1.4 0:05.58 httpd
832 root 17 0 1004 1004 756 R 9.9 0.1 0:00.12 top
31769 nobody 10 0 15348 14m 12m S 1.6 1.7 0:23.35 httpd
775 nobody 10 0 10908 10m 8648 S 1.6 1.2 0:00.91 httpd
1 root 8 0 244 244 216 S 0.0 0.0 0:19.79 init
2 root 8 0 0 0 0 S 0.0 0.0 0:00.00 keventd
3 root 19 19 0 0 0 S 0.0 0.0 0:19.06 ksoftirqd_CPU0
4 root 9 0 0 0 0 S 0.0 0.0 1:30.31 kswapd
5 root 9 0 0 0 0 S 0.0 0.0 0:06.03 bdflush
6 root 9 0 0 0 0 S 0.0 0.0 32:42.33 kupdated
10 root -1 -20 0 0 0 S 0.0 0.0 0:00.00 mdrecoveryd
11 root 9 0 0 0 0 S 0.0 0.0 0:01.07 kreiserfsd
60 root 9 0 596 596 512 S 0.0 0.1 0:57.42 syslogd
63 root 9 0 456 456 400 S 0.0 0.1 0:00.01 klogd
173 root 7 -4 460 460 404 S 0.0 0.1 0:00.00 udevd
347 root 9 0 0 0 0 S 0.0 0.0 0:00.00 khubd
3304 root 8 0 516 516 460 S 0.0 0.1 0:00.03 inetd
3308 root 9 0 1508 1508 1248 S 0.0 0.2 0:00.70 sshd
3315 root 8 0 624 624 536 S 0.0 0.1 0:04.01 crond
3318 root 8 0 2480 2188 1736 S 0.0 0.2 0:44.92 sendmail
3321 smmsp 9 0 2056 1724 1528 S 0.0 0.2 0:00.04 sendmail
3328 root 9 0 1212 1212 1008 S 0.0 0.1 0:00.03 mysqld_safe
3359 mysql 9 0 220m 220m 3844 S 0.0 25.0 5:01.71 mysqld
3360 mysql 8 0 220m 220m 3844 S 0.0 25.0 0:17.25 mysqld
3361 mysql 9 0 220m 220m 3844 S 0.0 25.0 0:00.00 mysqld
3362 mysql 9 0 220m 220m 3844 S 0.0 25.0 0:00.01 mysqld
3363 mysql 9 0 220m 220m 3844 S 0.0 25.0 0:00.01 mysqld
3367 mysql 9 0 220m 220m 3844 S 0.0 25.0 0:00.00 mysqld
3369 mysql 9 0 220m 220m 3844 S 0.0 25.0 3:43.87 mysqld
3370 mysql 9 0 220m 220m 3844 S 0.0 25.0 2:16.74 mysqld
3371 mysql 9 0 220m 220m 3844 S 0.0 25.0 0:00.01 mysqld
3372 mysql 9 0 220m 220m 3844 S 0.0 25.0 7:22.78 mysqld
3426 root 9 0 484 484 432 S 0.0 0.1 0:00.01 agetty
3427 root 9 0 484 484 432 S 0.0 0.1 0:00.00 agetty
3428 root 9 0 484 484 432 S 0.0 0.1 0:00.01 agetty
3429 root 9 0 484 484 432 S 0.0 0.1 0:00.00 agetty
3430 root 9 0 484 484 432 S 0.0 0.1 0:00.00 agetty
6. Mysql configuration:
[client]
port = 3306
socket = /var/run/mysql/mysql.sock
[mysqld]
port = 3306
socket = /var/run/mysql/mysql.sock
skip-locking
key_buffer = 384M
max_allowed_packet = 1M
table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache = 8
query_cache_size = 32M
thread_concurrency = 8
log-bin
server-id = 1
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[isamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
7. mysqladmin -u root -p var ext stat ver
+---------------------------------+----------------------------+
| Variable_name | Value |
+---------------------------------+----------------------------+
| back_log | 50 |
| basedir | /usr/ |
| binlog_cache_size | 32768 |
| bulk_insert_buffer_size | 8388608 |
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
| concurrent_insert | ON |
| connect_timeout | 5 |
| datadir | /var/lib/mysql/ |
| date_format | %Y-%m-%d |
| datetime_format | %Y-%m-%d %H:%i:%s |
| default_week_format | 0 |
| delay_key_write | ON |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| expire_logs_days | 0 |
| flush | OFF |
| flush_time | 0 |
| ft_boolean_syntax | + -><()~*:""&| |
| ft_max_word_len | 84 |
| ft_min_word_len | 4 |
| ft_query_expansion_limit | 20 |
| ft_stopword_file | (built-in) |
| group_concat_max_len | 1024 |
| have_archive | NO |
| have_bdb | NO |
| have_blackhole_engine | NO |
| have_compress | YES |
| have_crypt | YES |
| have_csv | NO |
| have_example_engine | NO |
| have_geometry | YES |
| have_innodb | YES |
| have_isam | NO |
| have_ndbcluster | NO |
| have_openssl | YES |
| have_query_cache | YES |
| have_raid | YES |
| have_rtree_keys | YES |
| have_symlink | YES |
| init_connect | |
| init_file | |
| init_slave | |
| innodb_additional_mem_pool_size | 1048576 |
| innodb_autoextend_increment | 8 |
| innodb_buffer_pool_awe_mem_mb | 0 |
| innodb_buffer_pool_size | 8388608 |
| innodb_data_file_path | ibdata1:10M:autoextend |
| innodb_data_home_dir | |
| innodb_fast_shutdown | ON |
| innodb_file_io_threads | 4 |
| innodb_file_per_table | OFF |
| innodb_flush_log_at_trx_commit | 1 |
| innodb_flush_method | |
| innodb_force_recovery | 0 |
| innodb_lock_wait_timeout | 50 |
| innodb_locks_unsafe_for_binlog | OFF |
| 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_max_dirty_pages_pct | 90 |
| innodb_max_purge_lag | 0 |
| innodb_mirrored_log_groups | 1 |
| innodb_open_files | 300 |
| innodb_table_locks | ON |
| innodb_thread_concurrency | 8 |
| interactive_timeout | 28800 |
| join_buffer_size | 131072 |
| key_buffer_size | 402653184 |
| key_cache_age_threshold | 300 |
| key_cache_block_size | 1024 |
| key_cache_division_limit | 100 |
| language | /usr/share/mysql/english/ |
| large_files_support | ON |
| license | GPL |
| local_infile | ON |
| locked_in_memory | OFF |
| log | OFF |
| log_bin | ON |
| log_error | |
| log_slave_updates | OFF |
| log_slow_queries | OFF |
| log_update | 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 | 1047552 |
| max_binlog_cache_size | 4294967295 |
| max_binlog_size | 1073741824 |
| max_connect_errors | 10 |
| max_connections | 100 |
| max_delayed_threads | 20 |
| max_error_count | 64 |
| max_heap_table_size | 16777216 |
| max_insert_delayed_threads | 20 |
| max_join_size | 4294967295 |
| max_length_for_sort_data | 1024 |
| max_relay_log_size | 0 |
| max_seeks_for_key | 4294967295 |
| max_sort_length | 1024 |
| max_tmp_tables | 32 |
| max_user_connections | 0 |
| max_write_lock_count | 4294967295 |
| myisam_data_pointer_size | 4 |
| myisam_max_extra_sort_file_size | 2147483648 |
| myisam_max_sort_file_size | 2147483647 |
| myisam_recover_options | OFF |
| myisam_repair_threads | 1 |
| myisam_sort_buffer_size | 67108864 |
| net_buffer_length | 16384 |
| net_read_timeout | 30 |
| net_retry_count | 10 |
| net_write_timeout | 60 |
| new | OFF |
| old_passwords | OFF |
| open_files_limit | 1134 |
| pid_file | /var/run/mysql/mysql.pid |
| port | 0 |
| preload_buffer_size | 32768 |
| protocol_version | 10 |
| query_alloc_block_size | 8192 |
| query_cache_limit | 1048576 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 33554432 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 8192 |
| range_alloc_block_size | 2048 |
| read_buffer_size | 2093056 |
| read_only | OFF |
| read_rnd_buffer_size | 8384512 |
| relay_log_purge | ON |
| relay_log_space_limit | 0 |
| rpl_recovery_rank | 0 |
| secure_auth | OFF |
| server_id | 1 |
| skip_external_locking | ON |
| skip_networking | ON |
| skip_show_database | OFF |
| slave_net_timeout | 3600 |
| slave_transaction_retries | 0 |
| slow_launch_time | 2 |
| socket | /var/run/mysql/mysql.sock |
| sort_buffer_size | 2097144 |
| sql_mode | |
| storage_engine | MyISAM |
| sql_notes | ON |
| sql_warnings | ON |
| sync_binlog | 0 |
| sync_replication | 0 |
| sync_replication_slave_id | 0 |
| sync_replication_timeout | 0 |
| sync_frm | ON |
| system_time_zone | CEST |
| table_cache | 512 |
| table_type | MyISAM |
| thread_cache_size | 8 |
| thread_stack | 196608 |
| time_format | %H:%i:%s |
| time_zone | SYSTEM |
| tmp_table_size | 33554432 |
| tmpdir | |
| transaction_alloc_block_size | 8192 |
| transaction_prealloc_size | 4096 |
| tx_isolation | REPEATABLE-READ |
| version | 4.1.14-log |
| version_comment | Source distribution |
| version_compile_machine | i486 |
| version_compile_os | slackware-linux-gnu |
| wait_timeout | 28800 |
+---------------------------------+----------------------------+
+--------------------------------+------------+
| Variable_name | Value |
+--------------------------------+------------+
| Aborted_clients | 59 |
| Aborted_connects | 3 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 1279034546 |
| Bytes_sent | 918073153 |
| Com_admin_commands | 0 |
| Com_alter_db | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 5241744 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_commit | 0 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 0 |
| Com_dealloc_sql | 0 |
| Com_delete | 134790 |
| Com_delete_multi | 0 |
| Com_do | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_drop_user | 0 |
| Com_execute_sql | 0 |
| Com_flush | 0 |
| Com_grant | 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_help | 0 |
| Com_insert | 1074211 |
| Com_insert_select | 0 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 3 |
| Com_optimize | 89 |
| Com_preload_keys | 0 |
| Com_prepare_sql | 0 |
| Com_purge | 0 |
| Com_purge_before_date | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 79525 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_revoke_all | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 10141042 |
| Com_set_option | 848 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 11 |
| Com_show_charsets | 140 |
| Com_show_collations | 140 |
| Com_show_column_types | 0 |
| Com_show_create_db | 0 |
| Com_show_create_table | 285 |
| Com_show_databases | 23 |
| Com_show_errors | 0 |
| Com_show_fields | 288 |
| Com_show_grants | 103 |
| Com_show_innodb_status | 0 |
| Com_show_keys | 3 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_privileges | 0 |
| Com_show_processlist | 0 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 7 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 485 |
| Com_show_variables | 546 |
| Com_show_warnings | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_stmt_prepare | 0 |
| Com_stmt_execute | 0 |
| Com_stmt_send_long_data | 0 |
| Com_stmt_reset | 0 |
| Com_stmt_close | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 3 |
| Com_update | 3399084 |
| Com_update_multi | 0 |
| Connections | 5241703 |
| Created_tmp_disk_tables | 7697 |
| Created_tmp_files | 1815 |
| Created_tmp_tables | 141502 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 182251 |
| Handler_discover | 0 |
| Handler_read_first | 975551 |
| Handler_read_key | 269100067 |
| Handler_read_next | 389867588 |
| Handler_read_prev | 13893050 |
| Handler_read_rnd | 17206789 |
| Handler_read_rnd_next | 364063913 |
| Handler_rollback | 0 |
| Handler_update | 3631758 |
| Handler_write | 1988208 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 239463 |
| Key_blocks_used | 124910 |
| Key_read_requests | 1243444358 |
| Key_reads | 501396 |
| Key_write_requests | 3331421 |
| Key_writes | 2658313 |
| Max_used_connections | 69 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 289 |
| Open_streams | 0 |
| Open_tables | 240 |
| Opened_tables | 717 |
| Qcache_free_blocks | 4346 |
| Qcache_free_memory | 15109784 |
| Qcache_hits | 16622646 |
| Qcache_inserts | 10136774 |
| Qcache_lowmem_prunes | 122218 |
| Qcache_not_cached | 3983 |
| Qcache_queries_in_cache | 5976 |
| Qcache_total_blocks | 16531 |
| Questions | 41937641 |
| Rpl_status | NULL |
| Select_full_join | 1333 |
| Select_full_range_join | 0 |
| Select_range | 2927427 |
| Select_range_check | 0 |
| Select_scan | 838126 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slave_retried_transactions | 0 |
| Slow_launch_threads | 4 |
| Slow_queries | 24 |
| Sort_merge_passes | 902 |
| Sort_range | 2552704 |
| Sort_rows | 100614240 |
| Sort_scan | 172768 |
| Ssl_accept_renegotiates | 0 |
| Ssl_accepts | 0 |
| Ssl_callback_cache_hits | 0 |
| Ssl_cipher | |
| Ssl_cipher_list | |
| Ssl_client_connects | 0 |
| Ssl_connect_renegotiates | 0 |
| Ssl_ctx_verify_depth | 0 |
| Ssl_ctx_verify_mode | 0 |
| Ssl_default_timeout | 0 |
| Ssl_finished_accepts | 0 |
| Ssl_finished_connects | 0 |
| Ssl_session_cache_hits | 0 |
| Ssl_session_cache_misses | 0 |
| Ssl_session_cache_mode | NONE |
| Ssl_session_cache_overflows | 0 |
| Ssl_session_cache_size | 0 |
| Ssl_session_cache_timeouts | 0 |
| Ssl_sessions_reused | 0 |
| Ssl_used_session_cache_entries | 0 |
| Ssl_verify_depth | 0 |
| Ssl_verify_mode | 0 |
| Ssl_version | |
| Table_locks_immediate | 28380500 |
| Table_locks_waited | 7073 |
| Threads_cached | 6 |
| Threads_connected | 2 |
| Threads_created | 3347 |
| Threads_running | 1 |
| Uptime | 1141271 |
+--------------------------------+------------+
Uptime: 1141271 Threads: 2 Questions: 41937642 Slow queries: 24 Opens: 717
Flush tables: 1 Open tables: 240 Queries per second avg: 36.746
mysqladmin Ver 8.41 Distrib 4.1.14, for slackware-linux-gnu on i486
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.1.14-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/run/mysql/mysql.sock
Uptime: 13 days 5 hours 1 min 11 sec
Threads: 2 Questions: 41937642 Slow queries: 24 Opens: 717 Flush tables: 1
Open tables: 240 Queries per second avg: 36.746
8. I am only running vB
9. how many average and max concurrent users on your vB forum ? and what your cookie timeout is ?
Average: 280 (200 members, 80 guests)
Max: 400
Cookie timeout: 900
Topics: 37 864, Posts: 528 620, Members: 5 246
10. PHP Code:
http://forum.moppenet.com/phpinfo.php
11.
KeepAlive On
MaxKeepAliveRequests 100
KeepAliveTimeout 5
MinSpareServers 5
MaxSpareServers 15
StartServers 10
MaxClients 180
Maxrequestsperchild 500
12. what version of vB are you running ?
3.5.3
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
No
14. Post output from these 3 commands
uname -a
Linux moppenet 2.4.31 #21 Sun Jun 5 19:19:51 PDT 2005 i686 unknown unknown
GNU/Linux
ulimit -aH
core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
max locked memory (kbytes, -l) unlimited
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
stack size (kbytes, -s) unlimited
cpu time (seconds, -t) unlimited
max user processes (-u) 7168
virtual memory (kbytes, -v) unlimited
cat /proc/cpuinfo
processor : 0
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Pentium(R) 4 CPU 2.80GHz
stepping : 1
cpu MHz : 2800.200
cache size : 1024 KB
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 5
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov
pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe pni monitor ds_cpl
cid
bogomips : 5583.66
1. Dedicated Server
2. Server specs:
cpu speed/type single or dual cpus): Pentium 4 (3 Ghz)/1 MB cache
how much memory installed: 2 GB ram
hard drive type/configuration: 80 GB SATA
linux distributor: Linux Slackware 10.2
apache version: apache 1.3.33
PHP version: php 4.4.0
MySQL version: mysql 4.1.14
3. No
4. if possible how mysql was compiled/installed
Slackware install pkg
5. Top stats
top - 20:44:22 up 13 days, 5:30, 1 user, load average: 2.04, 1.62, 1.37
Tasks: 97 total, 2 running, 95 sleeping, 0 stopped, 0 zombie
Cpu(s): 23.5% user, 2.3% system, 0.0% nice, 74.2% idle
Mem: 904452k total, 860272k used, 44180k free, 41356k buffers
Swap: 2097136k total, 8600k used, 2088536k free, 415680k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
505 nobody 18 0 12884 12m 9068 R 16.5 1.4 0:05.58 httpd
832 root 17 0 1004 1004 756 R 9.9 0.1 0:00.12 top
31769 nobody 10 0 15348 14m 12m S 1.6 1.7 0:23.35 httpd
775 nobody 10 0 10908 10m 8648 S 1.6 1.2 0:00.91 httpd
1 root 8 0 244 244 216 S 0.0 0.0 0:19.79 init
2 root 8 0 0 0 0 S 0.0 0.0 0:00.00 keventd
3 root 19 19 0 0 0 S 0.0 0.0 0:19.06 ksoftirqd_CPU0
4 root 9 0 0 0 0 S 0.0 0.0 1:30.31 kswapd
5 root 9 0 0 0 0 S 0.0 0.0 0:06.03 bdflush
6 root 9 0 0 0 0 S 0.0 0.0 32:42.33 kupdated
10 root -1 -20 0 0 0 S 0.0 0.0 0:00.00 mdrecoveryd
11 root 9 0 0 0 0 S 0.0 0.0 0:01.07 kreiserfsd
60 root 9 0 596 596 512 S 0.0 0.1 0:57.42 syslogd
63 root 9 0 456 456 400 S 0.0 0.1 0:00.01 klogd
173 root 7 -4 460 460 404 S 0.0 0.1 0:00.00 udevd
347 root 9 0 0 0 0 S 0.0 0.0 0:00.00 khubd
3304 root 8 0 516 516 460 S 0.0 0.1 0:00.03 inetd
3308 root 9 0 1508 1508 1248 S 0.0 0.2 0:00.70 sshd
3315 root 8 0 624 624 536 S 0.0 0.1 0:04.01 crond
3318 root 8 0 2480 2188 1736 S 0.0 0.2 0:44.92 sendmail
3321 smmsp 9 0 2056 1724 1528 S 0.0 0.2 0:00.04 sendmail
3328 root 9 0 1212 1212 1008 S 0.0 0.1 0:00.03 mysqld_safe
3359 mysql 9 0 220m 220m 3844 S 0.0 25.0 5:01.71 mysqld
3360 mysql 8 0 220m 220m 3844 S 0.0 25.0 0:17.25 mysqld
3361 mysql 9 0 220m 220m 3844 S 0.0 25.0 0:00.00 mysqld
3362 mysql 9 0 220m 220m 3844 S 0.0 25.0 0:00.01 mysqld
3363 mysql 9 0 220m 220m 3844 S 0.0 25.0 0:00.01 mysqld
3367 mysql 9 0 220m 220m 3844 S 0.0 25.0 0:00.00 mysqld
3369 mysql 9 0 220m 220m 3844 S 0.0 25.0 3:43.87 mysqld
3370 mysql 9 0 220m 220m 3844 S 0.0 25.0 2:16.74 mysqld
3371 mysql 9 0 220m 220m 3844 S 0.0 25.0 0:00.01 mysqld
3372 mysql 9 0 220m 220m 3844 S 0.0 25.0 7:22.78 mysqld
3426 root 9 0 484 484 432 S 0.0 0.1 0:00.01 agetty
3427 root 9 0 484 484 432 S 0.0 0.1 0:00.00 agetty
3428 root 9 0 484 484 432 S 0.0 0.1 0:00.01 agetty
3429 root 9 0 484 484 432 S 0.0 0.1 0:00.00 agetty
3430 root 9 0 484 484 432 S 0.0 0.1 0:00.00 agetty
6. Mysql configuration:
[client]
port = 3306
socket = /var/run/mysql/mysql.sock
[mysqld]
port = 3306
socket = /var/run/mysql/mysql.sock
skip-locking
key_buffer = 384M
max_allowed_packet = 1M
table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache = 8
query_cache_size = 32M
thread_concurrency = 8
log-bin
server-id = 1
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[isamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
7. mysqladmin -u root -p var ext stat ver
+---------------------------------+----------------------------+
| Variable_name | Value |
+---------------------------------+----------------------------+
| back_log | 50 |
| basedir | /usr/ |
| binlog_cache_size | 32768 |
| bulk_insert_buffer_size | 8388608 |
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
| concurrent_insert | ON |
| connect_timeout | 5 |
| datadir | /var/lib/mysql/ |
| date_format | %Y-%m-%d |
| datetime_format | %Y-%m-%d %H:%i:%s |
| default_week_format | 0 |
| delay_key_write | ON |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| expire_logs_days | 0 |
| flush | OFF |
| flush_time | 0 |
| ft_boolean_syntax | + -><()~*:""&| |
| ft_max_word_len | 84 |
| ft_min_word_len | 4 |
| ft_query_expansion_limit | 20 |
| ft_stopword_file | (built-in) |
| group_concat_max_len | 1024 |
| have_archive | NO |
| have_bdb | NO |
| have_blackhole_engine | NO |
| have_compress | YES |
| have_crypt | YES |
| have_csv | NO |
| have_example_engine | NO |
| have_geometry | YES |
| have_innodb | YES |
| have_isam | NO |
| have_ndbcluster | NO |
| have_openssl | YES |
| have_query_cache | YES |
| have_raid | YES |
| have_rtree_keys | YES |
| have_symlink | YES |
| init_connect | |
| init_file | |
| init_slave | |
| innodb_additional_mem_pool_size | 1048576 |
| innodb_autoextend_increment | 8 |
| innodb_buffer_pool_awe_mem_mb | 0 |
| innodb_buffer_pool_size | 8388608 |
| innodb_data_file_path | ibdata1:10M:autoextend |
| innodb_data_home_dir | |
| innodb_fast_shutdown | ON |
| innodb_file_io_threads | 4 |
| innodb_file_per_table | OFF |
| innodb_flush_log_at_trx_commit | 1 |
| innodb_flush_method | |
| innodb_force_recovery | 0 |
| innodb_lock_wait_timeout | 50 |
| innodb_locks_unsafe_for_binlog | OFF |
| 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_max_dirty_pages_pct | 90 |
| innodb_max_purge_lag | 0 |
| innodb_mirrored_log_groups | 1 |
| innodb_open_files | 300 |
| innodb_table_locks | ON |
| innodb_thread_concurrency | 8 |
| interactive_timeout | 28800 |
| join_buffer_size | 131072 |
| key_buffer_size | 402653184 |
| key_cache_age_threshold | 300 |
| key_cache_block_size | 1024 |
| key_cache_division_limit | 100 |
| language | /usr/share/mysql/english/ |
| large_files_support | ON |
| license | GPL |
| local_infile | ON |
| locked_in_memory | OFF |
| log | OFF |
| log_bin | ON |
| log_error | |
| log_slave_updates | OFF |
| log_slow_queries | OFF |
| log_update | 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 | 1047552 |
| max_binlog_cache_size | 4294967295 |
| max_binlog_size | 1073741824 |
| max_connect_errors | 10 |
| max_connections | 100 |
| max_delayed_threads | 20 |
| max_error_count | 64 |
| max_heap_table_size | 16777216 |
| max_insert_delayed_threads | 20 |
| max_join_size | 4294967295 |
| max_length_for_sort_data | 1024 |
| max_relay_log_size | 0 |
| max_seeks_for_key | 4294967295 |
| max_sort_length | 1024 |
| max_tmp_tables | 32 |
| max_user_connections | 0 |
| max_write_lock_count | 4294967295 |
| myisam_data_pointer_size | 4 |
| myisam_max_extra_sort_file_size | 2147483648 |
| myisam_max_sort_file_size | 2147483647 |
| myisam_recover_options | OFF |
| myisam_repair_threads | 1 |
| myisam_sort_buffer_size | 67108864 |
| net_buffer_length | 16384 |
| net_read_timeout | 30 |
| net_retry_count | 10 |
| net_write_timeout | 60 |
| new | OFF |
| old_passwords | OFF |
| open_files_limit | 1134 |
| pid_file | /var/run/mysql/mysql.pid |
| port | 0 |
| preload_buffer_size | 32768 |
| protocol_version | 10 |
| query_alloc_block_size | 8192 |
| query_cache_limit | 1048576 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 33554432 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 8192 |
| range_alloc_block_size | 2048 |
| read_buffer_size | 2093056 |
| read_only | OFF |
| read_rnd_buffer_size | 8384512 |
| relay_log_purge | ON |
| relay_log_space_limit | 0 |
| rpl_recovery_rank | 0 |
| secure_auth | OFF |
| server_id | 1 |
| skip_external_locking | ON |
| skip_networking | ON |
| skip_show_database | OFF |
| slave_net_timeout | 3600 |
| slave_transaction_retries | 0 |
| slow_launch_time | 2 |
| socket | /var/run/mysql/mysql.sock |
| sort_buffer_size | 2097144 |
| sql_mode | |
| storage_engine | MyISAM |
| sql_notes | ON |
| sql_warnings | ON |
| sync_binlog | 0 |
| sync_replication | 0 |
| sync_replication_slave_id | 0 |
| sync_replication_timeout | 0 |
| sync_frm | ON |
| system_time_zone | CEST |
| table_cache | 512 |
| table_type | MyISAM |
| thread_cache_size | 8 |
| thread_stack | 196608 |
| time_format | %H:%i:%s |
| time_zone | SYSTEM |
| tmp_table_size | 33554432 |
| tmpdir | |
| transaction_alloc_block_size | 8192 |
| transaction_prealloc_size | 4096 |
| tx_isolation | REPEATABLE-READ |
| version | 4.1.14-log |
| version_comment | Source distribution |
| version_compile_machine | i486 |
| version_compile_os | slackware-linux-gnu |
| wait_timeout | 28800 |
+---------------------------------+----------------------------+
+--------------------------------+------------+
| Variable_name | Value |
+--------------------------------+------------+
| Aborted_clients | 59 |
| Aborted_connects | 3 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 1279034546 |
| Bytes_sent | 918073153 |
| Com_admin_commands | 0 |
| Com_alter_db | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 5241744 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_commit | 0 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 0 |
| Com_dealloc_sql | 0 |
| Com_delete | 134790 |
| Com_delete_multi | 0 |
| Com_do | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_drop_user | 0 |
| Com_execute_sql | 0 |
| Com_flush | 0 |
| Com_grant | 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_help | 0 |
| Com_insert | 1074211 |
| Com_insert_select | 0 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 3 |
| Com_optimize | 89 |
| Com_preload_keys | 0 |
| Com_prepare_sql | 0 |
| Com_purge | 0 |
| Com_purge_before_date | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 79525 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_revoke_all | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 10141042 |
| Com_set_option | 848 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 11 |
| Com_show_charsets | 140 |
| Com_show_collations | 140 |
| Com_show_column_types | 0 |
| Com_show_create_db | 0 |
| Com_show_create_table | 285 |
| Com_show_databases | 23 |
| Com_show_errors | 0 |
| Com_show_fields | 288 |
| Com_show_grants | 103 |
| Com_show_innodb_status | 0 |
| Com_show_keys | 3 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_privileges | 0 |
| Com_show_processlist | 0 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 7 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 485 |
| Com_show_variables | 546 |
| Com_show_warnings | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_stmt_prepare | 0 |
| Com_stmt_execute | 0 |
| Com_stmt_send_long_data | 0 |
| Com_stmt_reset | 0 |
| Com_stmt_close | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 3 |
| Com_update | 3399084 |
| Com_update_multi | 0 |
| Connections | 5241703 |
| Created_tmp_disk_tables | 7697 |
| Created_tmp_files | 1815 |
| Created_tmp_tables | 141502 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 182251 |
| Handler_discover | 0 |
| Handler_read_first | 975551 |
| Handler_read_key | 269100067 |
| Handler_read_next | 389867588 |
| Handler_read_prev | 13893050 |
| Handler_read_rnd | 17206789 |
| Handler_read_rnd_next | 364063913 |
| Handler_rollback | 0 |
| Handler_update | 3631758 |
| Handler_write | 1988208 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 239463 |
| Key_blocks_used | 124910 |
| Key_read_requests | 1243444358 |
| Key_reads | 501396 |
| Key_write_requests | 3331421 |
| Key_writes | 2658313 |
| Max_used_connections | 69 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 289 |
| Open_streams | 0 |
| Open_tables | 240 |
| Opened_tables | 717 |
| Qcache_free_blocks | 4346 |
| Qcache_free_memory | 15109784 |
| Qcache_hits | 16622646 |
| Qcache_inserts | 10136774 |
| Qcache_lowmem_prunes | 122218 |
| Qcache_not_cached | 3983 |
| Qcache_queries_in_cache | 5976 |
| Qcache_total_blocks | 16531 |
| Questions | 41937641 |
| Rpl_status | NULL |
| Select_full_join | 1333 |
| Select_full_range_join | 0 |
| Select_range | 2927427 |
| Select_range_check | 0 |
| Select_scan | 838126 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slave_retried_transactions | 0 |
| Slow_launch_threads | 4 |
| Slow_queries | 24 |
| Sort_merge_passes | 902 |
| Sort_range | 2552704 |
| Sort_rows | 100614240 |
| Sort_scan | 172768 |
| Ssl_accept_renegotiates | 0 |
| Ssl_accepts | 0 |
| Ssl_callback_cache_hits | 0 |
| Ssl_cipher | |
| Ssl_cipher_list | |
| Ssl_client_connects | 0 |
| Ssl_connect_renegotiates | 0 |
| Ssl_ctx_verify_depth | 0 |
| Ssl_ctx_verify_mode | 0 |
| Ssl_default_timeout | 0 |
| Ssl_finished_accepts | 0 |
| Ssl_finished_connects | 0 |
| Ssl_session_cache_hits | 0 |
| Ssl_session_cache_misses | 0 |
| Ssl_session_cache_mode | NONE |
| Ssl_session_cache_overflows | 0 |
| Ssl_session_cache_size | 0 |
| Ssl_session_cache_timeouts | 0 |
| Ssl_sessions_reused | 0 |
| Ssl_used_session_cache_entries | 0 |
| Ssl_verify_depth | 0 |
| Ssl_verify_mode | 0 |
| Ssl_version | |
| Table_locks_immediate | 28380500 |
| Table_locks_waited | 7073 |
| Threads_cached | 6 |
| Threads_connected | 2 |
| Threads_created | 3347 |
| Threads_running | 1 |
| Uptime | 1141271 |
+--------------------------------+------------+
Uptime: 1141271 Threads: 2 Questions: 41937642 Slow queries: 24 Opens: 717
Flush tables: 1 Open tables: 240 Queries per second avg: 36.746
mysqladmin Ver 8.41 Distrib 4.1.14, for slackware-linux-gnu on i486
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.1.14-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/run/mysql/mysql.sock
Uptime: 13 days 5 hours 1 min 11 sec
Threads: 2 Questions: 41937642 Slow queries: 24 Opens: 717 Flush tables: 1
Open tables: 240 Queries per second avg: 36.746
8. I am only running vB
9. how many average and max concurrent users on your vB forum ? and what your cookie timeout is ?
Average: 280 (200 members, 80 guests)
Max: 400
Cookie timeout: 900
Topics: 37 864, Posts: 528 620, Members: 5 246
10. PHP Code:
http://forum.moppenet.com/phpinfo.php
11.
KeepAlive On
MaxKeepAliveRequests 100
KeepAliveTimeout 5
MinSpareServers 5
MaxSpareServers 15
StartServers 10
MaxClients 180
Maxrequestsperchild 500
12. what version of vB are you running ?
3.5.3
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
No
14. Post output from these 3 commands
uname -a
Linux moppenet 2.4.31 #21 Sun Jun 5 19:19:51 PDT 2005 i686 unknown unknown
GNU/Linux
ulimit -aH
core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
max locked memory (kbytes, -l) unlimited
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
stack size (kbytes, -s) unlimited
cpu time (seconds, -t) unlimited
max user processes (-u) 7168
virtual memory (kbytes, -v) unlimited
cat /proc/cpuinfo
processor : 0
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Pentium(R) 4 CPU 2.80GHz
stepping : 1
cpu MHz : 2800.200
cache size : 1024 KB
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 5
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov
pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe pni monitor ds_cpl
cid
bogomips : 5583.66