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/replication-multi-source-provision-replica.html
The best strategy for provisioning such a replica is therefore to use mysqldump to create an appropriate dump file on each source, then use the mysql client to import the dump file on the replica. If you are using GTID-based replication, you need to ... If the sources in the multi-source replication topology have existing data, it can save time to provision the replica with the relevant data before starting ...
https://dev.mysql.com/doc/refman/8.0/en/load-data-local-security.html
MySQL Shell and Local Data Loading MySQL Shell provides a number of utilities to dump tables, schemas, or server instances and load them into other instances. To get the best functionality, always use the most recent version available of MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-preload-buffer-pool.html
The percentage of recently used pages that is stored is defined by the innodb_buffer_pool_dump_pct configuration option. The underlying mechanism involves a background thread that is dispatched to perform the dump and load operations. If you plan to ... To reduce the warmup period after restarting the server, InnoDB saves a percentage of the most recently used pages for each buffer pool at server shutdown and restores these pages at server ...
https://dev.mysql.com/doc/refman/8.0/en/rebuilding-tables.html
Methods for rebuilding a table include: Dump and Reload Method ALTER TABLE Method REPAIR TABLE Method Dump and Reload Method If you are rebuilding tables because a different version of MySQL cannot handle them after a binary (in-place) upgrade or ...
https://dev.mysql.com/doc/refman/8.0/en/replication-snapshot-method.html
There are different ways to dump the data from the source database. To select the appropriate method of dumping the database, choose between these options: Use the mysqldump tool to create a dump of all the databases you want to replicate. This can ... If the source database contains existing data it is necessary to copy this data to each ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html
innodb_buffer_pool_dump_at_shutdown Command-Line Format --innodb-buffer-pool-dump-at-shutdown[={OFF|ON}] System Variable innodb_buffer_pool_dump_at_shutdown Scope Global Dynamic Yes SET_VAR Hint Applies No Type Boolean Default Value ON Specifies ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlbinlog.html
--hexdump, -H Command-Line Format --hexdump Display a hex dump of the log in comments, as described in Section 6.6.9.1, “mysqlbinlog Hex Dump Format”. The options read binary logs from a MySQL server with the COM_BINLOG_DUMP or ... The server's ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-backups-mysqldump.html
Using mysqldump to create a copy of a database enables you to capture all of the data in the database in a format that enables the information to be imported into another instance of MySQL Server (see Section 6.5.4, “mysqldump — A Database ...
https://dev.mysql.com/doc/refman/8.0/en/ibd2sdi.html
For example: Usage: ./ibd2sdi [-v] [-c <strict-check>] [-d <dump file name>] [-n] filename1 [filenames] See http://dev.mysql.com/doc/refman/8.0/en/ibd2sdi.html for usage hints. See http://dev.mysql.com/doc/refman/8.0/en/dbug-package.html -d, ...
https://dev.mysql.com/doc/refman/8.0/en/using-mysqldump.html
Tip Consider using the MySQL Shell dump utilities, which provide parallel dumping with multiple threads, file compression, and progress information display, as well as cloud features such as Oracle Cloud Infrastructure Object Storage streaming, and ...As a source of data for experimentation: To make a copy of a database that you can use without changing the original ...