Search Results
https://dev.mysql.com/doc/refman/8.4/en/ldap-pluggable-authentication.html
Note LDAP pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial product. MySQL Enterprise Edition supports an authentication method that enables MySQL Server to use LDAP (Lightweight Directory Access Protocol) ...
https://dev.mysql.com/doc/refman/8.4/en/mrr-optimization.html
Reading rows using a range scan on a secondary index can result in many random disk accesses to the base table when the table is large and not stored in the storage engine's cache. With the Disk-Sweep Multi-Range Read (MRR) optimization, MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-key-caches.html
Where there are multiple key caches, the server must know which cache to use when processing queries for a given MyISAM table. Performance gains occur for other reasons as well: The hot cache is used only for retrieval queries, so its contents are ... Note As of MySQL 8.4, the compound-part structured-variable syntax discussed here for referring to multiple MyISAM key caches is ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-syntax.html
Using nullable columns in unique keys and primary keys means that queries using these columns are handled as full table scans. Some SQL statements relating to certain MySQL features produce errors when used with NDB tables, as described in the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndb-api-statistics.html
A number of types of statistical counters relating to actions performed by or affecting Ndb objects are available. Such actions include starting and closing (or aborting) transactions; primary key and unique key operations; table, range, and pruned ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-diskpagebuffer.html
The diskpagebuffer table provides statistics about disk page buffer usage by NDB Cluster Disk Data tables. The diskpagebuffer table contains the following columns: node_id The data node ID block_instance Block instance pages_written Number of pages ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-option-tables.html
Ndb_pushed_queries_defined: Number of joins that API nodes have attempted to push down to data nodes. Ndb_pushed_queries_dropped: Number of joins that API nodes have tried to push down, but failed. Ndb_pushed_queries_executed: Number of joins ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-restore.html
The option checks before attempting to log whether all the tables being restored have explicitly defined primary keys; queries on a table having only the hidden primary key implemented by NDB cannot be converted to valid SQL. The NDB Cluster ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-schema.html
ndb_apply_status Table ndb_binlog_index Table ndb_replication Table Replication in NDB Cluster makes use of a number of dedicated tables in the mysql database on each MySQL Server instance acting as an SQL node in both the cluster being replicated ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-logging.html
The mysql client can do these types of logging for statements executed interactively: On Unix, mysql writes the statements to a history file. By default, this file is named .mysql_history in your home directory. To specify a different file, set the ...