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/replication-options-source.html
This section describes the server options and system variables that you can use on replication source servers. You can specify the options either on the command line or in an option file. On the source and each replica, you must set the server_id ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-component-usage.html
Before using MySQL Enterprise Data Masking and De-Identification, install it according to the instructions provided at Section 8.5.2.1, “MySQL Enterprise Data Masking and De-Identification Component Installation”. To use MySQL Enterprise Data ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-plugin-usage.html
Before using MySQL Enterprise Data Masking and De-Identification, install it according to the instructions provided at Section 8.5.3.1, “MySQL Enterprise Data Masking and De-Identification Plugin Installation”. To use MySQL Enterprise Data ...
https://dev.mysql.com/doc/refman/8.0/en/drop-index.html
To drop a primary key, the index name is always PRIMARY, which must be specified as a quoted identifier because PRIMARY is a reserved word: DROP INDEX `PRIMARY` ON t; Indexes on variable-width columns of NDB tables are dropped online; that is, ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-statements-current-table.html
However, the display length of statement digests may be longer than the available buffer size due to encoding of statement elements such as keywords and literal values in digest buffer. The events_statements_current table has these indexes: Primary ...The table stores one row per thread showing the current status of the thread's most recent monitored statement event, so there is no system variable for configuring the table ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-prepared-statements-instances-table.html
The prepared_statements_instances table has these indexes: Primary key on (OBJECT_INSTANCE_BEGIN) Index on (STATEMENT_ID) Index on (STATEMENT_NAME) Index on (OWNER_THREAD_ID, OWNER_EVENT_ID) Index on (OWNER_OBJECT_TYPE, OWNER_OBJECT_SCHEMA, ... The ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-processlist-table.html
The processlist table has these indexes: Primary key on (ID) TRUNCATE TABLE is not permitted for the processlist table. The MySQL process list indicates the operations currently being performed by the set of threads executing within the server. For ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-component-functions.html
mask_canada_sin(str [, mask_char]) Masks a Canada Social Insurance Number (SIN) and returns the number with all meaningful digits replaced by 'X' characters. Nine digits grouped in pattern: xxx-xxx-xxx ('-' is any separator character). Return value: ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-status-variables.html
MySQL 8.0 supports one status variable providing information about Group Replication. This variable is described here: group_replication_primary_member Shows the primary member's UUID when the group is operating in single-primary mode. If the group ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-innodb-cluster-introduction.html
Advanced users can also take advantage of a multi-primary mode, where all instances are primaries. This chapter introduces MySQL InnoDB Cluster, which combines MySQL technologies to enable you to deploy and administer a complete integrated high ...