Server Option, System Variable, and Status Variable Reference Name Cmd-Line Option File System Var Status Var Var Scope Dynamic have_profiling Yes Global No have_query_cache Yes Global No have_rtree_keys Yes Global No have_ssl Yes Global No have_statement_timeout Yes Global No have_symlink Yes Global No help Yes Yes histogram_generation_max_mem_size Yes Yes Yes Both Yes host_cache_size Yes Yes Yes Global Yes hostname Yes Global No identity Yes Session Yes immediate_server_version Yes Session Yes information_schema_stats_expiry Yes Yes Yes Both Yes init_connect Yes Yes Yes Global Yes init_file Yes Yes Yes Global No init_slave Yes Yes Yes Global Yes initialize Yes Yes initialize- insecure Yes Yes innodb Yes Yes innodb_adaptive_flushing Yes Yes Yes Global Yes innodb_adaptive_flushing_lwm Yes Yes Yes Global Yes innodb_adaptive_hash_index Yes Yes Yes Global Yes innodb_adaptive_hash_index_parts Yes Yes Yes Global No innodb_adaptive_max_sleep_delay Yes Yes Yes Global Yes innodb_api_bk_commit_interval Yes Yes Yes Global Yes innodb_api_disable_rowlock Yes Yes Yes Global No innodb_api_enable_binlog Yes Yes Yes Global No innodb_api_enable_mdl Yes Yes Yes Global No innodb_api_trx_level Yes Yes Yes Global Yes innodb_autoextend_increment Yes Yes Yes Global Yes innodb_autoinc_lock_mode Yes Yes Yes Global No innodb_background_drop_list_empty Yes Yes Yes Global Yes Innodb_buffer_pool_bytes_data Yes Global No Innodb_buffer_pool_bytes_dirty Yes Global No innodb_buffer_pool_chunk_size Yes Yes Yes Global No innodb_buffer_pool_debug Yes Yes Yes Global No innodb_buffer_pool_dump_at_shutdown Yes Yes Yes Global Yes 656