MySQL Forums
Forum List  »  Performance

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

Ankur Kaushik Wrote:
-------------------------------------------------------
> 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


Query Response time : 4.75 sec in Master with stric_crc32
Query Response time : 3.15 sec in slave with innodb checksum

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: innodb_checksum_algorithm stic_crc32 is slow response
1066
December 08, 2014 04:32AM


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.