Commit is slow in Mysql 5.7
Hello,
We use Mysql 5.7 where commit is too longer and website slow down.
We haven't set query cache on mysql.
So what is reason for that?
SHOW GLOBAL STATUS LIKE 'Qc%';
Qcache_free_blocks | 0
Qcache_free_memory | 0
Qcache_hits | 0
Qcache_inserts | 0
Qcache_lowmem_prunes | 0
Qcache_not_cached | 0
Qcache_queries_in_cache | 0
Qcache_total_blocks | 0
SHOW VARIABLES LIKE 'innodb_buffer_%'
innodb_buffer_pool_chunk_size | 134217728
innodb_buffer_pool_dump_at_shutdown | ON
innodb_buffer_pool_dump_now | OFF
innodb_buffer_pool_dump_pct | 25
innodb_buffer_pool_filename | ib_buffer_pool
innodb_buffer_pool_instances | 8
innodb_buffer_pool_load_abort | OFF
innodb_buffer_pool_load_at_startup | ON
innodb_buffer_pool_load_now | OFF
innodb_buffer_pool_size | 4294967296
Subject
Views
Written By
Posted
Commit is slow in Mysql 5.7
1096
September 05, 2020 02:49AM
507
September 05, 2020 01:04PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.