|
Here we go.
SHOW TABLE STATUS LIKE 'state':
'Name','Engine','Version','Row_format','Rows','Avg_row_length','Data_length','Max_data_length','Index_length','Data_free','Auto_increment','Create_time','Update_time','Check_time','Collation','Checksum','Create_options','Comment'
|
'state','InnoDB','10','Compact','97584790','222','21688745984','0','40238940160','2354053120','116466657','2014-11-05 15:47:10',\N,\N,'utf8_general_ci',\N,'','',
|
SHOW INDEX IN state
'Table','Non_unique','Key_name','Seq_in_index','Column_name','Collation','Cardinality','Sub_part','Packed','Null','Index_type','Comment','Index_comment'
|
'state','0','PRIMARY','1','id','A','97584986',\N,\N,'','BTREE','',''
|
'state','1','JobNumber','1','jobnr','A','1626416',\N,\N,'YES','BTREE','',''
|
'state','1','JobNumber','2','timestamp','A','97584986',\N,\N,'YES','BTREE','',''
|
'state','1','timestamp','1','timestamp','A','97584986',\N,\N,'YES','BTREE','',''
|
'state','1','station','1','station','A','30562',\N,\N,'YES','BTREE','',''
|
'state','1','station','2','timestamp','A','97584986',\N,\N,'YES','BTREE','',''
|
'state','1','techid','1','techid','A','8132082',\N,\N,'YES','BTREE','',''
|
'state','1','techid','2','timestamp','A','97584986',\N,\N,'YES','BTREE','',''
|
'state','1','iStatus','1','status','A','52948',\N,\N,'YES','BTREE','',''
|
'state','1','iStatus','2','timestamp','A','97584986',\N,\N,'YES','BTREE','',''
|
'state','1','iStatusNext','1','status','A','35995',\N,\N,'YES','BTREE','',''
|
'state','1','iStatusNext','2','nextstatus','A','91801',\N,\N,'YES','BTREE','',''
|
'state','1','iStatusNext','3','timestamp','A','97584986',\N,\N,'YES','BTREE','',''
|
'state','1','iNextStatus','1','nextstatus','A','36535',\N,\N,'YES','BTREE','',''
|
'state','1','iNextStatus','2','status','A','107236',\N,\N,'YES','BTREE','',''
|
'state','1','iNextStatus','3','nexttimestamp','A','97584986',\N,\N,'YES','BTREE','',''
|
'state','1','info1','1','info1','A','3614258','20',\N,'YES','BTREE','',''
|
'state','1','info1','2','timestamp','A','97584986',\N,\N,'YES','BTREE','',''
|
'state','1','info2','1','info2','A','2033020','20',\N,'YES','BTREE','',''
|
'state','1','info2','2','timestamp','A','97584986',\N,\N,'YES','BTREE','',''
|
'state','1','info3','1','info3','A','33696','20',\N,'YES','BTREE','',''
|
'state','1','info3','2','timestamp','A','97584986',\N,\N,'YES','BTREE','',''
|
'state','1','info4','1','info4','A','2','20',\N,'YES','BTREE','',''
|
'state','1','info4','2','timestamp','A','97584986',\N,\N,'YES','BTREE','',''
|
'state','1','info5','1','info5','A','1148','20',\N,'YES','BTREE','',''
|
'state','1','info5','2','timestamp','A','97584986',\N,\N,'YES','BTREE','',''
|
'state','1','iOrderid','1','ordernr','A','1394071',\N,\N,'YES','BTREE','',''
|
'state','1','iOrderid','2','timestamp','A','97584986',\N,\N,'YES','BTREE','',''
|
SHOW VARIABLES
'Variable_name','Value'
|
'aria_block_size','8192'
|
'aria_checkpoint_interval','30'
|
'aria_checkpoint_log_activity','1048576'
|
'aria_force_start_after_recovery_failures','0'
|
'aria_group_commit','none'
|
'aria_group_commit_interval','0'
|
'aria_log_file_size','1073741824'
|
'aria_log_purge_type','immediate'
|
'aria_max_sort_file_size','9223372036853727232'
|
'aria_page_checksum','ON'
|
'aria_pagecache_age_threshold','300'
|
'aria_pagecache_buffer_size','134217728'
|
'aria_pagecache_division_limit','100'
|
'aria_pagecache_file_hash_size','512'
|
'aria_recover','NORMAL'
|
'aria_repair_threads','1'
|
'aria_sort_buffer_size','268434432'
|
'aria_stats_method','nulls_unequal'
|
'aria_sync_log_dir','NEWFILE'
|
'aria_used_for_temp_tables','ON'
|
'auto_increment_increment','1'
|
'auto_increment_offset','1'
|
'autocommit','ON'
|
'automatic_sp_privileges','ON'
|
'back_log','150'
|
'basedir','/usr'
|
'big_tables','ON'
|
'binlog_annotate_row_events','OFF'
|
'binlog_cache_size','32768'
|
'binlog_checksum','NONE'
|
'binlog_commit_wait_count','0'
|
'binlog_commit_wait_usec','100000'
|
'binlog_direct_non_transactional_updates','OFF'
|
'binlog_format','MIXED'
|
'binlog_optimize_thread_scheduling','ON'
|
'binlog_stmt_cache_size','32768'
|
'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','/usr/share/mysql/charsets/'
|
'collation_connection','utf8_general_ci'
|
'collation_database','utf8_general_ci'
|
'collation_server','utf8_unicode_ci'
|
'completion_type','NO_CHAIN'
|
'concurrent_insert','AUTO'
|
'connect_timeout','10'
|
'datadir','/var/lib/mysql/'
|
'date_format','%Y-%m-%d'
|
'datetime_format','%Y-%m-%d %H:%i:%s'
|
'deadlock_search_depth_long','15'
|
'deadlock_search_depth_short','4'
|
'deadlock_timeout_long','50000000'
|
'deadlock_timeout_short','10000'
|
'debug_no_thread_alarm','OFF'
|
'default_master_connection',''
|
'default_regex_flags',''
|
'default_storage_engine','InnoDB'
|
'default_week_format','0'
|
'delay_key_write','ON'
|
'delayed_insert_limit','100'
|
'delayed_insert_timeout','300'
|
'delayed_queue_size','1000'
|
'div_precision_increment','4'
|
'error_count','0'
|
'event_scheduler','OFF'
|
'expensive_subquery_limit','100'
|
'expire_logs_days','5'
|
'external_user',''
|
'extra_max_connections','1'
|
'extra_port','0'
|
'flush','OFF'
|
'flush_time','0'
|
'foreign_key_checks','ON'
|
'ft_boolean_syntax','+ -><()~*:""&|'
|
'ft_max_word_len','84'
|
'ft_min_word_len','4'
|
'ft_query_expansion_limit','20'
|
'ft_stopword_file','(built-in)'
|
'general_log','OFF'
|
'general_log_file','OptoSQL3.log'
|
'group_concat_max_len','1024'
|
'gtid_binlog_pos','0-3-86688840'
|
'gtid_binlog_state','0-4-81723160,0-3-86688840'
|
'gtid_current_pos','0-3-86688840'
|
'gtid_domain_id','0'
|
'gtid_ignore_duplicates','OFF'
|
'gtid_seq_no','0'
|
'gtid_slave_pos','0-3-86688840'
|
'gtid_strict_mode','OFF'
|
'have_compress','YES'
|
'have_crypt','YES'
|
'have_dynamic_loading','YES'
|
'have_geometry','YES'
|
'have_openssl','YES'
|
'have_profiling','YES'
|
'have_query_cache','YES'
|
'have_rtree_keys','YES'
|
'have_ssl','DISABLED'
|
'have_symlink','DISABLED'
|
'histogram_size','0'
|
'histogram_type','SINGLE_PREC_HB'
|
'host_cache_size','128'
|
'hostname','OptoSQL3'
|
'identity','0'
|
'ignore_builtin_innodb','OFF'
|
'ignore_db_dirs',''
|
'in_transaction','0'
|
'init_connect',''
|
'init_file',''
|
'init_slave',''
|
'innodb_adaptive_flushing','ON'
|
'innodb_adaptive_flushing_lwm','10'
|
'innodb_adaptive_hash_index','ON'
|
'innodb_adaptive_hash_index_partitions','1'
|
'innodb_adaptive_max_sleep_delay','150000'
|
'innodb_additional_mem_pool_size','8388608'
|
'innodb_api_bk_commit_interval','5'
|
'innodb_api_disable_rowlock','OFF'
|
'innodb_api_enable_binlog','OFF'
|
'innodb_api_enable_mdl','OFF'
|
'innodb_api_trx_level','0'
|
'innodb_autoextend_increment','64'
|
'innodb_autoinc_lock_mode','1'
|
'innodb_buffer_pool_dump_at_shutdown','OFF'
|
'innodb_buffer_pool_dump_now','OFF'
|
'innodb_buffer_pool_filename','ib_buffer_pool'
|
'innodb_buffer_pool_instances','8'
|
'innodb_buffer_pool_load_abort','OFF'
|
'innodb_buffer_pool_load_at_startup','OFF'
|
'innodb_buffer_pool_load_now','OFF'
|
'innodb_buffer_pool_populate','OFF'
|
'innodb_buffer_pool_size','8589934592'
|
'innodb_change_buffer_max_size','25'
|
'innodb_change_buffering','all'
|
'innodb_checksum_algorithm','innodb'
|
'innodb_checksums','ON'
|
'innodb_cleaner_lsn_age_factor','high_checkpoint'
|
'innodb_cmp_per_index_enabled','OFF'
|
'innodb_commit_concurrency','0'
|
'innodb_compression_failure_threshold_pct','5'
|
'innodb_compression_level','6'
|
'innodb_compression_pad_pct_max','50'
|
'innodb_concurrency_tickets','5000'
|
'innodb_corrupt_table_action','assert'
|
'innodb_data_file_path','ibdata1:12M:autoextend'
|
'innodb_data_home_dir',''
|
'innodb_disable_sort_file_cache','OFF'
|
'innodb_doublewrite','ON'
|
'innodb_empty_free_list_algorithm','backoff'
|
'innodb_fake_changes','OFF'
|
'innodb_fast_shutdown','1'
|
'innodb_file_format','Antelope'
|
'innodb_file_format_check','ON'
|
'innodb_file_format_max','Antelope'
|
'innodb_file_per_table','ON'
|
'innodb_flush_log_at_timeout','1'
|
'innodb_flush_log_at_trx_commit','1'
|
'innodb_flush_method',''
|
'innodb_flush_neighbors','1'
|
'innodb_flushing_avg_loops','30'
|
'innodb_force_load_corrupted','OFF'
|
'innodb_force_recovery','0'
|
'innodb_foreground_preflush','exponential_backoff'
|
'innodb_ft_aux_table',''
|
'innodb_ft_cache_size','8000000'
|
'innodb_ft_enable_diag_print','OFF'
|
'innodb_ft_enable_stopword','ON'
|
'innodb_ft_max_token_size','84'
|
'innodb_ft_min_token_size','3'
|
'innodb_ft_num_word_optimize','2000'
|
'innodb_ft_result_cache_limit','2000000000'
|
'innodb_ft_server_stopword_table',''
|
'innodb_ft_sort_pll_degree','2'
|
'innodb_ft_total_cache_size','640000000'
|
'innodb_ft_user_stopword_table',''
|
'innodb_io_capacity','200'
|
'innodb_io_capacity_max','2000'
|
'innodb_kill_idle_transaction','0'
|
'innodb_large_prefix','OFF'
|
'innodb_lock_wait_timeout','50'
|
'innodb_locking_fake_changes','ON'
|
'innodb_locks_unsafe_for_binlog','OFF'
|
'innodb_log_arch_dir','./'
|
'innodb_log_arch_expire_sec','0'
|
'innodb_log_archive','OFF'
|
'innodb_log_block_size','512'
|
'innodb_log_buffer_size','8388608'
|
'innodb_log_checksum_algorithm','innodb'
|
'innodb_log_compressed_pages','ON'
|
'innodb_log_file_size','104857600'
|
'innodb_log_files_in_group','2'
|
'innodb_log_group_home_dir','./'
|
'innodb_lru_scan_depth','1024'
|
'innodb_max_bitmap_file_size','104857600'
|
'innodb_max_changed_pages','1000000'
|
'innodb_max_dirty_pages_pct','75'
|
'innodb_max_dirty_pages_pct_lwm','0'
|
'innodb_max_purge_lag','0'
|
'innodb_max_purge_lag_delay','0'
|
'innodb_mirrored_log_groups','1'
|
'innodb_monitor_disable',''
|
'innodb_monitor_enable',''
|
'innodb_monitor_reset',''
|
'innodb_monitor_reset_all',''
|
'innodb_old_blocks_pct','37'
|
'innodb_old_blocks_time','1000'
|
'innodb_online_alter_log_max_size','134217728'
|
'innodb_open_files','512'
|
'innodb_optimize_fulltext_only','OFF'
|
'innodb_page_size','16384'
|
'innodb_print_all_deadlocks','OFF'
|
'innodb_purge_batch_size','300'
|
'innodb_purge_threads','1'
|
'innodb_random_read_ahead','OFF'
|
'innodb_read_ahead_threshold','56'
|
'innodb_read_io_threads','4'
|
'innodb_read_only','OFF'
|
'innodb_replication_delay','0'
|
'innodb_rollback_on_timeout','OFF'
|
'innodb_rollback_segments','128'
|
'innodb_sched_priority_cleaner','19'
|
'innodb_show_locks_held','10'
|
'innodb_show_verbose_locks','0'
|
'innodb_simulate_comp_failures','0'
|
'innodb_sort_buffer_size','1048576'
|
'innodb_spin_wait_delay','6'
|
'innodb_stats_auto_recalc','ON'
|
'innodb_stats_method','nulls_equal'
|
'innodb_stats_on_metadata','OFF'
|
'innodb_stats_persistent','ON'
|
'innodb_stats_persistent_sample_pages','20'
|
'innodb_stats_sample_pages','8'
|
'innodb_stats_transient_sample_pages','8'
|
'innodb_status_output','OFF'
|
'innodb_status_output_locks','OFF'
|
'innodb_strict_mode','OFF'
|
'innodb_support_xa','ON'
|
'innodb_sync_array_size','1'
|
'innodb_sync_spin_loops','30'
|
'innodb_table_locks','ON'
|
'innodb_thread_concurrency','0'
|
'innodb_thread_sleep_delay','10000'
|
'innodb_track_changed_pages','OFF'
|
'innodb_undo_directory','.'
|
'innodb_undo_logs','128'
|
'innodb_undo_tablespaces','0'
|
'innodb_use_atomic_writes','OFF'
|
'innodb_use_fallocate','OFF'
|
'innodb_use_global_flush_log_at_trx_commit','ON'
|
'innodb_use_native_aio','ON'
|
'innodb_use_stacktrace','OFF'
|
'innodb_use_sys_malloc','ON'
|
'innodb_version','5.6.20-68.0'
|
'innodb_write_io_threads','4'
|
'insert_id','0'
|
'interactive_timeout','28800'
|
'join_buffer_size','131072'
|
'join_buffer_space_limit','2097152'
|
'join_cache_level','2'
|
'keep_files_on_create','OFF'
|
'key_buffer_size','134217728'
|
'key_cache_age_threshold','300'
|
'key_cache_block_size','1024'
|
'key_cache_division_limit','100'
|
'key_cache_file_hash_size','512'
|
'key_cache_segments','0'
|
'large_files_support','ON'
|
'large_page_size','0'
|
'large_pages','OFF'
|
'last_gtid',''
|
'last_insert_id','0'
|
'lc_messages','en_US'
|
'lc_messages_dir',''
|
'lc_time_names','en_US'
|
'license','GPL'
|
'local_infile','ON'
|
'lock_wait_timeout','31536000'
|
'locked_in_memory','OFF'
|
'log_bin','ON'
|
'log_bin_trust_function_creators','OFF'
|
'log_error','/var/log/mysqld.log'
|
'log_output','FILE'
|
'log_queries_not_using_indexes','OFF'
|
'log_slave_updates','ON'
|
'log_slow_filter','admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk'
|
'log_slow_rate_limit','1'
|
'log_slow_verbosity',''
|
'log_warnings','1'
|
'long_query_time','10.000000'
|
'low_priority_updates','OFF'
|
'lower_case_file_system','OFF'
|
'lower_case_table_names','1'
|
'master_verify_checksum','OFF'
|
'max_allowed_packet','33554432'
|
'max_binlog_cache_size','18446744073709547520'
|
'max_binlog_size','1073741824'
|
'max_binlog_stmt_cache_size','18446744073709547520'
|
'max_connect_errors','100'
|
'max_connections','500'
|
'max_delayed_threads','20'
|
'max_error_count','64'
|
'max_heap_table_size','67108864'
|
'max_insert_delayed_threads','20'
|
'max_join_size','18446744073709551615'
|
'max_length_for_sort_data','1024'
|
'max_long_data_size','33554432'
|
'max_prepared_stmt_count','16382'
|
'max_relay_log_size','1073741824'
|
'max_seeks_for_key','4294967295'
|
'max_sort_length','1024'
|
'max_sp_recursion_depth','0'
|
'max_tmp_tables','32'
|
'max_user_connections','0'
|
'max_write_lock_count','4294967295'
|
'metadata_locks_cache_size','1024'
|
'metadata_locks_hash_instances','8'
|
'min_examined_row_limit','0'
|
'mrr_buffer_size','262144'
|
'multi_range_count','256'
|
'myisam_block_size','1024'
|
'myisam_data_pointer_size','6'
|
'myisam_max_sort_file_size','9223372036853727232'
|
'myisam_mmap_size','18446744073709551615'
|
'myisam_recover_options','DEFAULT'
|
'myisam_repair_threads','1'
|
'myisam_sort_buffer_size','134216704'
|
'myisam_stats_method','nulls_unequal'
|
'myisam_use_mmap','OFF'
|
'net_buffer_length','16384'
|
'net_read_timeout','30'
|
'net_retry_count','10'
|
'net_write_timeout','60'
|
'old','OFF'
|
'old_alter_table','OFF'
|
'old_mode',''
|
'old_passwords','OFF'
|
'open_files_limit','2505'
|
'optimizer_prune_level','1'
|
'optimizer_search_depth','62'
|
'optimizer_selectivity_sampling_limit','100'
|
'optimizer_switch','index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on'
|
'optimizer_use_condition_selectivity','1'
|
'performance_schema','ON'
|
'performance_schema_accounts_size','100'
|
'performance_schema_digests_size','10000'
|
'performance_schema_events_stages_history_long_size','10000'
|
'performance_schema_events_stages_history_size','10'
|
'performance_schema_events_statements_history_long_size','10000'
|
'performance_schema_events_statements_history_size','10'
|
'performance_schema_events_waits_history_long_size','10000'
|
'performance_schema_events_waits_history_size','10'
|
'performance_schema_hosts_size','100'
|
'performance_schema_max_cond_classes','80'
|
'performance_schema_max_cond_instances','2900'
|
'performance_schema_max_file_classes','50'
|
'performance_schema_max_file_handles','32768'
|
'performance_schema_max_file_instances','2154'
|
'performance_schema_max_mutex_classes','200'
|
'performance_schema_max_mutex_instances','8000'
|
'performance_schema_max_rwlock_classes','40'
|
'performance_schema_max_rwlock_instances','3800'
|
'performance_schema_max_socket_classes','10'
|
'performance_schema_max_socket_instances','1020'
|
'performance_schema_max_stage_classes','150'
|
'performance_schema_max_statement_classes','180'
|
'performance_schema_max_table_handles','800'
|
'performance_schema_max_table_instances','12500'
|
'performance_schema_max_thread_classes','50'
|
'performance_schema_max_thread_instances','1100'
|
'performance_schema_session_connect_attrs_size','512'
|
'performance_schema_setup_actors_size','100'
|
'performance_schema_setup_objects_size','100'
|
'performance_schema_users_size','100'
|
'pid_file','/var/lib/mysql/OptoSQL3.pid'
|
'plugin_dir','/usr/lib64/mysql/plugin/'
|
'plugin_maturity','unknown'
|
'port','3306'
|
'preload_buffer_size','32768'
|
'profiling','OFF'
|
'profiling_history_size','15'
|
'progress_report_time','5'
|
'protocol_version','10'
|
'proxy_user',''
|
'pseudo_slave_mode','OFF'
|
'pseudo_thread_id','10793'
|
'query_alloc_block_size','8192'
|
'query_cache_limit','1048576'
|
'query_cache_min_res_unit','4096'
|
'query_cache_size','67108864'
|
'query_cache_strip_comments','OFF'
|
'query_cache_type','ON'
|
'query_cache_wlock_invalidate','OFF'
|
'query_prealloc_size','8192'
|
'rand_seed1','0'
|
'rand_seed2','0'
|
'range_alloc_block_size','4096'
|
'read_buffer_size','131072'
|
'read_only','ON'
|
'read_rnd_buffer_size','262144'
|
'relay_log',''
|
'relay_log_index',''
|
'relay_log_info_file','relay-log.info'
|
'relay_log_purge','ON'
|
'relay_log_recovery','OFF'
|
'relay_log_space_limit','0'
|
'replicate_annotate_row_events','OFF'
|
'replicate_do_db',''
|
'replicate_do_table',''
|
'replicate_events_marked_for_skip','replicate'
|
'replicate_ignore_db',''
|
'replicate_ignore_table',''
|
'replicate_wild_do_table',''
|
'replicate_wild_ignore_table',''
|
'report_host',''
|
'report_password',''
|
'report_port','3306'
|
'report_user',''
|
'rowid_merge_buff_size','8388608'
|
'rpl_recovery_rank','0'
|
'secure_auth','OFF'
|
'secure_file_priv',''
|
'server_id','4'
|
'skip_external_locking','ON'
|
'skip_name_resolve','ON'
|
'skip_networking','OFF'
|
'skip_replication','OFF'
|
'skip_show_database','OFF'
|
'slave_compressed_protocol','OFF'
|
'slave_ddl_exec_mode','IDEMPOTENT'
|
'slave_domain_parallel_threads','0'
|
'slave_exec_mode','STRICT'
|
'slave_load_tmpdir','/tmp'
|
'slave_max_allowed_packet','1073741824'
|
'slave_net_timeout','3600'
|
'slave_parallel_max_queued','131072'
|
'slave_parallel_threads','0'
|
'slave_skip_errors','OFF'
|
'slave_sql_verify_checksum','ON'
|
'slave_transaction_retries','10'
|
'slave_type_conversions',''
|
'slow_launch_time','2'
|
'slow_query_log','ON'
|
'slow_query_log_file','OptoSQL3-slow.log'
|
'socket','/var/lib/mysql/mysql.sock'
|
'sort_buffer_size','2097152'
|
'sql_auto_is_null','OFF'
|
'sql_big_selects','ON'
|
'sql_buffer_result','OFF'
|
'sql_log_bin','ON'
|
'sql_log_off','OFF'
|
'sql_mode',''
|
'sql_notes','ON'
|
'sql_quote_show_create','ON'
|
'sql_safe_updates','OFF'
|
'sql_select_limit','18446744073709551615'
|
'sql_slave_skip_counter','0'
|
'sql_warnings','OFF'
|
'ssl_ca',''
|
'ssl_capath',''
|
'ssl_cert',''
|
'ssl_cipher',''
|
'ssl_crl',''
|
'ssl_crlpath',''
|
'ssl_key',''
|
'storage_engine','InnoDB'
|
'stored_program_cache','256'
|
'sync_binlog','0'
|
'sync_frm','ON'
|
'sync_master_info','0'
|
'sync_relay_log','0'
|
'sync_relay_log_info','0'
|
'system_time_zone','CET'
|
'table_definition_cache','400'
|
'table_open_cache','512'
|
'thread_cache_size','4'
|
'thread_concurrency','10'
|
'thread_handling','one-thread-per-connection'
|
'thread_pool_idle_timeout','60'
|
'thread_pool_max_threads','500'
|
'thread_pool_oversubscribe','3'
|
'thread_pool_size','8'
|
'thread_pool_stall_limit','500'
|
'thread_stack','294912'
|
'time_format','%H:%i:%s'
|
'time_zone','SYSTEM'
|
'timed_mutexes','OFF'
|
'timestamp','1420462569.240073'
|
'tmp_table_size','134217728'
|
'tmpdir','/tmp'
|
'transaction_alloc_block_size','8192'
|
'transaction_prealloc_size','4096'
|
'tx_isolation','REPEATABLE-READ'
|
'tx_read_only','OFF'
|
'unique_checks','ON'
|
'updatable_views_with_limit','YES'
|
'use_stat_tables','NEVER'
|
'userstat','OFF'
|
'version','10.0.14-MariaDB-log'
|
'version_comment','MariaDB Server'
|
'version_compile_machine','x86_64'
|
'version_compile_os','Linux'
|
'version_malloc_library','bundled jemalloc'
|
'wait_timeout','28800'
|
'warning_count','0'
|
|