PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-other-options.html
myisamchk supports the following options for actions other than table checks and repairs: --analyze, -a Command-Line Format --analyze Analyze the distribution of key values. To obtain information about the key distribution, use a myisamchk ...This ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-option-tables.html
ndb-connectstring: Address of NDB management server distributing configuration information for this cluster. ndb-default-column-format: Use this value (FIXED or DYNAMIC) by default for COLUMN_FORMAT and ROW_FORMAT options when creating or adding ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlbinlog-backup.html
By default, mysqlbinlog reads binary log files and displays their contents in text format. mysqlbinlog Backup Capabilities mysqlbinlog Backup Options Static and Live Backups Output File Naming Example: mysqldump + mysqlbinlog for Backup and Restore ...This enables you to examine events within the files more easily and to re-execute them (for example, by using the output as input to ...
https://dev.mysql.com/doc/refman/8.0/en/replication-configuration.html
Events in the binary log are recorded using a number of formats. A third type, mixed-format replication (MIXED), uses SBR or RBR replication automatically to take advantage of the benefits of both SBR and RBR formats when appropriate. Detailed ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-load-data.html
When binlog_format=MIXED is set, the statement is logged in row-based format. When binlog_format=STATEMENT is set, note that LOAD DATA does not generate a warning, unlike other unsafe statements. If you use LOAD DATA with binlog_format=STATEMENT, ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-gtids.html
For additional information, see Section 19.1.3, “Replication with Global Transaction Identifiers”. binlog_gtid_simple_recovery Command-Line Format --binlog-gtid-simple-recovery[={OFF|ON}] System Variable binlog_gtid_simple_recovery Scope Global ... The MySQL Server system variables described in this section are used to monitor and control Global Transaction Identifiers ...
https://dev.mysql.com/doc/refman/8.0/en/replication-privilege-checks-account.html
The use of row-based binary logging (binlog_format=ROW) is strongly recommended for replication channels that are secured using a PRIVILEGE_CHECKS_USER account. From MySQL 8.0.19, the REQUIRE_ROW_FORMAT setting can be applied to secured channels, ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rules-db-options.html
The database that is checked for a match depends on the binary log format of the statement that is being handled. If the statement has been logged using the row format, the database where data is to be changed is the database that is checked. If the ... When evaluating replication options, the replica begins by checking to see whether there are any --replicate-do-db or --replicate-ignore-db options that ...
https://dev.mysql.com/doc/refman/8.0/en/show-replica-status.html
SHOW {REPLICA | SLAVE} STATUS [FOR CHANNEL channel] This statement provides status information on essential parameters of the replica threads. This is similar to the information available from the SHOW REPLICA STATUS statement, but represented in ...From MySQL 8.0.22, use SHOW REPLICA STATUS in place of SHOW SLAVE STATUS, which is deprecated from that ...
https://dev.mysql.com/doc/refman/8.0/en/show-table-status.html
SHOW TABLE STATUS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLE STATUS works likes SHOW TABLES, but provides a lot of information about each non-TEMPORARY table. Refer to the notes at the end of this section for information ...You ...