No Harmony
Thu 21st Dec '06, 11:24am
My users complain that the forum is sluggish recently, but server loads seem to be reasonable, I would really appreciate help with improving performance.
1. Is this on dedicated or shared virual server
VPS server hosted by powervps.com, there are 8 other small websites with low resource usage
2. your server specs
#1 Vendor: AuthenticAMDProcessor
#1 Name: Dual Core AMD Opteron(tm) Processor 265Processor
#1 speed: 448.190 MHzProcessor
#1 cache size: 1024 KB Processor
#2 Vendor: AuthenticAMDProcessor
#2 Name: Dual Core AMD Opteron(tm) Processor 265Processor
#2 speed: 448.190 MHzProcessor
#2 cache size: 1024 KB Processor
#3 Vendor: AuthenticAMDProcessor
#3 Name: Dual Core AMD Opteron(tm) Processor 265Processor
#3 speed: 448.190 MHzProcessor
#3 cache size: 1024 KB Processor
#4 Vendor: AuthenticAMDProcessor
#4 Name: Dual Core AMD Opteron(tm) Processor 265Processor
#4 speed: 448.190 MHzProcessor
#4 cache size: 1024 KBhow much memory installed: I am not sure
hard drive type/configuration: I am not sure
linux distributor or windows version:
Linux host.wirednewyork.com 2.6.8-022stab078.9-enterprise #1 SMP Thu Jun 8 12:38:51 MSD 2006 i686 athlon i386 GNU/Linux
WHM 10.8.0 cPanel 10.8.2-R119 Fedora Fedora i686 - WHM X v3.1.0 i686 - WHM X
apache/IIS version:
Server Version: Apache/1.3.37 (Unix) mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 PHP/4.4.1 FrontPage/5.0.2.2635.SR1.2 mod_ssl/2.8.28 OpenSSL/0.9.7a
Server Built: Oct 2 2006 12:15:51
PHP version: php 4.4.1
MySQL version: mysql 4.1.21-standard
3. if you use mysql 4.x instead of mysql 3.23.x, do you have any innodb type databases/tables on your server ?
I do not think so
4. if possible how mysql was compiled/installed
Whatever came with cpanel
5. your top stats
top - 01:23:14 up 65 days, 16:27, 2 users, load average: 1.33, 1.38, 1.68
Tasks: 50 total, 1 running, 49 sleeping, 0 stopped, 0 zombie
Cpu(s): 3.0% us, 0.7% sy, 0.0% ni, 86.6% id, 9.7% wa, 0.0% hi, 0.0% si
Mem: 8239196k total, 8187904k used, 51292k free, 187124k buffers
Swap: 8289532k total, 4144044k used, 4145488k free, 1994012k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
23684 nobody 15 0 26620 5584 24m S 2.0 0.1 0:00.01 httpd
23895 root 15 0 1816 840 1620 R 2.0 0.0 0:00.01 top
1 root 16 0 1476 488 1320 S 0.0 0.0 0:29.40 init
30564 root 16 0 1464 548 1300 S 0.0 0.0 3:10.60 syslogd
30616 root 16 0 2016 728 1688 S 0.0 0.0 0:05.38 xinetd
30655 root 15 0 11024 2700 3148 S 0.0 0.0 2:20.37 chkservd
32229 root 15 0 1516 628 1360 S 0.0 0.0 0:11.73 crond
1419 root 35 19 41420 31m 4732 S 0.0 0.4 22:13.76 cpanellogd
1472 nobody 18 0 4436 1636 2900 S 0.0 0.0 0:00.00 entropychat
1477 nobody 18 0 1616 312 1280 S 0.0 0.0 0:00.00 melange
1506 cpanel 16 0 6044 1980 3480 S 0.0 0.0 0:00.00 stunnel-4.15loc
1538 root 18 0 3972 796 3628 S 0.0 0.0 0:00.00 saslauthd
1568 root 18 0 1420 380 1256 S 0.0 0.0 0:00.00 portsentry
18269 root 16 0 10456 3160 7956 S 0.0 0.0 0:03.43 cppop
32119 root 16 0 5864 1480 5440 S 0.0 0.0 0:01.12 pure-ftpd
32127 root 16 0 3556 752 3216 S 0.0 0.0 0:00.22 pure-authd
9497 root 15 0 3656 1340 3440 S 0.0 0.0 0:06.84 sshd
10128 mailnull 16 0 6764 1644 6304 S 0.0 0.0 0:02.05 exim
10135 mailnull 16 0 6732 1540 6304 S 0.0 0.0 0:00.03 exim
10146 root 15 0 3404 1648 2792 S 0.0 0.0 0:05.34 antirelayd
11846 root 16 0 28064 9.8m 4140 S 0.0 0.1 0:04.22 spamd
24467 named 18 0 75264 20m 4780 S 0.0 0.3 0:00.00 named
24552 root 18 0 2008 848 1828 S 0.0 0.0 0:00.00 mysqld_safe
25638 mysql 16 0 291m 100m 6476 S 0.0 1.3 0:30.97 mysqld
30666 mailnull 15 0 10772 3588 6440 S 0.0 0.0 0:02.12 eximstats
12260 root 15 0 26620 5360 24m S 0.0 0.1 1:50.52 httpd
20272 root 16 0 28328 17m 4140 S 0.0 0.2 0:00.47 spamd
4039 root 16 0 28328 17m 4140 S 0.0 0.2 0:13.43 spamd
32429 root 16 0 12192 8068 9536 S 0.0 0.1 0:00.55 cpsrvd
10223 edward 16 0 5964 1668 5444 S 0.0 0.0 0:12.86 pure-ftpd
26012 edward 15 0 5964 1660 5444 S 0.0 0.0 0:04.96 pure-ftpd
9761 root 16 0 7440 2144 6852 S 0.0 0.0 0:00.13 sshd
9903 root 15 0 2064 1216 1876 S 0.0 0.0 0:00.11 bash
32240 edward 16 0 6000 1676 5444 S 0.0 0.0 0:00.04 pure-ftpd
5176 edward 15 0 5964 1644 5444 S 0.0 0.0 0:01.73 pure-ftpd
24490 edward 15 0 5964 1640 5444 S 0.0 0.0 0:01.06 pure-ftpd
9748 nobody 16 0 30416 9992 24m S 0.0 0.1 0:02.19 httpd
14177 root 16 0 7308 2100 6852 S 0.0 0.0 0:00.03 sshd
14320 root 15 0 2060 1188 1876 S 0.0 0.0 0:00.01 bash
15606 edward 15 0 5964 1636 5444 S 0.0 0.0 0:00.46 pure-ftpd
15685 edward 15 0 5964 1640 5444 S 0.0 0.0 0:00.33 pure-ftpd
17416 nobody 15 0 30388 9928 24m S 0.0 0.1 0:01.77 httpd
17885 nobody 15 0 30336 9980 24m S 0.0 0.1 0:01.83 httpd
13383 nobody 15 0 30424 9904 24m S 0.0 0.1 0:00.36 httpd
14043 nobody 16 0 30268 9896 24m S 0.0 0.1 0:00.47 httpd
7325 nobody 15 0 30280 9904 24m S 0.0 0.1 0:00.52 httpd
23661 nobody 16 0 26620 5584 24m S 0.0 0.1 0:00.01 httpd
23685 nobody 15 0 26620 5580 24m S 0.0 0.1 0:00.00 httpd
23829 root 16 0 6092 2004 5636 S 0.0 0.0 0:00.01 sshd
23834 sshd 16 0 5000 1612 4784 S 0.0 0.0 0:00.00 sshd
6. your mysql configuration variables located at /etc/my.cnf
[mysqld]
skip-locking
character-sets-dir=/usr/share/mysql/charsets/
query_cache_limit=8M
query_cache_size=64M
query_cache_type=1
max_user_connections=100
max_connections=250
interactive_timeout=120
wait_timeout=20
connect_timeout=10
thread_cache_size=1024
key_buffer=64M
join_buffer=8M
max_allowed_packet=64M
table_cache=4096
record_buffer=8M
sort_buffer_size=4086K
read_buffer_size=4086K
max_connect_errors=10
read_rnd_buffer_size=4086K
myisam_sort_buffer_size=64M
socket=/var/lib/mysql/mysql.sock
[mysql.server]
user=mysql
basedir=/var/lib
old-passwords = 1
[safe_mysqld]
open_files_limit=7192
[mysqldump]
quick
max_allowed_packet=64M
max_allowed_packet=64M
[mysql]
no-auto-rehash
[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=32
write_buffer=32M
[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=32M
write_buffer=32M
[mysqlhotcopy]
interactive-timeout
7. MySQL stats from ssh telnet as root user type: mysqladmin -u root -p var ext stat ver
+---------------------------------+------------------------------------------+
| Variable_name | Value |
+---------------------------------+------------------------------------------+
| back_log | 50 |
| basedir | / |
| 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 | 10 |
| 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_merge_engine | YES |
| have_openssl | NO |
| have_query_cache | YES |
| have_raid | NO |
| 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 | 120 |
| join_buffer_size | 8384512 |
| key_buffer_size | 67108864 |
| key_cache_age_threshold | 300 |
| key_cache_block_size | 1024 |
| key_cache_division_limit | 100 |
| language | /usr/share/mysql/english/ |
| large_files_support | ON |
| lc_time_names | en_US |
| license | GPL |
| local_infile | ON |
| locked_in_memory | OFF |
| log | OFF |
| log_bin | OFF |
| 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 | 67107840 |
| max_binlog_cache_size | 4294967295 |
| max_binlog_size | 1073741824 |
| max_connect_errors | 10 |
| max_connections | 250 |
| 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_prepared_stmt_count | 16382 |
| max_relay_log_size | 0 |
| max_seeks_for_key | 4294967295 |
| max_sort_length | 1024 |
| max_tmp_tables | 32 |
| max_user_connections | 100 |
| 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 |
| myisam_stats_method | nulls_unequal |
| net_buffer_length | 16384 |
| net_read_timeout | 30 |
| net_retry_count | 10 |
| net_write_timeout | 60 |
| new | OFF |
| old_passwords | OFF |
| open_files_limit | 8452 |
| pid_file | /var/lib/mysql/host.wirednewyork.com.pid |
| port | 3306 |
| preload_buffer_size | 32768 |
| prepared_stmt_count | 0 |
| protocol_version | 10 |
| query_alloc_block_size | 8192 |
| query_cache_limit | 8388608 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 67108864 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 8192 |
| range_alloc_block_size | 2048 |
| read_buffer_size | 4182016 |
| read_only | OFF |
| read_rnd_buffer_size | 4182016 |
| relay_log_purge | ON |
| relay_log_space_limit | 0 |
| rpl_recovery_rank | 0 |
| secure_auth | OFF |
| server_id | 0 |
| skip_external_locking | ON |
| skip_networking | OFF |
| skip_show_database | OFF |
| slave_net_timeout | 3600 |
| slave_transaction_retries | 0 |
| slow_launch_time | 2 |
| socket | /var/lib/mysql/mysql.sock |
| sort_buffer_size | 4184056 |
| sql_mode | |
| sql_notes | ON |
| sql_warnings | ON |
| storage_engine | MyISAM |
| sync_binlog | 0 |
| sync_frm | ON |
| sync_replication | 0 |
| sync_replication_slave_id | 0 |
| sync_replication_timeout | 0 |
| system_time_zone | EST |
| table_cache | 4096 |
| table_type | MyISAM |
| thread_cache_size | 1024 |
| 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.21-standard |
| version_comment | MySQL Community Edition - Standard (GPL) |
| version_compile_machine | i686 |
| version_compile_os | pc-linux-gnu |
| wait_timeout | 20 |
+---------------------------------+------------------------------------------+
+----------------------------+------------+
| Variable_name | Value |
+----------------------------+------------+
| Aborted_clients | 1704 |
| Aborted_connects | 60 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 1392545911 |
| Bytes_sent | 3043242579 |
| Com_admin_commands | 0 |
| Com_alter_db | 0 |
| Com_alter_table | 134 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 7 |
| Com_change_db | 328199 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_commit | 7 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 0 |
| Com_dealloc_sql | 0 |
| Com_delete | 8788 |
| 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 | 287743 |
| Com_insert_select | 4 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 1936 |
| Com_optimize | 0 |
| 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 | 9053 |
| 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 | 1300505 |
| Com_set_option | 2271 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 1 |
| Com_show_charsets | 3 |
| Com_show_collations | 3 |
| Com_show_column_types | 0 |
| Com_show_create_db | 0 |
| Com_show_create_table | 0 |
| Com_show_databases | 4 |
| Com_show_errors | 0 |
| Com_show_fields | 0 |
| Com_show_grants | 1 |
| Com_show_innodb_status | 0 |
| Com_show_keys | 0 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_ndb_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_privileges | 0 |
| Com_show_processlist | 1599 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 2 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 18 |
| Com_show_variables | 17 |
| Com_show_warnings | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_stmt_close | 0 |
| Com_stmt_execute | 0 |
| Com_stmt_prepare | 0 |
| Com_stmt_reset | 0 |
| Com_stmt_send_long_data | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 1936 |
| Com_update | 209585 |
| Com_update_multi | 114 |
| Connections | 333071 |
| Created_tmp_disk_tables | 149 |
| Created_tmp_files | 4 |
| Created_tmp_tables | 17207 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 117121 |
| Handler_discover | 0 |
| Handler_read_first | 519508 |
| Handler_read_key | 44346988 |
| Handler_read_next | 108688668 |
| Handler_read_prev | 657215 |
| Handler_read_rnd | 12172232 |
| Handler_read_rnd_next | 210503844 |
| Handler_rollback | 0 |
| Handler_update | 330571 |
| Handler_write | 3676665 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 24948 |
| Key_blocks_used | 33042 |
| Key_read_requests | 103655566 |
| Key_reads | 34884 |
| Key_write_requests | 394891 |
| Key_writes | 333888 |
| Max_used_connections | 102 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 1127 |
| Open_streams | 0 |
| Open_tables | 1047 |
| Opened_tables | 1053 |
| Qcache_free_blocks | 1511 |
| Qcache_free_memory | 46970712 |
| Qcache_hits | 1628169 |
| Qcache_inserts | 1291244 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 9080 |
| Qcache_queries_in_cache | 4107 |
| Qcache_total_blocks | 10350 |
| Questions | 4111898 |
| Rpl_status | NULL |
| Select_full_join | 15 |
| Select_full_range_join | 0 |
| Select_range | 358149 |
| Select_range_check | 0 |
| Select_scan | 250351 |
| Slave_open_temp_tables | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 9712 |
| Sort_merge_passes | 0 |
| Sort_range | 511337 |
| Sort_rows | 48192426 |
| Sort_scan | 18042 |
| Table_locks_immediate | 4157894 |
| Table_locks_waited | 12959 |
| Threads_cached | 92 |
| Threads_connected | 10 |
| Threads_created | 102 |
| Threads_running | 9 |
| Uptime | 478047 |
+----------------------------+------------+
Uptime: 478047 Threads: 10 Questions: 4111899 Slow queries: 9712 Opens: 1053 Flush tables: 1 Open tables: 1047 Queries per second avg: 8.601
mysqladmin Ver 8.41 Distrib 4.1.21, for pc-linux-gnu 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.1.21-standard
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 5 days 12 hours 47 min 27 sec
Threads: 10 Questions: 4111899 Slow queries: 9712 Opens: 1053 Flush tables: 1 Open tables: 1047 Queries per second avg: 8.601
8. is your vB the only thing on the server? or other scripts & sites which utilise php and mysql?
Only vB uses php and mysql
9. how many average and max concurrent users on your vB forum ? and what your cookie timeout is?
200-400 users, session 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://wirednewyork.com/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 Off
MaxKeepAliveRequests 50
KeepAliveTimeout 15
MinSpareServers 4
MaxSpareServers 8
StartServers 4
MaxClients 400
MaxRequestsPerChild 100
12. what version of vB are you running ?
3.6.4
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
None
14. Post output from these 3 commands
uname -a
Linux host.wirednewyork.com 2.6.8-022stab078.9-enterprise #1 SMP Thu Jun 8 12:38:51 MSD 2006 i686 athlon i386 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) 65536
virtual memory (kbytes, -v) unlimited
cat /proc/cpuinfo
processor : 0
vendor_id : AuthenticAMD
cpu family : 15
model : 33
model name : Dual Core AMD Opteron(tm) Processor 265
stepping : 2
cpu MHz : 448.190
cache size : 1024 KB
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 1
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext lm 3dnowext 3dnow pni
bogomips : 3522.56
processor : 1
vendor_id : AuthenticAMD
cpu family : 15
model : 33
model name : Dual Core AMD Opteron(tm) Processor 265
stepping : 2
cpu MHz : 448.190
cache size : 1024 KB
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 1
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext lm 3dnowext 3dnow pni
bogomips : 3579.90
processor : 2
vendor_id : AuthenticAMD
cpu family : 15
model : 33
model name : Dual Core AMD Opteron(tm) Processor 265
stepping : 2
cpu MHz : 448.190
cache size : 1024 KB
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 1
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext lm 3dnowext 3dnow pni
bogomips : 3579.90
processor : 3
vendor_id : AuthenticAMD
cpu family : 15
model : 33
model name : Dual Core AMD Opteron(tm) Processor 265
stepping : 2
cpu MHz : 448.190
cache size : 1024 KB
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 1
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext lm 3dnowext 3dnow pni
bogomips : 3579.90
1. Is this on dedicated or shared virual server
VPS server hosted by powervps.com, there are 8 other small websites with low resource usage
2. your server specs
#1 Vendor: AuthenticAMDProcessor
#1 Name: Dual Core AMD Opteron(tm) Processor 265Processor
#1 speed: 448.190 MHzProcessor
#1 cache size: 1024 KB Processor
#2 Vendor: AuthenticAMDProcessor
#2 Name: Dual Core AMD Opteron(tm) Processor 265Processor
#2 speed: 448.190 MHzProcessor
#2 cache size: 1024 KB Processor
#3 Vendor: AuthenticAMDProcessor
#3 Name: Dual Core AMD Opteron(tm) Processor 265Processor
#3 speed: 448.190 MHzProcessor
#3 cache size: 1024 KB Processor
#4 Vendor: AuthenticAMDProcessor
#4 Name: Dual Core AMD Opteron(tm) Processor 265Processor
#4 speed: 448.190 MHzProcessor
#4 cache size: 1024 KBhow much memory installed: I am not sure
hard drive type/configuration: I am not sure
linux distributor or windows version:
Linux host.wirednewyork.com 2.6.8-022stab078.9-enterprise #1 SMP Thu Jun 8 12:38:51 MSD 2006 i686 athlon i386 GNU/Linux
WHM 10.8.0 cPanel 10.8.2-R119 Fedora Fedora i686 - WHM X v3.1.0 i686 - WHM X
apache/IIS version:
Server Version: Apache/1.3.37 (Unix) mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 PHP/4.4.1 FrontPage/5.0.2.2635.SR1.2 mod_ssl/2.8.28 OpenSSL/0.9.7a
Server Built: Oct 2 2006 12:15:51
PHP version: php 4.4.1
MySQL version: mysql 4.1.21-standard
3. if you use mysql 4.x instead of mysql 3.23.x, do you have any innodb type databases/tables on your server ?
I do not think so
4. if possible how mysql was compiled/installed
Whatever came with cpanel
5. your top stats
top - 01:23:14 up 65 days, 16:27, 2 users, load average: 1.33, 1.38, 1.68
Tasks: 50 total, 1 running, 49 sleeping, 0 stopped, 0 zombie
Cpu(s): 3.0% us, 0.7% sy, 0.0% ni, 86.6% id, 9.7% wa, 0.0% hi, 0.0% si
Mem: 8239196k total, 8187904k used, 51292k free, 187124k buffers
Swap: 8289532k total, 4144044k used, 4145488k free, 1994012k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
23684 nobody 15 0 26620 5584 24m S 2.0 0.1 0:00.01 httpd
23895 root 15 0 1816 840 1620 R 2.0 0.0 0:00.01 top
1 root 16 0 1476 488 1320 S 0.0 0.0 0:29.40 init
30564 root 16 0 1464 548 1300 S 0.0 0.0 3:10.60 syslogd
30616 root 16 0 2016 728 1688 S 0.0 0.0 0:05.38 xinetd
30655 root 15 0 11024 2700 3148 S 0.0 0.0 2:20.37 chkservd
32229 root 15 0 1516 628 1360 S 0.0 0.0 0:11.73 crond
1419 root 35 19 41420 31m 4732 S 0.0 0.4 22:13.76 cpanellogd
1472 nobody 18 0 4436 1636 2900 S 0.0 0.0 0:00.00 entropychat
1477 nobody 18 0 1616 312 1280 S 0.0 0.0 0:00.00 melange
1506 cpanel 16 0 6044 1980 3480 S 0.0 0.0 0:00.00 stunnel-4.15loc
1538 root 18 0 3972 796 3628 S 0.0 0.0 0:00.00 saslauthd
1568 root 18 0 1420 380 1256 S 0.0 0.0 0:00.00 portsentry
18269 root 16 0 10456 3160 7956 S 0.0 0.0 0:03.43 cppop
32119 root 16 0 5864 1480 5440 S 0.0 0.0 0:01.12 pure-ftpd
32127 root 16 0 3556 752 3216 S 0.0 0.0 0:00.22 pure-authd
9497 root 15 0 3656 1340 3440 S 0.0 0.0 0:06.84 sshd
10128 mailnull 16 0 6764 1644 6304 S 0.0 0.0 0:02.05 exim
10135 mailnull 16 0 6732 1540 6304 S 0.0 0.0 0:00.03 exim
10146 root 15 0 3404 1648 2792 S 0.0 0.0 0:05.34 antirelayd
11846 root 16 0 28064 9.8m 4140 S 0.0 0.1 0:04.22 spamd
24467 named 18 0 75264 20m 4780 S 0.0 0.3 0:00.00 named
24552 root 18 0 2008 848 1828 S 0.0 0.0 0:00.00 mysqld_safe
25638 mysql 16 0 291m 100m 6476 S 0.0 1.3 0:30.97 mysqld
30666 mailnull 15 0 10772 3588 6440 S 0.0 0.0 0:02.12 eximstats
12260 root 15 0 26620 5360 24m S 0.0 0.1 1:50.52 httpd
20272 root 16 0 28328 17m 4140 S 0.0 0.2 0:00.47 spamd
4039 root 16 0 28328 17m 4140 S 0.0 0.2 0:13.43 spamd
32429 root 16 0 12192 8068 9536 S 0.0 0.1 0:00.55 cpsrvd
10223 edward 16 0 5964 1668 5444 S 0.0 0.0 0:12.86 pure-ftpd
26012 edward 15 0 5964 1660 5444 S 0.0 0.0 0:04.96 pure-ftpd
9761 root 16 0 7440 2144 6852 S 0.0 0.0 0:00.13 sshd
9903 root 15 0 2064 1216 1876 S 0.0 0.0 0:00.11 bash
32240 edward 16 0 6000 1676 5444 S 0.0 0.0 0:00.04 pure-ftpd
5176 edward 15 0 5964 1644 5444 S 0.0 0.0 0:01.73 pure-ftpd
24490 edward 15 0 5964 1640 5444 S 0.0 0.0 0:01.06 pure-ftpd
9748 nobody 16 0 30416 9992 24m S 0.0 0.1 0:02.19 httpd
14177 root 16 0 7308 2100 6852 S 0.0 0.0 0:00.03 sshd
14320 root 15 0 2060 1188 1876 S 0.0 0.0 0:00.01 bash
15606 edward 15 0 5964 1636 5444 S 0.0 0.0 0:00.46 pure-ftpd
15685 edward 15 0 5964 1640 5444 S 0.0 0.0 0:00.33 pure-ftpd
17416 nobody 15 0 30388 9928 24m S 0.0 0.1 0:01.77 httpd
17885 nobody 15 0 30336 9980 24m S 0.0 0.1 0:01.83 httpd
13383 nobody 15 0 30424 9904 24m S 0.0 0.1 0:00.36 httpd
14043 nobody 16 0 30268 9896 24m S 0.0 0.1 0:00.47 httpd
7325 nobody 15 0 30280 9904 24m S 0.0 0.1 0:00.52 httpd
23661 nobody 16 0 26620 5584 24m S 0.0 0.1 0:00.01 httpd
23685 nobody 15 0 26620 5580 24m S 0.0 0.1 0:00.00 httpd
23829 root 16 0 6092 2004 5636 S 0.0 0.0 0:00.01 sshd
23834 sshd 16 0 5000 1612 4784 S 0.0 0.0 0:00.00 sshd
6. your mysql configuration variables located at /etc/my.cnf
[mysqld]
skip-locking
character-sets-dir=/usr/share/mysql/charsets/
query_cache_limit=8M
query_cache_size=64M
query_cache_type=1
max_user_connections=100
max_connections=250
interactive_timeout=120
wait_timeout=20
connect_timeout=10
thread_cache_size=1024
key_buffer=64M
join_buffer=8M
max_allowed_packet=64M
table_cache=4096
record_buffer=8M
sort_buffer_size=4086K
read_buffer_size=4086K
max_connect_errors=10
read_rnd_buffer_size=4086K
myisam_sort_buffer_size=64M
socket=/var/lib/mysql/mysql.sock
[mysql.server]
user=mysql
basedir=/var/lib
old-passwords = 1
[safe_mysqld]
open_files_limit=7192
[mysqldump]
quick
max_allowed_packet=64M
max_allowed_packet=64M
[mysql]
no-auto-rehash
[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=32
write_buffer=32M
[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=32M
write_buffer=32M
[mysqlhotcopy]
interactive-timeout
7. MySQL stats from ssh telnet as root user type: mysqladmin -u root -p var ext stat ver
+---------------------------------+------------------------------------------+
| Variable_name | Value |
+---------------------------------+------------------------------------------+
| back_log | 50 |
| basedir | / |
| 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 | 10 |
| 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_merge_engine | YES |
| have_openssl | NO |
| have_query_cache | YES |
| have_raid | NO |
| 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 | 120 |
| join_buffer_size | 8384512 |
| key_buffer_size | 67108864 |
| key_cache_age_threshold | 300 |
| key_cache_block_size | 1024 |
| key_cache_division_limit | 100 |
| language | /usr/share/mysql/english/ |
| large_files_support | ON |
| lc_time_names | en_US |
| license | GPL |
| local_infile | ON |
| locked_in_memory | OFF |
| log | OFF |
| log_bin | OFF |
| 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 | 67107840 |
| max_binlog_cache_size | 4294967295 |
| max_binlog_size | 1073741824 |
| max_connect_errors | 10 |
| max_connections | 250 |
| 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_prepared_stmt_count | 16382 |
| max_relay_log_size | 0 |
| max_seeks_for_key | 4294967295 |
| max_sort_length | 1024 |
| max_tmp_tables | 32 |
| max_user_connections | 100 |
| 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 |
| myisam_stats_method | nulls_unequal |
| net_buffer_length | 16384 |
| net_read_timeout | 30 |
| net_retry_count | 10 |
| net_write_timeout | 60 |
| new | OFF |
| old_passwords | OFF |
| open_files_limit | 8452 |
| pid_file | /var/lib/mysql/host.wirednewyork.com.pid |
| port | 3306 |
| preload_buffer_size | 32768 |
| prepared_stmt_count | 0 |
| protocol_version | 10 |
| query_alloc_block_size | 8192 |
| query_cache_limit | 8388608 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 67108864 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 8192 |
| range_alloc_block_size | 2048 |
| read_buffer_size | 4182016 |
| read_only | OFF |
| read_rnd_buffer_size | 4182016 |
| relay_log_purge | ON |
| relay_log_space_limit | 0 |
| rpl_recovery_rank | 0 |
| secure_auth | OFF |
| server_id | 0 |
| skip_external_locking | ON |
| skip_networking | OFF |
| skip_show_database | OFF |
| slave_net_timeout | 3600 |
| slave_transaction_retries | 0 |
| slow_launch_time | 2 |
| socket | /var/lib/mysql/mysql.sock |
| sort_buffer_size | 4184056 |
| sql_mode | |
| sql_notes | ON |
| sql_warnings | ON |
| storage_engine | MyISAM |
| sync_binlog | 0 |
| sync_frm | ON |
| sync_replication | 0 |
| sync_replication_slave_id | 0 |
| sync_replication_timeout | 0 |
| system_time_zone | EST |
| table_cache | 4096 |
| table_type | MyISAM |
| thread_cache_size | 1024 |
| 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.21-standard |
| version_comment | MySQL Community Edition - Standard (GPL) |
| version_compile_machine | i686 |
| version_compile_os | pc-linux-gnu |
| wait_timeout | 20 |
+---------------------------------+------------------------------------------+
+----------------------------+------------+
| Variable_name | Value |
+----------------------------+------------+
| Aborted_clients | 1704 |
| Aborted_connects | 60 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 1392545911 |
| Bytes_sent | 3043242579 |
| Com_admin_commands | 0 |
| Com_alter_db | 0 |
| Com_alter_table | 134 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 7 |
| Com_change_db | 328199 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_commit | 7 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 0 |
| Com_dealloc_sql | 0 |
| Com_delete | 8788 |
| 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 | 287743 |
| Com_insert_select | 4 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 1936 |
| Com_optimize | 0 |
| 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 | 9053 |
| 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 | 1300505 |
| Com_set_option | 2271 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 1 |
| Com_show_charsets | 3 |
| Com_show_collations | 3 |
| Com_show_column_types | 0 |
| Com_show_create_db | 0 |
| Com_show_create_table | 0 |
| Com_show_databases | 4 |
| Com_show_errors | 0 |
| Com_show_fields | 0 |
| Com_show_grants | 1 |
| Com_show_innodb_status | 0 |
| Com_show_keys | 0 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_ndb_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_privileges | 0 |
| Com_show_processlist | 1599 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 2 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 18 |
| Com_show_variables | 17 |
| Com_show_warnings | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_stmt_close | 0 |
| Com_stmt_execute | 0 |
| Com_stmt_prepare | 0 |
| Com_stmt_reset | 0 |
| Com_stmt_send_long_data | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 1936 |
| Com_update | 209585 |
| Com_update_multi | 114 |
| Connections | 333071 |
| Created_tmp_disk_tables | 149 |
| Created_tmp_files | 4 |
| Created_tmp_tables | 17207 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 117121 |
| Handler_discover | 0 |
| Handler_read_first | 519508 |
| Handler_read_key | 44346988 |
| Handler_read_next | 108688668 |
| Handler_read_prev | 657215 |
| Handler_read_rnd | 12172232 |
| Handler_read_rnd_next | 210503844 |
| Handler_rollback | 0 |
| Handler_update | 330571 |
| Handler_write | 3676665 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 24948 |
| Key_blocks_used | 33042 |
| Key_read_requests | 103655566 |
| Key_reads | 34884 |
| Key_write_requests | 394891 |
| Key_writes | 333888 |
| Max_used_connections | 102 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 1127 |
| Open_streams | 0 |
| Open_tables | 1047 |
| Opened_tables | 1053 |
| Qcache_free_blocks | 1511 |
| Qcache_free_memory | 46970712 |
| Qcache_hits | 1628169 |
| Qcache_inserts | 1291244 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 9080 |
| Qcache_queries_in_cache | 4107 |
| Qcache_total_blocks | 10350 |
| Questions | 4111898 |
| Rpl_status | NULL |
| Select_full_join | 15 |
| Select_full_range_join | 0 |
| Select_range | 358149 |
| Select_range_check | 0 |
| Select_scan | 250351 |
| Slave_open_temp_tables | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 9712 |
| Sort_merge_passes | 0 |
| Sort_range | 511337 |
| Sort_rows | 48192426 |
| Sort_scan | 18042 |
| Table_locks_immediate | 4157894 |
| Table_locks_waited | 12959 |
| Threads_cached | 92 |
| Threads_connected | 10 |
| Threads_created | 102 |
| Threads_running | 9 |
| Uptime | 478047 |
+----------------------------+------------+
Uptime: 478047 Threads: 10 Questions: 4111899 Slow queries: 9712 Opens: 1053 Flush tables: 1 Open tables: 1047 Queries per second avg: 8.601
mysqladmin Ver 8.41 Distrib 4.1.21, for pc-linux-gnu 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.1.21-standard
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 5 days 12 hours 47 min 27 sec
Threads: 10 Questions: 4111899 Slow queries: 9712 Opens: 1053 Flush tables: 1 Open tables: 1047 Queries per second avg: 8.601
8. is your vB the only thing on the server? or other scripts & sites which utilise php and mysql?
Only vB uses php and mysql
9. how many average and max concurrent users on your vB forum ? and what your cookie timeout is?
200-400 users, session 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://wirednewyork.com/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 Off
MaxKeepAliveRequests 50
KeepAliveTimeout 15
MinSpareServers 4
MaxSpareServers 8
StartServers 4
MaxClients 400
MaxRequestsPerChild 100
12. what version of vB are you running ?
3.6.4
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
None
14. Post output from these 3 commands
uname -a
Linux host.wirednewyork.com 2.6.8-022stab078.9-enterprise #1 SMP Thu Jun 8 12:38:51 MSD 2006 i686 athlon i386 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) 65536
virtual memory (kbytes, -v) unlimited
cat /proc/cpuinfo
processor : 0
vendor_id : AuthenticAMD
cpu family : 15
model : 33
model name : Dual Core AMD Opteron(tm) Processor 265
stepping : 2
cpu MHz : 448.190
cache size : 1024 KB
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 1
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext lm 3dnowext 3dnow pni
bogomips : 3522.56
processor : 1
vendor_id : AuthenticAMD
cpu family : 15
model : 33
model name : Dual Core AMD Opteron(tm) Processor 265
stepping : 2
cpu MHz : 448.190
cache size : 1024 KB
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 1
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext lm 3dnowext 3dnow pni
bogomips : 3579.90
processor : 2
vendor_id : AuthenticAMD
cpu family : 15
model : 33
model name : Dual Core AMD Opteron(tm) Processor 265
stepping : 2
cpu MHz : 448.190
cache size : 1024 KB
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 1
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext lm 3dnowext 3dnow pni
bogomips : 3579.90
processor : 3
vendor_id : AuthenticAMD
cpu family : 15
model : 33
model name : Dual Core AMD Opteron(tm) Processor 265
stepping : 2
cpu MHz : 448.190
cache size : 1024 KB
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 1
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx mmxext lm 3dnowext 3dnow pni
bogomips : 3579.90