I don’t know why my MySQL database suddenly became slow.
The version of MySQL server is 8.0.26.
I find that DELETE/INSERT instructions are slow and I have a lot of threads running with waiting for handler commit during 1-2 seconds.
Somes lines in my.ini :
default-storage-engine=INNODB
sql-mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION"
slow-query-log=1
table_open_cache=2000
tmp_table_size=697M
thread_cache_size=10
key_buffer_size=8M
read_buffer_size=64K
read_rnd_buffer_size=256K
innodb_flush_log_at_trx_commit=1
innodb_log_file_size=48M
innodb_thread_concurrency=9
New contributor
Matt is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.