Orion1985
Mon 17th Apr '06, 9:27pm
1. Is this on dedicated or shared virual server.
- Dedicated
2. Server specs
CPU: Dual Intel Xeon CPU 3.00GHz
MEM: 2GB
HDD: 144GB, 10K RPM SCSI RAID 5.
APACHE: 2.0.53 Fedora
OS: Linux 2.6.12-1.1381_FC3smp
MYSQL: 3.23.58
PHP: 4.3.11-2.8
3. if you use mysql 4.x instead of mysql 3.23.x, do you have any innodb type databases/tables on your server ?
- Unknown
4. if possible how mysql was compiled/installed
- It was installed by my host, likely from Plesk, likely a default install.
5. top stats
top - 15:16:19 up 20 days, 2:59, 1 user, load average: 0.59, 0.61, 0.49
Mem: 2074380k total, 1953412k used, 120968k free, 125908k buffers
Swap: 8385920k total, 11932k used, 8373988k free, 1230244k cached
6.
MySQL Variables
back_log 50
basedir /usr/
bdb_cache_size 8388600
bdb_log_buffer_size 32768
bdb_home /var/lib/mysql/
bdb_max_lock 10000
bdb_logdir
bdb_shared_data OFF
bdb_tmpdir /tmp/
bdb_version Sleepycat Software: Berkeley DB 3.2.9a: (September 11, 2003)
binlog_cache_size 32768
character_set latin1
character_sets latin1 big5 cp1251 cp1257 croat czech danish dec8 dos estonia euc_kr gb2312 gbk german1
greek hebrew hp8 hungarian koi8_ru koi8_ukr latin2 latin5 swe7 usa7 win1250 win1251 win1251ukr ujis sjis tis620
concurrent_insert ON
connect_timeout 5
datadir /var/lib/mysql/
delay_key_write ON
delayed_insert_limit 100
delayed_insert_timeout 300
delayed_queue_size 1000
flush OFF
flush_time 0
have_bdb YES
have_gemini NO
have_innodb YES
have_isam YES
have_raid NO
have_openssl NO
init_file
innodb_additional_mem_pool_size 1048576
innodb_buffer_pool_size 8388608
innodb_data_file_path ibdata1:10M:autoextend
innodb_data_home_dir
innodb_file_io_threads 4
innodb_force_recovery 0
innodb_thread_concurrency 8
innodb_flush_log_at_trx_commit 1
innodb_fast_shutdown ON
innodb_flush_method
innodb_lock_wait_timeout 50
innodb_log_arch_dir
innodb_log_archive OFF
innodb_log_buffer_size 1048576
innodb_log_file_size 5242880
innodb_log_files_in_group 2
innodb_log_group_home_dir ./
innodb_mirrored_log_groups 1
interactive_timeout 28800
join_buffer_size 131072
key_buffer_size 8388600
language /usr/share/mysql/english/
large_files_support ON
locked_in_memory OFF
log OFF
log_update OFF
log_bin OFF
log_slave_updates OFF
log_long_queries OFF
long_query_time 10
low_priority_updates OFF
lower_case_table_names 0
max_allowed_packet 1048576
max_binlog_cache_size 4294967295
max_binlog_size 1073741824
max_connections 100
max_connect_errors 10
max_delayed_threads 20
max_heap_table_size 16777216
max_join_size 4294967295
max_sort_length 1024
max_user_connections 0
max_tmp_tables 32
max_write_lock_count 4294967295
myisam_max_extra_sort_file_size 256
myisam_max_sort_file_size 2047
myisam_recover_options 0
myisam_sort_buffer_size 8388608
net_buffer_length 16384
net_read_timeout 30
net_retry_count 10
net_write_timeout 60
open_files_limit 0
pid_file /var/run/mysqld/mysqld.pid
port 3306
protocol_version 10
record_buffer 131072
record_rnd_buffer 131072
query_buffer_size 0
safe_show_database ON
server_id 0
slave_net_timeout 3600
skip_locking ON
skip_networking OFF
skip_show_database OFF
slow_launch_time 2
socket /var/lib/mysql/mysql.sock
sort_buffer 2097144
sql_mode 0
table_cache 64
table_type MYISAM
thread_cache_size 0
thread_stack 65536
transaction_isolation READ-COMMITTED
timezone CDT
tmp_table_size 33554432
tmpdir /tmp/
version 3.23.58
wait_timeout 28800
MySQL Status
Aborted_clients 4
Aborted_connects 170
Bytes_received 2540155849
Bytes_sent 107877701
Com_admin_commands 0
Com_alter_table 0
Com_analyze 0
Com_backup_table 0
Com_begin 7534
Com_change_db 2180018
Com_change_master 0
Com_check 1452
Com_commit 7534
Com_create_db 0
Com_create_function 0
Com_create_index 0
Com_create_table 0
Com_delete 97119
Com_drop_db 0
Com_drop_function 0
Com_drop_index 0
Com_drop_table 0
Com_flush 0
Com_grant 0
Com_insert 111651
Com_insert_select 949
Com_kill 0
Com_load 0
Com_load_master_table 0
Com_lock_tables 0
Com_optimize 1452
Com_purge 0
Com_rename_table 0
Com_repair 0
Com_replace 262963
Com_replace_select 7
Com_reset 0
Com_restore_table 0
Com_revoke 0
Com_rollback 0
Com_select 8522861
Com_set_option 5833
Com_show_binlogs 0
Com_show_create 903
Com_show_databases 0
Com_show_fields 903
Com_show_grants 0
Com_show_keys 0
Com_show_logs 0
Com_show_master_status 0
Com_show_open_tables 0
Com_show_processlist 0
Com_show_slave_status 0
Com_show_status 1
Com_show_innodb_status 0
Com_show_tables 62
Com_show_variables 69
Com_slave_start 0
Com_slave_stop 0
Com_truncate 0
Com_unlock_tables 0
Com_update 1163294
Connections 1760171
Created_tmp_disk_tables 1502
Created_tmp_tables 93020
Created_tmp_files 33
Delayed_insert_threads 0
Delayed_writes 0
Delayed_errors 0
Flush_commands 1
Handler_delete 145726
Handler_read_first 1715643
Handler_read_key 193843381
Handler_read_next 1008009429
Handler_read_prev 0
Handler_read_rnd 510066345
Handler_read_rnd_next 2701317034
Handler_update 68074433
Handler_write 16191663
Key_blocks_used 7793
Key_read_requests 430978678
Key_reads 3456627
Key_write_requests 1295506
Key_writes 890502
Max_used_connections 100
Not_flushed_key_blocks 0
Not_flushed_delayed_rows 0
Open_tables 64
Open_files 117
Open_streams 0
Opened_tables 153437
Questions 14124638
Select_full_join 10556
Select_full_range_join 17372
Select_range 1743412
Select_range_check 0
Select_scan 1787464
Slave_running OFF
Slave_open_temp_tables 0
Slow_launch_threads 0
Slow_queries 15
Sort_merge_passes 13
Sort_range 750521
Sort_rows 1230099924
Sort_scan 269483
Table_locks_immediate 14053502
Table_locks_waited 14141
Threads_cached 0
Threads_created 1760170
Threads_connected 1
Threads_running 1
Uptime 614781
7. MySQL stats
| back_log | 50
|
| basedir | /usr/
|
| bdb_cache_size | 8388600
|
| bdb_log_buffer_size | 32768
|
| bdb_home | /var/lib/mysql/
|
| bdb_max_lock | 10000
|
| bdb_logdir |
|
| bdb_shared_data | OFF
|
| bdb_tmpdir | /tmp/
|
| bdb_version | Sleepycat Software: Berkeley DB 3.2.9a: (September 11, 2003)
|
| binlog_cache_size | 32768
|
| character_set | latin1
|
| character_sets | latin1 big5 cp1251 cp1257 croat czech danish dec8 dos estonia euc_kr gb2312
gbk german1 greek hebrew hp8 hungarian koi8_ru koi8_ukr latin2 latin5 swe7 usa7 win1250 win1251 win1251ukr
ujis sjis tis620 |
| concurrent_insert | ON
|
| connect_timeout | 5
|
| datadir | /var/lib/mysql/
|
| delay_key_write | ON
|
| delayed_insert_limit | 100
|
| delayed_insert_timeout | 300
|
| delayed_queue_size | 1000
|
| flush | OFF
|
| flush_time | 0
|
| have_bdb | YES
|
| have_gemini | NO
|
| have_innodb | YES
|
| have_isam | YES
|
| have_raid | NO
|
| have_openssl | NO
|
| init_file |
|
| innodb_additional_mem_pool_size | 1048576
|
| innodb_buffer_pool_size | 8388608
|
| innodb_data_file_path | ibdata1:10M:autoextend
|
| innodb_data_home_dir |
|
| innodb_file_io_threads | 4
|
| innodb_force_recovery | 0
|
| innodb_thread_concurrency | 8
|
| innodb_flush_log_at_trx_commit | 1
|
| innodb_fast_shutdown | ON
|
| innodb_flush_method |
|
| innodb_lock_wait_timeout | 50
|
| innodb_log_arch_dir |
|
| innodb_log_archive | OFF
|
| innodb_log_buffer_size | 1048576
|
| innodb_log_file_size | 5242880
|
| innodb_log_files_in_group | 2
|
| innodb_log_group_home_dir | ./
|
| innodb_mirrored_log_groups | 1
|
| interactive_timeout | 28800
|
| join_buffer_size | 131072
|
| key_buffer_size | 8388600
|
| language | /usr/share/mysql/english/
|
| large_files_support | ON
|
| locked_in_memory | OFF
|
| log | OFF
|
| log_update | OFF
|
| log_bin | OFF
|
| log_slave_updates | OFF
|
| log_long_queries | OFF
|
| long_query_time | 10
|
| low_priority_updates | OFF
|
| lower_case_table_names | 0
|
| max_allowed_packet | 1048576
|
| max_binlog_cache_size | 4294967295
|
| max_binlog_size | 1073741824
|
| max_connections | 100
|
| max_connect_errors | 10
|
| max_delayed_threads | 20
|
| max_heap_table_size | 16777216
|
| max_join_size | 4294967295
|
| max_sort_length | 1024
|
| max_user_connections | 0
|
| max_tmp_tables | 32
|
| max_write_lock_count | 4294967295
|
| myisam_max_extra_sort_file_size | 256
|
| myisam_max_sort_file_size | 2047
|
| myisam_recover_options | 0
|
| myisam_sort_buffer_size | 8388608
|
| net_buffer_length | 16384
|
| net_read_timeout | 30
|
| net_retry_count | 10
|
| net_write_timeout | 60
|
| open_files_limit | 0
|
| pid_file | /var/run/mysqld/mysqld.pid
|
| port | 3306
|
| protocol_version | 10
|
| record_buffer | 131072
|
| record_rnd_buffer | 131072
|
| query_buffer_size | 0
|
| safe_show_database | ON
|
| server_id | 0
|
| slave_net_timeout | 3600
|
| skip_locking | ON
|
| skip_networking | OFF
|
| skip_show_database | OFF
|
| slow_launch_time | 2
|
| socket | /var/lib/mysql/mysql.sock
|
| sort_buffer | 2097144
|
| sql_mode | 0
|
| table_cache | 64
|
| table_type | MYISAM
|
| thread_cache_size | 0
|
| thread_stack | 65536
|
| transaction_isolation | READ-COMMITTED
|
| timezone | CDT
|
| tmp_table_size | 33554432
|
| tmpdir | /tmp/
|
| version | 3.23.58
|
| wait_timeout | 28800
|
+---------------------------------+------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------
---------------------+
+--------------------------+------------+
| Variable_name | Value |
+--------------------------+------------+
| Aborted_clients | 8 |
| Aborted_connects | 174 |
| Bytes_received | 2584624164 |
| Bytes_sent | 3707583314 |
| Com_admin_commands | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 7534 |
| Com_change_db | 2221522 |
| Com_change_master | 0 |
| Com_check | 1452 |
| Com_commit | 7534 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 1 |
| Com_delete | 99305 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 1 |
| Com_flush | 0 |
| Com_grant | 0 |
| Com_insert | 113377 |
| Com_insert_select | 983 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 0 |
| Com_optimize | 1452 |
| Com_purge | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 267128 |
| Com_replace_select | 7 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 0 |
| Com_select | 8665163 |
| Com_set_option | 5994 |
| Com_show_binlogs | 0 |
| Com_show_create | 903 |
| Com_show_databases | 0 |
| Com_show_fields | 903 |
| Com_show_grants | 0 |
| Com_show_keys | 0 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_open_tables | 0 |
| Com_show_processlist | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 56 |
| Com_show_innodb_status | 0 |
| Com_show_tables | 62 |
| Com_show_variables | 92 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 0 |
| Com_update | 1185454 |
| Connections | 1794192 |
| Created_tmp_disk_tables | 1550 |
| Created_tmp_tables | 94586 |
| Created_tmp_files | 33 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_delete | 148041 |
| Handler_read_first | 1748245 |
| Handler_read_key | 196861347 |
| Handler_read_next | 1026520165 |
| Handler_read_prev | 0 |
| Handler_read_rnd | 513797522 |
| Handler_read_rnd_next | 2807637114 |
| Handler_update | 68682654 |
| Handler_write | 16441168 |
| Key_blocks_used | 7793 |
| Key_read_requests | 439685214 |
| Key_reads | 3487392 |
| Key_write_requests | 1322110 |
| Key_writes | 910864 |
| Max_used_connections | 100 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 64 |
| Open_files | 119 |
| Open_streams | 0 |
| Opened_tables | 156371 |
| Questions | 14372933 |
| Select_full_join | 10800 |
| Select_full_range_join | 17759 |
| Select_range | 1774785 |
| Select_range_check | 0 |
| Select_scan | 1812520 |
| Slave_running | OFF |
| Slave_open_temp_tables | 0 |
| Slow_launch_threads | 0 |
| Slow_queries | 15 |
| Sort_merge_passes | 13 |
| Sort_range | 761739 |
| Sort_rows | 1247949412 |
| Sort_scan | 273645 |
| Table_locks_immediate | 14288574 |
| Table_locks_waited | 14396 |
| Threads_cached | 0 |
| Threads_created | 1794191 |
| Threads_connected | 1 |
| Threads_running | 1 |
| Uptime | 624231 |
+--------------------------+------------+
Uptime: 624232 Threads: 1 Questions: 14372934 Slow queries: 15 Opens: 156371 Flush tables: 1 Open
tables: 64 Queries per second avg: 23.025
mysqladmin Ver 8.23 Distrib 3.23.58, for redhat-linux-gnu on i386
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 3.23.58
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 7 days 5 hours 23 min 52 sec
Threads: 1 Questions: 14372934 Slow queries: 15 Opens: 156371 Flush tables: 1 Open tables: 64 Queries per
second avg: 23.025
8. is your vB the only thing on the server? or other scripts & sites which utilise php and mysql?
Vbulletin 3.5.3
Photopost 5.21 (35,000+ pics, 1200+ videos)
Reviewpost 3.11
vBadvanced CMPS v2.0.0 (vB 3.5)
phpAdsNew 2.0
9.
Cookie timeout is currently: 1 hour
Users online normally shows: 400-800 members
This is a new server, we've had as many as 4300 members showing online during "breaking news" events a few times per year on the old server at old host, but haven't seen that level of traffic on this new server yet at our new host. Most so far is maybe 800.
It's very sluggish, and had this issue the other day, but it recovered on it's own:
Database error in vBulletin :
mysql_connect(): Too many connections
Classname : vb_database
10. http://www.*******.com/temp/phpinfo.php (http://www.digitalcorvettes.com/temp/phpinfo.php)
11.
KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 15
MinSpareServers 5
MaxSpareServers 20
StartServers 8
MaxClients 256
MaxRequestsPerChild 4000
12. VB 3.5.3
13. None
14. Command output
uname -a
Linux dc.*******.com 2.6.12-1.1381_FC3smp #1 SMP Fri Oct 21 04:03:26 EDT 2005 i686 i686 i386 GNU/Linux
ulimit -aH
core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
pending signals (-i) 32759
max locked memory (kbytes, -l) 32
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
stack size (kbytes, -s) unlimited
cpu time (seconds, -t) unlimited
max user processes (-u) 32759
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
cat /proc/cpuinfo
processor : 0
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 3.00GHz
stepping : 3
cpu MHz : 3001.437
cache size : 2048 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 1
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 nx lm pni monitor ds_cpl cid cx16 xtpr
bogomips : 5947.39
processor : 1
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 3.00GHz
stepping : 3
cpu MHz : 3001.437
cache size : 2048 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 1
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 nx lm pni monitor ds_cpl cid cx16 xtpr
bogomips : 5996.54
processor : 2
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 3.00GHz
stepping : 3
cpu MHz : 3001.437
cache size : 2048 KB
physical id : 3
siblings : 2
core id : 3
cpu cores : 1
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 nx lm pni monitor ds_cpl cid cx16 xtpr
bogomips : 5980.16
processor : 3
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 3.00GHz
stepping : 3
cpu MHz : 3001.437
cache size : 2048 KB
physical id : 3
siblings : 2
core id : 3
cpu cores : 1
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 nx lm pni monitor ds_cpl cid cx16 xtpr
bogomips : 5996.54
Thanks in advance, we appreciate the help. :D
- Dedicated
2. Server specs
CPU: Dual Intel Xeon CPU 3.00GHz
MEM: 2GB
HDD: 144GB, 10K RPM SCSI RAID 5.
APACHE: 2.0.53 Fedora
OS: Linux 2.6.12-1.1381_FC3smp
MYSQL: 3.23.58
PHP: 4.3.11-2.8
3. if you use mysql 4.x instead of mysql 3.23.x, do you have any innodb type databases/tables on your server ?
- Unknown
4. if possible how mysql was compiled/installed
- It was installed by my host, likely from Plesk, likely a default install.
5. top stats
top - 15:16:19 up 20 days, 2:59, 1 user, load average: 0.59, 0.61, 0.49
Mem: 2074380k total, 1953412k used, 120968k free, 125908k buffers
Swap: 8385920k total, 11932k used, 8373988k free, 1230244k cached
6.
MySQL Variables
back_log 50
basedir /usr/
bdb_cache_size 8388600
bdb_log_buffer_size 32768
bdb_home /var/lib/mysql/
bdb_max_lock 10000
bdb_logdir
bdb_shared_data OFF
bdb_tmpdir /tmp/
bdb_version Sleepycat Software: Berkeley DB 3.2.9a: (September 11, 2003)
binlog_cache_size 32768
character_set latin1
character_sets latin1 big5 cp1251 cp1257 croat czech danish dec8 dos estonia euc_kr gb2312 gbk german1
greek hebrew hp8 hungarian koi8_ru koi8_ukr latin2 latin5 swe7 usa7 win1250 win1251 win1251ukr ujis sjis tis620
concurrent_insert ON
connect_timeout 5
datadir /var/lib/mysql/
delay_key_write ON
delayed_insert_limit 100
delayed_insert_timeout 300
delayed_queue_size 1000
flush OFF
flush_time 0
have_bdb YES
have_gemini NO
have_innodb YES
have_isam YES
have_raid NO
have_openssl NO
init_file
innodb_additional_mem_pool_size 1048576
innodb_buffer_pool_size 8388608
innodb_data_file_path ibdata1:10M:autoextend
innodb_data_home_dir
innodb_file_io_threads 4
innodb_force_recovery 0
innodb_thread_concurrency 8
innodb_flush_log_at_trx_commit 1
innodb_fast_shutdown ON
innodb_flush_method
innodb_lock_wait_timeout 50
innodb_log_arch_dir
innodb_log_archive OFF
innodb_log_buffer_size 1048576
innodb_log_file_size 5242880
innodb_log_files_in_group 2
innodb_log_group_home_dir ./
innodb_mirrored_log_groups 1
interactive_timeout 28800
join_buffer_size 131072
key_buffer_size 8388600
language /usr/share/mysql/english/
large_files_support ON
locked_in_memory OFF
log OFF
log_update OFF
log_bin OFF
log_slave_updates OFF
log_long_queries OFF
long_query_time 10
low_priority_updates OFF
lower_case_table_names 0
max_allowed_packet 1048576
max_binlog_cache_size 4294967295
max_binlog_size 1073741824
max_connections 100
max_connect_errors 10
max_delayed_threads 20
max_heap_table_size 16777216
max_join_size 4294967295
max_sort_length 1024
max_user_connections 0
max_tmp_tables 32
max_write_lock_count 4294967295
myisam_max_extra_sort_file_size 256
myisam_max_sort_file_size 2047
myisam_recover_options 0
myisam_sort_buffer_size 8388608
net_buffer_length 16384
net_read_timeout 30
net_retry_count 10
net_write_timeout 60
open_files_limit 0
pid_file /var/run/mysqld/mysqld.pid
port 3306
protocol_version 10
record_buffer 131072
record_rnd_buffer 131072
query_buffer_size 0
safe_show_database ON
server_id 0
slave_net_timeout 3600
skip_locking ON
skip_networking OFF
skip_show_database OFF
slow_launch_time 2
socket /var/lib/mysql/mysql.sock
sort_buffer 2097144
sql_mode 0
table_cache 64
table_type MYISAM
thread_cache_size 0
thread_stack 65536
transaction_isolation READ-COMMITTED
timezone CDT
tmp_table_size 33554432
tmpdir /tmp/
version 3.23.58
wait_timeout 28800
MySQL Status
Aborted_clients 4
Aborted_connects 170
Bytes_received 2540155849
Bytes_sent 107877701
Com_admin_commands 0
Com_alter_table 0
Com_analyze 0
Com_backup_table 0
Com_begin 7534
Com_change_db 2180018
Com_change_master 0
Com_check 1452
Com_commit 7534
Com_create_db 0
Com_create_function 0
Com_create_index 0
Com_create_table 0
Com_delete 97119
Com_drop_db 0
Com_drop_function 0
Com_drop_index 0
Com_drop_table 0
Com_flush 0
Com_grant 0
Com_insert 111651
Com_insert_select 949
Com_kill 0
Com_load 0
Com_load_master_table 0
Com_lock_tables 0
Com_optimize 1452
Com_purge 0
Com_rename_table 0
Com_repair 0
Com_replace 262963
Com_replace_select 7
Com_reset 0
Com_restore_table 0
Com_revoke 0
Com_rollback 0
Com_select 8522861
Com_set_option 5833
Com_show_binlogs 0
Com_show_create 903
Com_show_databases 0
Com_show_fields 903
Com_show_grants 0
Com_show_keys 0
Com_show_logs 0
Com_show_master_status 0
Com_show_open_tables 0
Com_show_processlist 0
Com_show_slave_status 0
Com_show_status 1
Com_show_innodb_status 0
Com_show_tables 62
Com_show_variables 69
Com_slave_start 0
Com_slave_stop 0
Com_truncate 0
Com_unlock_tables 0
Com_update 1163294
Connections 1760171
Created_tmp_disk_tables 1502
Created_tmp_tables 93020
Created_tmp_files 33
Delayed_insert_threads 0
Delayed_writes 0
Delayed_errors 0
Flush_commands 1
Handler_delete 145726
Handler_read_first 1715643
Handler_read_key 193843381
Handler_read_next 1008009429
Handler_read_prev 0
Handler_read_rnd 510066345
Handler_read_rnd_next 2701317034
Handler_update 68074433
Handler_write 16191663
Key_blocks_used 7793
Key_read_requests 430978678
Key_reads 3456627
Key_write_requests 1295506
Key_writes 890502
Max_used_connections 100
Not_flushed_key_blocks 0
Not_flushed_delayed_rows 0
Open_tables 64
Open_files 117
Open_streams 0
Opened_tables 153437
Questions 14124638
Select_full_join 10556
Select_full_range_join 17372
Select_range 1743412
Select_range_check 0
Select_scan 1787464
Slave_running OFF
Slave_open_temp_tables 0
Slow_launch_threads 0
Slow_queries 15
Sort_merge_passes 13
Sort_range 750521
Sort_rows 1230099924
Sort_scan 269483
Table_locks_immediate 14053502
Table_locks_waited 14141
Threads_cached 0
Threads_created 1760170
Threads_connected 1
Threads_running 1
Uptime 614781
7. MySQL stats
| back_log | 50
|
| basedir | /usr/
|
| bdb_cache_size | 8388600
|
| bdb_log_buffer_size | 32768
|
| bdb_home | /var/lib/mysql/
|
| bdb_max_lock | 10000
|
| bdb_logdir |
|
| bdb_shared_data | OFF
|
| bdb_tmpdir | /tmp/
|
| bdb_version | Sleepycat Software: Berkeley DB 3.2.9a: (September 11, 2003)
|
| binlog_cache_size | 32768
|
| character_set | latin1
|
| character_sets | latin1 big5 cp1251 cp1257 croat czech danish dec8 dos estonia euc_kr gb2312
gbk german1 greek hebrew hp8 hungarian koi8_ru koi8_ukr latin2 latin5 swe7 usa7 win1250 win1251 win1251ukr
ujis sjis tis620 |
| concurrent_insert | ON
|
| connect_timeout | 5
|
| datadir | /var/lib/mysql/
|
| delay_key_write | ON
|
| delayed_insert_limit | 100
|
| delayed_insert_timeout | 300
|
| delayed_queue_size | 1000
|
| flush | OFF
|
| flush_time | 0
|
| have_bdb | YES
|
| have_gemini | NO
|
| have_innodb | YES
|
| have_isam | YES
|
| have_raid | NO
|
| have_openssl | NO
|
| init_file |
|
| innodb_additional_mem_pool_size | 1048576
|
| innodb_buffer_pool_size | 8388608
|
| innodb_data_file_path | ibdata1:10M:autoextend
|
| innodb_data_home_dir |
|
| innodb_file_io_threads | 4
|
| innodb_force_recovery | 0
|
| innodb_thread_concurrency | 8
|
| innodb_flush_log_at_trx_commit | 1
|
| innodb_fast_shutdown | ON
|
| innodb_flush_method |
|
| innodb_lock_wait_timeout | 50
|
| innodb_log_arch_dir |
|
| innodb_log_archive | OFF
|
| innodb_log_buffer_size | 1048576
|
| innodb_log_file_size | 5242880
|
| innodb_log_files_in_group | 2
|
| innodb_log_group_home_dir | ./
|
| innodb_mirrored_log_groups | 1
|
| interactive_timeout | 28800
|
| join_buffer_size | 131072
|
| key_buffer_size | 8388600
|
| language | /usr/share/mysql/english/
|
| large_files_support | ON
|
| locked_in_memory | OFF
|
| log | OFF
|
| log_update | OFF
|
| log_bin | OFF
|
| log_slave_updates | OFF
|
| log_long_queries | OFF
|
| long_query_time | 10
|
| low_priority_updates | OFF
|
| lower_case_table_names | 0
|
| max_allowed_packet | 1048576
|
| max_binlog_cache_size | 4294967295
|
| max_binlog_size | 1073741824
|
| max_connections | 100
|
| max_connect_errors | 10
|
| max_delayed_threads | 20
|
| max_heap_table_size | 16777216
|
| max_join_size | 4294967295
|
| max_sort_length | 1024
|
| max_user_connections | 0
|
| max_tmp_tables | 32
|
| max_write_lock_count | 4294967295
|
| myisam_max_extra_sort_file_size | 256
|
| myisam_max_sort_file_size | 2047
|
| myisam_recover_options | 0
|
| myisam_sort_buffer_size | 8388608
|
| net_buffer_length | 16384
|
| net_read_timeout | 30
|
| net_retry_count | 10
|
| net_write_timeout | 60
|
| open_files_limit | 0
|
| pid_file | /var/run/mysqld/mysqld.pid
|
| port | 3306
|
| protocol_version | 10
|
| record_buffer | 131072
|
| record_rnd_buffer | 131072
|
| query_buffer_size | 0
|
| safe_show_database | ON
|
| server_id | 0
|
| slave_net_timeout | 3600
|
| skip_locking | ON
|
| skip_networking | OFF
|
| skip_show_database | OFF
|
| slow_launch_time | 2
|
| socket | /var/lib/mysql/mysql.sock
|
| sort_buffer | 2097144
|
| sql_mode | 0
|
| table_cache | 64
|
| table_type | MYISAM
|
| thread_cache_size | 0
|
| thread_stack | 65536
|
| transaction_isolation | READ-COMMITTED
|
| timezone | CDT
|
| tmp_table_size | 33554432
|
| tmpdir | /tmp/
|
| version | 3.23.58
|
| wait_timeout | 28800
|
+---------------------------------+------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------
---------------------+
+--------------------------+------------+
| Variable_name | Value |
+--------------------------+------------+
| Aborted_clients | 8 |
| Aborted_connects | 174 |
| Bytes_received | 2584624164 |
| Bytes_sent | 3707583314 |
| Com_admin_commands | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 7534 |
| Com_change_db | 2221522 |
| Com_change_master | 0 |
| Com_check | 1452 |
| Com_commit | 7534 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 1 |
| Com_delete | 99305 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 1 |
| Com_flush | 0 |
| Com_grant | 0 |
| Com_insert | 113377 |
| Com_insert_select | 983 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 0 |
| Com_optimize | 1452 |
| Com_purge | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 267128 |
| Com_replace_select | 7 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 0 |
| Com_select | 8665163 |
| Com_set_option | 5994 |
| Com_show_binlogs | 0 |
| Com_show_create | 903 |
| Com_show_databases | 0 |
| Com_show_fields | 903 |
| Com_show_grants | 0 |
| Com_show_keys | 0 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_open_tables | 0 |
| Com_show_processlist | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 56 |
| Com_show_innodb_status | 0 |
| Com_show_tables | 62 |
| Com_show_variables | 92 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 0 |
| Com_update | 1185454 |
| Connections | 1794192 |
| Created_tmp_disk_tables | 1550 |
| Created_tmp_tables | 94586 |
| Created_tmp_files | 33 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_delete | 148041 |
| Handler_read_first | 1748245 |
| Handler_read_key | 196861347 |
| Handler_read_next | 1026520165 |
| Handler_read_prev | 0 |
| Handler_read_rnd | 513797522 |
| Handler_read_rnd_next | 2807637114 |
| Handler_update | 68682654 |
| Handler_write | 16441168 |
| Key_blocks_used | 7793 |
| Key_read_requests | 439685214 |
| Key_reads | 3487392 |
| Key_write_requests | 1322110 |
| Key_writes | 910864 |
| Max_used_connections | 100 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 64 |
| Open_files | 119 |
| Open_streams | 0 |
| Opened_tables | 156371 |
| Questions | 14372933 |
| Select_full_join | 10800 |
| Select_full_range_join | 17759 |
| Select_range | 1774785 |
| Select_range_check | 0 |
| Select_scan | 1812520 |
| Slave_running | OFF |
| Slave_open_temp_tables | 0 |
| Slow_launch_threads | 0 |
| Slow_queries | 15 |
| Sort_merge_passes | 13 |
| Sort_range | 761739 |
| Sort_rows | 1247949412 |
| Sort_scan | 273645 |
| Table_locks_immediate | 14288574 |
| Table_locks_waited | 14396 |
| Threads_cached | 0 |
| Threads_created | 1794191 |
| Threads_connected | 1 |
| Threads_running | 1 |
| Uptime | 624231 |
+--------------------------+------------+
Uptime: 624232 Threads: 1 Questions: 14372934 Slow queries: 15 Opens: 156371 Flush tables: 1 Open
tables: 64 Queries per second avg: 23.025
mysqladmin Ver 8.23 Distrib 3.23.58, for redhat-linux-gnu on i386
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 3.23.58
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 7 days 5 hours 23 min 52 sec
Threads: 1 Questions: 14372934 Slow queries: 15 Opens: 156371 Flush tables: 1 Open tables: 64 Queries per
second avg: 23.025
8. is your vB the only thing on the server? or other scripts & sites which utilise php and mysql?
Vbulletin 3.5.3
Photopost 5.21 (35,000+ pics, 1200+ videos)
Reviewpost 3.11
vBadvanced CMPS v2.0.0 (vB 3.5)
phpAdsNew 2.0
9.
Cookie timeout is currently: 1 hour
Users online normally shows: 400-800 members
This is a new server, we've had as many as 4300 members showing online during "breaking news" events a few times per year on the old server at old host, but haven't seen that level of traffic on this new server yet at our new host. Most so far is maybe 800.
It's very sluggish, and had this issue the other day, but it recovered on it's own:
Database error in vBulletin :
mysql_connect(): Too many connections
Classname : vb_database
10. http://www.*******.com/temp/phpinfo.php (http://www.digitalcorvettes.com/temp/phpinfo.php)
11.
KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 15
MinSpareServers 5
MaxSpareServers 20
StartServers 8
MaxClients 256
MaxRequestsPerChild 4000
12. VB 3.5.3
13. None
14. Command output
uname -a
Linux dc.*******.com 2.6.12-1.1381_FC3smp #1 SMP Fri Oct 21 04:03:26 EDT 2005 i686 i686 i386 GNU/Linux
ulimit -aH
core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
pending signals (-i) 32759
max locked memory (kbytes, -l) 32
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
stack size (kbytes, -s) unlimited
cpu time (seconds, -t) unlimited
max user processes (-u) 32759
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
cat /proc/cpuinfo
processor : 0
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 3.00GHz
stepping : 3
cpu MHz : 3001.437
cache size : 2048 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 1
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 nx lm pni monitor ds_cpl cid cx16 xtpr
bogomips : 5947.39
processor : 1
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 3.00GHz
stepping : 3
cpu MHz : 3001.437
cache size : 2048 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 1
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 nx lm pni monitor ds_cpl cid cx16 xtpr
bogomips : 5996.54
processor : 2
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 3.00GHz
stepping : 3
cpu MHz : 3001.437
cache size : 2048 KB
physical id : 3
siblings : 2
core id : 3
cpu cores : 1
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 nx lm pni monitor ds_cpl cid cx16 xtpr
bogomips : 5980.16
processor : 3
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 3.00GHz
stepping : 3
cpu MHz : 3001.437
cache size : 2048 KB
physical id : 3
siblings : 2
core id : 3
cpu cores : 1
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 nx lm pni monitor ds_cpl cid cx16 xtpr
bogomips : 5996.54
Thanks in advance, we appreciate the help. :D