nano /etc/my.cnf.d #
# This group is read both both by the client and the server
# use it for options that affect everything
#
[client-server]
#
# include all files from the config directory
#
!includedir /etc/my.cnf.d
[mysqld]
sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
bind-address = ::ffff:127.0.0.1
local-infile=0
innodb_buffer_pool_size = 35G
max_allowed_packet = 256M
open_files_limit = 40000
innodb_file_per_table = 1
max_connections = 2750
max_connect_errors = 350
max_heap_table_size=1G
tmp_table_size=1G
innodb_io_capacity=10000
read_buffer_size=4M
read_rnd_buffer_size=32M
aria_pagecache_division_limit=50
key_cache_division_limit=50
innodb_buffer_pool_instances=8
innodb_buffer_pool_size=25G
innodb_lru_scan_depth=100
innodb_thread_concurrency=12