OnR
Fri 27th Apr '07, 5:32pm
1. Is this on dedicated or shared virual server. If shared, how many sites share this server (ask web host if needed)
VPS
2. your server specs.
INTEL P4 3.4
Memory : 256 MB
hard drive type/configuration : 10 GB HDD
PHP PHP 4.4.4-8+etch1
MySQL 5.0.32
Apache/2.2.3
linux distributor : Debian etch
3. what version of vB are you running ?
3.6.5
4. if you use mysql 4.x instead of mysql 3.23.x, do you have any innodb type databases/tables on your server ?
No.
5. if possible how mysql was compiled/installed
Installed with apt-get
6. your top stats
top - 23:19:32 up 2 days, 4:44, 1 user, load average: 0.21, 0.46, 0.46
Tasks: 68 total, 1 running, 56 sleeping, 11 stopped, 0 zombie
Cpu(s): 4.6% us, 1.4% sy, 0.0% ni, 92.9% id, 1.0% wa, 0.0% hi, 0.1% si
Mem: 262144k total, 119504k used, 142640k free, 0k buffers
Swap: 1048576k total, 1048576k used, 0k free, 0k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
1 root 15 0 1568 528 460 S 0.0 0.2 0:14.35 init
29206 root 15 0 1724 712 568 S 0.0 0.3 0:01.36 syslogd
29470 clamav 15 0 5568 1596 1152 S 0.0 0.6 0:00.12 freshclam
29474 root 23 0 1756 396 316 S 0.0 0.2 0:00.01 courierlogger
29475 root 15 0 1912 600 476 S 0.0 0.2 0:00.00 authdaemond
29477 root 15 0 1912 568 308 S 0.0 0.2 0:00.00 authdaemond
29478 root 15 0 1912 568 308 S 0.0 0.2 0:00.00 authdaemond
29479 root 15 0 1912 568 308 S 0.0 0.2 0:00.00 authdaemond
29480 root 15 0 1912 276 152 S 0.0 0.1 0:00.00 authdaemond
29481 root 15 0 1912 568 308 S 0.0 0.2 0:00.00 authdaemond
29485 root 23 0 1756 328 252 S 0.0 0.1 0:00.00 courierlogger
29486 root 16 0 1856 548 460 S 0.0 0.2 0:00.00 couriertcpd
29491 root 16 0 1856 520 432 S 0.0 0.2 0:00.00 couriertcpd
29493 root 16 0 1752 480 400 S 0.0 0.2 0:00.00 courierlogger
29496 dcc 15 0 26520 8500 692 S 0.0 3.2 0:00.02 dccifd
29575 root 16 0 3600 980 692 S 0.0 0.4 0:00.01 sshd
29630 root 18 0 2268 808 644 S 0.0 0.3 0:00.00 xinetd
29666 daemon 15 0 1776 404 300 S 0.0 0.2 0:00.00 atd
29669 root 16 0 1840 840 668 S 0.0 0.3 0:00.05 cron
29766 root 22 0 1564 400 328 S 0.0 0.2 0:00.00 vhcs2_daemon
29975 root 16 0 20756 7144 4104 S 0.0 2.7 0:00.40 apache2
30016 root 24 0 38832 2696 1740 S 0.0 1.0 0:05.60 named
30105 root 15 0 4816 1660 1340 S 0.0 0.6 0:01.30 master
30111 postfix 15 0 4856 1756 1380 S 0.0 0.7 0:00.48 qmgr
30136 nobody 15 0 9136 1520 528 S 0.0 0.6 0:00.18 proftpd
30186 amavis 15 0 54496 45m 2524 S 0.0 17.9 0:00.52 amavisd-new
30213 root 15 0 30796 27m 2352 S 0.0 10.9 0:00.75 spamd
30238 root 15 0 30796 26m 620 S 0.0 10.2 0:00.07 spamd
30239 root 15 0 30796 26m 532 S 0.0 10.2 0:00.09 spamd
29930 root 15 0 2176 1128 860 T 0.0 0.4 0:00.00 top
30229 root 15 0 2176 1124 860 T 0.0 0.4 0:00.01 top
3502 amavis 15 0 55916 46m 2668 S 0.0 18.2 0:00.57 amavisd-new
4926 postfix 15 0 4820 1624 1308 S 0.0 0.6 0:00.02 pickup
6397 www-data 15 0 31624 17m 4132 S 0.0 6.9 0:08.61 apache2
7168 root 15 0 14720 1972 1512 S 0.0 0.8 0:00.22 sshd
7209 root 15 0 2712 1588 1224 S 0.0 0.6 0:00.00 bash
7684 root 15 0 2072 1084 716 T 0.0 0.4 0:00.00 pico
7756 root 15 0 2172 1128 860 T 0.0 0.4 0:00.01 top
7810 www-data 15 0 35252 21m 4132 S 0.0 8.3 0:03.59 apache2
8090 root 25 0 2404 1148 932 S 0.0 0.4 0:00.02 mysqld_safe
8127 mysql 15 0 181m 45m 5240 S 0.0 17.6 0:48.87 mysqld
8128 root 16 0 1560 508 440 S 0.0 0.2 0:00.00 logger
8348 root 15 0 2172 1128 860 T 0.0 0.4 0:00.05 top
8630 www-data 15 0 37616 24m 4620 S 0.0 9.4 0:03.91 apache2
8676 amavis 16 0 56096 46m 2652 S 0.0 18.2 0:00.52 amavisd-new
9434 www-data 15 0 35448 21m 4120 S 0.0 8.4 0:03.67 apache2
10083 www-data 15 0 30304 16m 4088 S 0.0 6.4 0:06.94 apache2
10182 root 16 0 13496 4392 2916 T 0.0 1.7 0:00.01 php5
10291 www-data 15 0 30436 16m 4096 S 0.0 6.5 0:08.22 apache2
10477 root 15 0 2172 1132 860 T 0.0 0.4 0:00.00 top
10500 root 15 0 2076 1096 720 T 0.0 0.4 0:00.01 pico
10721 www-data 15 0 32708 18m 4108 S 0.0 7.3 0:04.05 apache2
10892 root 15 0 5192 1896 1504 T 0.0 0.7 0:00.01 mysqladmin
10903 root 15 0 5188 1900 1508 T 0.0 0.7 0:00.03 mysqladmin
10922 root 16 0 5188 1892 1504 T 0.0 0.7 0:00.03 mysqladmin
11042 www-data 15 0 28836 14m 3712 S 0.0 5.7 0:01.51 apache2
11047 www-data 15 0 28976 15m 4260 S 0.0 6.0 0:03.28 apache2
11132 www-data 15 0 28860 14m 3696 S 0.0 5.7 0:01.12 apache2
11219 www-data 15 0 28312 14m 4036 S 0.0 5.6 0:00.80 apache2
11220 www-data 15 0 29440 15m 3716 S 0.0 5.9 0:01.45 apache2
11261 www-data 15 0 26000 11m 3580 S 0.0 4.6 0:00.30 apache2
11262 www-data 15 0 28884 14m 3712 S 0.0 5.7 0:01.13 apache2
11339 postfix 17 0 4888 2012 1664 S 0.0 0.8 0:00.02 cleanup
11340 postfix 16 0 4832 1944 1588 S 0.0 0.7 0:00.01 trivial-rewrite
7. your mysql configuration variables located at /etc/my.cnf or c:\my.cnf or my.ini so post the contents inside of my.cnf (minus any passwords of course).
#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html
# This will be passed to all mysql clients
# It has been reported that passwords should be enclosed with ticks/quotes
# escpecially if they contain "#" chars...
# Remember to edit /etc/mysql/debian.cnf when changing the socket location.
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
# Here is entries for some specific programs
# The following values assume you have at least 32M ram
# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0
[mysqld]
#
# * Basic Settings
#
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
language = /usr/share/mysql/english
skip-external-locking
max_connections = 300
max_user_connections = 50
key_buffer = 32M
key_buffer_size=64M
myisam_sort_buffer_size = 16M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 4M
interactive_timeout = 20
wait_timeout = 28800
connect_timeout = 10
query_cache_limit = 1M
#query_cache_size = 8M
query_cache_type = 1
table_cache=256
sort_buffer=128M
thread_cache_size = 30
skip-external-locking
read_buffer=2M
record_buffer=1M
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address = 127.0.0.1
#
# * Fine Tuning
#
#key_buffer = 16M
max_allowed_packet = 32M
thread_stack = 128K
#thread_cache_size = 8
#max_connections = 100
#table_cache = 64
#thread_concurrency = 10
#
# * Query Cache Configuration
#
query_cache_limit = 1M
query_cache_size = 16M
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
#log = /var/log/mysql/mysql.log
#
# Error logging goes to syslog. This is a Debian improvement :)
#
# Here you can see queries with especially long duration
#log_slow_queries = /var/log/mysql/mysql-slow.log
#long_query_time = 2
#log-queries-not-using-indexes
#
# The following can be used as easy to replay backup logs or for replication.
#server-id = 1
log_bin = /var/log/mysql/mysql-bin.log
# WARNING: Using expire_logs_days without bin_log crashes the server! See README.Debian!
expire_logs_days = 10
max_binlog_size = 100M
#binlog_do_db = include_database_name
#binlog_ignore_db = include_database_name
#
# * BerkeleyDB
#
# Using BerkeleyDB is now discouraged as its support will cease in 5.1.12.
skip-bdb
#
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
# You might want to disable InnoDB to shrink the mysqld process by circa 100MB.
#skip-innodb
#
# * Security Features
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
#
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem
[mysqldump]
quick
quote-names
max_allowed_packet = 16M
[mysql]
#no-auto-rehash # faster start of mysql but no tab completition
[isamchk]
key_buffer = 16M
#
# * NDB Cluster
#
# See /usr/share/doc/mysql-server-*/README.Debian for more information.
#
# The following configuration is read by the NDB Data Nodes (ndbd processes)
# not from the NDB Management Nodes (ndb_mgmd processes).
#
# [MYSQL_CLUSTER]
# ndb-connectstring=127.0.0.1
#
# * IMPORTANT: Additional settings that can override those from this file!
#
!includedir /etc/mysql/conf.d/
8. MySQL stats from ssh telnet as root user type:
+---------------------------------+-----------------------------+
| Variable_name | Value |
+---------------------------------+-----------------------------+
| auto_increment_increment | 1 |
| auto_increment_offset | 1 |
| automatic_sp_privileges | ON |
| 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_filesystem | binary |
| 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 |
| completion_type | 0 |
| concurrent_insert | 1 |
| 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 |
| div_precision_increment | 4 |
| engine_condition_pushdown | OFF |
| expire_logs_days | 10 |
| 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 | YES |
| have_bdb | NO |
| have_blackhole_engine | NO |
| have_compress | YES |
| have_crypt | YES |
| have_csv | YES |
| have_dynamic_loading | YES |
| have_example_engine | NO |
| have_federated_engine | YES |
| have_geometry | YES |
| have_innodb | YES |
| have_isam | NO |
| have_merge_engine | YES |
| have_ndbcluster | DISABLED |
| have_openssl | DISABLED |
| 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_checksums | ON |
| innodb_commit_concurrency | 0 |
| innodb_concurrency_tickets | 500 |
| innodb_data_file_path | ibdata1:10M:autoextend |
| innodb_data_home_dir | |
| innodb_doublewrite | ON |
| innodb_fast_shutdown | 1 |
| 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_rollback_on_timeout | OFF |
| innodb_support_xa | ON |
| innodb_sync_spin_loops | 20 |
| innodb_table_locks | ON |
| innodb_thread_concurrency | 8 |
| innodb_thread_sleep_delay | 10000 |
| interactive_timeout | 20 |
| join_buffer_size | 1044480 |
| key_buffer_size | 67108864 |
| key_cache_age_threshold | 300 |
| key_cache_block_size | 1024 |
| key_cache_division_limit | 100 |
| language | /usr/share/mysql/english/ |
| large_files_support | ON |
| large_page_size | 0 |
| large_pages | OFF |
| lc_time_names | en_US |
| license | GPL |
| local_infile | ON |
| locked_in_memory | OFF |
| log | OFF |
| log_bin | ON |
| log_bin_trust_function_creators | OFF |
| log_error | |
| log_queries_not_using_indexes | OFF |
| log_slave_updates | OFF |
| log_slow_queries | 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 | 33553408 |
| max_binlog_cache_size | 4294967295 |
| max_binlog_size | 104857600 |
| max_connect_errors | 10 |
| max_connections | 300 |
| max_delayed_threads | 20 |
| max_error_count | 64 |
| max_heap_table_size | 16777216 |
| max_insert_delayed_threads | 20 |
| max_join_size | 18446744073709551615 |
| max_length_for_sort_data | 1024 |
| max_prepared_stmt_count | 16382 |
| max_relay_log_size | 0 |
| max_seeks_for_key | 4294967295 |
| max_sort_length | 1024 |
| max_sp_recursion_depth | 0 |
| max_tmp_tables | 32 |
| max_user_connections | 50 |
| max_write_lock_count | 4294967295 |
| multi_range_count | 256 |
| myisam_data_pointer_size | 6 |
| myisam_max_sort_file_size | 2147483647 |
| myisam_recover_options | OFF |
| myisam_repair_threads | 1 |
| myisam_sort_buffer_size | 16777216 |
| myisam_stats_method | nulls_unequal |
| ndb_autoincrement_prefetch_sz | 32 |
| ndb_force_send | ON |
| ndb_use_exact_count | ON |
| ndb_use_transactions | OFF |
| ndb_cache_check_time | 0 |
| net_buffer_length | 16384 |
| net_read_timeout | 30 |
| net_retry_count | 10 |
| net_write_timeout | 60 |
| new | OFF |
| old_passwords | OFF |
| open_files_limit | 1024 |
| optimizer_prune_level | 1 |
| optimizer_search_depth | 62 |
| pid_file | /var/run/mysqld/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 | 16777216 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 8192 |
| range_alloc_block_size | 2048 |
| read_buffer_size | 1044480 |
| read_only | OFF |
| read_rnd_buffer_size | 262144 |
| relay_log_purge | ON |
| relay_log_space_limit | 0 |
| rpl_recovery_rank | 0 |
| secure_auth | OFF |
| server_id | 1 |
| skip_external_locking | ON |
| skip_networking | OFF |
| skip_show_database | OFF |
| slave_compressed_protocol | OFF |
| slave_load_tmpdir | /tmp/ |
| slave_net_timeout | 3600 |
| slave_skip_errors | OFF |
| slave_transaction_retries | 10 |
| slow_launch_time | 2 |
| socket | /var/run/mysqld/mysqld.sock |
| sort_buffer_size | 134217720 |
| sql_big_selects | ON |
| sql_mode | |
| sql_notes | ON |
| sql_warnings | OFF |
| ssl_ca | |
| ssl_capath | |
| ssl_cert | |
| ssl_cipher | |
| ssl_key | |
| storage_engine | MyISAM |
| sync_binlog | 0 |
| sync_frm | ON |
| system_time_zone | EEST |
| table_cache | 256 |
| table_lock_wait_timeout | 50 |
| table_type | MyISAM |
| thread_cache_size | 30 |
| thread_stack | 131072 |
| time_format | %H:%i:%s |
| time_zone | SYSTEM |
| timed_mutexes | OFF |
| tmp_table_size | 33554432 |
| tmpdir | /tmp |
| transaction_alloc_block_size | 8192 |
| transaction_prealloc_size | 4096 |
| tx_isolation | REPEATABLE-READ |
| updatable_views_with_limit | YES |
| version | 5.0.32-Debian_7etch1-log |
| version_comment | Debian etch distribution |
| version_compile_machine | i486 |
| version_compile_os | pc-linux-gnu |
| wait_timeout | 28800 |
+---------------------------------+-----------------------------+
+-----------------------------------+-----------+
| Variable_name | Value |
+-----------------------------------+-----------+
| Aborted_clients | 12 |
| Aborted_connects | 3 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 1 |
| Bytes_received | 2897760 |
| Bytes_sent | 293525610 |
| Com_admin_commands | 2 |
| Com_alter_db | 0 |
| Com_alter_table | 69 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 767 |
| Com_change_master | 0 |
| Com_check | 214 |
| Com_checksum | 0 |
| Com_commit | 0 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 14 |
| Com_create_user | 0 |
| Com_dealloc_sql | 0 |
| Com_delete | 63 |
| Com_delete_multi | 0 |
| Com_do | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_drop_user | 0 |
| Com_execute_sql | 0 |
| Com_flush | 1 |
| Com_grant | 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_help | 0 |
| Com_insert | 170 |
| Com_insert_select | 0 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 0 |
| 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 | 30 |
| 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 | 3225 |
| Com_set_option | 10 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_charsets | 0 |
| Com_show_collations | 0 |
| Com_show_column_types | 0 |
| Com_show_create_db | 0 |
| Com_show_create_table | 0 |
| Com_show_databases | 1 |
| Com_show_errors | 0 |
| Com_show_fields | 0 |
| Com_show_grants | 0 |
| Com_show_innodb_status | 0 |
| Com_show_keys | 0 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_ndb_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_privileges | 0 |
| Com_show_processlist | 0 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 8 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 0 |
| Com_show_triggers | 0 |
| Com_show_variables | 10 |
| Com_show_warnings | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_stmt_close | 0 |
| Com_stmt_execute | 0 |
| Com_stmt_fetch | 0 |
| Com_stmt_prepare | 0 |
| Com_stmt_reset | 0 |
| Com_stmt_send_long_data | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 0 |
| Com_update | 491 |
| Com_update_multi | 1 |
| Com_xa_commit | 0 |
| Com_xa_end | 0 |
| Com_xa_prepare | 0 |
| Com_xa_recover | 0 |
| Com_xa_rollback | 0 |
| Com_xa_start | 0 |
| Compression | OFF |
| Connections | 749 |
| Created_tmp_disk_tables | 2 |
| Created_tmp_files | 37 |
| Created_tmp_tables | 139 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 1 |
| Handler_delete | 37 |
| Handler_discover | 0 |
| Handler_prepare | 0 |
| Handler_read_first | 473 |
| Handler_read_key | 45649 |
| Handler_read_next | 2831584 |
| Handler_read_prev | 461 |
| Handler_read_rnd | 6440 |
| Handler_read_rnd_next | 549507 |
| Handler_rollback | 0 |
| Handler_savepoint | 0 |
| Handler_savepoint_rollback | 0 |
| Handler_update | 702 |
| Handler_write | 4324 |
| Innodb_buffer_pool_pages_data | 20 |
| Innodb_buffer_pool_pages_dirty | 0 |
| Innodb_buffer_pool_pages_flushed | 0 |
| Innodb_buffer_pool_pages_free | 492 |
| Innodb_buffer_pool_pages_latched | 0 |
| Innodb_buffer_pool_pages_misc | 0 |
| Innodb_buffer_pool_pages_total | 512 |
| Innodb_buffer_pool_read_ahead_rnd | 1 |
| Innodb_buffer_pool_read_ahead_seq | 0 |
| Innodb_buffer_pool_read_requests | 232 |
| Innodb_buffer_pool_reads | 13 |
| Innodb_buffer_pool_wait_free | 0 |
| Innodb_buffer_pool_write_requests | 0 |
| Innodb_data_fsyncs | 3 |
| Innodb_data_pending_fsyncs | 0 |
| Innodb_data_pending_reads | 0 |
| Innodb_data_pending_writes | 0 |
| Innodb_data_read | 2510848 |
| Innodb_data_reads | 26 |
| Innodb_data_writes | 3 |
| Innodb_data_written | 1536 |
| Innodb_dblwr_pages_written | 0 |
| Innodb_dblwr_writes | 0 |
| Innodb_log_waits | 0 |
| Innodb_log_write_requests | 0 |
| Innodb_log_writes | 1 |
| Innodb_os_log_fsyncs | 3 |
| Innodb_os_log_pending_fsyncs | 0 |
| Innodb_os_log_pending_writes | 0 |
| Innodb_os_log_written | 512 |
| Innodb_page_size | 16384 |
| Innodb_pages_created | 0 |
| Innodb_pages_read | 20 |
| Innodb_pages_written | 0 |
| Innodb_row_lock_current_waits | 0 |
| Innodb_row_lock_time | 0 |
| Innodb_row_lock_time_avg | 0 |
| Innodb_row_lock_time_max | 0 |
| Innodb_row_lock_waits | 0 |
| Innodb_rows_deleted | 0 |
| Innodb_rows_inserted | 0 |
| Innodb_rows_read | 0 |
| Innodb_rows_updated | 0 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 49452 |
| Key_blocks_used | 8538 |
| Key_read_requests | 393506 |
| Key_reads | 8582 |
| Key_write_requests | 7481 |
| Key_writes | 6781 |
| Last_query_cost | 0.000000 |
| Max_used_connections | 18 |
| Ndb_cluster_node_id | 0 |
| Ndb_config_from_host | |
| Ndb_config_from_port | 0 |
| Ndb_number_of_data_nodes | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 445 |
| Open_streams | 0 |
| Open_tables | 234 |
| Opened_tables | 352 |
| Prepared_stmt_count | 0 |
| Qcache_free_blocks | 143 |
| Qcache_free_memory | 11986160 |
| Qcache_hits | 4289 |
| Qcache_inserts | 3161 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 84 |
| Qcache_queries_in_cache | 327 |
| Qcache_total_blocks | 938 |
| Questions | 10090 |
| Rpl_status | NULL |
| Select_full_join | 2 |
| Select_full_range_join | 0 |
| Select_range | 941 |
| Select_range_check | 0 |
| Select_scan | 901 |
| Slave_open_temp_tables | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 0 |
| Sort_merge_passes | 16 |
| Sort_range | 617 |
| Sort_rows | 2102945 |
| Sort_scan | 250 |
| Ssl_accept_renegotiates | 0 |
| Ssl_accepts | 0 |
| Ssl_callback_cache_hits | 0 |
| Ssl_cipher | |
| Ssl_cipher_list | |
| Ssl_client_connects | 0 |
| Ssl_connect_renegotiates | 0 |
| Ssl_ctx_verify_depth | 0 |
| Ssl_ctx_verify_mode | 0 |
| Ssl_default_timeout | 0 |
| Ssl_finished_accepts | 0 |
| Ssl_finished_connects | 0 |
| Ssl_session_cache_hits | 0 |
| Ssl_session_cache_misses | 0 |
| Ssl_session_cache_mode | NONE |
| Ssl_session_cache_overflows | 0 |
| Ssl_session_cache_size | 0 |
| Ssl_session_cache_timeouts | 0 |
| Ssl_sessions_reused | 0 |
| Ssl_used_session_cache_entries | 0 |
| Ssl_verify_depth | 0 |
| Ssl_verify_mode | 0 |
| Ssl_version | |
| Table_locks_immediate | 7008 |
| Table_locks_waited | 8 |
| Tc_log_max_pages_used | 0 |
| Tc_log_page_size | 0 |
| Tc_log_page_waits | 0 |
| Threads_cached | 5 |
| Threads_connected | 13 |
| Threads_created | 18 |
| Threads_running | 1 |
| Uptime | 1490 |
+-----------------------------------+-----------+
Uptime: 1490 Threads: 12 Questions: 10092 Slow queries: 0 Opens: 352 Flush tables: 1 Open tables: 234 Queries per second avg: 6.773
mysqladmin Ver 8.41 Distrib 5.0.32, for pc-linux-gnu on i486
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 5.0.32-Debian_7etch1-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/run/mysqld/mysqld.sock
Uptime: 24 min 50 sec
Threads: 12 Questions: 10092 Slow queries: 0 Opens: 352 Flush tables: 1 Open tables: 234 Queries per second avg: 6.773
9. is your vB the only thing on the server? or other scripts & sites which utilise php and mysql?
No.
10. how many average and max concurrent users on your vB forum ? and what your cookie timeout is ?
Average : 40-50
Max : 250
Cookie Timeout : 900
11. create a file named phpinfo.php and place this code in it and post the url/link to it from your web site
http://www.nuveforum.net/phpinfo
12. if you run Apache and you have your own dedicated server or access to your httpd.conf (apache configuration file) can you post the values you have set for the following :
KeepAlive : ON
MaxKeepAliveRequests : 100
KeepAliveTimeout : 15
MinSpareServers : 5
MaxSpareServers : 10
StartServers : 5
MaxClients : 150
Maxrequestsperchild value = 0
13. check to see if any files i.e. apache log files are hitting 2GB or 4GB max file size limits i.e. see if you have max file size exceeded messages in apache error log
No...
14. Post output from these 3 commands
uname -a
Linux vs.nuveforum.net 2.6.17-11-server #1 SMP Fri Oct 27 12:19:26 CEST 2006 i686 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) unlimited
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) unlimited
virtual memory (kbytes, -v) unlimited
cat /proc/cpuinfo
processor : 0
vendor_id : GenuineIntel
cpu family : 15
model : 6
model name : Intel(R) Pentium(R) D CPU 3.40GHz
stepping : 5
cpu MHz : 3400.047
cache size : 2048 KB
physical id : 0
siblings : 1
core id : 255
cpu cores : 1
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 6
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 constant_tsc pni monitor ds_cpl est cid cx16 xtpr lahf_lm
bogomips : 6804.82
processor : 1
vendor_id : GenuineIntel
cpu family : 15
model : 6
model name : Intel(R) Pentium(R) D CPU 3.40GHz
stepping : 5
cpu MHz : 3400.047
cache size : 2048 KB
physical id : 1
siblings : 1
core id : 255
cpu cores : 1
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 6
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 constant_tsc pni monitor ds_cpl est cid cx16 xtpr lahf_lm
bogomips : 6800.18
VPS
2. your server specs.
INTEL P4 3.4
Memory : 256 MB
hard drive type/configuration : 10 GB HDD
PHP PHP 4.4.4-8+etch1
MySQL 5.0.32
Apache/2.2.3
linux distributor : Debian etch
3. what version of vB are you running ?
3.6.5
4. if you use mysql 4.x instead of mysql 3.23.x, do you have any innodb type databases/tables on your server ?
No.
5. if possible how mysql was compiled/installed
Installed with apt-get
6. your top stats
top - 23:19:32 up 2 days, 4:44, 1 user, load average: 0.21, 0.46, 0.46
Tasks: 68 total, 1 running, 56 sleeping, 11 stopped, 0 zombie
Cpu(s): 4.6% us, 1.4% sy, 0.0% ni, 92.9% id, 1.0% wa, 0.0% hi, 0.1% si
Mem: 262144k total, 119504k used, 142640k free, 0k buffers
Swap: 1048576k total, 1048576k used, 0k free, 0k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
1 root 15 0 1568 528 460 S 0.0 0.2 0:14.35 init
29206 root 15 0 1724 712 568 S 0.0 0.3 0:01.36 syslogd
29470 clamav 15 0 5568 1596 1152 S 0.0 0.6 0:00.12 freshclam
29474 root 23 0 1756 396 316 S 0.0 0.2 0:00.01 courierlogger
29475 root 15 0 1912 600 476 S 0.0 0.2 0:00.00 authdaemond
29477 root 15 0 1912 568 308 S 0.0 0.2 0:00.00 authdaemond
29478 root 15 0 1912 568 308 S 0.0 0.2 0:00.00 authdaemond
29479 root 15 0 1912 568 308 S 0.0 0.2 0:00.00 authdaemond
29480 root 15 0 1912 276 152 S 0.0 0.1 0:00.00 authdaemond
29481 root 15 0 1912 568 308 S 0.0 0.2 0:00.00 authdaemond
29485 root 23 0 1756 328 252 S 0.0 0.1 0:00.00 courierlogger
29486 root 16 0 1856 548 460 S 0.0 0.2 0:00.00 couriertcpd
29491 root 16 0 1856 520 432 S 0.0 0.2 0:00.00 couriertcpd
29493 root 16 0 1752 480 400 S 0.0 0.2 0:00.00 courierlogger
29496 dcc 15 0 26520 8500 692 S 0.0 3.2 0:00.02 dccifd
29575 root 16 0 3600 980 692 S 0.0 0.4 0:00.01 sshd
29630 root 18 0 2268 808 644 S 0.0 0.3 0:00.00 xinetd
29666 daemon 15 0 1776 404 300 S 0.0 0.2 0:00.00 atd
29669 root 16 0 1840 840 668 S 0.0 0.3 0:00.05 cron
29766 root 22 0 1564 400 328 S 0.0 0.2 0:00.00 vhcs2_daemon
29975 root 16 0 20756 7144 4104 S 0.0 2.7 0:00.40 apache2
30016 root 24 0 38832 2696 1740 S 0.0 1.0 0:05.60 named
30105 root 15 0 4816 1660 1340 S 0.0 0.6 0:01.30 master
30111 postfix 15 0 4856 1756 1380 S 0.0 0.7 0:00.48 qmgr
30136 nobody 15 0 9136 1520 528 S 0.0 0.6 0:00.18 proftpd
30186 amavis 15 0 54496 45m 2524 S 0.0 17.9 0:00.52 amavisd-new
30213 root 15 0 30796 27m 2352 S 0.0 10.9 0:00.75 spamd
30238 root 15 0 30796 26m 620 S 0.0 10.2 0:00.07 spamd
30239 root 15 0 30796 26m 532 S 0.0 10.2 0:00.09 spamd
29930 root 15 0 2176 1128 860 T 0.0 0.4 0:00.00 top
30229 root 15 0 2176 1124 860 T 0.0 0.4 0:00.01 top
3502 amavis 15 0 55916 46m 2668 S 0.0 18.2 0:00.57 amavisd-new
4926 postfix 15 0 4820 1624 1308 S 0.0 0.6 0:00.02 pickup
6397 www-data 15 0 31624 17m 4132 S 0.0 6.9 0:08.61 apache2
7168 root 15 0 14720 1972 1512 S 0.0 0.8 0:00.22 sshd
7209 root 15 0 2712 1588 1224 S 0.0 0.6 0:00.00 bash
7684 root 15 0 2072 1084 716 T 0.0 0.4 0:00.00 pico
7756 root 15 0 2172 1128 860 T 0.0 0.4 0:00.01 top
7810 www-data 15 0 35252 21m 4132 S 0.0 8.3 0:03.59 apache2
8090 root 25 0 2404 1148 932 S 0.0 0.4 0:00.02 mysqld_safe
8127 mysql 15 0 181m 45m 5240 S 0.0 17.6 0:48.87 mysqld
8128 root 16 0 1560 508 440 S 0.0 0.2 0:00.00 logger
8348 root 15 0 2172 1128 860 T 0.0 0.4 0:00.05 top
8630 www-data 15 0 37616 24m 4620 S 0.0 9.4 0:03.91 apache2
8676 amavis 16 0 56096 46m 2652 S 0.0 18.2 0:00.52 amavisd-new
9434 www-data 15 0 35448 21m 4120 S 0.0 8.4 0:03.67 apache2
10083 www-data 15 0 30304 16m 4088 S 0.0 6.4 0:06.94 apache2
10182 root 16 0 13496 4392 2916 T 0.0 1.7 0:00.01 php5
10291 www-data 15 0 30436 16m 4096 S 0.0 6.5 0:08.22 apache2
10477 root 15 0 2172 1132 860 T 0.0 0.4 0:00.00 top
10500 root 15 0 2076 1096 720 T 0.0 0.4 0:00.01 pico
10721 www-data 15 0 32708 18m 4108 S 0.0 7.3 0:04.05 apache2
10892 root 15 0 5192 1896 1504 T 0.0 0.7 0:00.01 mysqladmin
10903 root 15 0 5188 1900 1508 T 0.0 0.7 0:00.03 mysqladmin
10922 root 16 0 5188 1892 1504 T 0.0 0.7 0:00.03 mysqladmin
11042 www-data 15 0 28836 14m 3712 S 0.0 5.7 0:01.51 apache2
11047 www-data 15 0 28976 15m 4260 S 0.0 6.0 0:03.28 apache2
11132 www-data 15 0 28860 14m 3696 S 0.0 5.7 0:01.12 apache2
11219 www-data 15 0 28312 14m 4036 S 0.0 5.6 0:00.80 apache2
11220 www-data 15 0 29440 15m 3716 S 0.0 5.9 0:01.45 apache2
11261 www-data 15 0 26000 11m 3580 S 0.0 4.6 0:00.30 apache2
11262 www-data 15 0 28884 14m 3712 S 0.0 5.7 0:01.13 apache2
11339 postfix 17 0 4888 2012 1664 S 0.0 0.8 0:00.02 cleanup
11340 postfix 16 0 4832 1944 1588 S 0.0 0.7 0:00.01 trivial-rewrite
7. your mysql configuration variables located at /etc/my.cnf or c:\my.cnf or my.ini so post the contents inside of my.cnf (minus any passwords of course).
#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html
# This will be passed to all mysql clients
# It has been reported that passwords should be enclosed with ticks/quotes
# escpecially if they contain "#" chars...
# Remember to edit /etc/mysql/debian.cnf when changing the socket location.
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
# Here is entries for some specific programs
# The following values assume you have at least 32M ram
# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0
[mysqld]
#
# * Basic Settings
#
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
language = /usr/share/mysql/english
skip-external-locking
max_connections = 300
max_user_connections = 50
key_buffer = 32M
key_buffer_size=64M
myisam_sort_buffer_size = 16M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 4M
interactive_timeout = 20
wait_timeout = 28800
connect_timeout = 10
query_cache_limit = 1M
#query_cache_size = 8M
query_cache_type = 1
table_cache=256
sort_buffer=128M
thread_cache_size = 30
skip-external-locking
read_buffer=2M
record_buffer=1M
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address = 127.0.0.1
#
# * Fine Tuning
#
#key_buffer = 16M
max_allowed_packet = 32M
thread_stack = 128K
#thread_cache_size = 8
#max_connections = 100
#table_cache = 64
#thread_concurrency = 10
#
# * Query Cache Configuration
#
query_cache_limit = 1M
query_cache_size = 16M
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
#log = /var/log/mysql/mysql.log
#
# Error logging goes to syslog. This is a Debian improvement :)
#
# Here you can see queries with especially long duration
#log_slow_queries = /var/log/mysql/mysql-slow.log
#long_query_time = 2
#log-queries-not-using-indexes
#
# The following can be used as easy to replay backup logs or for replication.
#server-id = 1
log_bin = /var/log/mysql/mysql-bin.log
# WARNING: Using expire_logs_days without bin_log crashes the server! See README.Debian!
expire_logs_days = 10
max_binlog_size = 100M
#binlog_do_db = include_database_name
#binlog_ignore_db = include_database_name
#
# * BerkeleyDB
#
# Using BerkeleyDB is now discouraged as its support will cease in 5.1.12.
skip-bdb
#
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
# You might want to disable InnoDB to shrink the mysqld process by circa 100MB.
#skip-innodb
#
# * Security Features
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
#
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem
[mysqldump]
quick
quote-names
max_allowed_packet = 16M
[mysql]
#no-auto-rehash # faster start of mysql but no tab completition
[isamchk]
key_buffer = 16M
#
# * NDB Cluster
#
# See /usr/share/doc/mysql-server-*/README.Debian for more information.
#
# The following configuration is read by the NDB Data Nodes (ndbd processes)
# not from the NDB Management Nodes (ndb_mgmd processes).
#
# [MYSQL_CLUSTER]
# ndb-connectstring=127.0.0.1
#
# * IMPORTANT: Additional settings that can override those from this file!
#
!includedir /etc/mysql/conf.d/
8. MySQL stats from ssh telnet as root user type:
+---------------------------------+-----------------------------+
| Variable_name | Value |
+---------------------------------+-----------------------------+
| auto_increment_increment | 1 |
| auto_increment_offset | 1 |
| automatic_sp_privileges | ON |
| 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_filesystem | binary |
| 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 |
| completion_type | 0 |
| concurrent_insert | 1 |
| 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 |
| div_precision_increment | 4 |
| engine_condition_pushdown | OFF |
| expire_logs_days | 10 |
| 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 | YES |
| have_bdb | NO |
| have_blackhole_engine | NO |
| have_compress | YES |
| have_crypt | YES |
| have_csv | YES |
| have_dynamic_loading | YES |
| have_example_engine | NO |
| have_federated_engine | YES |
| have_geometry | YES |
| have_innodb | YES |
| have_isam | NO |
| have_merge_engine | YES |
| have_ndbcluster | DISABLED |
| have_openssl | DISABLED |
| 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_checksums | ON |
| innodb_commit_concurrency | 0 |
| innodb_concurrency_tickets | 500 |
| innodb_data_file_path | ibdata1:10M:autoextend |
| innodb_data_home_dir | |
| innodb_doublewrite | ON |
| innodb_fast_shutdown | 1 |
| 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_rollback_on_timeout | OFF |
| innodb_support_xa | ON |
| innodb_sync_spin_loops | 20 |
| innodb_table_locks | ON |
| innodb_thread_concurrency | 8 |
| innodb_thread_sleep_delay | 10000 |
| interactive_timeout | 20 |
| join_buffer_size | 1044480 |
| key_buffer_size | 67108864 |
| key_cache_age_threshold | 300 |
| key_cache_block_size | 1024 |
| key_cache_division_limit | 100 |
| language | /usr/share/mysql/english/ |
| large_files_support | ON |
| large_page_size | 0 |
| large_pages | OFF |
| lc_time_names | en_US |
| license | GPL |
| local_infile | ON |
| locked_in_memory | OFF |
| log | OFF |
| log_bin | ON |
| log_bin_trust_function_creators | OFF |
| log_error | |
| log_queries_not_using_indexes | OFF |
| log_slave_updates | OFF |
| log_slow_queries | 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 | 33553408 |
| max_binlog_cache_size | 4294967295 |
| max_binlog_size | 104857600 |
| max_connect_errors | 10 |
| max_connections | 300 |
| max_delayed_threads | 20 |
| max_error_count | 64 |
| max_heap_table_size | 16777216 |
| max_insert_delayed_threads | 20 |
| max_join_size | 18446744073709551615 |
| max_length_for_sort_data | 1024 |
| max_prepared_stmt_count | 16382 |
| max_relay_log_size | 0 |
| max_seeks_for_key | 4294967295 |
| max_sort_length | 1024 |
| max_sp_recursion_depth | 0 |
| max_tmp_tables | 32 |
| max_user_connections | 50 |
| max_write_lock_count | 4294967295 |
| multi_range_count | 256 |
| myisam_data_pointer_size | 6 |
| myisam_max_sort_file_size | 2147483647 |
| myisam_recover_options | OFF |
| myisam_repair_threads | 1 |
| myisam_sort_buffer_size | 16777216 |
| myisam_stats_method | nulls_unequal |
| ndb_autoincrement_prefetch_sz | 32 |
| ndb_force_send | ON |
| ndb_use_exact_count | ON |
| ndb_use_transactions | OFF |
| ndb_cache_check_time | 0 |
| net_buffer_length | 16384 |
| net_read_timeout | 30 |
| net_retry_count | 10 |
| net_write_timeout | 60 |
| new | OFF |
| old_passwords | OFF |
| open_files_limit | 1024 |
| optimizer_prune_level | 1 |
| optimizer_search_depth | 62 |
| pid_file | /var/run/mysqld/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 | 16777216 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 8192 |
| range_alloc_block_size | 2048 |
| read_buffer_size | 1044480 |
| read_only | OFF |
| read_rnd_buffer_size | 262144 |
| relay_log_purge | ON |
| relay_log_space_limit | 0 |
| rpl_recovery_rank | 0 |
| secure_auth | OFF |
| server_id | 1 |
| skip_external_locking | ON |
| skip_networking | OFF |
| skip_show_database | OFF |
| slave_compressed_protocol | OFF |
| slave_load_tmpdir | /tmp/ |
| slave_net_timeout | 3600 |
| slave_skip_errors | OFF |
| slave_transaction_retries | 10 |
| slow_launch_time | 2 |
| socket | /var/run/mysqld/mysqld.sock |
| sort_buffer_size | 134217720 |
| sql_big_selects | ON |
| sql_mode | |
| sql_notes | ON |
| sql_warnings | OFF |
| ssl_ca | |
| ssl_capath | |
| ssl_cert | |
| ssl_cipher | |
| ssl_key | |
| storage_engine | MyISAM |
| sync_binlog | 0 |
| sync_frm | ON |
| system_time_zone | EEST |
| table_cache | 256 |
| table_lock_wait_timeout | 50 |
| table_type | MyISAM |
| thread_cache_size | 30 |
| thread_stack | 131072 |
| time_format | %H:%i:%s |
| time_zone | SYSTEM |
| timed_mutexes | OFF |
| tmp_table_size | 33554432 |
| tmpdir | /tmp |
| transaction_alloc_block_size | 8192 |
| transaction_prealloc_size | 4096 |
| tx_isolation | REPEATABLE-READ |
| updatable_views_with_limit | YES |
| version | 5.0.32-Debian_7etch1-log |
| version_comment | Debian etch distribution |
| version_compile_machine | i486 |
| version_compile_os | pc-linux-gnu |
| wait_timeout | 28800 |
+---------------------------------+-----------------------------+
+-----------------------------------+-----------+
| Variable_name | Value |
+-----------------------------------+-----------+
| Aborted_clients | 12 |
| Aborted_connects | 3 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 1 |
| Bytes_received | 2897760 |
| Bytes_sent | 293525610 |
| Com_admin_commands | 2 |
| Com_alter_db | 0 |
| Com_alter_table | 69 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 767 |
| Com_change_master | 0 |
| Com_check | 214 |
| Com_checksum | 0 |
| Com_commit | 0 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 14 |
| Com_create_user | 0 |
| Com_dealloc_sql | 0 |
| Com_delete | 63 |
| Com_delete_multi | 0 |
| Com_do | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_drop_user | 0 |
| Com_execute_sql | 0 |
| Com_flush | 1 |
| Com_grant | 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_help | 0 |
| Com_insert | 170 |
| Com_insert_select | 0 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 0 |
| 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 | 30 |
| 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 | 3225 |
| Com_set_option | 10 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_charsets | 0 |
| Com_show_collations | 0 |
| Com_show_column_types | 0 |
| Com_show_create_db | 0 |
| Com_show_create_table | 0 |
| Com_show_databases | 1 |
| Com_show_errors | 0 |
| Com_show_fields | 0 |
| Com_show_grants | 0 |
| Com_show_innodb_status | 0 |
| Com_show_keys | 0 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_ndb_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_privileges | 0 |
| Com_show_processlist | 0 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 8 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 0 |
| Com_show_triggers | 0 |
| Com_show_variables | 10 |
| Com_show_warnings | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_stmt_close | 0 |
| Com_stmt_execute | 0 |
| Com_stmt_fetch | 0 |
| Com_stmt_prepare | 0 |
| Com_stmt_reset | 0 |
| Com_stmt_send_long_data | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 0 |
| Com_update | 491 |
| Com_update_multi | 1 |
| Com_xa_commit | 0 |
| Com_xa_end | 0 |
| Com_xa_prepare | 0 |
| Com_xa_recover | 0 |
| Com_xa_rollback | 0 |
| Com_xa_start | 0 |
| Compression | OFF |
| Connections | 749 |
| Created_tmp_disk_tables | 2 |
| Created_tmp_files | 37 |
| Created_tmp_tables | 139 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 1 |
| Handler_delete | 37 |
| Handler_discover | 0 |
| Handler_prepare | 0 |
| Handler_read_first | 473 |
| Handler_read_key | 45649 |
| Handler_read_next | 2831584 |
| Handler_read_prev | 461 |
| Handler_read_rnd | 6440 |
| Handler_read_rnd_next | 549507 |
| Handler_rollback | 0 |
| Handler_savepoint | 0 |
| Handler_savepoint_rollback | 0 |
| Handler_update | 702 |
| Handler_write | 4324 |
| Innodb_buffer_pool_pages_data | 20 |
| Innodb_buffer_pool_pages_dirty | 0 |
| Innodb_buffer_pool_pages_flushed | 0 |
| Innodb_buffer_pool_pages_free | 492 |
| Innodb_buffer_pool_pages_latched | 0 |
| Innodb_buffer_pool_pages_misc | 0 |
| Innodb_buffer_pool_pages_total | 512 |
| Innodb_buffer_pool_read_ahead_rnd | 1 |
| Innodb_buffer_pool_read_ahead_seq | 0 |
| Innodb_buffer_pool_read_requests | 232 |
| Innodb_buffer_pool_reads | 13 |
| Innodb_buffer_pool_wait_free | 0 |
| Innodb_buffer_pool_write_requests | 0 |
| Innodb_data_fsyncs | 3 |
| Innodb_data_pending_fsyncs | 0 |
| Innodb_data_pending_reads | 0 |
| Innodb_data_pending_writes | 0 |
| Innodb_data_read | 2510848 |
| Innodb_data_reads | 26 |
| Innodb_data_writes | 3 |
| Innodb_data_written | 1536 |
| Innodb_dblwr_pages_written | 0 |
| Innodb_dblwr_writes | 0 |
| Innodb_log_waits | 0 |
| Innodb_log_write_requests | 0 |
| Innodb_log_writes | 1 |
| Innodb_os_log_fsyncs | 3 |
| Innodb_os_log_pending_fsyncs | 0 |
| Innodb_os_log_pending_writes | 0 |
| Innodb_os_log_written | 512 |
| Innodb_page_size | 16384 |
| Innodb_pages_created | 0 |
| Innodb_pages_read | 20 |
| Innodb_pages_written | 0 |
| Innodb_row_lock_current_waits | 0 |
| Innodb_row_lock_time | 0 |
| Innodb_row_lock_time_avg | 0 |
| Innodb_row_lock_time_max | 0 |
| Innodb_row_lock_waits | 0 |
| Innodb_rows_deleted | 0 |
| Innodb_rows_inserted | 0 |
| Innodb_rows_read | 0 |
| Innodb_rows_updated | 0 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 49452 |
| Key_blocks_used | 8538 |
| Key_read_requests | 393506 |
| Key_reads | 8582 |
| Key_write_requests | 7481 |
| Key_writes | 6781 |
| Last_query_cost | 0.000000 |
| Max_used_connections | 18 |
| Ndb_cluster_node_id | 0 |
| Ndb_config_from_host | |
| Ndb_config_from_port | 0 |
| Ndb_number_of_data_nodes | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 445 |
| Open_streams | 0 |
| Open_tables | 234 |
| Opened_tables | 352 |
| Prepared_stmt_count | 0 |
| Qcache_free_blocks | 143 |
| Qcache_free_memory | 11986160 |
| Qcache_hits | 4289 |
| Qcache_inserts | 3161 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 84 |
| Qcache_queries_in_cache | 327 |
| Qcache_total_blocks | 938 |
| Questions | 10090 |
| Rpl_status | NULL |
| Select_full_join | 2 |
| Select_full_range_join | 0 |
| Select_range | 941 |
| Select_range_check | 0 |
| Select_scan | 901 |
| Slave_open_temp_tables | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 0 |
| Sort_merge_passes | 16 |
| Sort_range | 617 |
| Sort_rows | 2102945 |
| Sort_scan | 250 |
| Ssl_accept_renegotiates | 0 |
| Ssl_accepts | 0 |
| Ssl_callback_cache_hits | 0 |
| Ssl_cipher | |
| Ssl_cipher_list | |
| Ssl_client_connects | 0 |
| Ssl_connect_renegotiates | 0 |
| Ssl_ctx_verify_depth | 0 |
| Ssl_ctx_verify_mode | 0 |
| Ssl_default_timeout | 0 |
| Ssl_finished_accepts | 0 |
| Ssl_finished_connects | 0 |
| Ssl_session_cache_hits | 0 |
| Ssl_session_cache_misses | 0 |
| Ssl_session_cache_mode | NONE |
| Ssl_session_cache_overflows | 0 |
| Ssl_session_cache_size | 0 |
| Ssl_session_cache_timeouts | 0 |
| Ssl_sessions_reused | 0 |
| Ssl_used_session_cache_entries | 0 |
| Ssl_verify_depth | 0 |
| Ssl_verify_mode | 0 |
| Ssl_version | |
| Table_locks_immediate | 7008 |
| Table_locks_waited | 8 |
| Tc_log_max_pages_used | 0 |
| Tc_log_page_size | 0 |
| Tc_log_page_waits | 0 |
| Threads_cached | 5 |
| Threads_connected | 13 |
| Threads_created | 18 |
| Threads_running | 1 |
| Uptime | 1490 |
+-----------------------------------+-----------+
Uptime: 1490 Threads: 12 Questions: 10092 Slow queries: 0 Opens: 352 Flush tables: 1 Open tables: 234 Queries per second avg: 6.773
mysqladmin Ver 8.41 Distrib 5.0.32, for pc-linux-gnu on i486
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 5.0.32-Debian_7etch1-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/run/mysqld/mysqld.sock
Uptime: 24 min 50 sec
Threads: 12 Questions: 10092 Slow queries: 0 Opens: 352 Flush tables: 1 Open tables: 234 Queries per second avg: 6.773
9. is your vB the only thing on the server? or other scripts & sites which utilise php and mysql?
No.
10. how many average and max concurrent users on your vB forum ? and what your cookie timeout is ?
Average : 40-50
Max : 250
Cookie Timeout : 900
11. create a file named phpinfo.php and place this code in it and post the url/link to it from your web site
http://www.nuveforum.net/phpinfo
12. if you run Apache and you have your own dedicated server or access to your httpd.conf (apache configuration file) can you post the values you have set for the following :
KeepAlive : ON
MaxKeepAliveRequests : 100
KeepAliveTimeout : 15
MinSpareServers : 5
MaxSpareServers : 10
StartServers : 5
MaxClients : 150
Maxrequestsperchild value = 0
13. check to see if any files i.e. apache log files are hitting 2GB or 4GB max file size limits i.e. see if you have max file size exceeded messages in apache error log
No...
14. Post output from these 3 commands
uname -a
Linux vs.nuveforum.net 2.6.17-11-server #1 SMP Fri Oct 27 12:19:26 CEST 2006 i686 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) unlimited
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) unlimited
virtual memory (kbytes, -v) unlimited
cat /proc/cpuinfo
processor : 0
vendor_id : GenuineIntel
cpu family : 15
model : 6
model name : Intel(R) Pentium(R) D CPU 3.40GHz
stepping : 5
cpu MHz : 3400.047
cache size : 2048 KB
physical id : 0
siblings : 1
core id : 255
cpu cores : 1
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 6
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 constant_tsc pni monitor ds_cpl est cid cx16 xtpr lahf_lm
bogomips : 6804.82
processor : 1
vendor_id : GenuineIntel
cpu family : 15
model : 6
model name : Intel(R) Pentium(R) D CPU 3.40GHz
stepping : 5
cpu MHz : 3400.047
cache size : 2048 KB
physical id : 1
siblings : 1
core id : 255
cpu cores : 1
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 6
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 constant_tsc pni monitor ds_cpl est cid cx16 xtpr lahf_lm
bogomips : 6800.18