Last active
January 12, 2016 05:37
-
-
Save diogenese/c69a14d1c683bc73523d to your computer and use it in GitHub Desktop.
Local MariaDB server global variables
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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 = OFF | |
| 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 = STATEMENT | |
| 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 = utf8mb4 | |
| character_set_filesystem = binary | |
| character_set_results = utf8 | |
| character_set_server = latin1 | |
| character_set_system = utf8 | |
| character_sets_dir = /usr/share/mysql/charsets/ | |
| collation_connection = utf8_general_ci | |
| collation_database = utf8mb4_unicode_ci | |
| collation_server = latin1_swedish_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 = 0 | |
| 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 = ON | |
| general_log_file = /var/log/mysqld/query.log | |
| group_concat_max_len = 1024 | |
| gtid_binlog_pos = | |
| gtid_binlog_state = | |
| gtid_current_pos = | |
| gtid_domain_id = 0 | |
| gtid_ignore_duplicates = OFF | |
| gtid_seq_no = 0 | |
| gtid_slave_pos = | |
| 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 = master.privatedomain | |
| 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.000000 | |
| 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 = 134217728 | |
| 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 = 50331648 | |
| 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.000000 | |
| innodb_max_dirty_pages_pct_lwm = 0.001000 | |
| 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 = 300 | |
| 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_modified_counter = 0 | |
| innodb_stats_on_metadata = OFF | |
| innodb_stats_persistent = ON | |
| innodb_stats_persistent_sample_pages = 20 | |
| innodb_stats_sample_pages = 8 | |
| innodb_stats_traditional = ON | |
| 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.26-74.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 = 16777216 | |
| 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 = OFF | |
| log_bin_trust_function_creators = OFF | |
| log_error = /var/log/mysqld/mysqld.log | |
| log_output = FILE | |
| log_queries_not_using_indexes = OFF | |
| log_slave_updates = OFF | |
| 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 = 0 | |
| 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 = 151 | |
| max_delayed_threads = 20 | |
| max_digest_length = 1024 | |
| max_error_count = 64 | |
| max_heap_table_size = 16777216 | |
| 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 = 8388608 | |
| myisam_stats_method = nulls_unequal | |
| myisam_use_mmap = OFF | |
| net_buffer_length = 8192 | |
| 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 = 1024 | |
| 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 = OFF | |
| performance_schema_accounts_size = -1 | |
| performance_schema_digests_size = -1 | |
| performance_schema_events_stages_history_long_size = -1 | |
| performance_schema_events_stages_history_size = -1 | |
| performance_schema_events_statements_history_long_size = -1 | |
| performance_schema_events_statements_history_size = -1 | |
| performance_schema_events_waits_history_long_size = -1 | |
| performance_schema_events_waits_history_size = -1 | |
| performance_schema_hosts_size = -1 | |
| performance_schema_max_cond_classes = 80 | |
| performance_schema_max_cond_instances = -1 | |
| performance_schema_max_digest_length = 1024 | |
| performance_schema_max_file_classes = 50 | |
| performance_schema_max_file_handles = 32768 | |
| performance_schema_max_file_instances = -1 | |
| performance_schema_max_mutex_classes = 200 | |
| performance_schema_max_mutex_instances = -1 | |
| performance_schema_max_rwlock_classes = 40 | |
| performance_schema_max_rwlock_instances = -1 | |
| performance_schema_max_socket_classes = 10 | |
| performance_schema_max_socket_instances = -1 | |
| performance_schema_max_stage_classes = 150 | |
| performance_schema_max_statement_classes = 180 | |
| performance_schema_max_table_handles = -1 | |
| performance_schema_max_table_instances = -1 | |
| performance_schema_max_thread_classes = 50 | |
| performance_schema_max_thread_instances = -1 | |
| performance_schema_session_connect_attrs_size = -1 | |
| performance_schema_setup_actors_size = 100 | |
| performance_schema_setup_objects_size = 100 | |
| performance_schema_users_size = -1 | |
| pid_file = /var/run/mysqld/mysqld.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 = 194 | |
| query_alloc_block_size = 8192 | |
| query_cache_limit = 1048576 | |
| query_cache_min_res_unit = 4096 | |
| query_cache_size = 0 | |
| 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 = 262144 | |
| read_only = OFF | |
| read_rnd_buffer_size = 524288 | |
| 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 = 1 | |
| skip_external_locking = ON | |
| skip_name_resolve = OFF | |
| 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 = /var/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 = /var/log/mysqld/slow.log | |
| socket = /var/lib/mysql/mysql.sock | |
| sort_buffer_size = 524288 | |
| 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 = PST | |
| table_definition_cache = 400 | |
| table_open_cache = 64 | |
| thread_cache_size = 0 | |
| 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 = 1452504899.822080 | |
| tmp_table_size = 16777216 | |
| tmpdir = /var/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.22-MariaDB-log | |
| version_comment = Mageia MariaDB Server | |
| version_compile_machine = x86_64 | |
| version_compile_os = Linux | |
| version_malloc_library = system jemalloc | |
| wait_timeout = 28800 | |
| warning_count = 0 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment