We are currently doing many insert/update transactions on our Mysql 8 server.
The duration of these transactions is really long and the problem is that we cannot predicate them (business choice)
We doubled the capacity of our machine (64GB in memory)But RAM and CPU do not seem to be more used than before.
Can I optimize these configuration ?
key_buffer_size=4G
innodb_buffer_pool_size=45G
innodb_log_file_size=4G
innodb_buffer_pool_instances=40
#innodb_buffer_pool_chunk_size=6G
#innodb_io_capacity = 4000
innodb_read_io_threads = 64
innodb_thread_concurrency = 0
innodb_write_io_threads = 64
sql-mode='NO_ENGINE_SUBSTITUTION'
secure-file-priv = ""
tmp_table_size=32M
max_heap_table_size=32M
internal_tmp_mem_storage_engine=Memory
#big_tables=ON
#debug slow queries
slow_query_log=1
slow_query_log_file=/var/log/mysql/mysql-slow.log
long_query_time=15
#log_slow_admin_statements=1
#log_queries_not_using_indexes=1
A) SELECT COUNT(*) FROM information_schema.tables;
5827 / 1069
B) SHOW GLOBAL STATUS; after minimum 24 hours UPTIME
C) SHOW GLOBAL VARIABLES
D) SHOW FULL PROCESSLIST
E) STATUS; not SHOW STATUS, just STATUS;
Doesn't work
G) SHOW ENGINE INNODB STATUS;
RAM and CPU do not seem to be more used than before. Configuration is wrong..?
