1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108
| [mysqld]
server-id = 1 port = 3306 user = mysql
log_error = /var/log/mysqld.log tmpdir = /tmp
pid-file = /var/lib/mysql/mysql.pid socket = /var/lib/mysql/mysql.sock datadir = /var/lib/mysql
character_set_server=utf8mb4
transaction_isolation = READ-COMMITTED
innodb_print_all_deadlocks = 1
log_timestamps=SYSTEM sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
event_scheduler = 1
lower_case_table_names = 1
innodb_ft_min_token_size=1 ngram_token_size=1
skip-name-resolve
max_connections = 800
max_connect_errors = 1000
open_files_limit = 102400
interactive_timeout = 1200
wait_timeout = 600
table_open_cache = 128
tmp_table_size = 128M
max_heap_table_size = 128M
join_buffer_size = 2M
read_buffer_size = 16M
read_rnd_buffer_size = 8M
sort_buffer_size = 8M
max_allowed_packet = 32M
innodb_buffer_pool_size = 10G
innodb_log_file_size = 2G
innodb_flush_log_at_trx_commit = 1
innodb_flush_method = O_DIRECT
innodb_autoinc_lock_mode = 2
innodb_lock_wait_timeout = 20
innodb_strict_mode = 1
innodb_buffer_pool_dump_at_shutdown = 1 innodb_buffer_pool_load_at_startup = 1
innodb_lru_scan_depth = 2000 innodb_io_capacity = 4000 innodb_io_capacity_max = 8000
innodb_flush_neighbors = 1
slow_query_log_file = /var/log/mysql/mysql-slow.log
slow_query_log = 1
long_query_time = 3
min_examined_row_limit = 100
|