t3nt3tion
Fri 29th Dec '06, 2:32pm
I need some help with my server. I have a large user forum, but when only 10 users are online, loads go up fast and high. I hope it`s not a kernel issue.
================================================== ================================================== =====
cpu speed/type: AMD Athlon(tm) 64 Processor 3800+ / 2387 GHz
how much memory installed: 1GB ram
hard drive type/configuration: 80 GB non raid
linux distributor or windows version: CentOS release 4.4 (Final) 64bit
apache/IIS version: apache 1.3.37
PHP version: php 4.4.4 w/ Eaccelerator&Zend 3.0.1
MySQL version: mysql 4.1.21 for 64 bit OS
I have plain vBulletin databases with photopost gallery.
MySql was installed by cPanel build.
================================================== ================================================== =====
my.cnf output :
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
#skip-locking
#skip-innodb
#query_cache_limit=1M
#query_cache_size=2M
#query_cache_type=1
#max_connections=500
#interactive_timeout=100
#wait_timeout=100
#connect_timeout=10
#thread_cache_size=128
#key_buffer=16M
#join_buffer=1M
max_allowed_packet=8M
#table_cache=1024
#record_buffer=1M
#sort_buffer_size=2M
#read_buffer_size=2M
#max_connect_errors=10
thread_concurrency=2
#myisam_sort_buffer_size=64M
#log-bin
server-id=1
long_query_time=3
#key_buffer_size=5M
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
open_files_limit=8192
[mysqldump]
quick
#max_allowed_packet=16M
[mysql]
no-auto-rehash
#safe-updates
[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[mysqlhotcopy]
interactive-timeout
================================================== ================================================== =====
MySql variables output :
+---------------------------------+----------------------------------------------------------+
| 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 | 5 |
| datadir | /var/lib/mysql/ |
| date_format | %Y-%m-%d |
| datetime_format | %Y-%m-%d %H:%i:%s |
| default_week_format | 0 |
| delay_key_write | ON |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| expire_logs_days | 0 |
| flush | OFF |
| flush_time | 0 |
| ft_boolean_syntax | + -><()~*:""&| |
| ft_max_word_len | 84 |
| ft_min_word_len | 4 |
| ft_query_expansion_limit | 20 |
| ft_stopword_file | (built-in) |
| group_concat_max_len | 1024 |
| have_archive | NO |
| have_bdb | NO |
| have_blackhole_engine | NO |
| have_compress | YES |
| have_crypt | YES |
| have_csv | NO |
| have_example_engine | NO |
| have_geometry | YES |
| have_innodb | YES |
| have_isam | NO |
| have_ndbcluster | NO |
| have_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 | 28800 |
| join_buffer_size | 131072 |
| key_buffer_size | 8388600 |
| 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 | 3 |
| low_priority_updates | OFF |
| lower_case_file_system | OFF |
| lower_case_table_names | 0 |
| max_allowed_packet | 8387584 |
| max_binlog_cache_size | 18446744073709551615 |
| max_binlog_size | 1073741824 |
| max_connect_errors | 10 |
| max_connections | 100 |
| max_delayed_threads | 20 |
| max_error_count | 64 |
| max_heap_table_size | 16777216 |
| max_insert_delayed_threads | 20 |
| max_join_size | 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 | 8388608 |
| 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 | 1024 |
| pid_file | /var/lib/mysql/xxxx.xxxxxx.com.pid |
| port | 3306 |
| preload_buffer_size | 32768 |
| prepared_stmt_count | 0 |
| protocol_version | 10 |
| query_alloc_block_size | 8192 |
| query_cache_limit | 1048576 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 0 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 8192 |
| range_alloc_block_size | 2048 |
| read_buffer_size | 131072 |
| read_only | OFF |
| read_rnd_buffer_size | 262144 |
| relay_log_purge | ON |
| relay_log_space_limit | 0 |
| rpl_recovery_rank | 0 |
| secure_auth | OFF |
| server_id | 1 |
| skip_external_locking | ON |
| skip_networking | 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 | CST |
| table_cache | 64 |
| table_type | MyISAM |
| thread_cache_size | 0 |
| 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 | x86_64 |
| version_compile_os | unknown-linux-gnu |
| wait_timeout | 28800 |
+---------------------------------+----------------------------------------------------------+
+----------------------------+------------+
| Variable_name | Value |
+----------------------------+------------+
| Aborted_clients | 0 |
| Aborted_connects | 0 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 18386383 |
| Bytes_sent | 1624596328 |
| Com_admin_commands | 88 |
| Com_alter_db | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 13101 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_commit | 0 |
| Com_create_db | 1 |
| Com_create_function | 0 |
| Com_create_index | 1 |
| Com_create_table | 2 |
| Com_dealloc_sql | 0 |
| Com_delete | 449 |
| 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 | 1 |
| Com_grant | 1 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_help | 0 |
| Com_insert | 366 |
| Com_insert_select | 1 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 38 |
| 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 | 940 |
| 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 | 69969 |
| Com_set_option | 18 |
| 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 | 15 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 4 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 0 |
| Com_show_variables | 2 |
| 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 | 38 |
| Com_update | 18684 |
| Com_update_multi | 121 |
| Connections | 5935 |
| Created_tmp_disk_tables | 52 |
| Created_tmp_files | 211 |
| Created_tmp_tables | 682 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 111 |
| Handler_discover | 0 |
| Handler_read_first | 7443 |
| Handler_read_key | 2653264 |
| Handler_read_next | 2664326 |
| Handler_read_prev | 215 |
| Handler_read_rnd | 1202035 |
| Handler_read_rnd_next | 11050261 |
| Handler_rollback | 0 |
| Handler_update | 293537 |
| Handler_write | 703189 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 1435 |
| Key_blocks_used | 5734 |
| Key_read_requests | 6989986 |
| Key_reads | 10603 |
| Key_write_requests | 1707 |
| Key_writes | 823 |
| Max_used_connections | 25 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 119 |
| Open_streams | 0 |
| Open_tables | 64 |
| Opened_tables | 889 |
| Qcache_free_blocks | 0 |
| Qcache_free_memory | 0 |
| Qcache_hits | 0 |
| Qcache_inserts | 0 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 0 |
| Qcache_queries_in_cache | 0 |
| Qcache_total_blocks | 0 |
| Questions | 109680 |
| Rpl_status | NULL |
| Select_full_join | 12 |
| Select_full_range_join | 2 |
| Select_range | 10406 |
| Select_range_check | 0 |
| Select_scan | 38578 |
| Slave_open_temp_tables | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 8 |
| Sort_merge_passes | 166 |
| Sort_range | 1749 |
| Sort_rows | 2167414 |
| Sort_scan | 659 |
| Table_locks_immediate | 102941 |
| Table_locks_waited | 13 |
| Threads_cached | 0 |
| Threads_connected | 4 |
| Threads_created | 5934 |
| Threads_running | 1 |
| Uptime | 4478 |
+----------------------------+------------+
Uptime: 4478 Threads: 4 Questions: 109681 Slow queries: 8 Opens: 889 Flush tables: 1 Open tables: 64 Queries per second avg: 24.493
mysqladmin Ver 8.41 Distrib 4.1.21, 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.21-standard
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 1 hour 14 min 38 sec
Threads: 4 Questions: 109681 Slow queries: 8 Opens: 889 Flush tables: 1 Open tables: 64 Queries per second avg: 24.493
================================================== ================================================== =====
Generated MySql report :
MySQL 4.1.21-standard uptime 0 2:2:7 Fri Dec 29 12:04:57 2006
__ Key __________________________________________________ _______________
Buffer used 5.60M of 8.00M %Used: 70.00
Current 2.90M %Usage: 36.25
Write ratio 0.366
Read ratio 0.002
__ Questions __________________________________________________ _________
Total 179.31k 24.5/s
DMS 136.65k 18.7/s %Total: 76.21
Com_ 30.19k 4.1/s 16.84
COM_QUIT 12.57k 1.7/s 7.01
-Unknown 98 0.0/s 0.05
Slow 21 0.0/s 0.01 %DMS: 0.02
DMS 136.65k 18.7/s 76.21
SELECT 111.54k 15.2/s 62.21 81.63
UPDATE 20.63k 2.8/s 11.50 15.10
REPLACE 2.08k 0.3/s 1.16 1.52
DELETE 1.62k 0.2/s 0.91 1.19
INSERT 775 0.1/s 0.43 0.57
Com_ 30.19k 4.1/s 16.84
change_db 29.90k 4.1/s 16.67
admin_comma 89 0.0/s 0.05
lock_tables 65 0.0/s 0.04
__ SELECT and Sort __________________________________________________ ___
Scan 43.46k 5.9/s %SELECT: 38.96
Range 22.87k 3.1/s 20.51
Full join 15 0.0/s 0.01
Range check 0 0/s 0.00
Full rng join 2 0.0/s 0.00
Sort scan 1.53k 0.2/s
Sort range 3.69k 0.5/s
Sort mrg pass 288 0.0/s
__ Table Locks __________________________________________________ _______
Waited 23 0.0/s %Total: 0.01
Immediate 166.48k 22.7/s
__ Tables __________________________________________________ ____________
Open 64 of 64 %Cache: 100.00
Opened 1.65k 0.2/s
__ Connections __________________________________________________ _______
Max used 25 of 100 %Max: 25.00
Total 12.57k 1.7/s
__ Created Temp __________________________________________________ ______
Disk table 83 0.0/s
Table 1.16k 0.2/s
File 350 0.0/s
__ Threads __________________________________________________ ___________
Running 1 of 6
Cached 0 of 0 %Hit: 0.01
Created 12.57k 1.7/s
Slow 0 0/s
__ Aborted __________________________________________________ ___________
Clients 0 0/s
Connects 0 0/s
__ Bytes __________________________________________________ _____________
Sent 4.09G 558.4k/s
Received 40.96M 5.6k/s
================================================== ================================================== =====
2 vBulletin websites are the only thing chewing the server, and 1 is mostly inactive.
Coockie is set to 900s . I have on average 20-30 users always online.
Most users online were 1,913 . It depends on the hour.
As for phpinfo, tell me what varibles are needed, and I will paste them here.
================================================== ================================================== =====
Apache httpd.conf :
KeepAlive = Off
MaxKeepAliveRequests = 100
KeepAliveTimeout = 15
MinSpareServers = 5
MaxSpareServers = 10
StartServers = 5
MaxClients = 150
Maxrequestsperchild = 0
================================================== ================================================== =====
vBulletin version 3.6.3
================================================== ================================================== =====
uname -a
Linux xxxxxxx 2.6.9-34.0.2.EL #1 Fri Jul 7 17:58:49 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 : 47
model name : AMD Athlon(tm) 64 Processor 3800+
stepping : 2
cpu MHz : 2387.818
cache size : 512 KB
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 syscall nx mmxext lm 3dnowext 3dnow pni
bogomips : 4782.00
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 [4] [5]
================================================== ================================================== =====
cpu speed/type: AMD Athlon(tm) 64 Processor 3800+ / 2387 GHz
how much memory installed: 1GB ram
hard drive type/configuration: 80 GB non raid
linux distributor or windows version: CentOS release 4.4 (Final) 64bit
apache/IIS version: apache 1.3.37
PHP version: php 4.4.4 w/ Eaccelerator&Zend 3.0.1
MySQL version: mysql 4.1.21 for 64 bit OS
I have plain vBulletin databases with photopost gallery.
MySql was installed by cPanel build.
================================================== ================================================== =====
my.cnf output :
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
#skip-locking
#skip-innodb
#query_cache_limit=1M
#query_cache_size=2M
#query_cache_type=1
#max_connections=500
#interactive_timeout=100
#wait_timeout=100
#connect_timeout=10
#thread_cache_size=128
#key_buffer=16M
#join_buffer=1M
max_allowed_packet=8M
#table_cache=1024
#record_buffer=1M
#sort_buffer_size=2M
#read_buffer_size=2M
#max_connect_errors=10
thread_concurrency=2
#myisam_sort_buffer_size=64M
#log-bin
server-id=1
long_query_time=3
#key_buffer_size=5M
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
open_files_limit=8192
[mysqldump]
quick
#max_allowed_packet=16M
[mysql]
no-auto-rehash
#safe-updates
[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[mysqlhotcopy]
interactive-timeout
================================================== ================================================== =====
MySql variables output :
+---------------------------------+----------------------------------------------------------+
| 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 | 5 |
| datadir | /var/lib/mysql/ |
| date_format | %Y-%m-%d |
| datetime_format | %Y-%m-%d %H:%i:%s |
| default_week_format | 0 |
| delay_key_write | ON |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| expire_logs_days | 0 |
| flush | OFF |
| flush_time | 0 |
| ft_boolean_syntax | + -><()~*:""&| |
| ft_max_word_len | 84 |
| ft_min_word_len | 4 |
| ft_query_expansion_limit | 20 |
| ft_stopword_file | (built-in) |
| group_concat_max_len | 1024 |
| have_archive | NO |
| have_bdb | NO |
| have_blackhole_engine | NO |
| have_compress | YES |
| have_crypt | YES |
| have_csv | NO |
| have_example_engine | NO |
| have_geometry | YES |
| have_innodb | YES |
| have_isam | NO |
| have_ndbcluster | NO |
| have_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 | 28800 |
| join_buffer_size | 131072 |
| key_buffer_size | 8388600 |
| 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 | 3 |
| low_priority_updates | OFF |
| lower_case_file_system | OFF |
| lower_case_table_names | 0 |
| max_allowed_packet | 8387584 |
| max_binlog_cache_size | 18446744073709551615 |
| max_binlog_size | 1073741824 |
| max_connect_errors | 10 |
| max_connections | 100 |
| max_delayed_threads | 20 |
| max_error_count | 64 |
| max_heap_table_size | 16777216 |
| max_insert_delayed_threads | 20 |
| max_join_size | 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 | 8388608 |
| 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 | 1024 |
| pid_file | /var/lib/mysql/xxxx.xxxxxx.com.pid |
| port | 3306 |
| preload_buffer_size | 32768 |
| prepared_stmt_count | 0 |
| protocol_version | 10 |
| query_alloc_block_size | 8192 |
| query_cache_limit | 1048576 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 0 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 8192 |
| range_alloc_block_size | 2048 |
| read_buffer_size | 131072 |
| read_only | OFF |
| read_rnd_buffer_size | 262144 |
| relay_log_purge | ON |
| relay_log_space_limit | 0 |
| rpl_recovery_rank | 0 |
| secure_auth | OFF |
| server_id | 1 |
| skip_external_locking | ON |
| skip_networking | 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 | CST |
| table_cache | 64 |
| table_type | MyISAM |
| thread_cache_size | 0 |
| 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 | x86_64 |
| version_compile_os | unknown-linux-gnu |
| wait_timeout | 28800 |
+---------------------------------+----------------------------------------------------------+
+----------------------------+------------+
| Variable_name | Value |
+----------------------------+------------+
| Aborted_clients | 0 |
| Aborted_connects | 0 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 18386383 |
| Bytes_sent | 1624596328 |
| Com_admin_commands | 88 |
| Com_alter_db | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 13101 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_commit | 0 |
| Com_create_db | 1 |
| Com_create_function | 0 |
| Com_create_index | 1 |
| Com_create_table | 2 |
| Com_dealloc_sql | 0 |
| Com_delete | 449 |
| 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 | 1 |
| Com_grant | 1 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_help | 0 |
| Com_insert | 366 |
| Com_insert_select | 1 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 38 |
| 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 | 940 |
| 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 | 69969 |
| Com_set_option | 18 |
| 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 | 15 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 4 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 0 |
| Com_show_variables | 2 |
| 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 | 38 |
| Com_update | 18684 |
| Com_update_multi | 121 |
| Connections | 5935 |
| Created_tmp_disk_tables | 52 |
| Created_tmp_files | 211 |
| Created_tmp_tables | 682 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 111 |
| Handler_discover | 0 |
| Handler_read_first | 7443 |
| Handler_read_key | 2653264 |
| Handler_read_next | 2664326 |
| Handler_read_prev | 215 |
| Handler_read_rnd | 1202035 |
| Handler_read_rnd_next | 11050261 |
| Handler_rollback | 0 |
| Handler_update | 293537 |
| Handler_write | 703189 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 1435 |
| Key_blocks_used | 5734 |
| Key_read_requests | 6989986 |
| Key_reads | 10603 |
| Key_write_requests | 1707 |
| Key_writes | 823 |
| Max_used_connections | 25 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 119 |
| Open_streams | 0 |
| Open_tables | 64 |
| Opened_tables | 889 |
| Qcache_free_blocks | 0 |
| Qcache_free_memory | 0 |
| Qcache_hits | 0 |
| Qcache_inserts | 0 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 0 |
| Qcache_queries_in_cache | 0 |
| Qcache_total_blocks | 0 |
| Questions | 109680 |
| Rpl_status | NULL |
| Select_full_join | 12 |
| Select_full_range_join | 2 |
| Select_range | 10406 |
| Select_range_check | 0 |
| Select_scan | 38578 |
| Slave_open_temp_tables | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 8 |
| Sort_merge_passes | 166 |
| Sort_range | 1749 |
| Sort_rows | 2167414 |
| Sort_scan | 659 |
| Table_locks_immediate | 102941 |
| Table_locks_waited | 13 |
| Threads_cached | 0 |
| Threads_connected | 4 |
| Threads_created | 5934 |
| Threads_running | 1 |
| Uptime | 4478 |
+----------------------------+------------+
Uptime: 4478 Threads: 4 Questions: 109681 Slow queries: 8 Opens: 889 Flush tables: 1 Open tables: 64 Queries per second avg: 24.493
mysqladmin Ver 8.41 Distrib 4.1.21, 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.21-standard
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 1 hour 14 min 38 sec
Threads: 4 Questions: 109681 Slow queries: 8 Opens: 889 Flush tables: 1 Open tables: 64 Queries per second avg: 24.493
================================================== ================================================== =====
Generated MySql report :
MySQL 4.1.21-standard uptime 0 2:2:7 Fri Dec 29 12:04:57 2006
__ Key __________________________________________________ _______________
Buffer used 5.60M of 8.00M %Used: 70.00
Current 2.90M %Usage: 36.25
Write ratio 0.366
Read ratio 0.002
__ Questions __________________________________________________ _________
Total 179.31k 24.5/s
DMS 136.65k 18.7/s %Total: 76.21
Com_ 30.19k 4.1/s 16.84
COM_QUIT 12.57k 1.7/s 7.01
-Unknown 98 0.0/s 0.05
Slow 21 0.0/s 0.01 %DMS: 0.02
DMS 136.65k 18.7/s 76.21
SELECT 111.54k 15.2/s 62.21 81.63
UPDATE 20.63k 2.8/s 11.50 15.10
REPLACE 2.08k 0.3/s 1.16 1.52
DELETE 1.62k 0.2/s 0.91 1.19
INSERT 775 0.1/s 0.43 0.57
Com_ 30.19k 4.1/s 16.84
change_db 29.90k 4.1/s 16.67
admin_comma 89 0.0/s 0.05
lock_tables 65 0.0/s 0.04
__ SELECT and Sort __________________________________________________ ___
Scan 43.46k 5.9/s %SELECT: 38.96
Range 22.87k 3.1/s 20.51
Full join 15 0.0/s 0.01
Range check 0 0/s 0.00
Full rng join 2 0.0/s 0.00
Sort scan 1.53k 0.2/s
Sort range 3.69k 0.5/s
Sort mrg pass 288 0.0/s
__ Table Locks __________________________________________________ _______
Waited 23 0.0/s %Total: 0.01
Immediate 166.48k 22.7/s
__ Tables __________________________________________________ ____________
Open 64 of 64 %Cache: 100.00
Opened 1.65k 0.2/s
__ Connections __________________________________________________ _______
Max used 25 of 100 %Max: 25.00
Total 12.57k 1.7/s
__ Created Temp __________________________________________________ ______
Disk table 83 0.0/s
Table 1.16k 0.2/s
File 350 0.0/s
__ Threads __________________________________________________ ___________
Running 1 of 6
Cached 0 of 0 %Hit: 0.01
Created 12.57k 1.7/s
Slow 0 0/s
__ Aborted __________________________________________________ ___________
Clients 0 0/s
Connects 0 0/s
__ Bytes __________________________________________________ _____________
Sent 4.09G 558.4k/s
Received 40.96M 5.6k/s
================================================== ================================================== =====
2 vBulletin websites are the only thing chewing the server, and 1 is mostly inactive.
Coockie is set to 900s . I have on average 20-30 users always online.
Most users online were 1,913 . It depends on the hour.
As for phpinfo, tell me what varibles are needed, and I will paste them here.
================================================== ================================================== =====
Apache httpd.conf :
KeepAlive = Off
MaxKeepAliveRequests = 100
KeepAliveTimeout = 15
MinSpareServers = 5
MaxSpareServers = 10
StartServers = 5
MaxClients = 150
Maxrequestsperchild = 0
================================================== ================================================== =====
vBulletin version 3.6.3
================================================== ================================================== =====
uname -a
Linux xxxxxxx 2.6.9-34.0.2.EL #1 Fri Jul 7 17:58:49 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 : 47
model name : AMD Athlon(tm) 64 Processor 3800+
stepping : 2
cpu MHz : 2387.818
cache size : 512 KB
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 syscall nx mmxext lm 3dnowext 3dnow pni
bogomips : 4782.00
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 [4] [5]