Supported MySQL Server System Variables
Go Up to Parameters, Arguments, Options, and Variables Appendix
The following variables are available from the Explorer’s Configuration node. For information on working with these variables, see Working with Configuration/initialization Parameters.
autocommit |
back_log |
basedir |
big-tables |
binlog_cache_size |
bulk_insert_buffer_size |
character_set_client |
character_set_connection |
character_set_database |
character_set_results |
character-set-server |
character_set_system |
character-sets-dir |
collation_connection |
collation_database |
collation-server |
concurrent_insert |
connect_timeout |
datadir |
date_format |
datetime_format |
default_week_format |
delay_key_write |
delayed_insert_limit |
delayed_insert_timeout |
delayed_queue_size |
expire_logs_days |
flush |
flush_time |
foreign_key_checks |
ft_boolean_syntax |
ft_max_word_len |
ft_min_word_len |
ft_query_expansion_limit |
ft_stopword_file |
group_concat_max_len |
have_archive |
have_bdb |
have_blackhole_engine |
have_compress |
have_crypt |
have_csv |
have_example_engine |
have_geometry |
have_innodb |
have_isam |
have_merge_engine |
have_ndbcluster |
have_openssl |
have_query_cache |
have_raid |
have_rtree_keys |
have_symlink |
identity |
init_connect |
init_file |
init_slave |
innodb_additional_mem_pool_size |
innodb_autoextend_increment |
innodb_buffer_pool_awe_mem_mb |
innodb_buffer_pool_size |
innodb_data_file_path |
innodb_data_home_dir |
innodb_fast_shutdown |
innodb_file_io_threads |
innodb_file_per_table |
innodb_flush_log_at_trx_commit |
innodb_flush_method |
innodb_force_recovery |
innodb_lock_wait_timeout |
innodb_locks_unsafe_for_binlog |
innodb_log_arch_dir |
innodb_log_archive |
innodb_log_buffer_size |
innodb_log_file_size |
innodb_log_files_in_group |
innodb_log_group_home_dir |
innodb_max_dirty_pages_pct |
innodb_max_purge_lag |
innodb_mirrored_log_groups |
innodb_open_file |
innodb_table_locks |
innodb_thread_concurrency |
insert_id |
interactive_timeout |
join_buffer_size |
key_buffer_size |
key_cache_age_threshold |
key_cache_block_size |
key_cache_division_limit |
language |
large_files_support |
last_insert_id |
lc_time_names |
license |
local_infile |
log |
log_bin |
log_error |
log_slave_updates |
log_slow_queries |
log_update |
log_warnings |
long_query_time |
low_priority_updates |
lower_case_file_system |
lower_case_table_names |
max_allowed_packet |
max_binlog_cache_size |
max_binlog_size |
max_connect_errors |
max_connections |
max_delayed_threads,max_error_count |
max_heap_table_size |
max_insert_delayed_threads |
max_join_size |
max_length_for_sort_data |
max_prepared_stmt_count |
max_relay_log_size |
max_seeks_for_key |
max_sort_length |
max_tmp_tables |
max_user_connections |
max_write_lock_count |
myisam_data_pointer_size |
myisam_max_extra_sort_file_size |
myisam_max_sort_file_size |
myisam_recover_option |
myisam_repair_threads |
myisam_sort_buffer_size |
myisam_stats_method |
named_pipe |
net_buffer_length |
net_read_timeout |
net_retry_count |
net_write_timeout |
new |
old_passwords |
open_files_limit |
pid_file |
port |
preload_buffer_size |
prepared_stmt_count |
protocol_version |
query_alloc_block_size |
query_cache_limit |
query_cache_min_res_unit |
query_cache_size |
query_cache_type |
query_cache_wlock_invalidate |
query_prealloc_size |
range_alloc_block_size |
read_buffer_size |
read_only |
read_rnd_buffer_size |
relay_log_purge |
relay_log_space_limit |
rpl_recovery_rank |
secure_auth |
shared_memory |
shared_memory_base_name |
server_id |
skip_external_locking |
skip_networking |
skip_show_database |
slave_net_timeout |
slave_transaction_retries |
slow_launch_time |
sort_buffer_size |
sql_auto_is_null |
sql_big_selects |
sql_buffer_result |
sql_log_bin |
sql_log_off |
sql_log_update |
sql_mode |
sql_notes |
sql_quote_show_create |
sql_safe_updates |
sql_select_limit |
sql_warnings |
storage_engine |
sync_binlog |
sync_frm |
sync_replication |
sync_replication_slave_id |
sync_replication_timeout |
system_time_zone |
table_cache |
table_type |
thread_cache_size |
thread_stack |
timestamp |
time_format |
time_zone |
tmp_table_size |
tmpdir |
transaction_alloc_block_size |
transaction_prealloc_size |
tx_isolation |
unique_checks |
version |
version_comment |
version_compile_machine |
version_compile_os |
wait_timeout |