Rechercher dans le manuel MySQL
Search Results
https://dev.mysql.com/checksum-table.html
[QUICK | EXTENDED] CHECKSUM TABLE reports a checksum for the contents of a table. If you run CHECKSUM TABLE against a view, the Checksum value is always NULL, and a warning is returned. For a nonexistent table, CHECKSUM TABLE returns NULL and ...You ...
https://dev.mysql.com/innochecksum.html
This tool reads an InnoDB tablespace file, calculates the checksum for each page, compares the calculated checksum to the stored checksum, and reports mismatches, which indicate damaged pages. Because checksum mismatches cause InnoDB to deliberately ...It was originally developed to speed up verifying the integrity of tablespace files after power outages but can also be used after file ...
https://dev.mysql.com/verifying-md5-checksum.html
After you have downloaded a MySQL package, you should make sure that its MD5 checksum matches the one provided on the MySQL download pages. Each package has an individual checksum that you can verify against the package that you downloaded. The ...
https://dev.mysql.com/replication-features-checksum-table.html
CHECKSUM TABLE returns a checksum that is calculated row by row, using a method that depends on the table row storage format. The storage format is not guaranteed to remain the same between MySQL versions, so the checksum value might change ...
https://dev.mysql.com/innodb-parameters.html
innodb_checksum_algorithm Property Value Command-Line Format --innodb-checksum-algorithm=value System Variable innodb_checksum_algorithm Scope Global Dynamic Yes SET_VAR Hint Applies No Type Enumeration Default Value crc32 Valid Values ... System ...
https://dev.mysql.com/verifying-package-integrity.html
There are three means of integrity checking: MD5 checksums Cryptographic signatures using GnuPG, the GNU Privacy Guard For RPM packages, the built-in RPM integrity verification mechanism The following sections describe how to use these methods. If ... After downloading the MySQL package that suits your needs and before attempting to install it, make sure that it is intact and has not been tampered ...
https://dev.mysql.com/replication-options-binary-log.html
These are enabled using the two options listed here: --binlog-checksum={NONE|CRC32} Property Value Command-Line Format --binlog-checksum=type Type String Default Value CRC32 Valid Values NONECRC32 Enabling this option causes the master to write ...
https://dev.mysql.com/mysql-cluster-params-other.html
PreSendChecksum: If this parameter and Checksum are both enabled, perform pre-send checksum checks, and check all TCP signals between nodes for errors Proxy: ReceiveBufferMemory: Bytes of buffer for signals received by this node SendBufferMemory: ...
https://dev.mysql.com/mysql-cluster-shm-definition.html
Checksum: Indicates that a checksum is included in each signal sent through the transporter. When it is enabled, checksums for all messages are calculated before being placed in the send buffer. Communications between NDB cluster nodes are normally ...
https://dev.mysql.com/replication-options-reference.html
The following two lists provide basic information about the MySQL command-line options and system variables applicable to replication and the binary log. The command-line options and system variables in the following list relate to replication ...
Document created the 26/06/2006, last modified the 26/10/2018
Source of the printed document:https://www.gaudry.be/en/mysql-rf-fct-checksum-p-1.html
The infobrol is a personal site whose content is my sole responsibility. The text is available under CreativeCommons license (BY-NC-SA). More info on the terms of use and the author.
References
These references and links indicate documents consulted during the writing of this page, or which may provide additional information, but the authors of these sources can not be held responsible for the content of this page.
The author This site is solely responsible for the way in which the various concepts, and the freedoms that are taken with the reference works, are presented here. Remember that you must cross multiple source information to reduce the risk of errors.
