PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/backup-policy.html
A full backup (a snapshot of the data at a point in time) can be done in MySQL with several tools. For example, MySQL Enterprise Backup can perform a physical backup of an entire instance, with optimizations to minimize overhead and avoid disruption ...This backup operation acquires a global read lock on all tables at the beginning of the dump (using FLUSH TABLES WITH READ ...
https://dev.mysql.com/doc/refman/8.0/en/load-data.html
The mysqlimport utility provides another way to load data files; it operates by sending a LOAD DATA statement to the server. For example, if mysqld was started with the local_infile system variable disabled, LOCAL produces an error. For example, if ...The file can be read from the server host or the client host, depending on whether the LOCAL modifier is ...
https://dev.mysql.com/doc/refman/8.0/en/replication-delayed.html
MySQL supports delayed replication such that a replica server deliberately executes transactions later than the source by at least a specified amount of time. In MySQL 8.0, the method of delaying replication depends on two timestamps, ...This ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-cloning.html
If the remote cloning procedure takes a long time, in releases before MySQL 8.0.22, it is possible for the set of certification information that accumulates for the group during that time to become too large to transmit to the joining member. The ...
https://dev.mysql.com/doc/refman/8.0/en/replication-multi-source-provision-replica.html
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 replication. The best strategy for provisioning such a replica is therefore to use ...In a ...
https://dev.mysql.com/doc/refman/8.0/en/get-diagnostics.html
It is a MySQL extension that GET [CURRENT] DIAGNOSTICS is permitted outside handler context to check the execution of any SQL statement. For a description of the diagnostics area, see Section 15.6.7.7, “The MySQL Diagnostics Area”. When a ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-ft-index-table-table.html
The same word can occur several times within the cache table, once for each combination of DOC_ID and POSITION values. The INNODB_FT_INDEX_TABLE table provides information about the inverted index used to process text searches against the FULLTEXT ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-plugin-installation.html
Note Only one keyring component or plugin should be enabled at a time. A keyring component must be enabled on the MySQL Server instance if you need to support secure storage for persisted system variable values, rather than a keyring plugin, which ... Keyring service consumers require that a keyring component or plugin be installed: To use a keyring plugin, begin with the instructions ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-diskio.html
Specifying a threshold to force smaller, periodic flushes may be beneficial in cases where multiple MySQL instances use the same storage devices. For example, creating a new MySQL instance and its associated data files could cause large surges of ...
https://dev.mysql.com/doc/refman/8.0/en/rewriter-query-rewrite-plugin-usage.html
These statements are subject to rewriting: As of MySQL 8.0.12: SELECT, INSERT, REPLACE, UPDATE, and DELETE. Beginning with MySQL 8.0.31, statements run by users with the SKIP_QUERY_REWRITE privilege are not subject to rewriting, provided that the ...