noppid
Mon 19th Jun '06, 10:16pm
1. Is this on dedicated or shared virual server. If shared, how many sites share this server
Dedicated server with 7 vBulletin installations and 40 websites.
There are other PHP database applications on this server.
2. your server specs. For example:
AMD Opteron Dual-Core 165
2 GB RAM
2pcs Western Digital 250G SATA RAID Edition WD2500SD, 7200rpm, 8-Meg Buffer
CentOS 4.3 x86_64
Apache/1.3.36
PHP version: php 4.4.2
MySQL version: mysql 4.1.20
eAccelerator 0.9.4 is installed.
3. if you use mysql 4.x instead of mysql 3.23.x, do you have any innodb type databases/tables on
your server ?
NO
4. if possible how mysql was compiled/installed
Cpanel
5. your top stats
top - 20:52:46 up 6 days, 9:59, 1 user, load average: 0.25, 0.45, 0.43
Tasks: 154 total, 1 running, 153 sleeping, 0 stopped, 0 zombie
Cpu(s): 11.0% us, 2.7% sy, 0.0% ni, 85.4% id, 0.8% wa, 0.0% hi, 0.2% si
Mem: 2056428k total, 1979412k used, 77016k free, 55660k buffers
Swap: 2048276k total, 46700k used, 2001576k free, 1314256k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
6823 nobody 15 0 232m 14m 7884 S 6.0 0.7 0:00.18 httpd
6822 nobody 16 0 231m 12m 6952 S 5.3 0.6 0:00.16 httpd
4488 mysql 15 0 158m 85m 2968 S 4.0 4.2 3:27.32 mysqld
6820 nobody 15 0 230m 12m 7308 S 4.0 0.6 0:00.12 httpd
5354 nobody 15 0 233m 50m 42m S 2.7 2.5 0:10.31 httpd
6811 nobody 16 0 231m 14m 8108 S 1.0 0.7 0:00.05 httpd
6827 nobody 15 0 229m 10m 6556 S 1.0 0.5 0:00.03 httpd
6813 nobody 16 0 230m 11m 6960 S 0.7 0.6 0:00.02 httpd
6814 nobody 16 0 230m 11m 6960 S 0.7 0.6 0:00.02 httpd
20724 root 16 0 228m 8284 4484 S 0.3 0.4 0:03.27 httpd
5345 nobody 15 0 233m 46m 38m S 0.3 2.3 0:12.15 httpd
1 root 16 0 4748 512 428 S 0.0 0.0 0:01.64 init
2 root RT 0 0 0 0 S 0.0 0.0 0:00.54 migration/0
3 root 34 19 0 0 0 S 0.0 0.0 0:00.03 ksoftirqd/0
4 root RT 0 0 0 0 S 0.0 0.0 0:00.52 migration/1
5 root 34 19 0 0 0 S 0.0 0.0 0:00.05 ksoftirqd/1
6 root 5 -10 0 0 0 S 0.0 0.0 0:00.09 events/0
7 root 5 -10 0 0 0 S 0.0 0.0 0:00.07 events/1
8 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 khelper
9 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 kblockd/0
10 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 kblockd/1
11 root 15 0 0 0 0 S 0.0 0.0 0:00.00 khubd
45 root 15 -10 0 0 0 S 0.0 0.0 0:00.00 aio/0
44 root 15 0 0 0 0 S 0.0 0.0 0:27.48 kswapd0
46 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 aio/1
119 root 24 0 0 0 0 S 0.0 0.0 0:00.00 kseriod
192 root 19 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_0
207 root 15 0 0 0 0 S 0.0 0.0 1:12.79 kjournald
1089 root 6 -10 3604 500 408 S 0.0 0.0 0:00.00 udevd
1308 root 6 -10 0 0 0 S 0.0 0.0 0:00.00 kauditd
1346 root 7 -10 0 0 0 S 0.0 0.0 0:00.00 kmirrord
1347 root 7 -10 0 0 0 S 0.0 0.0 0:00.00 kmir_mon
1383 root 15 0 0 0 0 S 0.0 0.0 0:00.00 kjournald
1866 root 16 0 2548 508 416 S 0.0 0.0 0:00.14 irqbalance
1903 29 16 0 7956 872 732 S 0.0 0.0 0:00.00 rpc.statd
1931 root 16 0 19856 1340 1204 S 0.0 0.1 0:00.01 rpc.idmapd
2056 root 16 0 21960 1812 1552 S 0.0 0.1 0:05.72 sshd
2079 root 16 0 8712 828 664 S 0.0 0.0 0:00.00 xinetd
2200 root 16 0 57104 1136 732 S 0.0 0.1 0:00.17 crond
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]
safe-show-database
back_log = 75
skip-innodb
max_connections = 500
key_buffer = 32M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1800
thread_cache_size = 384
wait_timeout = 45
connect_timeout = 10
tmp_table_size = 64M
max_heap_table_size = 64M
max_allowed_packet = 64M
max_connect_errors = 10
read_rnd_buffer_size = 524288
bulk_insert_buffer_size = 8M
query_cache_limit = 3M
query_cache_size = 80M
query_cache_type = 1
query_prealloc_size = 163840
query_alloc_block_size = 32768
default-storage-engine = MyISAM
[mysqld_safe]
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
[mysqlhotcopy]
interactive-timeout
7. MySQL stats from ssh telnet as root user type:
a.)Quote:
mysqladmin -u root -p var ext stat ver
+---------------------------------+------------------------------------------+
| Variable_name | Value |
+---------------------------------+------------------------------------------+
| back_log | 75 |
| 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 | DISABLED |
| have_isam | NO |
| have_ndbcluster | NO |
| 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 | |
| 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 | 1044480 |
| key_buffer_size | 33554432 |
| 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 | 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 | 18446744073709551615 |
| max_binlog_size | 1073741824 |
| max_connect_errors | 10 |
| max_connections | 500 |
| max_delayed_threads | 20 |
| max_error_count | 64 |
| max_heap_table_size | 67107840 |
| max_insert_delayed_threads | 20 |
| max_join_size | 18446744073709551615 |
| max_length_for_sort_data | 1024 |
| max_prepared_stmt_count | 16382 |
| max_relay_log_size | 0 |
| max_seeks_for_key | 18446744073709551615 |
| max_sort_length | 1024 |
| max_tmp_tables | 32 |
| max_user_connections | 0 |
| max_write_lock_count | 18446744073709551615 |
| myisam_data_pointer_size | 4 |
| myisam_max_extra_sort_file_size | 2147483648 |
| myisam_max_sort_file_size | 9223372036854775807 |
| 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 | 4110 |
:
| pid_file | /var/lib/mysql/server.lvcmedia.com.pid |
| port | 3306 |
| preload_buffer_size | 32768 |
| prepared_stmt_count | 0 |
| protocol_version | 10 |
| query_alloc_block_size | 32768 |
| query_cache_limit | 3145728 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 83886080 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 163840 |
| range_alloc_block_size | 2048 |
| read_buffer_size | 1044480 |
| read_only | OFF |
| read_rnd_buffer_size | 520192 |
| 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 | 2097144 |
| 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 | EDT |
| table_cache | 1800 |
| table_type | MyISAM |
| thread_cache_size | 384 |
| thread_stack | 196608 |
| time_format | %H:%i:%s |
| time_zone | SYSTEM |
:
| tmp_table_size | 67108864 |
| tmpdir | |
| transaction_alloc_block_size | 8192 |
| transaction_prealloc_size | 4096 |
| tx_isolation | REPEATABLE-READ |
| version | 4.1.20-standard |
| version_comment | MySQL Community Edition - Standard (GPL) |
| version_compile_machine | x86_64 |
| version_compile_os | unknown-linux-gnu |
| wait_timeout | 45 |
+---------------------------------+------------------------------------------+
+----------------------------+------------+
| Variable_name | Value |
+----------------------------+------------+
| Aborted_clients | 86 |
| Aborted_connects | 114 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 32311738 |
| Bytes_sent | 2304146921 |
| Com_admin_commands | 0 |
| Com_alter_db | 0 |
| Com_alter_table | 27 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 3 |
| Com_change_db | 17261 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_commit | 3 |
| Com_create_db | 2 |
| Com_create_function | 0 |
| Com_create_index | 40 |
| Com_create_table | 23 |
| Com_dealloc_sql | 0 |
| Com_delete | 1735 |
| 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 | 4 |
| Com_grant | 22 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_help | 0 |
| Com_insert | 4251 |
| Com_insert_select | 34 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 86 |
| 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 | 512 |
| 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 | 46414 |
| Com_set_option | 13 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_charsets | 0 |
| Com_show_collations | 0 |
| Com_show_column_types | 0 |
| Com_show_create_db | 0 |
| Com_show_create_table | 0 |
| Com_show_databases | 0 |
| Com_show_errors | 0 |
| Com_show_fields | 0 |
| Com_show_grants | 0 |
| 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 | 21 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 12 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 7 |
| Com_show_variables | 11 |
| 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 | 86 |
| Com_update | 11327 |
| Com_update_multi | 0 |
| Connections | 12613 |
| Created_tmp_disk_tables | 2991 |
| Created_tmp_files | 34 |
| Created_tmp_tables | 3777 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 1809 |
| Handler_discover | 0 |
| Handler_read_first | 7431 |
| Handler_read_key | 530210 |
| Handler_read_next | 14985605 |
| Handler_read_prev | 32390 |
| Handler_read_rnd | 102768 |
| Handler_read_rnd_next | 34873477 |
| Handler_rollback | 0 |
| Handler_update | 11812 |
| Handler_write | 15378770 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 6091 |
| Key_blocks_used | 20701 |
| Key_read_requests | 1978040 |
| Key_reads | 20855 |
| Key_write_requests | 14300 |
| Key_writes | 9794 |
| Max_used_connections | 17 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 1398 |
| Open_streams | 0 |
| Open_tables | 749 |
| Opened_tables | 782 |
| Qcache_free_blocks | 2058 |
| Qcache_free_memory | 37951000 |
| Qcache_hits | 42879 |
| Qcache_inserts | 42509 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 3891 |
| Qcache_queries_in_cache | 9499 |
| Qcache_total_blocks | 22038 |
| Questions | 137217 |
| Rpl_status | NULL |
| Select_full_join | 20 |
| Select_full_range_join | 0 |
| Select_range | 11061 |
| Select_range_check | 0 |
| Select_scan | 5489 |
| Slave_open_temp_tables | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 1 |
| Slow_queries | 110 |
| Sort_merge_passes | 17 |
| Sort_range | 6262 |
| Sort_rows | 347844 |
| Sort_scan | 4751 |
| Table_locks_immediate | 107563 |
| Table_locks_waited | 29 |
| Threads_cached | 7 |
| Threads_connected | 10 |
| Threads_created | 17 |
| Threads_running | 1 |
| Uptime | 3909 |
+----------------------------+------------+
Uptime: 3909 Threads: 10 Questions: 137218 Slow queries: 110 Opens: 782 Flush tables: 1 Open tables: 749 Queries per se
cond avg: 35.103
mysqladmin Ver 8.41 Distrib 4.1.20, for unknown-linux-gnu on x86_64
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.20-standard
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 1 hour 5 min 9 sec
Threads: 10 Questions: 137218 Slow queries: 110 Opens: 782 Flush tables: 1 Open tables: 749 Queries per second avg: 35.1
03
Also if you want to better see what's going on install mysqlreport at
http://www.vbulletin.com/forum/showthread.php?t=175177 and run it by typing
b.) Quote:
mysqlreport --all -tab /statistics.txt
MySQL 4.1.20-standard uptime 0 1:12:22 Mon Jun 19 21:19:23 2006
__ Key __________________________________________________ _______________
Buffer usage 20.67M of 32.00M %Used: 64.58
Write ratio 0.68
Read ratio 0.01
__ Questions __________________________________________________ _________
Total 151.74k 34.95/s
DMS 70.43k 16.22/s %Total: 46.42
QC Hits 48.51k 11.17/s 31.97
Com_ 19.07k 4.39/s 12.57
COM_QUIT 13.87k 3.19/s 9.14
-Unknown 134 0.03/s 0.09
Slow 116 0.03/s 0.08 %DMS: 0.16
DMS 70.43k 16.22/s 46.42
SELECT 51.20k 11.79/s 33.74 72.70
UPDATE 12.25k 2.82/s 8.07 17.39
INSERT 4.63k 1.07/s 3.05 6.58
DELETE 1.79k 0.41/s 1.18 2.54
REPLACE 559 0.13/s 0.37 0.79
Com_ 19.07k 4.39/s 12.57
change_db 18.69k 4.31/s 12.32
lock_tables 90 0.02/s 0.06
unlock_tabl 90 0.02/s 0.06
__ SELECT and Sort __________________________________________________ ___
Scan 6.02k 1.39/s %SELECT: 11.76
Range 12.11k 2.79/s 23.65
Full join 21 0.00/s 0.04
Range check 0 0.00/s 0.00
Full rng join 0 0.00/s 0.00
Sort scan 5.45k 1.25/s
Sort range 7.11k 1.64/s
Sort mrg pass 18 0.00/s
__ Query Cache __________________________________________________ _______
Memory usage 46.31M of 80.00M %Used: 57.89
Block Fragmnt 8.53%
Hits 48.51k 11.17/s
Inserts 46.75k 10.77/s
Prunes 1 0.00/s
Insrt:Prune 46.75k:1 10.77/s
Hit:Insert 1.04:1
__ Table Locks __________________________________________________ _______
Waited 32 0.01/s %Total: 0.03
Immediate 117.78k 27.12/s
__ Tables __________________________________________________ ____________
Open 756 of 1800 %Cache: 42.00
Opened 789 0.18/s
__ Connections __________________________________________________ _______
Max used 17 of 500 %Max: 3.40
Total 13.91k 3.20/s
__ Created Temp __________________________________________________ ______
Disk table 3.37k 0.78/s
Table 4.44k 1.02/s
File 36 0.01/s
__ Threads __________________________________________________ ___________
Running 1 of 5
Cache 12 %Hit: 99.88
Created 17 0.00/s
Slow 1 0.00/s
__ Aborted __________________________________________________ ___________
Clients 90 0.02/s
Connects 126 0.03/s
__ Bytes __________________________________________________ _____________
Sent 2.53G 581.89/s
8. is your vB the only thing on the server? or other scripts & sites which utilise php and mysql?
Other sites run mysql apps. Directory software and amazon stores. Small DBs.
9. how many average and max concurrent users on your vB forum ? and what your cookie timeout is ?
200 avg. 400 max. cookie timeout 30 minutes.
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.lakecs.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 On
MaxKeepAliveRequests 120
KeepAliveTimeout 6
MinSpareServers 10
MaxSpareServers 15
StartServers 10
MaxClients 150
AND Maxrequestsperchild value = 1000
12. what version of vB are you running ?
One 3.5.0. Two 3.0.x forum. four or so 3.5.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
find / -size +2000000k
Found: /proc/kcore
14. Post output from these 3 commands
uname -a
Linux server.lvcmedia.com 2.6.9-34.0.1.ELsmp #1 SMP Wed May 24 05:28:30 CDT 2006 x86_64 x86_64 x86_64 GNU/Linux
ulimit -aH
core file size (blocks, -c) 1000000
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
pending signals (-i) 1024
max locked memory (kbytes, -l) 32
max memory size (kbytes, -m) unlimited
open files (-n) 4096
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
stack size (kbytes, -s) 8192
cpu time (seconds, -t) unlimited
max user processes (-u) 14335
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
cat /proc/cpuinfo
processor : 0
vendor_id : AuthenticAMD
cpu family : 15
model : 35
model name : Dual Core AMD Opteron(tm) Processor 165
stepping : 2
cpu MHz : 1795.568
cache size : 1024 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 2
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 : 3594.90
TLB size : 1088 4K pages
clflush size : 64
cache_alignment : 64
address sizes : 40 bits physical, 48 bits virtual
power management: ts fid vid ttp
processor : 1
vendor_id : AuthenticAMD
cpu family : 15
model : 35
model name : Dual Core AMD Opteron(tm) Processor 165
stepping : 2
cpu MHz : 1795.568
cache size : 1024 KB
physical id : 0
siblings : 2
core id : 1
cpu cores : 2
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 : 3590.76
TLB size : 1088 4K pages
clflush size : 64
cache_alignment : 64
address sizes : 40 bits physical, 48 bits virtual
power management: ts fid vid ttp
Thank you for your help. We appreciate it.
Dedicated server with 7 vBulletin installations and 40 websites.
There are other PHP database applications on this server.
2. your server specs. For example:
AMD Opteron Dual-Core 165
2 GB RAM
2pcs Western Digital 250G SATA RAID Edition WD2500SD, 7200rpm, 8-Meg Buffer
CentOS 4.3 x86_64
Apache/1.3.36
PHP version: php 4.4.2
MySQL version: mysql 4.1.20
eAccelerator 0.9.4 is installed.
3. if you use mysql 4.x instead of mysql 3.23.x, do you have any innodb type databases/tables on
your server ?
NO
4. if possible how mysql was compiled/installed
Cpanel
5. your top stats
top - 20:52:46 up 6 days, 9:59, 1 user, load average: 0.25, 0.45, 0.43
Tasks: 154 total, 1 running, 153 sleeping, 0 stopped, 0 zombie
Cpu(s): 11.0% us, 2.7% sy, 0.0% ni, 85.4% id, 0.8% wa, 0.0% hi, 0.2% si
Mem: 2056428k total, 1979412k used, 77016k free, 55660k buffers
Swap: 2048276k total, 46700k used, 2001576k free, 1314256k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
6823 nobody 15 0 232m 14m 7884 S 6.0 0.7 0:00.18 httpd
6822 nobody 16 0 231m 12m 6952 S 5.3 0.6 0:00.16 httpd
4488 mysql 15 0 158m 85m 2968 S 4.0 4.2 3:27.32 mysqld
6820 nobody 15 0 230m 12m 7308 S 4.0 0.6 0:00.12 httpd
5354 nobody 15 0 233m 50m 42m S 2.7 2.5 0:10.31 httpd
6811 nobody 16 0 231m 14m 8108 S 1.0 0.7 0:00.05 httpd
6827 nobody 15 0 229m 10m 6556 S 1.0 0.5 0:00.03 httpd
6813 nobody 16 0 230m 11m 6960 S 0.7 0.6 0:00.02 httpd
6814 nobody 16 0 230m 11m 6960 S 0.7 0.6 0:00.02 httpd
20724 root 16 0 228m 8284 4484 S 0.3 0.4 0:03.27 httpd
5345 nobody 15 0 233m 46m 38m S 0.3 2.3 0:12.15 httpd
1 root 16 0 4748 512 428 S 0.0 0.0 0:01.64 init
2 root RT 0 0 0 0 S 0.0 0.0 0:00.54 migration/0
3 root 34 19 0 0 0 S 0.0 0.0 0:00.03 ksoftirqd/0
4 root RT 0 0 0 0 S 0.0 0.0 0:00.52 migration/1
5 root 34 19 0 0 0 S 0.0 0.0 0:00.05 ksoftirqd/1
6 root 5 -10 0 0 0 S 0.0 0.0 0:00.09 events/0
7 root 5 -10 0 0 0 S 0.0 0.0 0:00.07 events/1
8 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 khelper
9 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 kblockd/0
10 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 kblockd/1
11 root 15 0 0 0 0 S 0.0 0.0 0:00.00 khubd
45 root 15 -10 0 0 0 S 0.0 0.0 0:00.00 aio/0
44 root 15 0 0 0 0 S 0.0 0.0 0:27.48 kswapd0
46 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 aio/1
119 root 24 0 0 0 0 S 0.0 0.0 0:00.00 kseriod
192 root 19 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_0
207 root 15 0 0 0 0 S 0.0 0.0 1:12.79 kjournald
1089 root 6 -10 3604 500 408 S 0.0 0.0 0:00.00 udevd
1308 root 6 -10 0 0 0 S 0.0 0.0 0:00.00 kauditd
1346 root 7 -10 0 0 0 S 0.0 0.0 0:00.00 kmirrord
1347 root 7 -10 0 0 0 S 0.0 0.0 0:00.00 kmir_mon
1383 root 15 0 0 0 0 S 0.0 0.0 0:00.00 kjournald
1866 root 16 0 2548 508 416 S 0.0 0.0 0:00.14 irqbalance
1903 29 16 0 7956 872 732 S 0.0 0.0 0:00.00 rpc.statd
1931 root 16 0 19856 1340 1204 S 0.0 0.1 0:00.01 rpc.idmapd
2056 root 16 0 21960 1812 1552 S 0.0 0.1 0:05.72 sshd
2079 root 16 0 8712 828 664 S 0.0 0.0 0:00.00 xinetd
2200 root 16 0 57104 1136 732 S 0.0 0.1 0:00.17 crond
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]
safe-show-database
back_log = 75
skip-innodb
max_connections = 500
key_buffer = 32M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1800
thread_cache_size = 384
wait_timeout = 45
connect_timeout = 10
tmp_table_size = 64M
max_heap_table_size = 64M
max_allowed_packet = 64M
max_connect_errors = 10
read_rnd_buffer_size = 524288
bulk_insert_buffer_size = 8M
query_cache_limit = 3M
query_cache_size = 80M
query_cache_type = 1
query_prealloc_size = 163840
query_alloc_block_size = 32768
default-storage-engine = MyISAM
[mysqld_safe]
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
[mysqlhotcopy]
interactive-timeout
7. MySQL stats from ssh telnet as root user type:
a.)Quote:
mysqladmin -u root -p var ext stat ver
+---------------------------------+------------------------------------------+
| Variable_name | Value |
+---------------------------------+------------------------------------------+
| back_log | 75 |
| 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 | DISABLED |
| have_isam | NO |
| have_ndbcluster | NO |
| 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 | |
| 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 | 1044480 |
| key_buffer_size | 33554432 |
| 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 | 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 | 18446744073709551615 |
| max_binlog_size | 1073741824 |
| max_connect_errors | 10 |
| max_connections | 500 |
| max_delayed_threads | 20 |
| max_error_count | 64 |
| max_heap_table_size | 67107840 |
| max_insert_delayed_threads | 20 |
| max_join_size | 18446744073709551615 |
| max_length_for_sort_data | 1024 |
| max_prepared_stmt_count | 16382 |
| max_relay_log_size | 0 |
| max_seeks_for_key | 18446744073709551615 |
| max_sort_length | 1024 |
| max_tmp_tables | 32 |
| max_user_connections | 0 |
| max_write_lock_count | 18446744073709551615 |
| myisam_data_pointer_size | 4 |
| myisam_max_extra_sort_file_size | 2147483648 |
| myisam_max_sort_file_size | 9223372036854775807 |
| 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 | 4110 |
:
| pid_file | /var/lib/mysql/server.lvcmedia.com.pid |
| port | 3306 |
| preload_buffer_size | 32768 |
| prepared_stmt_count | 0 |
| protocol_version | 10 |
| query_alloc_block_size | 32768 |
| query_cache_limit | 3145728 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 83886080 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 163840 |
| range_alloc_block_size | 2048 |
| read_buffer_size | 1044480 |
| read_only | OFF |
| read_rnd_buffer_size | 520192 |
| 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 | 2097144 |
| 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 | EDT |
| table_cache | 1800 |
| table_type | MyISAM |
| thread_cache_size | 384 |
| thread_stack | 196608 |
| time_format | %H:%i:%s |
| time_zone | SYSTEM |
:
| tmp_table_size | 67108864 |
| tmpdir | |
| transaction_alloc_block_size | 8192 |
| transaction_prealloc_size | 4096 |
| tx_isolation | REPEATABLE-READ |
| version | 4.1.20-standard |
| version_comment | MySQL Community Edition - Standard (GPL) |
| version_compile_machine | x86_64 |
| version_compile_os | unknown-linux-gnu |
| wait_timeout | 45 |
+---------------------------------+------------------------------------------+
+----------------------------+------------+
| Variable_name | Value |
+----------------------------+------------+
| Aborted_clients | 86 |
| Aborted_connects | 114 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 32311738 |
| Bytes_sent | 2304146921 |
| Com_admin_commands | 0 |
| Com_alter_db | 0 |
| Com_alter_table | 27 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 3 |
| Com_change_db | 17261 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_commit | 3 |
| Com_create_db | 2 |
| Com_create_function | 0 |
| Com_create_index | 40 |
| Com_create_table | 23 |
| Com_dealloc_sql | 0 |
| Com_delete | 1735 |
| 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 | 4 |
| Com_grant | 22 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_help | 0 |
| Com_insert | 4251 |
| Com_insert_select | 34 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 86 |
| 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 | 512 |
| 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 | 46414 |
| Com_set_option | 13 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_charsets | 0 |
| Com_show_collations | 0 |
| Com_show_column_types | 0 |
| Com_show_create_db | 0 |
| Com_show_create_table | 0 |
| Com_show_databases | 0 |
| Com_show_errors | 0 |
| Com_show_fields | 0 |
| Com_show_grants | 0 |
| 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 | 21 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 12 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 7 |
| Com_show_variables | 11 |
| 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 | 86 |
| Com_update | 11327 |
| Com_update_multi | 0 |
| Connections | 12613 |
| Created_tmp_disk_tables | 2991 |
| Created_tmp_files | 34 |
| Created_tmp_tables | 3777 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 1809 |
| Handler_discover | 0 |
| Handler_read_first | 7431 |
| Handler_read_key | 530210 |
| Handler_read_next | 14985605 |
| Handler_read_prev | 32390 |
| Handler_read_rnd | 102768 |
| Handler_read_rnd_next | 34873477 |
| Handler_rollback | 0 |
| Handler_update | 11812 |
| Handler_write | 15378770 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 6091 |
| Key_blocks_used | 20701 |
| Key_read_requests | 1978040 |
| Key_reads | 20855 |
| Key_write_requests | 14300 |
| Key_writes | 9794 |
| Max_used_connections | 17 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 1398 |
| Open_streams | 0 |
| Open_tables | 749 |
| Opened_tables | 782 |
| Qcache_free_blocks | 2058 |
| Qcache_free_memory | 37951000 |
| Qcache_hits | 42879 |
| Qcache_inserts | 42509 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 3891 |
| Qcache_queries_in_cache | 9499 |
| Qcache_total_blocks | 22038 |
| Questions | 137217 |
| Rpl_status | NULL |
| Select_full_join | 20 |
| Select_full_range_join | 0 |
| Select_range | 11061 |
| Select_range_check | 0 |
| Select_scan | 5489 |
| Slave_open_temp_tables | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 1 |
| Slow_queries | 110 |
| Sort_merge_passes | 17 |
| Sort_range | 6262 |
| Sort_rows | 347844 |
| Sort_scan | 4751 |
| Table_locks_immediate | 107563 |
| Table_locks_waited | 29 |
| Threads_cached | 7 |
| Threads_connected | 10 |
| Threads_created | 17 |
| Threads_running | 1 |
| Uptime | 3909 |
+----------------------------+------------+
Uptime: 3909 Threads: 10 Questions: 137218 Slow queries: 110 Opens: 782 Flush tables: 1 Open tables: 749 Queries per se
cond avg: 35.103
mysqladmin Ver 8.41 Distrib 4.1.20, for unknown-linux-gnu on x86_64
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.20-standard
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 1 hour 5 min 9 sec
Threads: 10 Questions: 137218 Slow queries: 110 Opens: 782 Flush tables: 1 Open tables: 749 Queries per second avg: 35.1
03
Also if you want to better see what's going on install mysqlreport at
http://www.vbulletin.com/forum/showthread.php?t=175177 and run it by typing
b.) Quote:
mysqlreport --all -tab /statistics.txt
MySQL 4.1.20-standard uptime 0 1:12:22 Mon Jun 19 21:19:23 2006
__ Key __________________________________________________ _______________
Buffer usage 20.67M of 32.00M %Used: 64.58
Write ratio 0.68
Read ratio 0.01
__ Questions __________________________________________________ _________
Total 151.74k 34.95/s
DMS 70.43k 16.22/s %Total: 46.42
QC Hits 48.51k 11.17/s 31.97
Com_ 19.07k 4.39/s 12.57
COM_QUIT 13.87k 3.19/s 9.14
-Unknown 134 0.03/s 0.09
Slow 116 0.03/s 0.08 %DMS: 0.16
DMS 70.43k 16.22/s 46.42
SELECT 51.20k 11.79/s 33.74 72.70
UPDATE 12.25k 2.82/s 8.07 17.39
INSERT 4.63k 1.07/s 3.05 6.58
DELETE 1.79k 0.41/s 1.18 2.54
REPLACE 559 0.13/s 0.37 0.79
Com_ 19.07k 4.39/s 12.57
change_db 18.69k 4.31/s 12.32
lock_tables 90 0.02/s 0.06
unlock_tabl 90 0.02/s 0.06
__ SELECT and Sort __________________________________________________ ___
Scan 6.02k 1.39/s %SELECT: 11.76
Range 12.11k 2.79/s 23.65
Full join 21 0.00/s 0.04
Range check 0 0.00/s 0.00
Full rng join 0 0.00/s 0.00
Sort scan 5.45k 1.25/s
Sort range 7.11k 1.64/s
Sort mrg pass 18 0.00/s
__ Query Cache __________________________________________________ _______
Memory usage 46.31M of 80.00M %Used: 57.89
Block Fragmnt 8.53%
Hits 48.51k 11.17/s
Inserts 46.75k 10.77/s
Prunes 1 0.00/s
Insrt:Prune 46.75k:1 10.77/s
Hit:Insert 1.04:1
__ Table Locks __________________________________________________ _______
Waited 32 0.01/s %Total: 0.03
Immediate 117.78k 27.12/s
__ Tables __________________________________________________ ____________
Open 756 of 1800 %Cache: 42.00
Opened 789 0.18/s
__ Connections __________________________________________________ _______
Max used 17 of 500 %Max: 3.40
Total 13.91k 3.20/s
__ Created Temp __________________________________________________ ______
Disk table 3.37k 0.78/s
Table 4.44k 1.02/s
File 36 0.01/s
__ Threads __________________________________________________ ___________
Running 1 of 5
Cache 12 %Hit: 99.88
Created 17 0.00/s
Slow 1 0.00/s
__ Aborted __________________________________________________ ___________
Clients 90 0.02/s
Connects 126 0.03/s
__ Bytes __________________________________________________ _____________
Sent 2.53G 581.89/s
8. is your vB the only thing on the server? or other scripts & sites which utilise php and mysql?
Other sites run mysql apps. Directory software and amazon stores. Small DBs.
9. how many average and max concurrent users on your vB forum ? and what your cookie timeout is ?
200 avg. 400 max. cookie timeout 30 minutes.
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.lakecs.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 On
MaxKeepAliveRequests 120
KeepAliveTimeout 6
MinSpareServers 10
MaxSpareServers 15
StartServers 10
MaxClients 150
AND Maxrequestsperchild value = 1000
12. what version of vB are you running ?
One 3.5.0. Two 3.0.x forum. four or so 3.5.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
find / -size +2000000k
Found: /proc/kcore
14. Post output from these 3 commands
uname -a
Linux server.lvcmedia.com 2.6.9-34.0.1.ELsmp #1 SMP Wed May 24 05:28:30 CDT 2006 x86_64 x86_64 x86_64 GNU/Linux
ulimit -aH
core file size (blocks, -c) 1000000
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
pending signals (-i) 1024
max locked memory (kbytes, -l) 32
max memory size (kbytes, -m) unlimited
open files (-n) 4096
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
stack size (kbytes, -s) 8192
cpu time (seconds, -t) unlimited
max user processes (-u) 14335
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
cat /proc/cpuinfo
processor : 0
vendor_id : AuthenticAMD
cpu family : 15
model : 35
model name : Dual Core AMD Opteron(tm) Processor 165
stepping : 2
cpu MHz : 1795.568
cache size : 1024 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 2
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 : 3594.90
TLB size : 1088 4K pages
clflush size : 64
cache_alignment : 64
address sizes : 40 bits physical, 48 bits virtual
power management: ts fid vid ttp
processor : 1
vendor_id : AuthenticAMD
cpu family : 15
model : 35
model name : Dual Core AMD Opteron(tm) Processor 165
stepping : 2
cpu MHz : 1795.568
cache size : 1024 KB
physical id : 0
siblings : 2
core id : 1
cpu cores : 2
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 : 3590.76
TLB size : 1088 4K pages
clflush size : 64
cache_alignment : 64
address sizes : 40 bits physical, 48 bits virtual
power management: ts fid vid ttp
Thank you for your help. We appreciate it.