I've read somewhere that using CHECKSUM = 1 can reduce the chances of corruption in MYISAM tables. Is it correct? Will it affect the insert/update timing and query performance?
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
Setting CHECKSUM=1 when creating a table can help detect cases of table corruption. It does make insert and update operations a little bit slower, since the checksum must be calculated for each row. See also the "Corrupted MyISAM Tables" section of the manual.
Dig Deeper on Open source databases
Related Q&A from Scott Noyes
Get suggestions for choosing MySQL character sets and field collations from expert Scott Noyes.continue reading
A MySQL expert describes two ways that the multi-master support can be used.continue reading
An expert describes where to find information on detection deadlock algorithms in MySQL.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.