hantak
Tue 3rd Jul '07, 7:22pm
Been noticing some performance problems recently. Running a small site (average 40 users concurrently). Unsure if these issues are from my settings or other guys on my shared virtual server.
Haven't done that much tweaking from the default install of the OS. I did add the apc php cacher.
I know I have to update the MySQL and PHP executables. And I have to update to vb 3.6.7. Just looking to make sure my memory / thread settings are right.
One thing I had just noticied was my thread_concurrency should be at 8 instead of 4.
Are there any other settings that should be tweaked?
-----
1. Shared Virtual Server (unsure of number of sites on server)
2.
2x Dual-Core Intel Xeon 2.8 GHz Processor
1 GB RAM (256 MB Dedicated)
73GB 10K Ultra 320 SCSI Drives (Raid 1)
CentOS 4.4
Apache v1.3.37
PHP 4.4.4
MySQL 4.1.21-standard
3. vBulletin 3.6.4
4. no innodb tables
6.
top - 14:36:13 up 87 days, 4:24, 0 users, load average: 0.31, 0.30, 0.41
Tasks: 53 total, 1 running, 52 sleeping, 0 stopped, 0 zombie
Cpu(s): 2.0% us, 0.8% sy, 0.0% ni, 81.9% id, 15.3% wa, 0.0% hi, 0.0% si
Mem: 6220344k total, 6188064k used, 32280k free, 234056k buffers
Swap: 12289716k total, 417712k used, 11872004k free, 2259820k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
5684 mysql 11 -5 138m 18m 1948 S 4.0 0.3 0:01.69 mysqld
30014 apache 15 0 152m 38m 32m S 3.3 0.6 0:23.19 httpd
18431 apache 15 0 152m 38m 32m S 3.0 0.6 0:17.82 httpd
30281 mysql 11 -5 138m 18m 1948 S 1.3 0.3 0:00.58 mysqld
1 root 16 0 1616 536 512 S 0.0 0.0 0:01.49 init
24135 root 15 0 1520 536 452 S 0.0 0.0 0:46.56 syslogd
24497 root 16 0 4016 684 592 S 0.0 0.0 0:00.05 sshd
25801 root 18 0 2068 536 532 S 0.0 0.0 0:00.00 xinetd
28387 root 15 0 888 148 120 S 0.0 0.0 0:01.02 da-popb4smtp
1674 ftp 16 0 2384 992 664 S 0.0 0.0 0:03.67 proftpd
3802 root 18 0 4060 532 456 S 0.0 0.0 0:00.00 saslauthd
9560 named 16 0 68260 2396 1704 S 0.0 0.0 0:01.27 named
25721 root 15 0 3716 576 520 S 0.0 0.0 0:10.72 crond
7789 mail 15 0 7980 1140 768 S 0.0 0.0 0:00.89 exim
6058 nobody 16 0 6628 1160 916 S 0.0 0.0 0:00.70 directadmin
27883 root 16 0 6900 2192 1764 S 0.0 0.0 0:00.15 sshd
28074 hantak 16 0 7056 1752 1292 S 0.0 0.0 0:02.75 sshd
28078 hantak 16 0 2148 1268 1032 S 0.0 0.0 0:00.02 bash
28366 root 15 0 4068 1084 856 S 0.0 0.0 0:00.00 su
28402 root 16 0 2728 1320 1056 S 0.0 0.0 0:00.05 bash
29982 root 15 0 148m 13m 9840 S 0.0 0.2 0:00.21 httpd
30013 apache 16 0 153m 38m 31m S 0.0 0.6 0:23.38 httpd
30015 apache 16 0 153m 37m 30m S 0.0 0.6 0:21.96 httpd
30016 apache 16 0 152m 37m 31m S 0.0 0.6 0:23.66 httpd
30017 apache 15 0 152m 38m 32m S 0.0 0.6 0:19.62 httpd
30018 apache 16 0 155m 43m 34m S 0.0 0.7 0:20.23 httpd
30019 apache 16 0 152m 34m 28m S 0.0 0.6 0:22.23 httpd
30020 apache 16 0 158m 42m 30m S 0.0 0.7 0:24.45 httpd
30508 apache 16 0 152m 40m 35m S 0.0 0.7 0:22.18 httpd
30553 apache 16 0 152m 37m 32m S 0.0 0.6 0:23.17 httpd
11692 apache 16 0 150m 30m 25m S 0.0 0.5 0:23.53 httpd
11719 apache 15 0 153m 38m 32m S 0.0 0.6 0:20.79 httpd
11720 apache 16 0 152m 36m 30m S 0.0 0.6 0:21.46 httpd
11846 apache 16 0 154m 38m 31m S 0.0 0.6 0:22.15 httpd
16263 apache 15 0 152m 33m 28m S 0.0 0.6 0:13.45 httpd
16300 apache 15 0 152m 36m 30m S 0.0 0.6 0:15.01 httpd
16302 apache 16 0 152m 32m 26m S 0.0 0.5 0:10.75 httpd
32344 apache 16 0 152m 34m 29m S 0.0 0.6 0:13.60 httpd
1675 root 16 0 3360 1044 884 S 0.0 0.0 0:00.01 mysqld_safe
1853 mysql 10 -5 138m 18m 1948 S 0.0 0.3 0:00.08 mysqld
1911 mysql 10 -5 138m 18m 1948 S 0.0 0.3 0:00.00 mysqld
1912 mysql 10 -5 138m 18m 1948 S 0.0 0.3 0:00.07 mysqld
3468 mysql 11 -5 138m 18m 1948 S 0.0 0.3 0:01.54 mysqld
5434 mysql 10 -5 138m 18m 1948 S 0.0 0.3 0:01.37 mysqld
7387 mysql 10 -5 138m 18m 1948 S 0.0 0.3 0:00.87 mysqld
7432 mysql 11 -5 138m 18m 1948 S 0.0 0.3 0:01.83 mysqld
7434 mysql 10 -5 138m 18m 1948 S 0.0 0.3 0:00.96 mysqld
3858 nobody 15 0 6628 340 96 S 0.0 0.0 0:00.00 directadmin
3861 nobody 15 0 6628 340 96 S 0.0 0.0 0:00.00 directadmin
7.
[mysqld]
safe-show-database
back_log = 75
skip-innodb
max_connections = 500
key_buffer = 64M
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 = 15
connect_timeout = 10
tmp_table_size = 64M
max_heap_table_size = 64M
max_allowed_packet = 64M
max_connect_errors = 10
thread_concurrency = 8
read_rnd_buffer_size = 524288
bulk_insert_buffer_size = 8M
query_cache_limit = 4M
query_cache_size = 64M
query_cache_type = 1
query_prealloc_size = 131072
query_alloc_block_size = 65536
default-storage-engine = MyISAM
[mysqld_safe]
nice = -5
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
8.
+---------------------------------+----------------------------------------------+
| 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 | 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 | 1044480 |
| key_buffer_size | 25165824 |
| key_cache_age_threshold | 300 |
| key_cache_block_size | 1024 |
| key_cache_division_limit | 100 |
| language | /usr/share/mysql/english/ |
| large_files_support | ON |
| lc_time_names | en_US |
| license | GPL |
| local_infile | ON |
| locked_in_memory | OFF |
| log | OFF |
| log_bin | OFF |
| log_error | |
| log_slave_updates | OFF |
| log_slow_queries | OFF |
| log_update | OFF |
| log_warnings | 1 |
| long_query_time | 10 |
| low_priority_updates | OFF |
| lower_case_file_system | OFF |
| lower_case_table_names | 0 |
| max_allowed_packet | 67107840 |
| max_binlog_cache_size | 4294967295 |
| max_binlog_size | 1073741824 |
| max_connect_errors | 10 |
| max_connections | 500 |
| max_delayed_threads | 20 |
| max_error_count | 64 |
| max_heap_table_size | 67107840 |
| max_insert_delayed_threads | 20 |
| max_join_size | 4294967295 |
| max_length_for_sort_data | 1024 |
| max_prepared_stmt_count | 16382 |
| max_relay_log_size | 0 |
| max_seeks_for_key | 4294967295 |
| max_sort_length | 1024 |
| max_tmp_tables | 32 |
| max_user_connections | 0 |
| max_write_lock_count | 4294967295 |
| myisam_data_pointer_size | 4 |
| myisam_max_extra_sort_file_size | 2147483648 |
| myisam_max_sort_file_size | 2147483647 |
| myisam_recover_options | OFF |
| myisam_repair_threads | 1 |
| myisam_sort_buffer_size | 67108864 |
| 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 | 2910 |
| pid_file | /var/lib/mysql/host.gamercastnetwork.com.pid |
| port | 3306 |
| preload_buffer_size | 32768 |
| prepared_stmt_count | 0 |
| protocol_version | 10 |
| query_alloc_block_size | 65536 |
| query_cache_limit | 2097152 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 16777216 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 131072 |
| 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 | OFF |
| sql_warnings | OFF |
| 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 | 1200 |
| table_type | MyISAM |
| thread_cache_size | 128 |
| thread_stack | 126976 |
| 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.21-standard |
| version_comment | MySQL Community Edition - Standard (GPL) |
| version_compile_machine | i686 |
| version_compile_os | pc-linux-gnu |
| wait_timeout | 15 |
+---------------------------------+----------------------------------------------+
+----------------------------+------------+
| Variable_name | Value |
+----------------------------+------------+
| Aborted_clients | 166 |
| Aborted_connects | 1 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 66763182 |
| Bytes_sent | 2981758359 |
| Com_admin_commands | 0 |
| Com_alter_db | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 25575 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_commit | 0 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 0 |
| Com_dealloc_sql | 0 |
| Com_delete | 1149 |
| Com_delete_multi | 0 |
| Com_do | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_drop_user | 0 |
| Com_execute_sql | 0 |
| Com_flush | 0 |
| Com_grant | 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_help | 0 |
| Com_insert | 4629 |
| Com_insert_select | 0 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 78 |
| 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 | 11659 |
| 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 | 63574 |
| Com_set_option | 356 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 5 |
| Com_show_charsets | 28 |
| Com_show_collations | 28 |
| Com_show_column_types | 0 |
| Com_show_create_db | 0 |
| Com_show_create_table | 132 |
| Com_show_databases | 21 |
| Com_show_errors | 0 |
| Com_show_fields | 149 |
| Com_show_grants | 11 |
| Com_show_innodb_status | 0 |
| Com_show_keys | 3 |
| 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 | 0 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 24 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 222 |
| Com_show_variables | 91 |
| 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 | 77 |
| Com_unlock_tables | 78 |
| Com_update | 21194 |
| Com_update_multi | 0 |
| Connections | 25548 |
| Created_tmp_disk_tables | 95 |
| Created_tmp_files | 4 |
| Created_tmp_tables | 2932 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 3279 |
| Handler_discover | 0 |
| Handler_read_first | 15891 |
| Handler_read_key | 2497921 |
| Handler_read_next | 8795591 |
| Handler_read_prev | 122565 |
| Handler_read_rnd | 119205 |
| Handler_read_rnd_next | 8396344 |
| Handler_rollback | 0 |
| Handler_update | 55090 |
| Handler_write | 120261 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 13328 |
| Key_blocks_used | 8478 |
| Key_read_requests | 12071997 |
| Key_reads | 8884 |
| Key_write_requests | 56043 |
| Key_writes | 29592 |
| Max_used_connections | 17 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 735 |
| Open_streams | 0 |
| Open_tables | 417 |
| Opened_tables | 608 |
| Qcache_free_blocks | 427 |
| Qcache_free_memory | 7025016 |
| Qcache_hits | 79578 |
| Qcache_inserts | 63005 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 249 |
| Qcache_queries_in_cache | 2766 |
| Qcache_total_blocks | 6443 |
| Questions | 234114 |
| Rpl_status | NULL |
| Select_full_join | 15 |
| Select_full_range_join | 0 |
| Select_range | 17241 |
| Select_range_check | 0 |
| Select_scan | 12518 |
| Slave_open_temp_tables | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 107 |
| Sort_merge_passes | 0 |
| Sort_range | 8796 |
| Sort_rows | 327998 |
| Sort_scan | 4482 |
| Table_locks_immediate | 199916 |
| Table_locks_waited | 298 |
| Threads_cached | 16 |
| Threads_connected | 1 |
| Threads_created | 17 |
| Threads_running | 1 |
| Uptime | 69155 |
+----------------------------+------------+
mysqladmin Ver 8.41 Distrib 4.1.21, for pc-linux-gnu on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 4.1.21-standard
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 19 hours 12 min 35 sec
Threads: 1 Questions: 234115 Slow queries: 107 Opens: 608 Flush tables: 1 Open tables: 417 Queries per second avg: 3.385
9.
A few other scripts and jobs that hit the database, but vb is the most used feature of the site.
10.
Small site, on average 30-50 users concurrently
11.
http://www.gamercastnetwork.com/phpinfo.php
12.
KeepAlive On
MaxKeepAliveRequests 500
KeepAliveTimeout 5
MinSpareServers 5
MaxSpareServers 20
StartServers 8
MaxClients 450
MaxRequestsPerChild 1000
14.
uname -a
Linux host.gamercastnetwork.com 2.6.9-023stab043.1-enterprise #1 SMP Mon Mar 5 16:58:09 MSK 2007 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) 1024
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) 53248
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 2.80GHz
stepping : 3
cpu MHz : 2793.549
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 xtpr
bogomips : 5589.78
processor : 1
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 2.80GHz
stepping : 3
cpu MHz : 2793.549
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 xtpr
bogomips : 5586.34
processor : 2
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 2.80GHz
stepping : 3
cpu MHz : 2793.549
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 xtpr
bogomips : 5586.50
processor : 3
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 2.80GHz
stepping : 3
cpu MHz : 2793.549
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 xtpr
bogomips : 5586.47
Haven't done that much tweaking from the default install of the OS. I did add the apc php cacher.
I know I have to update the MySQL and PHP executables. And I have to update to vb 3.6.7. Just looking to make sure my memory / thread settings are right.
One thing I had just noticied was my thread_concurrency should be at 8 instead of 4.
Are there any other settings that should be tweaked?
-----
1. Shared Virtual Server (unsure of number of sites on server)
2.
2x Dual-Core Intel Xeon 2.8 GHz Processor
1 GB RAM (256 MB Dedicated)
73GB 10K Ultra 320 SCSI Drives (Raid 1)
CentOS 4.4
Apache v1.3.37
PHP 4.4.4
MySQL 4.1.21-standard
3. vBulletin 3.6.4
4. no innodb tables
6.
top - 14:36:13 up 87 days, 4:24, 0 users, load average: 0.31, 0.30, 0.41
Tasks: 53 total, 1 running, 52 sleeping, 0 stopped, 0 zombie
Cpu(s): 2.0% us, 0.8% sy, 0.0% ni, 81.9% id, 15.3% wa, 0.0% hi, 0.0% si
Mem: 6220344k total, 6188064k used, 32280k free, 234056k buffers
Swap: 12289716k total, 417712k used, 11872004k free, 2259820k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
5684 mysql 11 -5 138m 18m 1948 S 4.0 0.3 0:01.69 mysqld
30014 apache 15 0 152m 38m 32m S 3.3 0.6 0:23.19 httpd
18431 apache 15 0 152m 38m 32m S 3.0 0.6 0:17.82 httpd
30281 mysql 11 -5 138m 18m 1948 S 1.3 0.3 0:00.58 mysqld
1 root 16 0 1616 536 512 S 0.0 0.0 0:01.49 init
24135 root 15 0 1520 536 452 S 0.0 0.0 0:46.56 syslogd
24497 root 16 0 4016 684 592 S 0.0 0.0 0:00.05 sshd
25801 root 18 0 2068 536 532 S 0.0 0.0 0:00.00 xinetd
28387 root 15 0 888 148 120 S 0.0 0.0 0:01.02 da-popb4smtp
1674 ftp 16 0 2384 992 664 S 0.0 0.0 0:03.67 proftpd
3802 root 18 0 4060 532 456 S 0.0 0.0 0:00.00 saslauthd
9560 named 16 0 68260 2396 1704 S 0.0 0.0 0:01.27 named
25721 root 15 0 3716 576 520 S 0.0 0.0 0:10.72 crond
7789 mail 15 0 7980 1140 768 S 0.0 0.0 0:00.89 exim
6058 nobody 16 0 6628 1160 916 S 0.0 0.0 0:00.70 directadmin
27883 root 16 0 6900 2192 1764 S 0.0 0.0 0:00.15 sshd
28074 hantak 16 0 7056 1752 1292 S 0.0 0.0 0:02.75 sshd
28078 hantak 16 0 2148 1268 1032 S 0.0 0.0 0:00.02 bash
28366 root 15 0 4068 1084 856 S 0.0 0.0 0:00.00 su
28402 root 16 0 2728 1320 1056 S 0.0 0.0 0:00.05 bash
29982 root 15 0 148m 13m 9840 S 0.0 0.2 0:00.21 httpd
30013 apache 16 0 153m 38m 31m S 0.0 0.6 0:23.38 httpd
30015 apache 16 0 153m 37m 30m S 0.0 0.6 0:21.96 httpd
30016 apache 16 0 152m 37m 31m S 0.0 0.6 0:23.66 httpd
30017 apache 15 0 152m 38m 32m S 0.0 0.6 0:19.62 httpd
30018 apache 16 0 155m 43m 34m S 0.0 0.7 0:20.23 httpd
30019 apache 16 0 152m 34m 28m S 0.0 0.6 0:22.23 httpd
30020 apache 16 0 158m 42m 30m S 0.0 0.7 0:24.45 httpd
30508 apache 16 0 152m 40m 35m S 0.0 0.7 0:22.18 httpd
30553 apache 16 0 152m 37m 32m S 0.0 0.6 0:23.17 httpd
11692 apache 16 0 150m 30m 25m S 0.0 0.5 0:23.53 httpd
11719 apache 15 0 153m 38m 32m S 0.0 0.6 0:20.79 httpd
11720 apache 16 0 152m 36m 30m S 0.0 0.6 0:21.46 httpd
11846 apache 16 0 154m 38m 31m S 0.0 0.6 0:22.15 httpd
16263 apache 15 0 152m 33m 28m S 0.0 0.6 0:13.45 httpd
16300 apache 15 0 152m 36m 30m S 0.0 0.6 0:15.01 httpd
16302 apache 16 0 152m 32m 26m S 0.0 0.5 0:10.75 httpd
32344 apache 16 0 152m 34m 29m S 0.0 0.6 0:13.60 httpd
1675 root 16 0 3360 1044 884 S 0.0 0.0 0:00.01 mysqld_safe
1853 mysql 10 -5 138m 18m 1948 S 0.0 0.3 0:00.08 mysqld
1911 mysql 10 -5 138m 18m 1948 S 0.0 0.3 0:00.00 mysqld
1912 mysql 10 -5 138m 18m 1948 S 0.0 0.3 0:00.07 mysqld
3468 mysql 11 -5 138m 18m 1948 S 0.0 0.3 0:01.54 mysqld
5434 mysql 10 -5 138m 18m 1948 S 0.0 0.3 0:01.37 mysqld
7387 mysql 10 -5 138m 18m 1948 S 0.0 0.3 0:00.87 mysqld
7432 mysql 11 -5 138m 18m 1948 S 0.0 0.3 0:01.83 mysqld
7434 mysql 10 -5 138m 18m 1948 S 0.0 0.3 0:00.96 mysqld
3858 nobody 15 0 6628 340 96 S 0.0 0.0 0:00.00 directadmin
3861 nobody 15 0 6628 340 96 S 0.0 0.0 0:00.00 directadmin
7.
[mysqld]
safe-show-database
back_log = 75
skip-innodb
max_connections = 500
key_buffer = 64M
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 = 15
connect_timeout = 10
tmp_table_size = 64M
max_heap_table_size = 64M
max_allowed_packet = 64M
max_connect_errors = 10
thread_concurrency = 8
read_rnd_buffer_size = 524288
bulk_insert_buffer_size = 8M
query_cache_limit = 4M
query_cache_size = 64M
query_cache_type = 1
query_prealloc_size = 131072
query_alloc_block_size = 65536
default-storage-engine = MyISAM
[mysqld_safe]
nice = -5
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
8.
+---------------------------------+----------------------------------------------+
| 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 | 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 | 1044480 |
| key_buffer_size | 25165824 |
| key_cache_age_threshold | 300 |
| key_cache_block_size | 1024 |
| key_cache_division_limit | 100 |
| language | /usr/share/mysql/english/ |
| large_files_support | ON |
| lc_time_names | en_US |
| license | GPL |
| local_infile | ON |
| locked_in_memory | OFF |
| log | OFF |
| log_bin | OFF |
| log_error | |
| log_slave_updates | OFF |
| log_slow_queries | OFF |
| log_update | OFF |
| log_warnings | 1 |
| long_query_time | 10 |
| low_priority_updates | OFF |
| lower_case_file_system | OFF |
| lower_case_table_names | 0 |
| max_allowed_packet | 67107840 |
| max_binlog_cache_size | 4294967295 |
| max_binlog_size | 1073741824 |
| max_connect_errors | 10 |
| max_connections | 500 |
| max_delayed_threads | 20 |
| max_error_count | 64 |
| max_heap_table_size | 67107840 |
| max_insert_delayed_threads | 20 |
| max_join_size | 4294967295 |
| max_length_for_sort_data | 1024 |
| max_prepared_stmt_count | 16382 |
| max_relay_log_size | 0 |
| max_seeks_for_key | 4294967295 |
| max_sort_length | 1024 |
| max_tmp_tables | 32 |
| max_user_connections | 0 |
| max_write_lock_count | 4294967295 |
| myisam_data_pointer_size | 4 |
| myisam_max_extra_sort_file_size | 2147483648 |
| myisam_max_sort_file_size | 2147483647 |
| myisam_recover_options | OFF |
| myisam_repair_threads | 1 |
| myisam_sort_buffer_size | 67108864 |
| 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 | 2910 |
| pid_file | /var/lib/mysql/host.gamercastnetwork.com.pid |
| port | 3306 |
| preload_buffer_size | 32768 |
| prepared_stmt_count | 0 |
| protocol_version | 10 |
| query_alloc_block_size | 65536 |
| query_cache_limit | 2097152 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 16777216 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 131072 |
| 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 | OFF |
| sql_warnings | OFF |
| 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 | 1200 |
| table_type | MyISAM |
| thread_cache_size | 128 |
| thread_stack | 126976 |
| 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.21-standard |
| version_comment | MySQL Community Edition - Standard (GPL) |
| version_compile_machine | i686 |
| version_compile_os | pc-linux-gnu |
| wait_timeout | 15 |
+---------------------------------+----------------------------------------------+
+----------------------------+------------+
| Variable_name | Value |
+----------------------------+------------+
| Aborted_clients | 166 |
| Aborted_connects | 1 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 66763182 |
| Bytes_sent | 2981758359 |
| Com_admin_commands | 0 |
| Com_alter_db | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 25575 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_commit | 0 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 0 |
| Com_dealloc_sql | 0 |
| Com_delete | 1149 |
| Com_delete_multi | 0 |
| Com_do | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_drop_user | 0 |
| Com_execute_sql | 0 |
| Com_flush | 0 |
| Com_grant | 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_help | 0 |
| Com_insert | 4629 |
| Com_insert_select | 0 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 78 |
| 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 | 11659 |
| 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 | 63574 |
| Com_set_option | 356 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 5 |
| Com_show_charsets | 28 |
| Com_show_collations | 28 |
| Com_show_column_types | 0 |
| Com_show_create_db | 0 |
| Com_show_create_table | 132 |
| Com_show_databases | 21 |
| Com_show_errors | 0 |
| Com_show_fields | 149 |
| Com_show_grants | 11 |
| Com_show_innodb_status | 0 |
| Com_show_keys | 3 |
| 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 | 0 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 24 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 222 |
| Com_show_variables | 91 |
| 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 | 77 |
| Com_unlock_tables | 78 |
| Com_update | 21194 |
| Com_update_multi | 0 |
| Connections | 25548 |
| Created_tmp_disk_tables | 95 |
| Created_tmp_files | 4 |
| Created_tmp_tables | 2932 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 3279 |
| Handler_discover | 0 |
| Handler_read_first | 15891 |
| Handler_read_key | 2497921 |
| Handler_read_next | 8795591 |
| Handler_read_prev | 122565 |
| Handler_read_rnd | 119205 |
| Handler_read_rnd_next | 8396344 |
| Handler_rollback | 0 |
| Handler_update | 55090 |
| Handler_write | 120261 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 13328 |
| Key_blocks_used | 8478 |
| Key_read_requests | 12071997 |
| Key_reads | 8884 |
| Key_write_requests | 56043 |
| Key_writes | 29592 |
| Max_used_connections | 17 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 735 |
| Open_streams | 0 |
| Open_tables | 417 |
| Opened_tables | 608 |
| Qcache_free_blocks | 427 |
| Qcache_free_memory | 7025016 |
| Qcache_hits | 79578 |
| Qcache_inserts | 63005 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 249 |
| Qcache_queries_in_cache | 2766 |
| Qcache_total_blocks | 6443 |
| Questions | 234114 |
| Rpl_status | NULL |
| Select_full_join | 15 |
| Select_full_range_join | 0 |
| Select_range | 17241 |
| Select_range_check | 0 |
| Select_scan | 12518 |
| Slave_open_temp_tables | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 107 |
| Sort_merge_passes | 0 |
| Sort_range | 8796 |
| Sort_rows | 327998 |
| Sort_scan | 4482 |
| Table_locks_immediate | 199916 |
| Table_locks_waited | 298 |
| Threads_cached | 16 |
| Threads_connected | 1 |
| Threads_created | 17 |
| Threads_running | 1 |
| Uptime | 69155 |
+----------------------------+------------+
mysqladmin Ver 8.41 Distrib 4.1.21, for pc-linux-gnu on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 4.1.21-standard
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 19 hours 12 min 35 sec
Threads: 1 Questions: 234115 Slow queries: 107 Opens: 608 Flush tables: 1 Open tables: 417 Queries per second avg: 3.385
9.
A few other scripts and jobs that hit the database, but vb is the most used feature of the site.
10.
Small site, on average 30-50 users concurrently
11.
http://www.gamercastnetwork.com/phpinfo.php
12.
KeepAlive On
MaxKeepAliveRequests 500
KeepAliveTimeout 5
MinSpareServers 5
MaxSpareServers 20
StartServers 8
MaxClients 450
MaxRequestsPerChild 1000
14.
uname -a
Linux host.gamercastnetwork.com 2.6.9-023stab043.1-enterprise #1 SMP Mon Mar 5 16:58:09 MSK 2007 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) 1024
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) 53248
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 2.80GHz
stepping : 3
cpu MHz : 2793.549
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 xtpr
bogomips : 5589.78
processor : 1
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 2.80GHz
stepping : 3
cpu MHz : 2793.549
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 xtpr
bogomips : 5586.34
processor : 2
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 2.80GHz
stepping : 3
cpu MHz : 2793.549
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 xtpr
bogomips : 5586.50
processor : 3
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 2.80GHz
stepping : 3
cpu MHz : 2793.549
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 xtpr
bogomips : 5586.47