MySQL 3.23, 4.0, 4.1 Reference Manual :: 5 Database Administration :: 5.2 mysqld — The MySQL Server :: 5.2.1 Option and Variable Reference
Section Navigation [Toggle]
The following table provides a list of all the command line
options, server and status variables applicable within
mysqld.
The table lists command line options (Cmd-line), options valid in configuration files (Option file), server system variables (Server Var), and status variables (Status var) in one unified list, with notification of where each option/variable is valid. If a server option set on the command line or in an option file differs from the name of the corresponding server system or status variable, the variable name is noted immediately below the corresponding option. For status variables, the scope of the variable is shown (Scope) as either global, session, or both. Please see the corresponding sections for details on setting and using the options and variables. Where appropriate, a direct link to further information on the item as available.
Note
This table is part of an ongoing process to expand and simplify the information provided on these elements. Further improvements to the table, and corresponding descriptions will be applied over the coming months.
| Name | Cmd-line | Option file | Server Var | Status Var | Var Scope | Dynamic |
|---|---|---|---|---|---|---|
| abort-slave-event-count | Y | Y | no | |||
| allow-suspicious-udfs | Y | Y | no | |||
| ansi | Y | Y | ||||
| autocommit | Y | session | yes | |||
| back_log | Y | Y | Y | yes | ||
| basedir | Y | Y | Y | no | ||
| bdb | Y | Y | no | |||
| - Variable: have_bdb | Y | no | ||||
| bdb-home | Y | Y | no | |||
| - Variable: bdb_home | Y | no | ||||
| bdb-lock-detect | Y | Y | ||||
| bdb-logdir | Y | Y | no | |||
| - Variable: bdb_logdir | Y | no | ||||
| bdb-no-recover | Y | Y | ||||
| bdb-no-sync | Y | Y | ||||
| bdb-shared-data | Y | Y | no | |||
| - Variable: bdb_shared_data | Y | no | ||||
| bdb-tmpdir | Y | Y | no | |||
| - Variable: bdb_tmpdir | Y | no | ||||
| bdb_cache_size | Y | Y | Y | no | ||
| bdb_lock_max | Y | Y | Y | no | ||
| bdb_log_buffer_size | Y | Y | Y | no | ||
| bdb_max_lock | Y | Y | Y | no | ||
| big-tables | Y | Y | session | yes | ||
| - Variable: big_tables | Y | session | yes | |||
| bind-address | Y | Y | Y | no | ||
| binlog-do-db | Y | Y | ||||
| binlog-ignore-db | Y | Y | ||||
| binlog_cache_size | Y | Y | Y | global | yes | |
| bootstrap | Y | |||||
| bulk_insert_buffer_size | Y | Y | Y | both | yes | |
| character-set-client-handshake | Y | |||||
| character-set-server | Y | Y | yes | |||
| - Variable: character_set_server | Y | yes | ||||
| character-sets-dir | Y | Y | Y | no | ||
| character_set_client | Y | both | yes | |||
| character_set_connection | Y | both | yes | |||
| character_set_results | Y | both | yes | |||
| chroot | Y | Y | ||||
| collation-server | Y | Y | yes | |||
| - Variable: collation_server | Y | yes | ||||
| concurrent-insert | Y | Y | global | yes | ||
| - Variable: concurrent_insert | Y | global | yes | |||
| connect_timeout | Y | Y | Y | global | yes | |
| console | Y | Y | ||||
| core-file | Y | Y | ||||
| crash_binlog_innodb | Y | Y | ||||
| datadir | Y | Y | Y | no | ||
| date_format | Y | Y | yes | |||
| datetime_format | Y | Y | yes | |||
| debug | Y | Y | ||||
| default-character-set | Y | Y | Y | yes | ||
| default-collation | Y | Y | yes | |||
| default-storage-engine | Y | Y | ||||
| default-table-type | Y | Y | ||||
| default-time-zone | Y | Y | ||||
| default_week_format | Y | Y | Y | both | yes | |
| defaults-extra-file | Y | Y | ||||
| defaults-file | Y | Y | ||||
| delay-key-write | Y | Y | global | yes | ||
| - Variable: delay_key_write | Y | global | yes | |||
| delay-key-write-for-all-tables | Y | |||||
| delayed_insert_limit | Y | Y | Y | global | yes | |
| delayed_insert_timeout | Y | Y | Y | global | yes | |
| delayed_queue_size | Y | Y | Y | global | yes | |
| des-key-file | Y | Y | Y | no | ||
| disconnect-slave-event-count | Y | Y | ||||
| enable-locking | Y | |||||
| enable-pstack | Y | Y | ||||
| error_count | Y | session | yes | |||
| exit-info | Y | Y | ||||
| expire_logs_days | Y | Y | Y | global | yes | |
| external-locking | Y | Y | ||||
| flush | Y | Y | Y | global | yes | |
| flush_time | Y | Y | Y | global | yes | |
| foreign_key_checks | Y | session | yes | |||
| ft_boolean_syntax | Y | Y | Y | global | yes | |
| ft_max_word_len | Y | Y | Y | yes | ||
| ft_min_word_len | Y | Y | Y | yes | ||
| ft_query_expansion_limit | Y | Y | Y | yes | ||
| ft_stopword_file | Y | Y | Y | yes | ||
| gdb | Y | Y | ||||
| group_concat_max_len | Y | Y | Y | both | yes | |
| have_archive | Y | global | no | |||
| have_blackhole_engine | Y | global | no | |||
| have_compress | Y | global | no | |||
| have_crypt | Y | global | no | |||
| have_csv | Y | global | no | |||
| have_example_engine | Y | global | no | |||
| have_federated_engine | Y | global | no | |||
| have_geometry | Y | global | no | |||
| have_innodb | Y | global | no | |||
| have_ndbcluster | Y | global | no | |||
| have_openssl | Y | global | no | |||
| have_query_cache | Y | global | no | |||
| have_rtree_keys | Y | global | no | |||
| have_symlinks | Y | global | no | |||
| help | Y | |||||
| identity | Y | session | yes | |||
| init-connect | Y | Y | no | |||
| - Variable: init_connect | Y | no | ||||
| init-file | Y | Y | no | |||
| - Variable: init_file | Y | no | ||||
| init-rpl-role | Y | Y | ||||
| init-slave | Y | Y | no | |||
| - Variable: init_slave | Y | no | ||||
| innodb | Y | Y | ||||
| innodb_additional_mem_pool_size | Y | Y | Y | no | ||
| innodb_autoextend_increment | Y | Y | Y | global | yes | |
| innodb_buffer_pool_awe_mem_mb | Y | Y | Y | no | ||
| innodb_buffer_pool_size | Y | Y | Y | no | ||
| innodb_data_file_path | Y | Y | Y | no | ||
| innodb_data_home_dir | Y | Y | Y | no | ||
| innodb_fast_shutdown | Y | Y | Y | yes | ||
| innodb_file_io_threads | Y | Y | Y | yes | ||
| innodb_file_per_table | Y | Y | Y | yes | ||
| innodb_flush_log_at_trx_commit | Y | Y | Y | yes | ||
| innodb_flush_method | Y | Y | Y | yes | ||
| innodb_force_recovery | Y | Y | Y | yes | ||
| innodb_lock_wait_timeout | Y | Y | Y | both | yes | |
| innodb_locks_unsafe_for_binlog | Y | Y | Y | yes | ||
| innodb_log_arch_dir | Y | Y | Y | yes | ||
| innodb_log_archive | Y | Y | ||||
| innodb_log_buffer_size | Y | Y | Y | yes | ||
| innodb_log_file_size | Y | Y | Y | yes | ||
| innodb_log_files_in_group | Y | Y | Y | yes | ||
| innodb_log_group_home_dir | Y | Y | Y | yes | ||
| innodb_max_dirty_pages_pct | Y | Y | Y | global | yes | |
| innodb_max_purge_lag | Y | Y | Y | global | yes | |
| innodb_mirrored_log_groups | Y | Y | Y | yes | ||
| innodb_open_files | Y | Y | Y | yes | ||
| innodb_safe_binlog | Y | Y | Y | yes | ||
| innodb_status_file | Y | Y | Y | yes | ||
| innodb_table_locks | Y | Y | Y | both | yes | |
| innodb_thread_concurrency | Y | Y | Y | global | yes | |
| insert_id | Y | session | yes | |||
| interactive_timeout | Y | Y | Y | both | yes | |
| isam | Y | Y | Y | yes | ||
| join_buffer_size | Y | Y | Y | both | yes | |
| key_buffer_size | Y | Y | Y | global | yes | |
| key_cache_age_threshold | Y | Y | Y | yes | ||
| key_cache_block_size | Y | Y | Y | yes | ||
| key_cache_division_limit | Y | Y | Y | yes | ||
| language | Y | Y | Y | yes | ||
| last_insert_id | Y | session | yes | |||
| lc_time_names | Y | both | yes | |||
| license | Y | no | ||||
| local-infile | Y | Y | yes | |||
| - Variable: local_infile | Y | yes | ||||
| log | Y | Y | Y | yes | ||
| log-bin | Y | Y | Y | yes | ||
| log-bin-index | Y | Y | Y | yes | ||
| log-error | Y | Y | Y | yes | ||
| log-isam | Y | Y | Y | yes | ||
| log-long-format | Y | Y | ||||
| log-queries-not-using-indexes | Y | Y | yes | |||
| - Variable: log_queries_not_using_indexes | Y | yes | ||||
| log-short-format | Y | Y | Y | yes | ||
| log-slave-updates | Y | Y | Y | yes | ||
| log-slow-admin-statements | Y | Y | Y | yes | ||
| log-slow-queries | Y | Y | yes | |||
| - Variable: log_slow_queries | Y | yes | ||||
| log-update | Y | Y | yes | |||
| log-warnings | Y | Y | yes | |||
| - Variable: log_warnings | Y | yes | ||||
| long_query_time | Y | Y | Y | both | yes | |
| low-priority-updates | Y | Y | yes | |||
| - Variable: low_priority_updates | Y | yes | ||||
| lower_case_table_names | Y | Y | Y | yes | ||
| master-connect-retry | Y | Y | Y | yes | ||
| master-host | Y | Y | Y | yes | ||
| master-info-file | Y | Y | Y | yes | ||
| master-password | Y | Y | Y | yes | ||
| master-port | Y | Y | Y | yes | ||
| master-retry-count | Y | Y | Y | yes | ||
| master-ssl | Y | Y | Y | yes | ||
| master-ssl-ca | Y | Y | Y | yes | ||
| master-ssl-capath | Y | Y | Y | yes | ||
| master-ssl-cert | Y | Y | Y | yes | ||
| master-ssl-cipher | Y | Y | Y | yes | ||
| master-ssl-key | Y | Y | Y | yes | ||
| master-user | Y | Y | Y | yes | ||
| max-binlog-dump-events | Y | Y | Y | yes | ||
| max_allowed_packet | Y | Y | Y | both | yes | |
| max_binlog_cache_size | Y | Y | Y | global | yes | |
| max_binlog_size | Y | Y | Y | global | yes | |
| max_connect_errors | Y | Y | Y | global | yes | |
| max_connections | Y | Y | Y | global | yes | |
| max_delayed_threads | Y | Y | Y | global | yes | |
| max_error_count | Y | Y | Y | both | yes | |
| max_heap_table_size | Y | Y | Y | both | yes | |
| max_insert_delayed_threads | Y | global | yes | |||
| max_join_size | Y | Y | Y | both | yes | |
| max_length_for_sort_data | Y | Y | Y | yes | ||
| max_prepared_stmt_count | Y | Y | Y | global | yes | |
| max_relay_log_size | Y | Y | Y | global | yes | |
| max_seeks_for_key | Y | Y | Y | both | yes | |
| max_sort_length | Y | Y | Y | both | yes | |
| max_tmp_tables | Y | Y | Y | both | yes | |
| max_user_connections | Y | Y | Y | both | yes | |
| max_write_lock_count | Y | Y | Y | global | yes | |
| maximum-query_cache_size | Y | Y | no | |||
| memlock | Y | Y | yes | |||
| - Variable: locked_in_memory | Y | yes | ||||
| myisam-recover | Y | Y | Y | yes | ||
| myisam_block_size | Y | Y | Y | yes | ||
| myisam_data_pointer_size | Y | Y | Y | global | yes | |
| myisam_max_extra_sort_file_size | Y | Y | Y | yes | ||
| myisam_max_sort_file_size | Y | Y | Y | both | yes | |
| myisam_repair_threads | Y | Y | Y | both | yes | |
| myisam_sort_buffer_size | Y | Y | Y | both | yes | |
| myisam_stats_method | Y | Y | Y | both | yes | |
| named_pipe | Y | Y | ||||
| ndb-optimized-node-selection | Y | yes | ||||
| ndb_autoincrement_prefetch_sz | Y | Y | ||||
| ndb_extra_logging | Y | global | yes | |||
| ndb_force_send | Y | Y | Y | yes | ||
| ndb_index_stat_cache_entries | Y | Y | ||||
| ndb_index_stat_enable | Y | Y | ||||
| ndb_index_stat_update_freq | Y | Y | ||||
| ndb_report_thresh_binlog_epoch_slip | Y | Y | ||||
| ndb_report_thresh_binlog_mem_usage | Y | Y | ||||
| ndb_use_exact_count | Y | yes | ||||
| ndb_use_transactions | Y | Y | ||||
| ndbcluster | Y | Y | Y | yes | ||
| net_buffer_length | Y | Y | Y | both | yes | |
| net_read_timeout | Y | Y | Y | both | yes | |
| net_retry_count | Y | Y | Y | both | yes | |
| net_write_timeout | Y | Y | Y | both | yes | |
| new | Y | Y | Y | yes | ||
| no-defaults | Y | |||||
| old-passwords | Y | Y | yes | |||
| - Variable: old_passwords | Y | yes | ||||
| open_files_limit | Y | Y | Y | yes | ||
| pid-file | Y | Y | Y | yes | ||
| port | Y | Y | Y | yes | ||
| preload_buffer_size | Y | Y | Y | both | yes | |
| prepared_stmt_count | Y | Y | both | no | ||
| print-defaults | Y | |||||
| query_alloc_block_size | Y | Y | Y | both | yes | |
| query_cache_limit | Y | Y | Y | global | yes | |
| query_cache_min_res_unit | Y | Y | Y | yes | ||
| query_cache_size | Y | Y | Y | global | yes | |
| query_cache_type | Y | Y | Y | both | yes | |
| query_cache_wlock_invalidate | Y | Y | Y | both | yes | |
| query_prealloc_size | Y | Y | Y | both | yes | |
| range_alloc_block_size | Y | Y | Y | both | yes | |
| read_buffer_size | Y | Y | Y | both | yes | |
| read_only | Y | Y | Y | global | yes | |
| read_rnd_buffer_size | Y | Y | Y | both | yes | |
| record_buffer | Y | Y | Y | yes | ||
| relay-log | Y | Y | Y | yes | ||
| relay-log-index | Y | Y | Y | yes | ||
| relay-log-info-file | Y | Y | Y | yes | ||
| relay_log_purge | Y | Y | Y | yes | ||
| relay_log_space_limit | Y | Y | Y | yes | ||
| replicate-do-db | Y | Y | ||||
| replicate-do-table | Y | |||||
| replicate-ignore-db | Y | Y | ||||
| replicate-ignore-table | Y | Y | ||||
| replicate-rewrite-db | Y | Y | ||||
| replicate-same-server-id | Y | Y | Y | yes | ||
| replicate-wild-do-table | Y | Y | ||||
| replicate-wild-ignore-table | Y | Y | ||||
| report-host | Y | Y | Y | yes | ||
| report-password | Y | Y | Y | yes | ||
| report-port | Y | Y | Y | yes | ||
| report-user | Y | Y | Y | yes | ||
| rpl-recovery-rank | Y | Y | yes | |||
| - Variable: rpl_recovery_rank | Y | yes | ||||
| safe-mode | Y | Y | ||||
| safe-show-database | Y | Y | global | yes | ||
| - Variable: safe_show_database | Y | global | yes | |||
| safe-user-create | Y | Y | Y | yes | ||
| safemalloc-mem-limit | Y | Y | ||||
| secure-auth | Y | Y | yes | |||
| - Variable: secure_auth | Y | yes | ||||
| server-id | Y | Y | yes | |||
| - Variable: server_id | Y | yes | ||||
| set-variable | Y | Y | ||||
| shared_memory | Y | Y | ||||
| shared_memory_base_name | Y | Y | ||||
| show-slave-auth-info | Y | Y | Y | yes | ||
| shutdown_timeout | Y | Y | Y | both | yes | |
| skip-automatic-sp-privileges | Y | Y | ||||
| skip-bdb | Y | Y | no | |||
| - Variable: have_bdb | Y | no | ||||
| skip-character-set-client-handshake | Y | Y | ||||
| skip-concurrent-insert | Y | Y | global | yes | ||
| - Variable: concurrent_insert | Y | global | yes | |||
| skip-external-locking | Y | Y | ||||
| - Variable: external-locking | ||||||
| skip-grant-tables | Y | Y | Y | yes | ||
| skip-host-cache | Y | Y | ||||
| skip-innodb | Y | Y | ||||
| skip-innodb-checksums | Y | Y | ||||
| skip-locking | Y | Y | ||||
| skip-log-warnings | Y | Y | no | |||
| skip-name-resolve | Y | Y | ||||
| skip-networking | Y | Y | ||||
| skip-new | Y | Y | ||||
| skip-safe-malloc | Y | Y | ||||
| skip-show-database | Y | Y | ||||
| skip-slave-start | Y | Y | Y | yes | ||
| skip-ssl | Y | Y | ||||
| skip-stack-trace | Y | Y | ||||
| skip-symbolic-links | Y | |||||
| skip-symlink | Y | Y | ||||
| skip-sync-bdb-logs | Y | Y | ||||
| skip-thread-priority | Y | Y | ||||
| slave-load-tmpdir | Y | Y | Y | yes | ||
| slave-skip-errors | Y | Y | ||||
| slave_compressed_protocol | Y | Y | Y | global | yes | |
| slave_net_timeout | Y | Y | Y | global | yes | |
| slave_transaction_retries | Y | Y | Y | global | yes | |
| slow_launch_time | Y | Y | Y | global | yes | |
| socket | Y | Y | Y | yes | ||
| sort_buffer_size | Y | Y | Y | both | yes | |
| sporadic-binlog-dump-fail | Y | Y | Y | yes | ||
| sql-bin-update-same | Y | Y | Y | yes | ||
| sql-mode | Y | Y | yes | |||
| - Variable: sql_mode | Y | yes | ||||
| sql_auto_is_null | Y | session | yes | |||
| sql_big_selects | Y | session | yes | |||
| sql_big_tables | Y | session | yes | |||
| sql_buffer_result | Y | session | yes | |||
| sql_log_bin | Y | session | yes | |||
| sql_log_off | Y | session | yes | |||
| sql_log_update | Y | session | yes | |||
| sql_low_priority_updates | Y | both | yes | |||
| sql_max_join_size | Y | both | yes | |||
| sql_notes | Y | session | yes | |||
| sql_quote_show_create | Y | session | yes | |||
| sql_safe_updates | Y | session | yes | |||
| sql_select_limit | Y | session | yes | |||
| sql_slave_skip_counter | Y | global | yes | |||
| sql_warnings | Y | session | yes | |||
| ssl | Y | Y | Y | yes | ||
| ssl-ca | Y | Y | Y | yes | ||
| ssl-capath | Y | Y | Y | yes | ||
| ssl-cert | Y | Y | Y | yes | ||
| ssl-cipher | Y | Y | Y | yes | ||
| ssl-key | Y | Y | Y | yes | ||
| standalone | Y | Y | ||||
| storage_engine | Y | both | yes | |||
| symbolic-links | Y | Y | Y | yes | ||
| sync-bdb-logs | Y | Y | Y | yes | ||
| sync-binlog | Y | Y | yes | |||
| - Variable: sync_binlog | Y | yes | ||||
| sync-frm | Y | Y | yes | |||
| - Variable: sync_frm | Y | yes | ||||
| table_cache | Y | Y | Y | yes | ||
| table_type | Y | both | yes | |||
| temp-pool | Y | Y | Y | yes | ||
| thread_cache_size | Y | Y | Y | global | yes | |
| thread_concurrency | Y | Y | Y | yes | ||
| thread_stack | Y | Y | Y | yes | ||
| time_format | Y | Y | Y | yes | ||
| time_zone | Y | both | yes | |||
| timestamp | Y | session | yes | |||
| tmp_table_size | Y | Y | Y | both | yes | |
| tmpdir | Y | Y | Y | yes | ||
| transaction-isolation | Y | Y | ||||
| transaction_alloc_block_size | Y | Y | Y | both | yes | |
| transaction_prealloc_size | Y | Y | Y | both | yes | |
| tx_isolation | Y | both | yes | |||
| unique_checks | Y | session | yes | |||
| user | Y | Y | ||||
| verbose | Y | Y | Y | yes | ||
| version | Y | |||||
| version_comment | Y | no | ||||
| version_compile_machine | Y | no | ||||
| version_compile_os | Y | no | ||||
| warning_count | Y | session | yes | |||
| warnings | Y | Y |
User Comments
Add your own comment.