One command to view all MySQL configurations (original)

At the command prompt for MySQL, execute the following sentence:

mysql> show globalvariables

Get:

The text content of the above table:

"Variable_name" "Value" "Auto_increment_increment" "1" "Auto_increment_offset" "1" "Autocommit" "On" automatic_sp_ Privileges "On" "Back_log" "" "" "" Basedir "" C:\\Program Files (x86) \\MySQL\\MySQL Server 5.1\\ "" Big_tables "" OFF "Binlog _cache_size "" 32768 "" Binlog_direct_non_transactional_updates "" OFF "" Binlog_format "" STATEMENT "" Bulk_insert_buffer _size "8388608" "character_set_client" "UTF8" "character_set_connection" "UTF8" "character_set_database" "UTF8" " Character_set_filesystem "binary" "Character_set_results" "UTF8" "character_set_server" "UTF8" "character_set_ System "" UTF8 "" Character_sets_dir "" C:\\Program Files (x86) \\MySQL\\MySQL Server 5.1\\share\\charsets\\ "" Collation_ Connection "Utf8_general_ci" "Collation_database" "Utf8_general_ci" "Collation_server" "Utf8_general_ci" " Completion_type "" 0 "" Concurrent_insert "" 1 "" Connect_timeout "" Ten "" DataDir "" D:\\programdata\\mysql\\mysql Server 5.1 \\Data\\ "" Date_format ""%y-%m-%d "" Datetime_format ""%y-%m-%d%h:%i:%s "" Default_week_format "" 0 "" Delay_key_write "" On "" Delayed_insert_limIt "" "" Delayed_insert_timeout "" "" "" Delayed_queue_size "" "" "" "Div_precision_increment" "4" "Engine_condition_ Pushdown "On" "Error_count" "0" "Event_scheduler" "Off" "Expire_logs_days" "0" "Flush" "Off" "Flush_time" "1800" foreign _key_checks "On" "Ft_boolean_syntax" "+->< () ~*:" "" "&|" " Ft_max_word_len "" "" Ft_min_word_len "" 4 "" Ft_query_expansion_limit "" "" "Ft_stopword_file" "(built-in)" General_ Log "on" "General_log_file" "D:\\programdata\\mysql\\mysql Server 5.1\\data\\win-2736pk059n6.log" "Group_concat_max _len "102400" "Have_community_features" "Yes" "have_compress" "Yes" "Have_crypt" "NO" "have_csv" "Yes" have_dynamic_ Loading "yes" "have_geometry" "Yes" "Have_innodb" "Yes" "Have_ndbcluster" "NO" "Have_openssl" "DISABLED" "have_ Partitioning "yes" "Have_query_cache" "Yes" "Have_rtree_keys" "Yes" "Have_ssl" "DISABLED" "Have_symlink" "Yes" Hostname "WIN-2736PK059N6" "Identity" "0" "Ignore_builtin_innodb" "OFF" "Init_connect" "SET NAMES UTF8" "Init_file" "" " Init_slave "" "" Innodb_adaptive_hash_index "" On "" Innodb_additional_mem_pool_size "" 8388608 "" Innodb_autoextend_increment "" 8 "" Innodb_autoinc_lock_mode "" 1 "" Innodb_buffer_pool_size "" 378535936 "Innodb_checksums" "On" "Innodb_commit_concurrency" "0" "Innodb_concurrency_tickets" "" "Innodb_data_ File_path "Ibdata1:10m:autoextend" "Innodb_data_home_dir" "" "Innodb_doublewrite" "On" "Innodb_fast_shutdown" "1" Innodb_file_io_threads "" 4 "" Innodb_file_per_table "" OFF "" Innodb_flush_log_at_trx_commit "" 1 "" Innodb_flush_method " "" "" "Innodb_force_recovery" "0" "Innodb_lock_wait_timeout" "" "" Innodb_locks_unsafe_for_binlog "" OFF "Innodb_log_ Buffer_size "" 4194304 "" Innodb_log_file_size "" 76546048 "" Innodb_log_files_in_group "" 2 "" Innodb_log_group_home_dir " ". \ \" "Innodb_max_dirty_pages_pct" "" "" Innodb_max_purge_lag "" 0 "" innodb_mirrored_log_groups "" 1 "" Innodb_open_ Files "" "" Innodb_rollback_on_timeout "" OFF "" Innodb_stats_on_metadata "" On "" Innodb_support_xa "" On "innodb_sync_ Spin_loops "" "" "" Innodb_table_locks "" On "" Innodb_thread_concurrency "" 8 "" Innodb_thread_sleep_delay "" 10000 "" InnoDB _use_legacy_cardinality_algorIthm "On" "insert_id" "0" "Interactive_timeout" "288000" "Join_buffer_size" "131072" "Keep_files_on_create" "OFF" Key_ Buffer_size "195035136" "key_cache_age_threshold" "+" "key_cache_block_size" "1024x768" "Key_cache_division_limit" " "" "Language" "C:\\Program Files (x86) \\MySQL\\MySQL Server 5.1\\share\\english\\" "Large_files_support" "On" Large_ Page_size "" "0" "Large_pages" "OFF" "last_insert_id" "0" "Lc_time_names" "en_US" "License" "GPL" "Local_infile" "On" "Log" " On "" "Log_bin" "Off" "Log_bin_trust_function_creators" "Off" "Log_bin_trust_routine_creators" "Off" "Log_error" "D:\\ Programdata\\mysql\\mysql Server 5.1\\data\\win-2736pk059n6.err "" Log_output "" FILE "" log_queries_not_using_indexes "Off" "Log_slave_updates" "Off" "Log_slow_queries" "On" "Log_warnings" "1" "Long_query_time" "3.000000" low_priority_ Updates "OFF" "Lower_case_file_system" "On" "Lower_case_table_names" "1" "Max_allowed_packet" "524288000" "Max_binlog _cache_size "4294963200" "Max_binlog_size" "1073741824" "Max_connect_errors" "Ten" "Max_connections" "1510" "Max_ Delayed_threaDS "" "" Max_error_count "" "" "" "" "Max_heap_table_size" "16777216" "Max_insert_delayed_threads" "" "Max_join_size" " 18446744073709551615 "Max_length_for_sort_data" "1024x768" "Max_prepared_stmt_count" "16382" "Max_relay_log_size" "0" Max_seeks_for_key "4294967295" "Max_sort_length" "1024x768" "Max_sp_recursion_depth" "0" "max_tmp_tables" "+" "Max_user_ Connections "" 0 "" Max_write_lock_count "" 4294967295 "" Min_examined_row_limit "" 0 "" Multi_range_count "" "" "MYISAM_" Data_pointer_size "" 6 "" Myisam_max_sort_file_size "" 107374182400 "" Myisam_mmap_size "" 4294967295 "" Myisam_recover_ Options "" OFF "" Myisam_repair_threads "" 1 "" Myisam_sort_buffer_size "" 23068672 "" Myisam_stats_method "" Nulls_unequal " "Myisam_use_mmap" "Off" "Named_pipe" "Off" "Net_buffer_length" "16384" "Net_read_timeout" "" "" "Net_retry_count" "10" " Net_write_timeout "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" Old_alter_table "" "" Optimizer_prune_level "" 1 "" Optimizer_search_depth "" "" "" Optimizer_switch "" Index_merge=on,index_merge_union=on, Index_merge_sort_union=on,index_merge_intersection=on "" Pid_file "" D:\\programdata\\mysql\\mysql Server 5.1\\data\\win-2736pk059n6.pid "" Plugin_dir "" C:\\Program Files (x86) \\MySQL\\MySQL Server 5.1\\lib/plugin "" Port "" 3306 "" Preload_buffer_size "" 32768 " Profiling "" "OFF" "Profiling_history_size" "" "" "Protocol_version" "" "" pseudo_thread_id "" 0 "" Query_alloc_block_size " "8192" "Query_cache_limit" "1048576" "Query_cache_min_res_unit" "4096" "Query_cache_size" "127926272" "query_cache_ Type "on" "Query_cache_wlock_invalidate" "OFF" "Query_prealloc_size" "8192" "Rand_seed1" "" "Rand_seed2" "" Range_ Alloc_block_size "4096" "Read_buffer_size" "65536" "Read_Only" "OFF" "Read_rnd_buffer_size" "262144" "Relay_log" "" " Relay_log_index "" "Relay_log_info_file" "Relay-log.info" "Relay_log_purge" "On" "Relay_log_space_limit" "0" "Report_ Host "" "Report_password" "" "" Report_port "" 3306 "" Report_user "" "Rpl_recovery_rank" "0" "Secure_auth" "OFF" secure_ File_priv "" "" server_id "" 0 "" Shared_memory "" OFF "" Shared_memory_base_name "" MYSQL "" skip_external_locking "" on "Skip _name_resolve ""On" "skip_networking" "Off" "Skip_show_database" "Off" "Slave_compressed_protocol" "Off" "Slave_exec_mode" "STRICT" " Slave_load_tmpdir "" C:\\Windows\\Temp "" Slave_net_timeout "" 3600 "" Slave_skip_errors "" OFF "Slave_transaction_ Retries "" "" Slow_launch_time "" 2 "" Slow_query_log "" On "" Slow_query_log_file "" C:\\Program Files (x86) \\MySQL\\MySQL Server 5.1\\mysqllog/slowquery.log "" Socket "" MySQL "" Sort_buffer_size "" 262144 "" Sql_auto_is_null "" On "sql_big_ Selects "On" "Sql_big_tables" "Off" "Sql_buffer_result" "Off" "Sql_log_bin" "On" "Sql_log_off" "Off" "Sql_log_update" " On "" "Sql_low_priority_updates" "OFF" "Sql_max_join_size" "18446744073709551615" "Sql_mode" "Strict_trans_tables,no_ Auto_create_user,no_engine_substitution "Sql_notes" "On" "Sql_quote_show_create" "On" "Sql_safe_updates" "OFF" Sql_ Select_limit "18446744073709551615" "Sql_slave_skip_counter" "" "Sql_warnings" "OFF" "Ssl_ca" "" "Ssl_capath" "" Ssl_ Cert "" "" "Ssl_cipher" "" "" "Ssl_key" "" "Storage_engine" "InnoDB" "Sync_binlog" "0" "Sync_frm" "On" "System_time_zone" "" " Table_definition_cache"" "" "" "Table_lock_wait_timeout" "" "" "" Table_open_cache "" "" "" "Table_type" "InnoDB" "Thread_cache_size" "" "Thread_ Handling "" One-thread-per-connection "" Thread_stack "" 196608 "" Time_format ""%h:%i:%s "" Time_zone "" SYSTEM "" Timed_ Mutexes "" "OFF" "Timestamp" "1484874972" "Tmp_table_size" "23068672" "Tmpdir" "C:\\Windows\\Temp" "transaction_alloc_ Block_size "8192" "Transaction_prealloc_size" "4096" "Tx_isolation" "Repeatable-read" "Unique_checks" "on" updatable _views_with_limit "Yes" "Version" "5.1.53-community-log" "Version_comment" "MySQL Community Server (GPL)" "Version_ Compile_machine "" Ia32 "" Version_compile_os "" Win32 "" Wait_timeout "" 288000 "" Warning_count "" 1 "

If you need to find the value of a variable in a number of global variables, use the "like% required eigenvalues%" blur to find the global configuration that contains the eigenvalues after the command above.

For example:

1.mysql View the data store directory command for the database:

>mysql> show globalvariables like"%datadir%";

One command to view all MySQL configurations (original)