PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-config.html
ndb_config can also provide an offline dump of all configuration parameters which can be used, along with their default, maximum, and minimum values and other information. The dump can be produced in either text or XML format; for more information, ... This tool extracts current configuration information for data nodes, SQL nodes, and API nodes from one of a number of sources: an NDB Cluster management node, or its config.ini or my.cnf ...
https://dev.mysql.com/doc/refman/8.0/en/replica-connection-thread-states.html
Opening master dump table This state occurs after Creating table from master dump. Reading master dump table data This state occurs after Opening master dump table. Rebuilding the index on master dump table This state occurs after Reading master ...
https://dev.mysql.com/doc/refman/8.0/en/alter-database.html
This has implications for mysqldump and mysqlpump, which use SHOW CREATE DATABASE to produce CREATE DATABASE statements in dump output: In a dump file, the CREATE DATABASE statement for a read-only database contains the commented READ ONLY option.
https://dev.mysql.com/doc/refman/8.0/en/copying-databases.html
In cases where you need to transfer databases between different architectures, you can use mysqldump to create a file containing SQL statements. Note If GTIDs are in use on the server where you create the dump (gtid_mode=ON), by default, mysqldump ...You can then transfer the file to the other machine and feed it as input to the mysql ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbd-definition.html
You can use DUMP 908 to observe the effect of this parameter in the data node logs. This parameter cannot be set directly in the cluster configuration file, and under most circumstances should not need to be, but can be enabled directly using DUMP ... The [ndbd] and [ndbd default] sections are used to configure the behavior of the cluster's data ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-blob-tool.html
The basic syntax for ndb_blob_tool is shown here: ndb_blob_tool [options] table [column, ...] Unless you use the --help option, you must specify an action to be performed by including one or more of the options --check-orphans, --delete-orphans, or ... This tool can be used to check for and remove orphaned BLOB column parts from NDB tables, as well as to generate a file listing any orphaned ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-index-stat.html
--dump Command-Line Format --dump Dump the contents of the query cache. ndb_index_stat provides per-fragment statistical information about indexes on NDB tables. This includes cache version and age, number of index entries per partition, and memory ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlbinlog-backup.html
mysqlbinlog Backup Capabilities mysqlbinlog Backup Options Static and Live Backups Output File Naming Example: mysqldump + mysqlbinlog for Backup and Restore mysqlbinlog Backup Restrictions mysqlbinlog Backup Capabilities mysqlbinlog can read binary ... By default, mysqlbinlog reads binary log files and displays their contents in text ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-transaction-inconsistencies.html
If mysqldump is used with --dump-replica or --dump-slave, it does not record the existence of gaps; thus it prints CHANGE REPLICATION SOURCE TO | CHANGE MASTER TO with RELAY_LOG_POS set to the “low-water mark” position in Exec_master_log_pos.
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-failover.html
There are several variants of this method, the difference being in the manner in which data dumps and transactions from binary logs are transferred to the replica, as outlined here: Data Set Create a dump file using mysqldump on the source server.