back_log 151 back_log 80 bind_address * bind_address binlog_expire_logs_seconds 2592000 binlog_expire_logs_seconds 0 binlog_format ROW binlog_format MIXED binlog_row_metadata MINIMAL binlog_row_metadata NO_LOG collation_connection utf8mb4_0900_ai_ci collation_connection utf8mb4_uca1400_ai_ci collation_database utf8mb4_0900_ai_ci collation_database utf8mb4_uca1400_ai_ci collation_server utf8mb4_0900_ai_ci collation_server utf8mb4_uca1400_ai_ci default_tmp_storage_engine InnoDB default_tmp_storage_engine disconnect_on_expired_password ON disconnect_on_expired_password OFF event_scheduler ON event_scheduler OFF group_concat_max_len 1024 group_concat_max_len 1048576 have_symlink DISABLED have_symlink YES innodb_adaptive_hash_index ON innodb_adaptive_hash_index OFF innodb_autoinc_lock_mode 2 innodb_autoinc_lock_mode 1 innodb_buffer_pool_chunk_size 134217728 innodb_buffer_pool_chunk_size 0 innodb_checksum_algorithm crc32 innodb_checksum_algorithm full_crc32 innodb_flush_method fsync innodb_flush_method O_DIRECT innodb_flush_neighbors 0 innodb_flush_neighbors 1 innodb_log_write_ahead_size 8192 innodb_log_write_ahead_size 4096 innodb_lru_scan_depth 1024 innodb_lru_scan_depth 1536 innodb_max_dirty_pages_pct_lwm 10.000000 innodb_max_dirty_pages_pct_lwm 0.000000 innodb_max_undo_log_size 1073741824 innodb_max_undo_log_size 10485760 innodb_open_files 4000 innodb_open_files 2000 innodb_purge_batch_size 300 innodb_purge_batch_size 127 innodb_spin_wait_delay 6 innodb_spin_wait_delay 4 innodb_undo_log_truncate ON innodb_undo_log_truncate OFF innodb_undo_tablespaces 2 innodb_undo_tablespaces 3 key_buffer_size 8388608 key_buffer_size 134217728 local_infile OFF local_infile ON lock_wait_timeout 31536000 lock_wait_timeout 86400 log_bin ON log_bin OFF log_error /var/log/mysql/mysqld.log log_error log_slave_updates ON log_slave_updates OFF log_slow_admin_statements OFF log_slow_admin_statements ON log_slow_slave_statements OFF log_slow_slave_statements ON max_allowed_packet 67108864 max_allowed_packet 16777216 max_error_count 1024 max_error_count 64 max_length_for_sort_data 4096 max_length_for_sort_data 1024 max_relay_log_size 0 max_relay_log_size 1073741824 max_seeks_for_key 18446744073709551615 max_seeks_for_key 4294967295 max_write_lock_count 18446744073709551615 max_write_lock_count 4294967295 myisam_recover_options OFF myisam_recover_options BACKUP,QUICK myisam_sort_buffer_size 8388608 myisam_sort_buffer_size 134216704 open_files_limit 10000 open_files_limit 32186 optimizer_prune_level 1 optimizer_prune_level 2 optimizer_switch index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched_key_access=off,materialization=on,semijoin=on,loosescan=on,firstmatch=on,duplicateweedout=on,subquery_materialization_cost_based=on,use_index_extensions=on,condition_fanout_filter=on,derived_merge=on,use_invisible_indexes=off,skip_scan=on,hash_join=on,subquery_to_derived=off,prefer_ordering_index=on,hypergraph_optimizer=off,derived_condition_pushdown=on optimizer_switch index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=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=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=on,not_null_range_scan=off,hash_join_cardinality=on,cset_narrowing=on,sargable_casefold=on performance_schema ON performance_schema OFF secure_file_priv /var/lib/mysql-files/ secure_file_priv slave_load_tmpdir /var/tmp slave_load_tmpdir /tmp slave_parallel_workers 4 slave_parallel_workers 0 sort_buffer_size 262144 sort_buffer_size 2097152 sql_mode ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION sql_mode STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION ssl_ca ca.pem ssl_ca ssl_cert server-cert.pem ssl_cert ssl_key server-key.pem ssl_key sync_binlog 1 sync_binlog 0 table_definition_cache 2000 table_definition_cache 400 table_open_cache 4000 table_open_cache 2000 table_open_cache_instances 16 table_open_cache_instances 8 thread_cache_size 9 thread_cache_size 151 thread_stack 1048576 thread_stack 299008