# Server Variables # Connection: Faclins # Host: 200.204.53.126 # Saved: 2004-04-05 20:48:38 # 'Property','Value' 'back_log','50' 'basedir','/usr/bin/mysql-4.1.1/' 'bdb_cache_size','8388600' 'bdb_log_buffer_size','0' 'bdb_max_lock','10000' 'bdb_shared_data','OFF' '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/bin/mysql-4.1.1/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','254' 'ft_min_word_len','4' 'ft_query_expansion_limit','20' 'ft_stopword_file','(built-in)' 'have_bdb','DISABLED' 'have_compress','YES' 'have_crypt','YES' 'have_innodb','DISABLED' 'have_isam','NO' 'have_openssl','NO' 'have_query_cache','YES' 'have_raid','YES' 'have_symlink','YES' 'innodb_additional_mem_pool_size','524288' 'innodb_buffer_pool_awe_mem_mb','0' 'innodb_buffer_pool_size','1048576' 'innodb_fast_shutdown','ON' 'innodb_file_io_threads','4' 'innodb_file_per_table','OFF' 'innodb_flush_log_at_trx_commit','1' 'innodb_force_recovery','0' 'innodb_lock_wait_timeout','50' 'innodb_log_archive','OFF' 'innodb_log_buffer_size','262144' 'innodb_log_file_size','1048576' 'innodb_log_files_in_group','2' 'innodb_max_dirty_pages_pct','90' 'innodb_mirrored_log_groups','1' 'innodb_open_files','300' 'innodb_thread_concurrency','1' 'interactive_timeout','28800' 'join_buffer_size','131072' 'key_buffer_size','4194304' 'key_cache_age_threshold','300' 'key_cache_block_size','1024' 'key_cache_division_limit','100' 'language','/usr/bin/mysql-4.1.1/share/mysql/english/' 'large_files_support','ON' 'local_infile','ON' 'locked_in_memory','OFF' 'log','OFF' 'log_bin','OFF' 'log_slave_updates','OFF' 'log_slow_queries','ON' 'log_update','OFF' 'log_warnings','OFF' 'long_query_time','2' 'low_priority_updates','OFF' 'lower_case_table_names','OFF' 'max_allowed_packet','1047552' '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_join_size','18446744073709551615' 'max_length_for_sort_data','1024' 'max_prepared_statements','64' 'max_relay_log_size','0' 'max_seeks_for_key','4294967295' 'max_sort_length','1024' 'max_tmp_tables','32' 'max_user_connections','0' 'max_write_lock_count','4294967295' 'myisam_max_extra_sort_file_size','268435456' 'myisam_max_sort_file_size','2147483647' '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/run/mysql/mysql.pid' 'port','3306' 'preload_buffer_size','32768' 'protocol_version','10' 'pseudo_thread_id','0' 'query_alloc_block_size','8192' 'query_cache_limit','4194304' 'query_cache_min_res_unit','4096' 'query_cache_size','4194304' 'query_cache_type','ON' 'query_prealloc_size','8192' 'range_alloc_block_size','2048' 'read_buffer_size','520192' 'read_only','OFF' 'read_only','OFF' 'read_rnd_buffer_size','2093056' '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','3' 'socket','/tmp/mysql-socket/mysql.sock' 'sort_buffer_size','2097144' 'table_cache','16' 'table_type','MYISAM' 'thread_cache_size','0' 'thread_stack','131072' 'time_format','%H:%i:%s' 'timezone','BRT' 'tmp_table_size','33554432' 'transaction_alloc_block_size','8192' 'transaction_prealloc_size','4096' 'tx_isolation','REPEATABLE-READ' 'version','4.1.1-alpha-max-log' 'version_bdb','Sleepycat Software: Berkeley DB 4.1.24: (December 1, 2003)' 'version_comment','Official MySQL-max binary' 'version_compile_machine','i686' 'version_compile_os','pc-linux' 'wait_timeout','28800' STATUS +--------------------------+----------+ | Variable_name | Value | +--------------------------+----------+ | Aborted_clients | 16 | | Aborted_connects | 2 | | Bytes_received | 84034180 | | Bytes_sent | 90052835 | | Com_admin_commands | 37045 | | Com_alter_db | 0 | | Com_alter_table | 6 | | Com_analyze | 0 | | Com_backup_table | 0 | | Com_begin | 0 | | Com_change_db | 670057 | | 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 | 24374 | | Com_delete | 1407 | | Com_delete_multi | 0 | | Com_do | 0 | | Com_drop_db | 0 | | Com_drop_function | 0 | | Com_drop_index | 0 | | Com_drop_table | 10 | | Com_drop_user | 0 | | Com_flush | 4 | | Com_grant | 0 | | Com_ha_close | 0 | | Com_ha_open | 0 | | Com_ha_read | 0 | | Com_help | 0 | | Com_insert | 27151 | | Com_insert_select | 0 | | Com_kill | 0 | | Com_load | 0 | | Com_load_master_data | 0 | | Com_load_master_table | 0 | | Com_lock_tables | 3 | | Com_optimize | 0 | | Com_preload_keys | 0 | | Com_purge | 0 | | Com_purge_before_date | 0 | | Com_rename_table | 0 | | Com_repair | 54 | | Com_replace | 0 | | 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 | 186425 | | Com_set_option | 38489 | | Com_show_binlogs | 0 | | Com_show_binlog_events | 0 | | Com_show_charsets | 0 | | Com_show_collations | 0 | | Com_show_column_types | 0 | | Com_show_create_table | 63 | | Com_show_create_db | 0 | | Com_show_databases | 6 | | Com_show_errors | 0 | | Com_show_fields | 435 | | Com_show_grants | 0 | | Com_show_innodb_status | 0 | | Com_show_keys | 54 | | 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 | 11 | | Com_show_slave_hosts | 0 | | Com_show_slave_status | 0 | | Com_show_status | 57 | | Com_show_tables | 23 | | Com_show_table_types | 0 | | Com_show_variables | 3 | | Com_show_warnings | 0 | | Com_slave_start | 0 | | Com_slave_stop | 0 | | Com_truncate | 1 | | Com_unlock_tables | 0 | | Com_update | 40953 | | Com_update_multi | 0 | | Connections | 1395 | | Created_tmp_disk_tables | 0 | | Created_tmp_tables | 3076 | | Created_tmp_files | 0 | | Delayed_insert_threads | 0 | | Delayed_writes | 0 | | Delayed_errors | 0 | | Flush_commands | 1 | | Handler_commit | 0 | | Handler_delete | 2385 | | Handler_read_first | 128123 | | Handler_read_key | 1239415 | | Handler_read_next | 2385125 | | Handler_read_prev | 0 | | Handler_read_rnd | 95008 | | Handler_read_rnd_next | 5272224 | | Handler_rollback | 0 | | Handler_update | 263510 | | Handler_write | 437397 | | Key_blocks_not_flushed | 0 | | Key_blocks_used | 3637 | | Key_read_requests | 1776186 | | Key_reads | 4782 | | Key_write_requests | 34682 | | Key_writes | 11845 | | Max_used_connections | 16 | | Not_flushed_delayed_rows | 0 | | Open_tables | 16 | | Open_files | 28 | | Open_streams | 0 | | Opened_tables | 2921 | | Questions | 1342326 | | Qcache_queries_in_cache | 1062 | | Qcache_inserts | 185405 | | Qcache_hits | 348340 | | Qcache_lowmem_prunes | 0 | | Qcache_not_cached | 511 | | Qcache_free_memory | 2687728 | | Qcache_free_blocks | 188 | | Qcache_total_blocks | 2380 | | Rpl_status | NULL | | Select_full_join | 0 | | Select_full_range_join | 0 | | Select_range | 667 | | Select_range_check | 0 | | Select_scan | 24424 | | Slave_open_temp_tables | 0 | | Slave_running | OFF | | Slow_launch_threads | 0 | | Slow_queries | 14 | | Sort_merge_passes | 0 | | Sort_range | 272 | | Sort_rows | 239853 | | Sort_scan | 719 | | Table_locks_immediate | 280339 | | Table_locks_waited | 27 | | Threads_cached | 0 | | Threads_created | 1394 | | Threads_connected | 6 | | Threads_running | 1 | | Uptime | 118928 | +--------------------------+----------+ back_log