Hey Folks
I'm having a tough time finding any information in the available documentation about this feature. Does anyone out there have a bit of insight as to what exactly it does.
Docs says MySQL will store a checksum for each row if this is 'on' - that's about all I can find.
That's correct.
It causes a slight slowdown for updates (the checksum must be recalculated) but improves table checking operations (e.g., CHECK TABLE). It's only for MyISAM tables.
Some general questions are:
Where is it stored?
Is it assessable?
No, which means the answer to the question before this one is "it doesn't matter because you can't get at it." :-)
How is the checksum verified between two databases - e.g., in a master/slave environment?
Which technology is used (MD5 etc.)?
I'm not sure. I believe it may be a CRC algorithm. MD5 would be overkill for this kind of thing.
An even more general is, what would be a scenario in which I would use this feature? I'm thinking it would be nice to verify data traveling across a client server environment....but I may be wrong.....
It's for internal use only. If you want to verify data, you can institute your own application-level checksums.
Any insight?
Thanks
Mike
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
