Search Results
https://dev.mysql.com/doc/refman/8.4/en/order-by-optimization.html
Assuming that there is an index on (key_part1, key_part2), the following queries may use the index to resolve the ORDER BY part. In this query, the index on (key_part1, key_part2) enables the optimizer to avoid sorting: SELECT * FROM t1 ORDER BY ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-hash.html
Note For simplicity, the tables in the examples that follow do not use any keys. You should be aware that, if a table has any unique keys, every column used in the partitioning expression for this table must be part of every unique key, including ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-info.html
row *************************** id: 1 select_type: SIMPLE table: trb1 partitions: p0,p1,p2,p3 type: ALL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 10 Extra: Using filesort In this case, all four partitions are searched. However, ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-range.html
While the examples work as shown for purposes of the present discussion, you should keep in mind that tables are extremely likely in practice to have primary keys, unique keys, or both, and that allowable choices for partitioning columns depend on ... A table that is partitioned by range is partitioned in such a way that each partition contains rows for which the partitioning expression value lies within a given ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-types.html
When partitioning by KEY or LINEAR KEY, you can use a DATE, TIME, or DATETIME column as the partitioning column without performing any modification of the column value. For KEY partitioning, this issue is taken care of automatically by the hashing ... This section discusses the types of partitioning which are available in MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-statement-summary-tables.html
The Performance Schema maintains tables for collecting current and recent statement events, and aggregates that information in summary tables. Section 29.12.6, “Performance Schema Statement Event Tables” describes the events on which statement ...
https://dev.mysql.com/doc/refman/8.4/en/show-replica-status.html
Source_SSL_Allowed, Source_SSL_CA_File, Source_SSL_CA_Path, Source_SSL_Cert, Source_SSL_Cipher, Source_SSL_CRL_File, Source_SSL_CRL_Path, Source_SSL_Key, Source_SSL_Verify_Server_Cert These fields show the SSL parameters used by the replica to ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-create-certs.html
create certs [--ca|--keys] [--added] cluster_name The command creates all certificate authorities (CAs), keys, and certificate files needed for a cluster to use TLS connections on all hosts in the site. The --ca option limits the command to only ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-ssl-set.html
bool mysql_ssl_set(MYSQL *mysql, const char *key, const char *cert, const char *ca, const char *capath, const char *cipher) Description Note As of MySQL 8.0.35, mysql_ssl_set() is deprecated and subject to removal in a future MySQL release.
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-keyring-plugins.html
MySQL Server supports a keyring service that enables internal server components and plugins to securely store sensitive information for later retrieval. This section describes how to write a server-side keyring plugin that can be used by service ...