MySQL Forums
Forum List  »  Performance

Commit is slow in Mysql 5.7
Posted by: Himanshu Patel
Date: September 05, 2020 02:49AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Commit is slow in Mysql 5.7
211
September 05, 2020 02:49AM
87
September 05, 2020 01:04PM


Sorry, only registered users may post in this forum.

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.