fingerman
Tue 1st Jul '08, 10:48am
1. This is a dedicated server. No other sites are currently on this server, but some might be added in the future.
2. cpu speed/type single or dual cpus): 1.6Ghz Core Solo
how much memory installed: 512MB RAM
hard drive type/configuration: 80GB SATA non raid
linux distributor or windows version: Fedora Core 6
apache/IIS version: apache 2.2
PHP version: php 4.4.7
MySQL version: mysql 5.0.27
3. 4.7.2
4. No
5. Yum install
6. Newest member to the forums [taylorxoxox] (http://adultmb.com/vbulletin/admincp/user.php?do=edit&u=21747) Record online users 540 (05-24-2005 07:31 AM) Top poster [ddonjj - 3773] (http://adultmb.com/vbulletin/admincp/user.php?do=edit&u=1076) Most replied to thread [Last one who posts wins...] (http://adultmb.com/vbulletin/showthread.php?t=34508) Most viewed thread [Review of Tia] (http://adultmb.com/vbulletin/showthread.php?t=2019) Most popular forum [Windsor General Discussions] (http://adultmb.com/vbulletin/forumdisplay.php?f=9)
7. [mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
8.
+---------------------------------+------------------------------------------------------------+
| Variable_name |
Value |
+---------------------------------+------------------------------------------------------------+
| auto_increment_increment |
1 |
| auto_increment_offset |
1 |
| automatic_sp_privileges |
ON |
| back_log |
50 |
| basedir |
/usr/ |
| bdb_cache_size |
8388600 |
| bdb_home |
/var/lib/mysql/ |
| bdb_log_buffer_size |
32768 |
| bdb_logdir
| |
| bdb_max_lock |
10000 |
| bdb_shared_data |
OFF |
| bdb_tmpdir |
/tmp/ |
| 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 |
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 |
| div_precision_increment |
4 |
| engine_condition_pushdown |
OFF |
| 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 |
YES |
| have_blackhole_engine |
NO |
| have_compress |
YES |
| have_crypt |
YES |
| have_csv |
NO |
| have_dynamic_loading |
YES |
| have_example_engine |
NO |
| have_federated_engine |
NO |
| have_geometry |
YES |
| have_innodb |
YES |
| have_isam |
NO |
| have_merge_engine |
YES |
| have_ndbcluster |
NO |
| 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_support_xa |
ON |
| innodb_sync_spin_loops |
20 |
| innodb_table_locks |
ON |
| innodb_thread_concurrency |
8 |
| innodb_thread_sleep_delay |
10000 |
| interactive_timeout |
28800 |
| join_buffer_size |
131072 |
| key_buffer_size |
8388600 |
| key_cache_age_threshold |
300 |
| key_cache_block_size |
1024 |
| key_cache_division_limit |
100 |
| language |
/usr/share/mysql/english/ |
| large_files_support |
ON |
| 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 |
OFF |
| 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 |
1048576 |
| max_binlog_cache_size |
4294967295 |
| 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 |
4294967295 |
| max_length_for_sort_data |
1024 |
| max_prepared_stmt_count |
16382 |
| max_relay_log_size |
0 |
| max_seeks_for_key |
4294967295 |
| max_sort_length |
1024 |
| max_sp_recursion_depth |
0 |
| max_tmp_tables |
32 |
| max_user_connections |
0 |
| 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 |
8388608 |
| myisam_stats_method |
nulls_unequal |
| net_buffer_length |
16384 |
| net_read_timeout |
30 |
| net_retry_count |
10 |
| net_write_timeout |
60 |
| new |
OFF |
| old_passwords |
ON |
| 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 |
| prepared_stmt_count |
0 |
| protocol_version |
10 |
| query_alloc_block_size |
8192 |
| query_cache_limit |
1048576 |
| query_cache_min_res_unit |
4096 |
| query_cache_size |
0 |
| query_cache_type |
ON |
| query_cache_wlock_invalidate |
OFF |
| query_prealloc_size |
8192 |
| range_alloc_block_size |
2048 |
| read_buffer_size |
131072 |
| read_only |
OFF |
| read_rnd_buffer_size |
262144 |
| relay_log_purge |
ON |
| relay_log_space_limit |
0 |
| rpl_recovery_rank |
0 |
| secure_auth |
OFF |
| server_id |
0 |
| 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/lib/mysql/mysql.sock |
| sort_buffer_size |
2097144 |
| 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 |
EDT |
| table_cache |
64 |
| table_lock_wait_timeout |
50 |
| table_type |
MyISAM |
| thread_cache_size |
0 |
| thread_stack |
196608 |
| 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.27 |
| version_bdb | Sleepycat Software: Berkeley DB
4.1.24: (October 21, 2006) |
| version_comment | Source
distribution |
| version_compile_machine |
i686 |
| version_compile_os |
redhat-linux-gnu |
| wait_timeout |
28800 |
+---------------------------------+------------------------------------------------------------+
+-----------------------------------+------------+
| Variable_name | Value |
+-----------------------------------+------------+
| Aborted_clients | 0 |
| Aborted_connects | 12 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 22213144 |
| Bytes_sent | 4222361400 |
| Com_admin_commands | 1 |
| Com_alter_db | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 6208 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_commit | 0 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 12 |
| Com_dealloc_sql | 0 |
| Com_delete | 467 |
| Com_delete_multi | 0 |
| Com_do | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 12 |
| 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 | 2135 |
| Com_insert_select | 18 |
| 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 | 730 |
| 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 | 50505 |
| Com_set_option | 72 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 8 |
| Com_show_charsets | 18 |
| Com_show_collations | 18 |
| Com_show_column_types | 0 |
| Com_show_create_db | 0 |
| Com_show_create_table | 0 |
| Com_show_databases | 20 |
| Com_show_errors | 0 |
| Com_show_fields | 36 |
| Com_show_grants | 4 |
| 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 | 1 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 54 |
| Com_show_triggers | 0 |
| Com_show_variables | 47 |
| 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 | 12 |
| Com_unlock_tables | 0 |
| Com_update | 4403 |
| Com_update_multi | 12 |
| 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 | 6200 |
| Created_tmp_disk_tables | 56 |
| Created_tmp_files | 7 |
| Created_tmp_tables | 2023 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 888 |
| Handler_discover | 0 |
| Handler_prepare | 0 |
| Handler_read_first | 12237 |
| Handler_read_key | 1660533 |
| Handler_read_next | 957165 |
| Handler_read_prev | 20451 |
| Handler_read_rnd | 179908 |
| Handler_read_rnd_next | 4704254 |
| Handler_rollback | 0 |
| Handler_savepoint | 0 |
| Handler_savepoint_rollback | 0 |
| Handler_update | 8405 |
| Handler_write | 82139 |
| Innodb_buffer_pool_pages_data | 19 |
| Innodb_buffer_pool_pages_dirty | 0 |
| Innodb_buffer_pool_pages_flushed | 0 |
| Innodb_buffer_pool_pages_free | 493 |
| 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 | 77 |
| Innodb_buffer_pool_reads | 12 |
| 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 | 2494464 |
| Innodb_data_reads | 25 |
| 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 | 19 |
| 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 | 6464 |
| Key_blocks_used | 5961 |
| Key_read_requests | 5128273 |
| Key_reads | 22316 |
| Key_write_requests | 11980 |
| Key_writes | 4132 |
| Last_query_cost | 0.000000 |
| Max_used_connections | 8 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 123 |
| Open_streams | 0 |
| Open_tables | 64 |
| Opened_tables | 2760 |
| 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 | 71072 |
| Rpl_status | NULL |
| Select_full_join | 0 |
| Select_full_range_join | 43 |
| Select_range | 18912 |
| Select_range_check | 0 |
| Select_scan | 7527 |
| Slave_open_temp_tables | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 0 |
| Sort_merge_passes | 1 |
| Sort_range | 4378 |
| Sort_rows | 355774 |
| Sort_scan | 2345 |
| 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 | 91022 |
| Table_locks_waited | 3 |
| Tc_log_max_pages_used | 0 |
| Tc_log_page_size | 0 |
| Tc_log_page_waits | 0 |
| Threads_cached | 0 |
| Threads_connected | 1 |
| Threads_created | 6199 |
| Threads_running | 1 |
| Uptime | 20905 |
+-----------------------------------+------------+
Uptime: 20905 Threads: 1 Questions: 71073 Slow queries: 0 Opens:
2760 Flush tables: 1 Open tables: 64 Queries per second avg: 3.400
mysqladmin Ver 8.41 Distrib 5.0.27, for redhat-linux-gnu on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 5.0.27
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 5 hours 48 min 25 sec
Threads: 1 Questions: 71073 Slow queries: 0 Opens: 2760 Flush
tables: 1 Open tables: 64 Queries per second avg: 3.400
+------+------+-----------+----+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+------+------+-----------+----+---------+------+-------+------------------+
| 6199 | root | localhost | | Query | 0 | | show processlist |
+------+------+-----------+----+---------+------+-------+------------------+
9. Vbulletin, flashchat, arcade. Only vbulletin related scripts and no other sites at the moment.
10. Average is about 100 Max is usually 200 cookie timeout is 2700 seconds
11. http://www.adultmb.com/phpinfo.php
12. KeepAlive
ON
MaxKeepAliveRequests
100
KeepAliveTimeout
5
MinSpareServers
5
MaxSpareServers
10
StartServers
5
MaxClients
150
AND Maxrequestsperchild value = 0
13. No files
14. Linux mini1.glishost.com 2.6.20-1.2948.fc6 #1 SMP Fri Apr 27 18:53:15 EDT 2007 i686 i686 i386 GNU/Linux
core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
max nice (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 7692
max locked memory (kbytes, -l) 32
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
max rt priority (-r) 0
stack size (kbytes, -s) unlimited
cpu time (seconds, -t) unlimited
max user processes (-u) 7692
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
processor : 0
vendor_id : GenuineIntel
cpu family : 6
model : 14
model name : Genuine Intel(R) CPU T1200 @ 1.50GHz
stepping : 8
cpu MHz : 1500.000
cache size : 2048 KB
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 10
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic mtrr pge mca cmov pat clflush dts acpi mmx fxsr sse sse2 ss tm pbe nx constant_tsc up pni monitor vmx est tm2 xtpr
bogomips : 3002.67
clflush size : 64
2. cpu speed/type single or dual cpus): 1.6Ghz Core Solo
how much memory installed: 512MB RAM
hard drive type/configuration: 80GB SATA non raid
linux distributor or windows version: Fedora Core 6
apache/IIS version: apache 2.2
PHP version: php 4.4.7
MySQL version: mysql 5.0.27
3. 4.7.2
4. No
5. Yum install
6. Newest member to the forums [taylorxoxox] (http://adultmb.com/vbulletin/admincp/user.php?do=edit&u=21747) Record online users 540 (05-24-2005 07:31 AM) Top poster [ddonjj - 3773] (http://adultmb.com/vbulletin/admincp/user.php?do=edit&u=1076) Most replied to thread [Last one who posts wins...] (http://adultmb.com/vbulletin/showthread.php?t=34508) Most viewed thread [Review of Tia] (http://adultmb.com/vbulletin/showthread.php?t=2019) Most popular forum [Windsor General Discussions] (http://adultmb.com/vbulletin/forumdisplay.php?f=9)
7. [mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
8.
+---------------------------------+------------------------------------------------------------+
| Variable_name |
Value |
+---------------------------------+------------------------------------------------------------+
| auto_increment_increment |
1 |
| auto_increment_offset |
1 |
| automatic_sp_privileges |
ON |
| back_log |
50 |
| basedir |
/usr/ |
| bdb_cache_size |
8388600 |
| bdb_home |
/var/lib/mysql/ |
| bdb_log_buffer_size |
32768 |
| bdb_logdir
| |
| bdb_max_lock |
10000 |
| bdb_shared_data |
OFF |
| bdb_tmpdir |
/tmp/ |
| 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 |
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 |
| div_precision_increment |
4 |
| engine_condition_pushdown |
OFF |
| 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 |
YES |
| have_blackhole_engine |
NO |
| have_compress |
YES |
| have_crypt |
YES |
| have_csv |
NO |
| have_dynamic_loading |
YES |
| have_example_engine |
NO |
| have_federated_engine |
NO |
| have_geometry |
YES |
| have_innodb |
YES |
| have_isam |
NO |
| have_merge_engine |
YES |
| have_ndbcluster |
NO |
| 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_support_xa |
ON |
| innodb_sync_spin_loops |
20 |
| innodb_table_locks |
ON |
| innodb_thread_concurrency |
8 |
| innodb_thread_sleep_delay |
10000 |
| interactive_timeout |
28800 |
| join_buffer_size |
131072 |
| key_buffer_size |
8388600 |
| key_cache_age_threshold |
300 |
| key_cache_block_size |
1024 |
| key_cache_division_limit |
100 |
| language |
/usr/share/mysql/english/ |
| large_files_support |
ON |
| 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 |
OFF |
| 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 |
1048576 |
| max_binlog_cache_size |
4294967295 |
| 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 |
4294967295 |
| max_length_for_sort_data |
1024 |
| max_prepared_stmt_count |
16382 |
| max_relay_log_size |
0 |
| max_seeks_for_key |
4294967295 |
| max_sort_length |
1024 |
| max_sp_recursion_depth |
0 |
| max_tmp_tables |
32 |
| max_user_connections |
0 |
| 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 |
8388608 |
| myisam_stats_method |
nulls_unequal |
| net_buffer_length |
16384 |
| net_read_timeout |
30 |
| net_retry_count |
10 |
| net_write_timeout |
60 |
| new |
OFF |
| old_passwords |
ON |
| 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 |
| prepared_stmt_count |
0 |
| protocol_version |
10 |
| query_alloc_block_size |
8192 |
| query_cache_limit |
1048576 |
| query_cache_min_res_unit |
4096 |
| query_cache_size |
0 |
| query_cache_type |
ON |
| query_cache_wlock_invalidate |
OFF |
| query_prealloc_size |
8192 |
| range_alloc_block_size |
2048 |
| read_buffer_size |
131072 |
| read_only |
OFF |
| read_rnd_buffer_size |
262144 |
| relay_log_purge |
ON |
| relay_log_space_limit |
0 |
| rpl_recovery_rank |
0 |
| secure_auth |
OFF |
| server_id |
0 |
| 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/lib/mysql/mysql.sock |
| sort_buffer_size |
2097144 |
| 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 |
EDT |
| table_cache |
64 |
| table_lock_wait_timeout |
50 |
| table_type |
MyISAM |
| thread_cache_size |
0 |
| thread_stack |
196608 |
| 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.27 |
| version_bdb | Sleepycat Software: Berkeley DB
4.1.24: (October 21, 2006) |
| version_comment | Source
distribution |
| version_compile_machine |
i686 |
| version_compile_os |
redhat-linux-gnu |
| wait_timeout |
28800 |
+---------------------------------+------------------------------------------------------------+
+-----------------------------------+------------+
| Variable_name | Value |
+-----------------------------------+------------+
| Aborted_clients | 0 |
| Aborted_connects | 12 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 22213144 |
| Bytes_sent | 4222361400 |
| Com_admin_commands | 1 |
| Com_alter_db | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 6208 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_commit | 0 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 12 |
| Com_dealloc_sql | 0 |
| Com_delete | 467 |
| Com_delete_multi | 0 |
| Com_do | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 12 |
| 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 | 2135 |
| Com_insert_select | 18 |
| 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 | 730 |
| 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 | 50505 |
| Com_set_option | 72 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 8 |
| Com_show_charsets | 18 |
| Com_show_collations | 18 |
| Com_show_column_types | 0 |
| Com_show_create_db | 0 |
| Com_show_create_table | 0 |
| Com_show_databases | 20 |
| Com_show_errors | 0 |
| Com_show_fields | 36 |
| Com_show_grants | 4 |
| 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 | 1 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 54 |
| Com_show_triggers | 0 |
| Com_show_variables | 47 |
| 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 | 12 |
| Com_unlock_tables | 0 |
| Com_update | 4403 |
| Com_update_multi | 12 |
| 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 | 6200 |
| Created_tmp_disk_tables | 56 |
| Created_tmp_files | 7 |
| Created_tmp_tables | 2023 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 888 |
| Handler_discover | 0 |
| Handler_prepare | 0 |
| Handler_read_first | 12237 |
| Handler_read_key | 1660533 |
| Handler_read_next | 957165 |
| Handler_read_prev | 20451 |
| Handler_read_rnd | 179908 |
| Handler_read_rnd_next | 4704254 |
| Handler_rollback | 0 |
| Handler_savepoint | 0 |
| Handler_savepoint_rollback | 0 |
| Handler_update | 8405 |
| Handler_write | 82139 |
| Innodb_buffer_pool_pages_data | 19 |
| Innodb_buffer_pool_pages_dirty | 0 |
| Innodb_buffer_pool_pages_flushed | 0 |
| Innodb_buffer_pool_pages_free | 493 |
| 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 | 77 |
| Innodb_buffer_pool_reads | 12 |
| 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 | 2494464 |
| Innodb_data_reads | 25 |
| 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 | 19 |
| 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 | 6464 |
| Key_blocks_used | 5961 |
| Key_read_requests | 5128273 |
| Key_reads | 22316 |
| Key_write_requests | 11980 |
| Key_writes | 4132 |
| Last_query_cost | 0.000000 |
| Max_used_connections | 8 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 123 |
| Open_streams | 0 |
| Open_tables | 64 |
| Opened_tables | 2760 |
| 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 | 71072 |
| Rpl_status | NULL |
| Select_full_join | 0 |
| Select_full_range_join | 43 |
| Select_range | 18912 |
| Select_range_check | 0 |
| Select_scan | 7527 |
| Slave_open_temp_tables | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 0 |
| Sort_merge_passes | 1 |
| Sort_range | 4378 |
| Sort_rows | 355774 |
| Sort_scan | 2345 |
| 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 | 91022 |
| Table_locks_waited | 3 |
| Tc_log_max_pages_used | 0 |
| Tc_log_page_size | 0 |
| Tc_log_page_waits | 0 |
| Threads_cached | 0 |
| Threads_connected | 1 |
| Threads_created | 6199 |
| Threads_running | 1 |
| Uptime | 20905 |
+-----------------------------------+------------+
Uptime: 20905 Threads: 1 Questions: 71073 Slow queries: 0 Opens:
2760 Flush tables: 1 Open tables: 64 Queries per second avg: 3.400
mysqladmin Ver 8.41 Distrib 5.0.27, for redhat-linux-gnu on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 5.0.27
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 5 hours 48 min 25 sec
Threads: 1 Questions: 71073 Slow queries: 0 Opens: 2760 Flush
tables: 1 Open tables: 64 Queries per second avg: 3.400
+------+------+-----------+----+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+------+------+-----------+----+---------+------+-------+------------------+
| 6199 | root | localhost | | Query | 0 | | show processlist |
+------+------+-----------+----+---------+------+-------+------------------+
9. Vbulletin, flashchat, arcade. Only vbulletin related scripts and no other sites at the moment.
10. Average is about 100 Max is usually 200 cookie timeout is 2700 seconds
11. http://www.adultmb.com/phpinfo.php
12. KeepAlive
ON
MaxKeepAliveRequests
100
KeepAliveTimeout
5
MinSpareServers
5
MaxSpareServers
10
StartServers
5
MaxClients
150
AND Maxrequestsperchild value = 0
13. No files
14. Linux mini1.glishost.com 2.6.20-1.2948.fc6 #1 SMP Fri Apr 27 18:53:15 EDT 2007 i686 i686 i386 GNU/Linux
core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
max nice (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 7692
max locked memory (kbytes, -l) 32
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
max rt priority (-r) 0
stack size (kbytes, -s) unlimited
cpu time (seconds, -t) unlimited
max user processes (-u) 7692
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
processor : 0
vendor_id : GenuineIntel
cpu family : 6
model : 14
model name : Genuine Intel(R) CPU T1200 @ 1.50GHz
stepping : 8
cpu MHz : 1500.000
cache size : 2048 KB
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 10
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic mtrr pge mca cmov pat clflush dts acpi mmx fxsr sse sse2 ss tm pbe nx constant_tsc up pni monitor vmx est tm2 xtpr
bogomips : 3002.67
clflush size : 64