PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/myisamchk-repair-options.html
--correct-checksum Command-Line Format --correct-checksum Correct the checksum information for the table. --data-file-length=len, -D len Command-Line Format --data-file-length=len Type Numeric The maximum length of the data file (when re-creating ...
https://dev.mysql.com/doc/refman/9.7/en/myisam-check.html
It calculates a checksum for all key values in the rows and verifies that the checksum matches the checksum for the keys in the index tree. To check a MyISAM table, use the following commands: myisamchk tbl_name This finds 99.99% of all errors.
https://dev.mysql.com/doc/refman/9.7/en/glossary.html
checksum In InnoDB, a validation mechanism to detect corruption when a page in a tablespace is read from disk into the InnoDB buffer pool. This feature is controlled by the innodb_checksums configuration option in MySQL 5.5. The innochecksum command ... These terms are commonly used in information about the MySQL database ...
https://dev.mysql.com/doc/refman/9.7/en/binary-log.html
You can also cause the server to write checksums for the events by setting the binlog_checksum system variable. When reading back from the binary log, the source uses the event length by default, but can be made to use checksums if available by ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-tables-table.html
The information_schema_stats_expiry system variable defines the period of time before cached table statistics expire. If there are no cached statistics or statistics have expired, statistics are retrieved from storage engines when querying table ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-partitions-table.html
For each such row: The SUBPARTITION_NAME, SUBPARTITION_ORDINAL_POSITION, SUBPARTITION_METHOD, PARTITION_EXPRESSION, SUBPARTITION_EXPRESSION, CREATE_TIME, UPDATE_TIME, CHECK_TIME, CHECKSUM, and TABLESPACE_NAME columns are all NULL. Each row in this ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-configuring-instances.html
This setting disables checksums for events written to the binary log, which default to being enabled. Group Replication in MySQL 9.7 supports the presence of checksums in the binary log and can use them to verify the integrity of events on some ...
https://dev.mysql.com/doc/refman/9.7/en/programs-overview.html
MySQL administrative and utility programs: innochecksum An offline InnoDB offline file checksum utility. Later sections provide a more detailed description of each one, with the exception of NDB Cluster programs. Each program's description indicates ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-options-variables.html
ndb_row_checksum System Variable ndb_row_checksum Scope Global, Session Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 1 Minimum Value 0 Maximum Value 1 Traditionally, NDB has created tables with row checksums, which checks for ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-online-add-node-example.html
In this section we provide a detailed example illustrating how to add new NDB Cluster data nodes online, starting with an NDB Cluster having 2 data nodes in a single node group and concluding with a cluster having 4 data nodes in 2 node groups.