[server] # [mysqld] # # Global / Idioma # basedir = /usr bind_address = 10.20.10.12 server-id = 2 log_bin = /var/log/mysql/mysql-bin.log character_set_server = utf8mb4 collation_server = utf8mb4_spanish2_ci connect_timeout = 300 datadir = /var/lib/mysql default_storage_engine = InnoDB default_tmp_storage_engine = InnoDB lc_messages = es_ES lc_messages_dir = /usr/share/mysql lc_time_names = es_ES pid_file = /run/mysqld/mysqld.pid skip_external_locking = 1 sync_binlog = 128 symbolic-links = 0 tmpdir = /tmp user = mysql # # Replication # log-slave-updates = 1 log-basename = db2 binlog_format = row log_bin_compress = on relay_log = /var/lib/mysql/relay-bin relay_log_index = /var/lib/mysql/relay-bin.index auto_increment_increment = 1 auto_increment_offset = 1 slave_parallel_threads = 4 # # General # div_precision_increment = 6 expire_logs_days = 0.5 host_cache_size = 128 join_buffer_size = 512M lock_wait_timeout = 300 max_allowed_packet = 128MB max_connections = 8192 max_connect_errors = 8192 max_digest_length = 1024 max_error_count = 1024 max_prepared_stmt_count = 16382 max_sort_length = 8M max_user_connections = 0 preload_buffer_size = 128M query_cache_type = ON query_alloc_block_size = 128M query_prealloc_size = 512M query_cache_limit = 1024M query_cache_size = 2048M range_alloc_block_size = 16M sort_buffer_size = 4096M stored_program_cache = 1024 table_cache = 8192 table_definition_cache = 1024 table_open_cache = 4096 table_open_cache_instances = 4 thread_cache_size = 32 thread_stack = 1M tmp_table_size = 64M transaction_alloc_block_size = 8K transaction_prealloc_size = 2K # # Logs # log_error = /var/lib/mysql/mysql-error.log log_queries_not_using_indexes = 0 long_query_time = 3 max_binlog_size = 256M slow_query_log = 1 slow_query_log_file = /var/lib/mysql/mysql-slow.log # # MyISAM # bulk_insert_buffer_size = 16M concurrent_insert = 1 delay_key_write = on key_buffer_size = 2048M key_cache_age_threshold = 300 key_cache_block_size = 1024 key_cache_division_limit = 100 myisam_data_pointer_size = 6 myisam_max_sort_file_size = 1792M myisam_mmap_size = 2048M myisam_recover_options = FORCE,BACKUP myisam_repair_threads = 1 myisam_sort_buffer_size = 1024M read_buffer_size = 1024M read_rnd_buffer_size = 256M # # InnoDB # innodb_adaptive_flushing = 1 innodb_adaptive_flushing_lwm = 10 innodb_adaptive_hash_index = 1 innodb_adaptive_hash_index_parts = 32 innodb_autoextend_increment = 64 innodb_autoinc_lock_mode = 2 innodb_buffer_pool_chunk_size = 256M innodb_buffer_pool_dump_at_shutdown = 1 innodb_buffer_pool_dump_now = 0 innodb_buffer_pool_dump_pct = 25 innodb_buffer_pool_load_abort = 0 innodb_buffer_pool_load_at_startup = 1 innodb_buffer_pool_load_now = 0 innodb_buffer_pool_size = 4096M innodb_change_buffer_max_size = 25 innodb_change_buffering = 5 innodb_cmp_per_index_enabled = 0 innodb_commit_concurrency = 0 innodb_deadlock_detect = 1 innodb_disable_sort_file_cache = 0 innodb_doublewrite = 1 innodb_fast_shutdown = 1 innodb_file_per_table = 1 innodb_fill_factor = 80 innodb_flush_log_at_timeout = 1 innodb_flush_log_at_trx_commit = 1 innodb_flush_method = O_DIRECT innodb_flush_neighbors = 1 innodb_flush_sync = 1 innodb_flushing_avg_loops = 100 innodb_force_load_corrupted = 0 innodb_force_recovery = 0 innodb_ft_cache_size = 16M innodb_ft_enable_diag_print = 0 innodb_ft_enable_stopword = 1 innodb_ft_max_token_size = 84 innodb_ft_min_token_size = 3 innodb_ft_num_word_optimize = 4000 innodb_ft_result_cache_limit = 2048M innodb_ft_sort_pll_degree = 4 innodb_ft_total_cache_size = 2048M innodb_io_capacity = 9600 innodb_io_capacity_max = 10112 innodb_lock_wait_timeout = 30 innodb_log_buffer_size = 32M innodb_log_checksums = 1 innodb_log_compressed_pages = 1 innodb_log_file_size = 128M innodb_log_write_ahead_size = 8K innodb_lru_scan_depth = 128 innodb_max_dirty_pages_pct = 90 innodb_max_dirty_pages_pct_lwm = 10 innodb_max_purge_lag = 0 innodb_max_purge_lag_delay = 2000000 innodb_max_undo_log_size = 512M innodb_old_blocks_pct = 20 innodb_old_blocks_time = 1000 innodb_online_alter_log_max_size = 2048M innodb_optimize_fulltext_only = 0 innodb_purge_batch_size = 512 innodb_purge_threads = 8 innodb_purge_rseg_truncate_frequency = 128 innodb_random_read_ahead = 0 innodb_read_ahead_threshold = 56 innodb_read_io_threads = 4 innodb_replication_delay = 0 innodb_rollback_on_timeout = 0 innodb_sort_buffer_size = 4096M innodb_spin_wait_delay = 6 innodb_stats_auto_recalc = 1 innodb_stats_include_delete_marked = 0 innodb_stats_persistent = 1 innodb_strict_mode = 1 innodb_sync_array_size = 1 innodb_sync_spin_loops = 30 innodb_table_locks = 1 innodb_thread_concurrency = 8 innodb_undo_log_truncate = 1 innodb_use_native_aio = 1 innodb_write_io_threads = 4 # [embedded] # [mariadb] #