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/mysql-cluster-replication-general.html
All NDB tables being replicated must be created using a MySQL server and client. Tables and other database objects created using the NDB API (with, for example, Dictionary::createTable()) are not visible to a MySQL server and so are not replicated.
https://dev.mysql.com/doc/refman/8.0/en/password-logging.html
Passwords can be written as plain text in SQL statements such as CREATE USER, GRANT and SET PASSWORD. Statement logging avoids writing passwords as cleartext for the following statements: CREATE USER ... In particular, INSERT or UPDATE statements ...If such statements are logged by the MySQL server as written, passwords in them become visible to anyone with access to the ...
https://dev.mysql.com/doc/refman/8.0/en/using-mysqldump.html
This output consists of CREATE statements to create dumped objects (databases, tables, stored routines, and so forth), and INSERT statements to load data into tables. The server also sends a CREATE TABLE statement for the table to mysqldump, which ...The output can be saved in a file and reloaded later using mysql to recreate the dumped ... 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 ...
https://dev.mysql.com/doc/refman/8.0/en/sha256-pluggable-authentication.html
The following table shows the plugin names on the server and client sides. If sha256_password is the default authentication plugin, a simpler CREATE USER syntax can be used. As a result, it is possible to create the account and set its password ...
https://dev.mysql.com/doc/refman/8.0/en/show-events.html
Definer The account of the user who created the event, in 'user_name'@'host_name' format. Execute At For a one-time event, this is the DATETIME value specified in the AT clause of the CREATE EVENT statement used to create the event, or of the last ... SHOW EVENTS [{FROM | IN} schema_name] [LIKE 'pattern' | WHERE expr] This statement displays information about Event Manager events, which are discussed in Section 27.4, “Using the Event ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-plugin-installation.html
This section describes how to install or uninstall MySQL Enterprise Data Masking and De-Identification, which is implemented as a plugin library file containing a plugin and several loadable functions. For general information about installing or ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-replication.html
On the source, issue the following statement to enable the source to begin processing updates again: mysql> UNLOCK TABLES; A.14.5. Thus, when the update of client A makes it to co-source 2, it produces tables that are different from what you have on ... In the following section, we provide answers to questions that are most frequently asked about MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-limitations.html
Group Replication cannot be started following a MySQL Server upgrade that uses the MINIMAL option (--upgrade=MINIMAL), which does not upgrade system tables on which the replication internals depend. Note For a group in multi-primary mode, unless you ... Limit on Group Size Limits on Transaction Size The following known limitations exist for Group ...
https://dev.mysql.com/doc/refman/8.0/en/index-merge-optimization.html
This access method merges index scans from a single table only, not scans across multiple tables. AND key_partN = constN Any range condition over the primary key of an InnoDB table. If all columns used in the query are covered by the used indexes, ... The Index Merge access method retrieves rows with multiple range scans and merges their results into ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-dml.html
These operations are guaranteed to only affect one row when issued through the memcached interface, because the key is unique within the table. In the following SQL examples, t1 refers to the table used for memcached operations, based on the ...