I have two servers, one is an older 2008R2 and the specs are much junkier, but it does seem to feel much snappier. Both are running 8.0.30 version of mysql. I must find fault with my configuration… I've tried a few times to find the right balance of specifications. But have failed. Is there anything I'm just over-looking here as I post this INI contents:
The server is has 192gb… 2.6ghz 12core 2016 server.
[MySQLD]
port=3306
basedir=xxxxxxxxxx
datadir=xxxxxxxxxx
character-set-server=utf8
default-storage-engine=INNODB
read_buffer_size=1M
read_rnd_buffer_size=256K
join_buffer_size=256K
sort_buffer_size=512K
innodb_log_buffer_size=2M
innodb_buffer_pool_size=10G I had this as much larger, but I have tried different values… But there has to be a limit
innodb_redo_log_capacity=50M
innodb_io_capacity = 200
innodb_read_io_threads = 64
innodb_thread_concurrency = 0
innodb_write_io_threads = 64
innodb_buffer_pool_instances=8
innodb_lru_scan_depth=256
key_buffer_size=512M
max_connections=500
max_allowed_packet=500M
max_user_connections=0
thread_cache_size=35
thread_stack=196608
binlog_cache_size=32768
net_read_timeout=40
net_retry_count=15
net_write_timeout=40
open_files_limit=4161
table_definition_cache=400
event_scheduler=ON
sql_mode="TRADITIONAL"
explicit_defaults_for_timestamp
tmp_table_size=4G
log_bin_trust_function_creators=1
[client]
port=3306