Search Results
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-options-variables.html
clone_ssl_cert Command-Line Format --clone-ssl-cert=file_name System Variable clone_ssl_cert Scope Global Dynamic Yes SET_VAR Hint Applies No Type File name Default Value empty string Specifies the path to the public key certificate. clone_ssl_key ... This section describes the system variables that control operation of the clone ...
https://dev.mysql.com/doc/refman/8.4/en/create-trigger.html
syntax: a BEFORE INSERT trigger activates for every row, followed by either an AFTER INSERT trigger or both the BEFORE UPDATE and AFTER UPDATE triggers, depending on whether there was a duplicate key for the row. CREATE [DEFINER = user] TRIGGER [IF ...
https://dev.mysql.com/doc/refman/8.4/en/docker-mysql-getting-started.html
Warning The MySQL Docker images maintained by the MySQL team are built specifically for Linux platforms. Other platforms are not supported, and users using these MySQL Docker images on them are doing so at their own risk. See the discussion here ...
https://dev.mysql.com/doc/refman/8.4/en/estimating-performance.html
For a 500,000-row table with a key value length of three bytes (the size of MEDIUMINT), the formula indicates log(500,000)/log(1024/3*2/(3+4)) + 1 = 4 seeks. To avoid this, increase the key cache size as the data grows. For MyISAM tables, the key ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-distributed-recovery-connections.html
Group Replication automatically configures the settings for the clone SSL options (clone_ssl_ca, clone_ssl_cert, and clone_ssl_key) to match your settings for the corresponding Group Replication distributed recovery options ... When a joining member ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-user-credentials.html
If the replication user for distributed recovery uses the caching SHA-2 authentication plugin, and you are not using SSL for distributed recovery connections, RSA key-pairs are used for password exchange. You can either copy the public key of the ...
https://dev.mysql.com/doc/refman/8.4/en/index-btree-hash.html
For example, the following SELECT statements use indexes: SELECT * FROM tbl_name WHERE key_col LIKE 'Patrick%'; SELECT * FROM tbl_name WHERE key_col LIKE 'Pat%_ck%'; In the first statement, only rows with 'Patrick' <= key_col < 'Patricl' are ...
https://dev.mysql.com/doc/refman/8.4/en/index-statistics.html
Table statistics are based on value groups, where a value group is a set of rows with the same key prefix value. This affects ref accesses for comparisons of the form tbl_name.key = expr: MySQL does not access the table if the current value of expr ... Storage engines collect statistics about tables for use by the ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-fields-table.html
The INNODB_FIELDS table provides metadata about the key columns (fields) of InnoDB indexes. The INNODB_FIELDS table has these columns: INDEX_ID An identifier for the index associated with this key field; the same value as INNODB_INDEXES.INDEX_ID.
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-table-reference.html
The following table summarizes INFORMATION_SCHEMA InnoDB tables. For greater detail, see the individual table descriptions. Table 28.3 INFORMATION_SCHEMA InnoDB Tables Table Name Description INNODB_BUFFER_PAGE Pages in InnoDB buffer pool ...