Supported MySQL Server System Variables

From RapidSQL
Jump to: navigation, search

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