现在的位置: 首页 > 综合 > 正文

Mysql：命令选项、配置选项、（全局、会话）系统变量、状态变量：总揽

2013年05月14日 ⁄ 综合 ⁄ 共 7664字 ⁄ 字号 小 中 大 ⁄ 评论关闭

Server Option and Variable Reference

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 (System 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.

Table 5.1. mysqld Option/Variable Summary

Name Cmd-Line Option file System Var Status Var Var Scope Dynamic
abort-slave-event-count Yes Yes        
Aborted_clients       Yes Global No
Aborted_connects       Yes Global No
allow-suspicious-udfs Yes Yes        
ansi Yes Yes        
auto_increment_increment Yes Yes Yes   Both Yes
auto_increment_offset Yes Yes Yes   Both Yes
autocommit     Yes   Session Yes
automatic_sp_privileges     Yes   Global Yes
back_log Yes Yes Yes   Global No
basedir Yes Yes Yes   Global No
big-tables Yes Yes     Session Yes
- Variable: big_tables     Yes   Session Yes
bind-address Yes Yes        
Binlog_cache_disk_use       Yes Global No
binlog_cache_size Yes Yes Yes   Global Yes
Binlog_cache_use       Yes Global No
binlog-do-db Yes Yes        
binlog-format Yes Yes     Both Yes
- Variable: binlog_format     Yes   Both Yes
binlog-ignore-db Yes Yes        
binlog-row-event-max-size Yes Yes        
bootstrap Yes Yes        
bulk_insert_buffer_size Yes Yes Yes   Both Yes
Bytes_received       Yes Both No
Bytes_sent       Yes Both No
character_set_client     Yes   Both Yes
character-set-client-handshake Yes Yes        
character_set_connection     Yes   Both Yes
character_set_database[a]     Yes   Both Yes
character-set-filesystem Yes Yes     Both Yes
- Variable: character_set_filesystem     Yes   Both Yes
character_set_results     Yes   Both Yes
character-set-server Yes Yes     Both Yes
- Variable: character_set_server     Yes   Both Yes
character_set_system     Yes   Global No
character-sets-dir Yes Yes     Global No
- Variable: character_sets_dir     Yes   Global No
chroot Yes Yes        
collation_connection     Yes   Both Yes
collation_database[b]     Yes   Both Yes
collation-server Yes Yes     Both Yes
- Variable: collation_server     Yes   Both Yes
Com_admin_commands       Yes Both No
Com_alter_db       Yes Both No
Com_alter_event       Yes Both No
Com_alter_table       Yes Both No
Com_analyze       Yes Both No
Com_backup_table       Yes Both No
Com_begin       Yes Both No
Com_call_procedure       Yes Both No
Com_change_db       Yes Both No
Com_change_master       Yes Both No
Com_check       Yes Both No
Com_checksum       Yes Both No
Com_commit       Yes Both No
Com_create_db       Yes Both No
Com_create_event       Yes Both No
Com_create_function       Yes Both No
Com_create_index       Yes Both No
Com_create_table       Yes Both No
Com_create_user       Yes Both No
Com_dealloc_sql       Yes Both No
Com_delete       Yes Both No
Com_delete_multi       Yes Both No
Com_do       Yes Both No
Com_drop_db       Yes Both No
Com_drop_event       Yes Both No
Com_drop_function       Yes Both No
Com_drop_index       Yes Both No
Com_drop_table       Yes Both No
Com_drop_user       Yes Both No
Com_execute_sql       Yes Both No
Com_flush       Yes Both No
Com_grant       Yes Both No
Com_ha_close       Yes Both No
Com_ha_open       Yes Both No
Com_ha_read       Yes Both No
Com_help       Yes Both No
Com_insert       Yes Both No
Com_insert_select       Yes Both No
Com_kill       Yes Both No
Com_load       Yes Both No
Com_lock_tables       Yes Both No
Com_optimize       Yes Both No
Com_preload_keys       Yes Both No
Com_prepare_sql       Yes Both No
Com_purge       Yes Both No
Com_purge_before_date       Yes Both No
Com_rename_table       Yes Both No
Com_repair       Yes Both No
Com_replace       Yes Both No
Com_replace_select       Yes Both No
Com_reset       Yes Both No
Com_restore_table       Yes Both No
Com_revoke       Yes Both No
Com_revoke_all       Yes Both No
Com_rollback       Yes Both No
Com_savepoint       Yes Both No
Com_select       Yes Both No
Com_set_option       Yes Both No
Com_show_binlog_events       Yes Both No
Com_show_binlogs       Yes Both No
Com_show_charsets       Yes Both No
Com_show_collations       Yes Both No
Com_show_column_types       Yes Both No
Com_show_create_db       Yes Both No
Com_show_create_event       Yes Both No
Com_show_create_table       Yes Both No
Com_show_databases       Yes Both No
Com_show_engine_logs       Yes Both No
Com_show_engine_mutex       Yes Both No
Com_show_engine_status       Yes Both No
Com_show_errors       Yes Both No
Com_show_events       Yes Both No
Com_show_fields       Yes Both No
Com_show_grants       Yes Both No
Com_show_innodb_status       Yes Both No
Com_show_keys       Yes Both No
Com_show_logs       Yes Both No
Com_show_master_status       Yes Both No
Com_show_ndb_status       Yes Both No
Com_show_new_master       Yes Both No
Com_show_open_tables       Yes Both No
Com_show_plugins       Yes Both No
Com_show_privileges       Yes Both No
Com_show_processlist       Yes Both No
Com_show_profile       Yes Both No
Com_show_profiles       Yes Both No
Com_show_slave_hosts       Yes Both No
Com_show_slave_status       Yes Both No
Com_show_status       Yes Both No
Com_show_storage_engines       Yes Both No
Com_show_tables       Yes Both No
Com_show_triggers       Yes Both No
Com_show_variables       Yes Both No
Com_show_warnings       Yes Both No
Com_slave_start       Yes Both No
Com_slave_stop       Yes Both No
Com_stmt_close       Yes Both No
Com_stmt_execute       Yes Both No
Com_stmt_fetch       Yes Both No
Com_stmt_prepare       Yes Both No
Com_stmt_reprepare       Yes Both No
Com_stmt_reset       Yes Both No
Com_stmt_send_long_data       Yes Both No
Com_truncate       Yes Both No
Com_unlock_tables       Yes Both No
Com_update       Yes Both No
Com_update_multi       Yes Both No
Com_xa_commit       Yes Both No
Com_xa_end       Yes Both No
Com_xa_prepare       Yes Both No
Com_xa_recover       Yes Both No
Com_xa_rollback       Yes Both No
Com_xa_start       Yes Both No
completion_type Yes Yes Yes   Both Yes
Compression       Yes Session No
concurrent_insert Yes Yes Yes   Global Yes
connect_timeout Yes Yes Yes   Global Yes
Connections       Yes Global No
console Yes Yes        
core-file Yes Yes        
Created_tmp_disk_tables       Yes Both No
Created_tmp_files       Yes Global No
Created_tmp_tables       Yes Both No
datadir Yes Yes Yes   Global No
date_format     Yes   Both Yes
datetime_format Yes Yes Yes   Both Yes
debug Yes Yes Yes   Both Yes
default-storage-engine Yes Yes        
default-table-type Yes Yes        
default-time-zone Yes Yes        
default_week_format Yes Yes Yes   Both Yes
defaults-extra-file Yes          
defaults-file Yes          
defaults-group-suffix Yes          
delay-key-write Yes Yes     Global Yes
- Variable: delay_key_write     Yes   Global Yes
Delayed_errors       Yes Global No
delayed_insert_limit Yes Yes Yes   Global Yes
Delayed_insert_threads       Yes Global No
delayed_insert_timeout Yes Yes Yes   Global Yes
delayed_queue_size Yes Yes Yes   Global Yes
Delayed_writes       Yes Global No
des-key-file Yes Yes        
disconnect-slave-event-count Yes Yes        
div_precision_increment Yes Yes Yes   Both Yes
enable-locking Yes Yes        
enable-named-pipe Yes Yes        
enable-pstack Yes Yes        
engine-condition-pushdown Yes Yes     Both Yes
- Variable: engine_condition_pushdown     Yes   Both Yes
error_count     Yes   Session No
event-scheduler Yes Yes     Global Yes
- Variable: event_scheduler     Yes   Global Yes
exit-info Yes Yes        
expire_logs_days Yes Yes Yes   Global Yes
external-locking Yes Yes        
- Variable: skip_external_locking            
flush Yes Yes Yes   Global Yes
Flush_commands       Yes Global No
flush_time Yes Yes Yes   Global Yes
foreign_key_checks     Yes   Session Yes
ft_boolean_syntax Yes Yes Yes   Global Yes
ft_max_word_len Yes Yes Yes   Global No
ft_min_word_len Yes Yes Yes   Global No
ft_query_expansion_limit Yes Yes Yes   Global No
ft_stopword_file Yes Yes Yes   Global No
gdb Yes Yes        
general-log Yes Yes     Global Yes
- Variable: general_log     Yes   Global Yes
general_log_file Yes Yes Yes   Global Yes
group_concat_max_len Yes Yes Yes   Both Yes
Handler_commit       Yes Both No
Handler_delete       Yes Both No
Handler_discover       Yes Both No
Handler_prepare       Yes Both No
Handler_read_first       Yes Both No
Handler_read_key       Yes Both No
Handler_read_next       Yes Both No
Handler_read_prev       Yes Both No
Handler_read_rnd       Yes Both No
Handler_read_rnd_next       Yes Both No
Handler_rollback       Yes Both No
Handler_savepoint       Yes Both No
Handler_savepoint_rollback       Yes Both No
Handler_update       Yes Both No
Handler_write       Yes Both No
have_archive     Yes   Global No
have_blackhole_engine     Yes   Global No
have_compress     Yes   Global No
have_crypt     Yes   Global No
have_csv     Yes   Global No
have_dynamic_loading
返回
【上篇】
【下篇】

作者:

抱歉!评论已关闭.

返回首页

Copyright © 2013-2018 学步园  保留所有权利.
软文销售 QQ客服：2265327166 点击这里给我发消息（其他合作也可洽谈）