bplinson
Sat 30th Dec '06, 4:18am
1. Dedicated - runs two vBulletin websites.
2. Server Specs
CPU - Dual Xeon 2.8 Ghz
Ram - 2GB
HHD - 160 SATA
Software -
OS: SUSE 9
Apache v2.0.53
PHP 4.3.10
MySQL 4.1.10a
3. No Inno Table/DB
4. installed by host company - standard SUSE load
5. Top
top - 07:47:03 up 1 day, 2:00, 1 user, load average: 0.51, 0.49, 0.40
Tasks: 152 total, 1 running, 151 sleeping, 0 stopped, 0 zombie
Cpu(s): 1.1% us, 0.3% sy, 0.0% ni, 97.9% id, 0.6% wa, 0.1% hi, 0.0% si
Mem: 2055072k total, 1726688k used, 328384k free, 38504k buffers
Swap: 987956k total, 160612k used, 827344k free, 523888k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
3175 wwwrun 15 0 123m 14m 5148 S 4.0 0.7 0:00.12 httpd2-prefork
5826 mysql 16 0 157m 38m 3456 S 1.0 1.9 187:39.27 mysqld
3166 root 16 0 8504 1356 956 R 0.3 0.1 0:00.03 top
1 root 16 0 724 76 48 S 0.0 0.0 0:00.62 init
2 root RT 0 0 0 0 S 0.0 0.0 0:00.10 migration/0
3 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/0
4 root RT 0 0 0 0 S 0.0 0.0 0:00.08 migration/1
5 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/1
6 root RT 0 0 0 0 S 0.0 0.0 0:00.13 migration/2
7 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/2
8 root RT 0 0 0 0 S 0.0 0.0 0:00.13 migration/3
9 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/3
10 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 events/0
11 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 events/1
12 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 events/2
13 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 events/3
14 root 10 -5 0 0 0 S 0.0 0.0 0:00.01 khelper
19 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 kthread
34 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 kacpid
111 root 10 -5 0 0 0 S 0.0 0.0 0:00.53 kblockd/0
112 root 10 -5 0 0 0 S 0.0 0.0 0:04.59 kblockd/1
113 root 10 -5 0 0 0 S 0.0 0.0 0:04.72 kblockd/2
114 root 10 -5 0 0 0 S 0.0 0.0 0:00.53 kblockd/3
160 root 15 0 0 0 0 S 0.0 0.0 0:40.05 kswapd0
161 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 aio/0
162 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 aio/1
163 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 aio/2
164 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 aio/3
752 root 15 0 0 0 0 S 0.0 0.0 0:00.00 kseriod
924 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 ata/0
925 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 ata/1
926 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 ata/2
927 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 ata/3
933 root 20 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_0
939 root 19 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_1
1188 root 15 0 0 0 0 S 0.0 0.0 0:20.41 kjournald
2104 root 15 0 0 0 0 S 0.0 0.0 0:00.00 kjournald
2105 root 15 0 0 0 0 S 0.0 0.0 0:07.14 kjournald
2106 root 15 0 0 0 0 S 0.0 0.0 0:34.52 kjournald
2107 root 19 0 0 0 0 S 0.0 0.0 0:00.00 kjournald
2143 root 12 -4 2552 436 432 S 0.0 0.0 0:00.39 udevd
2204 root 19 0 0 0 0 S 0.0 0.0 0:00.00 khpsbpkt
2796 root 16 0 0 0 0 S 0.0 0.0 0:00.00 khubd
3324 messageb 15 0 14992 760 756 S 0.0 0.0 0:00.00 dbus-daemon-1
3336 root 16 0 2552 480 424 S 0.0 0.0 0:00.62 irqbalance
3431 root 18 0 3608 412 408 S 0.0 0.0 0:00.00 resmgrd
4190 root 14 -2 2600 352 352 S 0.0 0.0 0:00.00 hwscand
5274 root 16 0 9260 756 616 S 0.0 0.0 0:19.64 syslog-ng
5278 root 16 0 2816 416 412 S 0.0 0.0 0:00.00 klogd
5371 root 16 0 9996 680 612 S 0.0 0.0 0:00.12 cron
5377 qmails 16 0 2852 520 408 S 0.0 0.0 0:18.13 qmail-send
5. /etc/my.cnf
#
# Example MySQL config file for medium systems.
#
# This is for a system with little memory (32M - 64M) where MySQL plays
# an important part, or systems up to 128M where MySQL is used together with
# other programs (such as a web server)
#
# You can copy this file to
# /etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is /var/lib/mysql) or
# ~/.my.cnf to set user-specific options.
#
# In this file, you can use all long options that a program supports.
# If you want to know which options a program supports, run the program
# with the "--help" option.
# The following options will be passed to all MySQL clients
[client]
#password = your_password
port = 3306
socket = /var/lib/mysql/mysql.sock
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (via the "enable-named-pipe" option) will render mysqld useless!
#
#skip-networking
# Replication Master Server (default)
# binary logging is required for replication
# log-bin
# required unique id between 1 and 2^32 - 1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
server-id = 1
# Replication Slave (comment out master section to use this)
#
# To configure this host as a replication slave, you can choose between
# two methods :
#
# 1) Use the CHANGE MASTER TO command (fully described in our manual) -
# the syntax is:
#
# CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>,
# MASTER_USER=<user>, MASTER_PASSWORD=<password> ;
#
# where you replace <host>, <user>, <password> by quoted strings and
# <port> by the master's port number (3306 by default).
#
# Example:
#
# CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,
# MASTER_USER='joe', MASTER_PASSWORD='secret';
#
# OR
#
# 2) Set the variables below. However, in case you choose this method, then
# start replication for the first time (even unsuccessfully, for example
# if you mistyped the password in master-password and the slave fails to
# connect), the slave will create a master.info file, and any later
# change in this file to the variables' values below will be ignored and
# overridden by the content of the master.info file, unless you shutdown
# the slave server, delete master.info and restart the slaver server.
# For that reason, you may want to leave the lines below untouched
# (commented) and instead use CHANGE MASTER TO (see above)
#
# required unique id between 2 and 2^32 - 1
# (and different from the master)
# defaults to 2 if master-host is set
# but will not function as a slave if omitted
#server-id = 2
#
# The replication master for this slave - required
#master-host = <hostname>
#
# The username the slave will use for authentication when connecting
# to the master - required
#master-user = <username>
#
# The password the slave will authenticate with when connecting to
# the master - required
#master-password = <password>
#
# The port the master is listening on.
# optional - defaults to 3306
#master-port = <port>
#
# binary logging - not required for slaves, but recommended
#log-bin
# Point the following paths to different dedicated disks
#tmpdir = /tmp/
#log-update = /path-to-dedicated-directory/hostname
# Uncomment the following if you are using BDB tables
#bdb_cache_size = 4M
#bdb_max_lock = 10000
# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = /var/lib/mysql/
#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = /var/lib/mysql/
#innodb_log_arch_dir = /var/lib/mysql/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
#innodb_buffer_pool_size = 16M
#innodb_additional_mem_pool_size = 2M
# Set .._log_file_size to 25 % of buffer pool size
#innodb_log_file_size = 5M
#innodb_log_buffer_size = 8M
#innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50
# The safe_mysqld script
[safe_mysqld]
err-log=/var/lib/mysql/mysqld.log
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
su93159:/etc #
7.mysqladmin -u root -p var ext stat ver
+---------------------------------+----------------------------+
| Variable_name | Value |
+---------------------------------+----------------------------+
| back_log | 50 |
| basedir | /usr/ |
| 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_compress | YES |
| have_crypt | YES |
| have_csv | NO |
| have_example_engine | NO |
| have_geometry | YES |
| have_innodb | YES |
| have_isam | YES |
| have_ndbcluster | NO |
| have_openssl | NO |
| have_query_cache | YES |
| have_raid | NO |
| have_rtree_keys | YES |
| have_symlink | YES |
| init_connect | |
| init_file | |
| init_slave | |
| innodb_additional_mem_pool_size | 1048576 |
| innodb_autoextend_increment | 8 |
| innodb_buffer_pool_awe_mem_mb | 0 |
| innodb_buffer_pool_size | 8388608 |
| innodb_data_file_path | 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 | 16777216 |
| key_cache_age_threshold | 300 |
| key_cache_block_size | 1024 |
| key_cache_division_limit | 100 |
| language | /usr/share/mysql/english/ |
| large_files_support | ON |
| license | GPL |
| local_infile | ON |
| locked_in_memory | OFF |
| log | OFF |
| log_bin | OFF |
| log_error | |
| log_slave_updates | OFF |
| log_slow_queries | OFF |
| log_update | OFF |
| log_warnings | 1 |
| long_query_time | 10 |
| low_priority_updates | OFF |
| lower_case_file_system | OFF |
| lower_case_table_names | 0 |
| max_allowed_packet | 1047552 |
| 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_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 |
| net_buffer_length | 8192 |
| 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/mysqld.pid |
| port | 3306 |
| preload_buffer_size | 32768 |
| 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 | 258048 |
| read_only | OFF |
| read_rnd_buffer_size | 520192 |
| relay_log_purge | ON |
| 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 |
| slow_launch_time | 2 |
| socket | /var/lib/mysql/mysql.sock |
| sort_buffer_size | 524280 |
| sql_mode | |
| storage_engine | MyISAM |
| sync_binlog | 0 |
| sync_replication | 0 |
| sync_replication_slave_id | 0 |
| sync_replication_timeout | 0 |
| sync_frm | ON |
| system_time_zone | GMT |
| 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.10a |
| version_comment | SUSE MySQL RPM |
| version_compile_machine | x86_64 |
| version_compile_os | suse-linux |
| wait_timeout | 28800 |
+---------------------------------+----------------------------+
+--------------------------+-------------+
| Variable_name | Value |
+--------------------------+-------------+
| Aborted_clients | 50 |
| Aborted_connects | 433 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 1276616765 |
| Bytes_sent | 92743238471 |
| Com_admin_commands | 0 |
| Com_alter_db | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 5517 |
| Com_change_db | 200837 |
| Com_change_master | 0 |
| Com_check | 388 |
| Com_checksum | 0 |
| Com_commit | 5517 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 0 |
| Com_dealloc_sql | 0 |
| Com_delete | 15023 |
| 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 | 77661 |
| Com_insert_select | 289 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 680 |
| Com_optimize | 388 |
| 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 | 27671 |
| Com_replace_select | 1 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_revoke_all | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 5036665 |
| Com_set_option | 2221 |
| 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 | 3 |
| Com_show_create_table | 149 |
| Com_show_databases | 0 |
| Com_show_errors | 0 |
| Com_show_fields | 149 |
| Com_show_grants | 0 |
| Com_show_innodb_status | 0 |
| Com_show_keys | 0 |
| Com_show_logs | 0 |
| Com_show_master_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 | 13 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 194 |
| Com_show_variables | 1076 |
| Com_show_warnings | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 680 |
| Com_update | 410347 |
| Com_update_multi | 6 |
| Connections | 176159 |
| Created_tmp_disk_tables | 3473 |
| Created_tmp_files | 43115 |
| Created_tmp_tables | 39267 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 1 |
| Delayed_writes | 8321 |
| Flush_commands | 1 |
| Handler_commit | 5520 |
| Handler_delete | 29697 |
| Handler_discover | 0 |
| Handler_read_first | 283602 |
| Handler_read_key | 149061366 |
| Handler_read_next | 257868594 |
| Handler_read_prev | 1166418 |
| Handler_read_rnd | 75003748 |
| Handler_read_rnd_next | 627041043 |
| Handler_rollback | 1040 |
| Handler_update | 112204489 |
| Handler_write | 160073096 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 11442 |
| Key_blocks_used | 10053 |
| Key_read_requests | 926143968 |
| Key_reads | 2457691 |
| Key_write_requests | 88409056 |
| Key_writes | 168922 |
| Max_used_connections | 101 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 123 |
| Open_streams | 0 |
| Open_tables | 64 |
| Opened_tables | 284076 |
| 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 | 5961485 |
| Rpl_status | NULL |
| Select_full_join | 222 |
| Select_full_range_join | 0 |
| Select_range | 700588 |
| Select_range_check | 0 |
| Select_scan | 633279 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 3 |
| Slow_queries | 1059 |
| Sort_merge_passes | 61400 |
| Sort_range | 219558 |
| Sort_rows | 214580655 |
| Sort_scan | 320144 |
| Table_locks_immediate | 6629730 |
| Table_locks_waited | 3003 |
| Threads_cached | 0 |
| Threads_connected | 4 |
| Threads_created | 176157 |
| Threads_running | 1 |
| Uptime | 94223 |
+--------------------------+-------------+
Uptime: 94223 Threads: 4 Questions: 5961486 Slow queries: 1059 Opens: 284076 Flush tables: 1 Open tables: 64 Queries per second avg: 63.270
mysqladmin Ver 8.41 Distrib 4.1.10a, for suse-linux 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.10a
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 1 day 2 hours 10 min 23 sec
Threads: 4 Questions: 5961486 Slow queries: 1059 Opens: 284076 Flush tables: 1 Open tables: 64 Queries per second avg: 63.270
mysqlreport
Password for database user root: MySQL 4.1.10a uptime 1 2:18:31 Sat Dec 30 08:06:03 2006
__ Key __________________________________________________ _______________
Buffer used 9.82M of 16.00M %Used: 61.36
Current 7.19M %Usage: 44.95
Write ratio 0.002
Read ratio 0.003
__ Questions __________________________________________________ _________
Total 5.98M 63.2/s
DMS 5.59M 59.0/s %Total: 93.38
Com_ 219.32k 2.3/s 3.67
COM_QUIT 176.74k 1.9/s 2.95
-Unknown 123 0.0/s 0.00
Slow 1.06k 0.0/s 0.02 %DMS: 0.02
DMS 5.59M 59.0/s 93.38
SELECT 5.05M 53.3/s 84.47 90.46
UPDATE 411.80k 4.3/s 6.88 7.37
INSERT 78.22k 0.8/s 1.31 1.40
REPLACE 27.77k 0.3/s 0.46 0.50
DELETE 15.26k 0.2/s 0.26 0.27
Com_ 219.32k 2.3/s 3.67
change_db 202.31k 2.1/s 3.38
begin 5.52k 0.1/s 0.09
commit 5.52k 0.1/s 0.09
__ SELECT and Sort __________________________________________________ ___
Scan 635.48k 6.7/s %SELECT: 12.58
Range 702.90k 7.4/s 13.91
Full join 226 0.0/s 0.00
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 321.13k 3.4/s
Sort range 220.27k 2.3/s
Sort mrg pass 61.59k 0.7/s
__ Table Locks __________________________________________________ _______
Waited 3.01k 0.0/s %Total: 0.05
Immediate 6.65M 70.2/s
__ Tables __________________________________________________ ____________
Open 64 of 64 %Cache: 100.00
Opened 285.32k 3.0/s
__ Connections __________________________________________________ _______
Max used 101 of 100 %Max: 101.00
Total 176.77k 1.9/s
__ Created Temp __________________________________________________ ______
Disk table 3.49k 0.0/s
Table 39.40k 0.4/s
File 43.24k 0.5/s
__ Threads __________________________________________________ ___________
Running 1 of 2
Cached 0 of 0 %Hit: 0
Created 176.77k 1.9/s
Slow 3 0.0/s
__ Aborted __________________________________________________ ___________
Clients 50 0.0/s
Connects 434 0.0/s
__ Bytes __________________________________________________ _____________
Sent 93.05G 982.4k/s
Received 1.28G 13.5k/s8. 2 vbulletin forums with vBportal and PhotoPost
9. 130 - 250 Cookie timeout=900
10. xlforum.net/phpinfo.php
11. Not httpd.conf but server-tuning.conf
su93159:/etc/apache2 # cat server-tuning.conf
##
## Server-Pool Size Regulation (MPM specific)
##
# the MPM (multiprocessing module) is not a dynamically loadable module in the
# sense of other modules. It is a compile time decision which one is used. We
# provide different apache2 MPM packages, containing different httpd2 binaries
# compiled with the available MPMs. See APACHE_MPM in /etc/sysconfig/apache2.
# prefork MPM
<IfModule prefork.c>
# number of server processes to start
StartServers 5
# minimum number of server processes which are kept spare
MinSpareServers 5
# maximum number of server processes which are kept spare
MaxSpareServers 10
# highest possible MaxClients setting for the lifetime of the Apache process.
ServerLimit 150
# maximum number of server processes allowed to start
MaxClients 150
# maximum number of requests a server process serves
MaxRequestsPerChild 0
</IfModule>
# worker MPM
<IfModule worker.c>
# initial number of server processes to start
StartServers 2
# minimum number of worker threads which are kept spare
MinSpareThreads 25
# maximum number of worker threads which are kept spare
MaxSpareThreads 75
# maximum number of simultaneous client connections
MaxClients 150
# constant number of worker threads in each server process
ThreadsPerChild 25
# maximum number of requests a server process serves
MaxRequestsPerChild 0
</IfModule>
# leader MPM
<IfModule leader.c>
# initial number of server processes to start
StartServers 2
# minimum number of worker threads which are kept spare
MinSpareThreads 25
# maximum number of worker threads which are kept spare
MaxSpareThreads 75
# maximum number of simultaneous client connections
MaxClients 150
# constant number of worker threads in each server process
ThreadsPerChild 25
# maximum number of requests a server process serves
MaxRequestsPerChild 0
</IfModule>
# perchild MPM
<IfModule perchild.c>
# constant number of server processes
NumServers 5
# initial number of worker threads in each server process
StartThreads 5
# minimum number of worker threads which are kept spare
MinSpareThreads 5
# maximum number of worker threads which are kept spare
MaxSpareThreads 10
# maximum number of worker threads in each server process
MaxThreadsPerChild 20
# maximum number of connections per server process
MaxRequestsPerChild 0
AcceptMutex fcntl
</IfModule>
# metux MPM
<IfModule metuxmpm.c>
# initial number of worker threads in each server process
StartThreads 5
# minimum number of worker threads which are kept spare
MinSpareThreads 5
# maximum number of worker threads which are kept spare
MaxSpareThreads 10
# maximum number of connections per server process
MaxRequestsPerChild 0
Multiplexer "wwwrun" "www"
</IfModule>
#
# KeepAlive: Whether or not to allow persistent connections (more than
# one request per connection). Set to "Off" to deactivate.
#
KeepAlive On
#
# MaxKeepAliveRequests: The maximum number of requests to allow
# during a persistent connection. Set to 0 to allow an unlimited amount.
# We recommend you leave this number high, for maximum performance.
#
MaxKeepAliveRequests 100
#
# KeepAliveTimeout: Number of seconds to wait for the next request from the
# same client on the same connection.
#
KeepAliveTimeout 15
#
# EnableMMAP: Control whether memory-mapping is used to deliver
# files (assuming that the underlying OS supports it).
# The default is on; turn this off if you serve from NFS-mounted
# filesystems. On some systems, turning it off (regardless of
# filesystem) can improve performance; for details, please see
# http://httpd.apache.org/docs-2.0/mod/core.html#enablemmap
#
#EnableMMAP off
#
# EnableSendfile: Control whether the sendfile kernel support is
# used to deliver files (assuming that the OS supports it).
# The default is on; turn this off if you serve from NFS-mounted
# filesystems. Please see
# http://httpd.apache.org/docs-2.0/mod/core.html#enablesendfile
#
#EnableSendfile off
#
# The following directives modify normal HTTP response behavior to
# handle known problems with browser implementations.
#
BrowserMatch "Mozilla/2" nokeepalive
BrowserMatch "MSIE 4\.0b2;" nokeepalive downgrade-1.0 force-response-1.0
BrowserMatch "RealPlayer 4\.0" force-response-1.0
BrowserMatch "Java/1\.0" force-response-1.0
BrowserMatch "JDK/1\.0" force-response-1.0
#
# The following directive disables redirects on non-GET requests for
# a directory that does not include the trailing slash. This fixes a
# problem with Microsoft WebFolders which does not appropriately handle
# redirects for folders with DAV methods.
# Same deal with Apple's DAV filesystem and Gnome VFS support for DAV.
#
BrowserMatch "Microsoft Data Access Internet Publishing Provider" redirect-carefully
BrowserMatch "^WebDrive" redirect-carefully
BrowserMatch "^WebDAVFS/1.[012]" redirect-carefully
BrowserMatch "^gnome-vfs" redirect-carefully
su93159:/etc/apache2 #
13 None
14.
uname -a
Linux su93159 2.6.11.4-21.7-smp #1 SMP Thu Jun 2 14:23:14 UTC 2005 x86_64 x86_64 x86_64 GNU/Linux
ulimit -aH
core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
max locked memory (kbytes, -l) 32
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
stack size (kbytes, -s) unlimited
cpu time (seconds, -t) unlimited
max user processes (-u) 16382
virtual memory (kbytes, -v) 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 : 2800.237
cache size : 2048 KB
physical id : 0
siblings : 2
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 syscall lm pni monitor ds_ cpl cid cx16 xtpr
bogomips : 5521.40
clflush size : 64
cache_alignment : 128
address sizes : 36 bits physical, 48 bits virtual
power management:
processor : 1
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 2.80GHz
stepping : 3
cpu MHz : 2800.237
cache size : 2048 KB
physical id : 3
siblings : 2
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 syscall lm pni monitor ds_ cpl cid cx16 xtpr
bogomips : 5586.94
clflush size : 64
cache_alignment : 128
address sizes : 36 bits physical, 48 bits virtual
power management:
processor : 2
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 2.80GHz
stepping : 3
cpu MHz : 2800.237
cache size : 2048 KB
physical id : 0
siblings : 2
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 syscall lm pni monitor ds_ cpl cid cx16 xtpr
bogomips : 5586.94
clflush size : 64
cache_alignment : 128
address sizes : 36 bits physical, 48 bits virtual
power management:
processor : 3
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 2.80GHz
stepping : 3
cpu MHz : 2800.237
cache size : 2048 KB
physical id : 3
siblings : 2
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 syscall lm pni monitor ds_ cpl cid cx16 xtpr
bogomips : 5586.94
clflush size : 64
cache_alignment : 128
address sizes : 36 bits physical, 48 bits virtual
power management:
Thanks!!!
2. Server Specs
CPU - Dual Xeon 2.8 Ghz
Ram - 2GB
HHD - 160 SATA
Software -
OS: SUSE 9
Apache v2.0.53
PHP 4.3.10
MySQL 4.1.10a
3. No Inno Table/DB
4. installed by host company - standard SUSE load
5. Top
top - 07:47:03 up 1 day, 2:00, 1 user, load average: 0.51, 0.49, 0.40
Tasks: 152 total, 1 running, 151 sleeping, 0 stopped, 0 zombie
Cpu(s): 1.1% us, 0.3% sy, 0.0% ni, 97.9% id, 0.6% wa, 0.1% hi, 0.0% si
Mem: 2055072k total, 1726688k used, 328384k free, 38504k buffers
Swap: 987956k total, 160612k used, 827344k free, 523888k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
3175 wwwrun 15 0 123m 14m 5148 S 4.0 0.7 0:00.12 httpd2-prefork
5826 mysql 16 0 157m 38m 3456 S 1.0 1.9 187:39.27 mysqld
3166 root 16 0 8504 1356 956 R 0.3 0.1 0:00.03 top
1 root 16 0 724 76 48 S 0.0 0.0 0:00.62 init
2 root RT 0 0 0 0 S 0.0 0.0 0:00.10 migration/0
3 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/0
4 root RT 0 0 0 0 S 0.0 0.0 0:00.08 migration/1
5 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/1
6 root RT 0 0 0 0 S 0.0 0.0 0:00.13 migration/2
7 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/2
8 root RT 0 0 0 0 S 0.0 0.0 0:00.13 migration/3
9 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/3
10 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 events/0
11 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 events/1
12 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 events/2
13 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 events/3
14 root 10 -5 0 0 0 S 0.0 0.0 0:00.01 khelper
19 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 kthread
34 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 kacpid
111 root 10 -5 0 0 0 S 0.0 0.0 0:00.53 kblockd/0
112 root 10 -5 0 0 0 S 0.0 0.0 0:04.59 kblockd/1
113 root 10 -5 0 0 0 S 0.0 0.0 0:04.72 kblockd/2
114 root 10 -5 0 0 0 S 0.0 0.0 0:00.53 kblockd/3
160 root 15 0 0 0 0 S 0.0 0.0 0:40.05 kswapd0
161 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 aio/0
162 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 aio/1
163 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 aio/2
164 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 aio/3
752 root 15 0 0 0 0 S 0.0 0.0 0:00.00 kseriod
924 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 ata/0
925 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 ata/1
926 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 ata/2
927 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 ata/3
933 root 20 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_0
939 root 19 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_1
1188 root 15 0 0 0 0 S 0.0 0.0 0:20.41 kjournald
2104 root 15 0 0 0 0 S 0.0 0.0 0:00.00 kjournald
2105 root 15 0 0 0 0 S 0.0 0.0 0:07.14 kjournald
2106 root 15 0 0 0 0 S 0.0 0.0 0:34.52 kjournald
2107 root 19 0 0 0 0 S 0.0 0.0 0:00.00 kjournald
2143 root 12 -4 2552 436 432 S 0.0 0.0 0:00.39 udevd
2204 root 19 0 0 0 0 S 0.0 0.0 0:00.00 khpsbpkt
2796 root 16 0 0 0 0 S 0.0 0.0 0:00.00 khubd
3324 messageb 15 0 14992 760 756 S 0.0 0.0 0:00.00 dbus-daemon-1
3336 root 16 0 2552 480 424 S 0.0 0.0 0:00.62 irqbalance
3431 root 18 0 3608 412 408 S 0.0 0.0 0:00.00 resmgrd
4190 root 14 -2 2600 352 352 S 0.0 0.0 0:00.00 hwscand
5274 root 16 0 9260 756 616 S 0.0 0.0 0:19.64 syslog-ng
5278 root 16 0 2816 416 412 S 0.0 0.0 0:00.00 klogd
5371 root 16 0 9996 680 612 S 0.0 0.0 0:00.12 cron
5377 qmails 16 0 2852 520 408 S 0.0 0.0 0:18.13 qmail-send
5. /etc/my.cnf
#
# Example MySQL config file for medium systems.
#
# This is for a system with little memory (32M - 64M) where MySQL plays
# an important part, or systems up to 128M where MySQL is used together with
# other programs (such as a web server)
#
# You can copy this file to
# /etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is /var/lib/mysql) or
# ~/.my.cnf to set user-specific options.
#
# In this file, you can use all long options that a program supports.
# If you want to know which options a program supports, run the program
# with the "--help" option.
# The following options will be passed to all MySQL clients
[client]
#password = your_password
port = 3306
socket = /var/lib/mysql/mysql.sock
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (via the "enable-named-pipe" option) will render mysqld useless!
#
#skip-networking
# Replication Master Server (default)
# binary logging is required for replication
# log-bin
# required unique id between 1 and 2^32 - 1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
server-id = 1
# Replication Slave (comment out master section to use this)
#
# To configure this host as a replication slave, you can choose between
# two methods :
#
# 1) Use the CHANGE MASTER TO command (fully described in our manual) -
# the syntax is:
#
# CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>,
# MASTER_USER=<user>, MASTER_PASSWORD=<password> ;
#
# where you replace <host>, <user>, <password> by quoted strings and
# <port> by the master's port number (3306 by default).
#
# Example:
#
# CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,
# MASTER_USER='joe', MASTER_PASSWORD='secret';
#
# OR
#
# 2) Set the variables below. However, in case you choose this method, then
# start replication for the first time (even unsuccessfully, for example
# if you mistyped the password in master-password and the slave fails to
# connect), the slave will create a master.info file, and any later
# change in this file to the variables' values below will be ignored and
# overridden by the content of the master.info file, unless you shutdown
# the slave server, delete master.info and restart the slaver server.
# For that reason, you may want to leave the lines below untouched
# (commented) and instead use CHANGE MASTER TO (see above)
#
# required unique id between 2 and 2^32 - 1
# (and different from the master)
# defaults to 2 if master-host is set
# but will not function as a slave if omitted
#server-id = 2
#
# The replication master for this slave - required
#master-host = <hostname>
#
# The username the slave will use for authentication when connecting
# to the master - required
#master-user = <username>
#
# The password the slave will authenticate with when connecting to
# the master - required
#master-password = <password>
#
# The port the master is listening on.
# optional - defaults to 3306
#master-port = <port>
#
# binary logging - not required for slaves, but recommended
#log-bin
# Point the following paths to different dedicated disks
#tmpdir = /tmp/
#log-update = /path-to-dedicated-directory/hostname
# Uncomment the following if you are using BDB tables
#bdb_cache_size = 4M
#bdb_max_lock = 10000
# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = /var/lib/mysql/
#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = /var/lib/mysql/
#innodb_log_arch_dir = /var/lib/mysql/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
#innodb_buffer_pool_size = 16M
#innodb_additional_mem_pool_size = 2M
# Set .._log_file_size to 25 % of buffer pool size
#innodb_log_file_size = 5M
#innodb_log_buffer_size = 8M
#innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50
# The safe_mysqld script
[safe_mysqld]
err-log=/var/lib/mysql/mysqld.log
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
su93159:/etc #
7.mysqladmin -u root -p var ext stat ver
+---------------------------------+----------------------------+
| Variable_name | Value |
+---------------------------------+----------------------------+
| back_log | 50 |
| basedir | /usr/ |
| 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_compress | YES |
| have_crypt | YES |
| have_csv | NO |
| have_example_engine | NO |
| have_geometry | YES |
| have_innodb | YES |
| have_isam | YES |
| have_ndbcluster | NO |
| have_openssl | NO |
| have_query_cache | YES |
| have_raid | NO |
| have_rtree_keys | YES |
| have_symlink | YES |
| init_connect | |
| init_file | |
| init_slave | |
| innodb_additional_mem_pool_size | 1048576 |
| innodb_autoextend_increment | 8 |
| innodb_buffer_pool_awe_mem_mb | 0 |
| innodb_buffer_pool_size | 8388608 |
| innodb_data_file_path | 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 | 16777216 |
| key_cache_age_threshold | 300 |
| key_cache_block_size | 1024 |
| key_cache_division_limit | 100 |
| language | /usr/share/mysql/english/ |
| large_files_support | ON |
| license | GPL |
| local_infile | ON |
| locked_in_memory | OFF |
| log | OFF |
| log_bin | OFF |
| log_error | |
| log_slave_updates | OFF |
| log_slow_queries | OFF |
| log_update | OFF |
| log_warnings | 1 |
| long_query_time | 10 |
| low_priority_updates | OFF |
| lower_case_file_system | OFF |
| lower_case_table_names | 0 |
| max_allowed_packet | 1047552 |
| 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_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 |
| net_buffer_length | 8192 |
| 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/mysqld.pid |
| port | 3306 |
| preload_buffer_size | 32768 |
| 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 | 258048 |
| read_only | OFF |
| read_rnd_buffer_size | 520192 |
| relay_log_purge | ON |
| 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 |
| slow_launch_time | 2 |
| socket | /var/lib/mysql/mysql.sock |
| sort_buffer_size | 524280 |
| sql_mode | |
| storage_engine | MyISAM |
| sync_binlog | 0 |
| sync_replication | 0 |
| sync_replication_slave_id | 0 |
| sync_replication_timeout | 0 |
| sync_frm | ON |
| system_time_zone | GMT |
| 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.10a |
| version_comment | SUSE MySQL RPM |
| version_compile_machine | x86_64 |
| version_compile_os | suse-linux |
| wait_timeout | 28800 |
+---------------------------------+----------------------------+
+--------------------------+-------------+
| Variable_name | Value |
+--------------------------+-------------+
| Aborted_clients | 50 |
| Aborted_connects | 433 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 1276616765 |
| Bytes_sent | 92743238471 |
| Com_admin_commands | 0 |
| Com_alter_db | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 5517 |
| Com_change_db | 200837 |
| Com_change_master | 0 |
| Com_check | 388 |
| Com_checksum | 0 |
| Com_commit | 5517 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 0 |
| Com_dealloc_sql | 0 |
| Com_delete | 15023 |
| 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 | 77661 |
| Com_insert_select | 289 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 680 |
| Com_optimize | 388 |
| 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 | 27671 |
| Com_replace_select | 1 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_revoke_all | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 5036665 |
| Com_set_option | 2221 |
| 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 | 3 |
| Com_show_create_table | 149 |
| Com_show_databases | 0 |
| Com_show_errors | 0 |
| Com_show_fields | 149 |
| Com_show_grants | 0 |
| Com_show_innodb_status | 0 |
| Com_show_keys | 0 |
| Com_show_logs | 0 |
| Com_show_master_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 | 13 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 194 |
| Com_show_variables | 1076 |
| Com_show_warnings | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 680 |
| Com_update | 410347 |
| Com_update_multi | 6 |
| Connections | 176159 |
| Created_tmp_disk_tables | 3473 |
| Created_tmp_files | 43115 |
| Created_tmp_tables | 39267 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 1 |
| Delayed_writes | 8321 |
| Flush_commands | 1 |
| Handler_commit | 5520 |
| Handler_delete | 29697 |
| Handler_discover | 0 |
| Handler_read_first | 283602 |
| Handler_read_key | 149061366 |
| Handler_read_next | 257868594 |
| Handler_read_prev | 1166418 |
| Handler_read_rnd | 75003748 |
| Handler_read_rnd_next | 627041043 |
| Handler_rollback | 1040 |
| Handler_update | 112204489 |
| Handler_write | 160073096 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 11442 |
| Key_blocks_used | 10053 |
| Key_read_requests | 926143968 |
| Key_reads | 2457691 |
| Key_write_requests | 88409056 |
| Key_writes | 168922 |
| Max_used_connections | 101 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 123 |
| Open_streams | 0 |
| Open_tables | 64 |
| Opened_tables | 284076 |
| 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 | 5961485 |
| Rpl_status | NULL |
| Select_full_join | 222 |
| Select_full_range_join | 0 |
| Select_range | 700588 |
| Select_range_check | 0 |
| Select_scan | 633279 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 3 |
| Slow_queries | 1059 |
| Sort_merge_passes | 61400 |
| Sort_range | 219558 |
| Sort_rows | 214580655 |
| Sort_scan | 320144 |
| Table_locks_immediate | 6629730 |
| Table_locks_waited | 3003 |
| Threads_cached | 0 |
| Threads_connected | 4 |
| Threads_created | 176157 |
| Threads_running | 1 |
| Uptime | 94223 |
+--------------------------+-------------+
Uptime: 94223 Threads: 4 Questions: 5961486 Slow queries: 1059 Opens: 284076 Flush tables: 1 Open tables: 64 Queries per second avg: 63.270
mysqladmin Ver 8.41 Distrib 4.1.10a, for suse-linux 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.10a
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 1 day 2 hours 10 min 23 sec
Threads: 4 Questions: 5961486 Slow queries: 1059 Opens: 284076 Flush tables: 1 Open tables: 64 Queries per second avg: 63.270
mysqlreport
Password for database user root: MySQL 4.1.10a uptime 1 2:18:31 Sat Dec 30 08:06:03 2006
__ Key __________________________________________________ _______________
Buffer used 9.82M of 16.00M %Used: 61.36
Current 7.19M %Usage: 44.95
Write ratio 0.002
Read ratio 0.003
__ Questions __________________________________________________ _________
Total 5.98M 63.2/s
DMS 5.59M 59.0/s %Total: 93.38
Com_ 219.32k 2.3/s 3.67
COM_QUIT 176.74k 1.9/s 2.95
-Unknown 123 0.0/s 0.00
Slow 1.06k 0.0/s 0.02 %DMS: 0.02
DMS 5.59M 59.0/s 93.38
SELECT 5.05M 53.3/s 84.47 90.46
UPDATE 411.80k 4.3/s 6.88 7.37
INSERT 78.22k 0.8/s 1.31 1.40
REPLACE 27.77k 0.3/s 0.46 0.50
DELETE 15.26k 0.2/s 0.26 0.27
Com_ 219.32k 2.3/s 3.67
change_db 202.31k 2.1/s 3.38
begin 5.52k 0.1/s 0.09
commit 5.52k 0.1/s 0.09
__ SELECT and Sort __________________________________________________ ___
Scan 635.48k 6.7/s %SELECT: 12.58
Range 702.90k 7.4/s 13.91
Full join 226 0.0/s 0.00
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 321.13k 3.4/s
Sort range 220.27k 2.3/s
Sort mrg pass 61.59k 0.7/s
__ Table Locks __________________________________________________ _______
Waited 3.01k 0.0/s %Total: 0.05
Immediate 6.65M 70.2/s
__ Tables __________________________________________________ ____________
Open 64 of 64 %Cache: 100.00
Opened 285.32k 3.0/s
__ Connections __________________________________________________ _______
Max used 101 of 100 %Max: 101.00
Total 176.77k 1.9/s
__ Created Temp __________________________________________________ ______
Disk table 3.49k 0.0/s
Table 39.40k 0.4/s
File 43.24k 0.5/s
__ Threads __________________________________________________ ___________
Running 1 of 2
Cached 0 of 0 %Hit: 0
Created 176.77k 1.9/s
Slow 3 0.0/s
__ Aborted __________________________________________________ ___________
Clients 50 0.0/s
Connects 434 0.0/s
__ Bytes __________________________________________________ _____________
Sent 93.05G 982.4k/s
Received 1.28G 13.5k/s8. 2 vbulletin forums with vBportal and PhotoPost
9. 130 - 250 Cookie timeout=900
10. xlforum.net/phpinfo.php
11. Not httpd.conf but server-tuning.conf
su93159:/etc/apache2 # cat server-tuning.conf
##
## Server-Pool Size Regulation (MPM specific)
##
# the MPM (multiprocessing module) is not a dynamically loadable module in the
# sense of other modules. It is a compile time decision which one is used. We
# provide different apache2 MPM packages, containing different httpd2 binaries
# compiled with the available MPMs. See APACHE_MPM in /etc/sysconfig/apache2.
# prefork MPM
<IfModule prefork.c>
# number of server processes to start
StartServers 5
# minimum number of server processes which are kept spare
MinSpareServers 5
# maximum number of server processes which are kept spare
MaxSpareServers 10
# highest possible MaxClients setting for the lifetime of the Apache process.
ServerLimit 150
# maximum number of server processes allowed to start
MaxClients 150
# maximum number of requests a server process serves
MaxRequestsPerChild 0
</IfModule>
# worker MPM
<IfModule worker.c>
# initial number of server processes to start
StartServers 2
# minimum number of worker threads which are kept spare
MinSpareThreads 25
# maximum number of worker threads which are kept spare
MaxSpareThreads 75
# maximum number of simultaneous client connections
MaxClients 150
# constant number of worker threads in each server process
ThreadsPerChild 25
# maximum number of requests a server process serves
MaxRequestsPerChild 0
</IfModule>
# leader MPM
<IfModule leader.c>
# initial number of server processes to start
StartServers 2
# minimum number of worker threads which are kept spare
MinSpareThreads 25
# maximum number of worker threads which are kept spare
MaxSpareThreads 75
# maximum number of simultaneous client connections
MaxClients 150
# constant number of worker threads in each server process
ThreadsPerChild 25
# maximum number of requests a server process serves
MaxRequestsPerChild 0
</IfModule>
# perchild MPM
<IfModule perchild.c>
# constant number of server processes
NumServers 5
# initial number of worker threads in each server process
StartThreads 5
# minimum number of worker threads which are kept spare
MinSpareThreads 5
# maximum number of worker threads which are kept spare
MaxSpareThreads 10
# maximum number of worker threads in each server process
MaxThreadsPerChild 20
# maximum number of connections per server process
MaxRequestsPerChild 0
AcceptMutex fcntl
</IfModule>
# metux MPM
<IfModule metuxmpm.c>
# initial number of worker threads in each server process
StartThreads 5
# minimum number of worker threads which are kept spare
MinSpareThreads 5
# maximum number of worker threads which are kept spare
MaxSpareThreads 10
# maximum number of connections per server process
MaxRequestsPerChild 0
Multiplexer "wwwrun" "www"
</IfModule>
#
# KeepAlive: Whether or not to allow persistent connections (more than
# one request per connection). Set to "Off" to deactivate.
#
KeepAlive On
#
# MaxKeepAliveRequests: The maximum number of requests to allow
# during a persistent connection. Set to 0 to allow an unlimited amount.
# We recommend you leave this number high, for maximum performance.
#
MaxKeepAliveRequests 100
#
# KeepAliveTimeout: Number of seconds to wait for the next request from the
# same client on the same connection.
#
KeepAliveTimeout 15
#
# EnableMMAP: Control whether memory-mapping is used to deliver
# files (assuming that the underlying OS supports it).
# The default is on; turn this off if you serve from NFS-mounted
# filesystems. On some systems, turning it off (regardless of
# filesystem) can improve performance; for details, please see
# http://httpd.apache.org/docs-2.0/mod/core.html#enablemmap
#
#EnableMMAP off
#
# EnableSendfile: Control whether the sendfile kernel support is
# used to deliver files (assuming that the OS supports it).
# The default is on; turn this off if you serve from NFS-mounted
# filesystems. Please see
# http://httpd.apache.org/docs-2.0/mod/core.html#enablesendfile
#
#EnableSendfile off
#
# The following directives modify normal HTTP response behavior to
# handle known problems with browser implementations.
#
BrowserMatch "Mozilla/2" nokeepalive
BrowserMatch "MSIE 4\.0b2;" nokeepalive downgrade-1.0 force-response-1.0
BrowserMatch "RealPlayer 4\.0" force-response-1.0
BrowserMatch "Java/1\.0" force-response-1.0
BrowserMatch "JDK/1\.0" force-response-1.0
#
# The following directive disables redirects on non-GET requests for
# a directory that does not include the trailing slash. This fixes a
# problem with Microsoft WebFolders which does not appropriately handle
# redirects for folders with DAV methods.
# Same deal with Apple's DAV filesystem and Gnome VFS support for DAV.
#
BrowserMatch "Microsoft Data Access Internet Publishing Provider" redirect-carefully
BrowserMatch "^WebDrive" redirect-carefully
BrowserMatch "^WebDAVFS/1.[012]" redirect-carefully
BrowserMatch "^gnome-vfs" redirect-carefully
su93159:/etc/apache2 #
13 None
14.
uname -a
Linux su93159 2.6.11.4-21.7-smp #1 SMP Thu Jun 2 14:23:14 UTC 2005 x86_64 x86_64 x86_64 GNU/Linux
ulimit -aH
core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
max locked memory (kbytes, -l) 32
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
stack size (kbytes, -s) unlimited
cpu time (seconds, -t) unlimited
max user processes (-u) 16382
virtual memory (kbytes, -v) 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 : 2800.237
cache size : 2048 KB
physical id : 0
siblings : 2
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 syscall lm pni monitor ds_ cpl cid cx16 xtpr
bogomips : 5521.40
clflush size : 64
cache_alignment : 128
address sizes : 36 bits physical, 48 bits virtual
power management:
processor : 1
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 2.80GHz
stepping : 3
cpu MHz : 2800.237
cache size : 2048 KB
physical id : 3
siblings : 2
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 syscall lm pni monitor ds_ cpl cid cx16 xtpr
bogomips : 5586.94
clflush size : 64
cache_alignment : 128
address sizes : 36 bits physical, 48 bits virtual
power management:
processor : 2
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 2.80GHz
stepping : 3
cpu MHz : 2800.237
cache size : 2048 KB
physical id : 0
siblings : 2
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 syscall lm pni monitor ds_ cpl cid cx16 xtpr
bogomips : 5586.94
clflush size : 64
cache_alignment : 128
address sizes : 36 bits physical, 48 bits virtual
power management:
processor : 3
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 2.80GHz
stepping : 3
cpu MHz : 2800.237
cache size : 2048 KB
physical id : 3
siblings : 2
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 syscall lm pni monitor ds_ cpl cid cx16 xtpr
bogomips : 5586.94
clflush size : 64
cache_alignment : 128
address sizes : 36 bits physical, 48 bits virtual
power management:
Thanks!!!