MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

innodb_checksum_algorithm stic_crc32 is slow response
Posted by: Ankur Kaushik
Date: December 08, 2014 04:29AM

I have two server one is Master and Other is Slave ,
Executing same query but getting result is slow response in Master server

MySQL Version in SLave MySQL 5.6.21 and Master 5.6.14 enterprise version

In Master

innodb_checksum_algorithm=strict_crc32

Slow Log and binlog is opened

Query Response time : 3.15 sec

In SLAVE

innodb_checksum_algorithm=innodb

Slow log and binlog is not opened

Query Response time : 4.75 sec

Is the cause of innodb_checksum_algorithm which is making difference

Navigate: Previous Message• Next Message
Options: Reply• Quote




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.