| Variable_name | Value | +---------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------+ | back_log | 50 | | basedir | /usr/local/mysql/ | | binlog_cache_size | 32768 | | character_set | latin1 | | character_sets | latin1 dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 | | concurrent_insert | ON | | connect_timeout | 5 | | datadir | /usr/local/mysql/var/ | | delay_key_write | ON | | delayed_insert_limit | 100 | | delayed_insert_timeout | 300 | | delayed_queue_size | 1000 | | flush | OFF | | flush_time | 0 | | have_bdb | NO | | have_gemini | NO | | have_innodb | YES | | have_isam | YES | | have_raid | NO | | have_openssl | NO | | init_file | | | innodb_additional_mem_pool_size | 2097152 | | innodb_buffer_pool_size | 402653184 | | innodb_data_file_path | ibdata1 | | innodb_data_home_dir | /usr/local/mysql/var/ | | innodb_file_io_threads | 4 | | innodb_force_recovery | 0 | | innodb_thread_concurrency | 8 | | innodb_flush_log_at_trx_commit | 1 | | innodb_fast_shutdown | ON | | innodb_flush_method | | | innodb_lock_wait_timeout | 50 | | innodb_log_arch_dir | /usr/local/mysql/var/ | | innodb_log_archive | OFF | | innodb_log_buffer_size | 8388608 | | innodb_log_file_size | 5242880 | | innodb_log_files_in_group | 3 | | innodb_log_group_home_dir | /usr/local/mysql/var/ | | innodb_mirrored_log_groups | 1 | | interactive_timeout | 28800 | | join_buffer_size | 131072 | | key_buffer_size | 402649088 | | language | /usr/local/mysql/share/mysql/english/ | | large_files_support | ON | | locked_in_memory | OFF | | log | OFF | | log_update | OFF | | log_bin | ON | | log_slave_updates | OFF | | log_long_queries | OFF | | long_query_time | 10 | | low_priority_updates | OFF | | lower_case_table_names | 0 | | max_allowed_packet | 1047552 | | max_binlog_cache_size | 4294967295 | | max_binlog_size | 1073741824 | | max_connections | 250 | | max_connect_errors | 10 | | max_delayed_threads | 20 | | max_heap_table_size | 16777216 | | max_join_size | 4294967295 | | max_sort_length | 1024 | | max_user_connections | 0 | | max_tmp_tables | 32 | | max_write_lock_count | 4294967295 | | myisam_max_extra_sort_file_size | 256 | | myisam_max_sort_file_size | 2047 | | myisam_recover_options | 0 | | myisam_sort_buffer_size | 134217728 | | net_buffer_length | 16384 | | net_read_timeout | 30 | | net_retry_count | 10 | | net_write_timeout | 60 | | open_files_limit | 0 | | pid_file | /usr/local/mysql/var/www.wikipedia.org.pid | | port | 3306 | | protocol_version | 10 | | record_buffer | 4190208 | | record_rnd_buffer | 4190208 | | query_buffer_size | 0 | | safe_show_database | OFF | | server_id | 1 | | slave_net_timeout | 3600 | | skip_locking | ON | | skip_networking | OFF | | skip_show_database | OFF | | slow_launch_time | 2 | | socket | /tmp/mysql.sock | | sort_buffer | 16777208 | | sql_mode | 0 | | table_cache | 256 | | table_type | MYISAM | | thread_cache_size | 8 | | thread_stack | 65536 | | transaction_isolation | READ-COMMITTED | | timezone | UTC | | tmp_table_size | 33554432 | | tmpdir | /tmp/ | | version | 3.23.54-log | | wait_timeout | 28800 |