← Back to team overview

percona-discussion team mailing list archive

Re: simple optimizations

 

MARK,

Never looked into memory functions in details, this is something to check, definitely.

As for checksum, if you disable innodb_checksum=0 you can get visible performance benefit, so there can be better algorithm to handle it.


MARK CALLAGHAN wrote:
Have you seen this bug report?
http://bugs.mysql.com/bug.php?id=19975

Also, have you done any experiments with the page checksum method for
InnoDB to make it faster or to change the algorithm and I realize that
changing the algorithm has a huge impact on deployed servers. Once you
begin doing a lot of IO on fast SSD systems, you will burn a lot of
CPU time doing checksum validation.



--
Vadim Tkachenko, CTO
Percona Inc.
ICQ: 369-510-335, Skype: vadimtk153, Phone +1-888-401-3403
MySQL Performance Blog - http://www.mysqlperformanceblog.com
MySQL Consulting http://www.percona.com/



References