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/roles.html
The following list summarizes role-management capabilities provided by MySQL: CREATE ROLE and DROP ROLE create and remove roles. Creating Roles and Granting Privileges to Them Defining Mandatory Roles Checking Role Privileges Activating Roles ...
https://dev.mysql.com/doc/refman/8.0/en/invisible-columns.html
However, even if explicitly referenced, a column that is invisible in the existing table is visible in the new table: mysql> CREATE TABLE t1 (col1 INT, col2 INT INVISIBLE); mysql> CREATE TABLE t2 AS SELECT col1, col2 FROM t1; mysql> SHOW CREATE ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-search-mecab.html
The MeCab full-text parser plugin is a full-text parser plugin for Japanese that tokenizes a sequence of text into meaningful words. By comparison, the ngram full-text parser tokenizes text into a contiguous sequence of n characters, where n ... The ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-init-startup-configuration.html
If a tablespace file is not found, InnoDB logs an error and continues the startup sequence. System tablespace files are created in the data directory by default (datadir). For example, to create a system tablespace data file in a directory named ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-aws-plugin.html
To configure keyring_aws, you must obtain a secret access key that provides credentials for communicating with AWS KMS and write it to a configuration file: Create an AWS KMS account. Use AWS KMS to create a secret access key ID and secret access ...
https://dev.mysql.com/doc/refman/8.0/en/truncate-table.html
Logically, TRUNCATE TABLE is similar to a DELETE statement that deletes all rows, or a sequence of DROP TABLE and CREATE TABLE statements. It differs from DELETE in the following ways: Truncate operations drop and re-create the table, which is much ...To achieve high performance, TRUNCATE TABLE bypasses the DML method of deleting ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-operations.html
The CREATE INDEX statement only finishes after all transactions that are accessing the table are completed, so that the initial state of the index reflects the most recent contents of the table. Online DDL support for adding secondary indexes means ... Online support details, syntax examples, and usage notes for DDL operations are provided under the following topics in this ...
https://dev.mysql.com/doc/refman/8.0/en/change-replication-source-to.html
When using a multithreaded replica (replica_parallel_workers > 0), stopping the replica can cause gaps in the sequence of transactions that have been executed from the relay log, regardless of whether the replica was stopped intentionally or ...] ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-conflict-resolution.html
You must create any exceptions table before creating the data table with which it is to be used. Conflict Resolution Exceptions Table To use the NDB$OLD() conflict resolution function, it is also necessary to create an exceptions table corresponding ... Requirements Source Column Control Conflict Resolution Control Conflict Resolution Functions Conflict Resolution Exceptions Table Conflict Detection Status Variables Examples When using a replication setup involving multiple sources (including circular replication), it is possible that different sources may try to update the same row on the replica with different ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-standard-monitor.html
The contents include the current log sequence number, how far the log has been flushed to disk, and the position at which InnoDB last took a checkpoint. The Lock Monitor is the same as the Standard Monitor except that it includes additional lock ...