Search Results
https://dev.mysql.com/doc/refman/8.4/en/ldap-pluggable-authentication.html
The client-side mysql_clear_password plugin is built into the libmysqlclient client library. The client-side SASL LDAP plugin is included in all distributions, including community distributions, and, as mentioned previously, the client-side ... Note ...
https://dev.mysql.com/doc/refman/8.4/en/manual-info.html
For example, while working with replication the commands might be prefixed with source and replica: source> type a mysql statement on the replication source here replica> type a mysql statement on the replica here Database, table, and column names ... This is the Reference Manual for the MySQL Database System, version 8.4, through release ...
https://dev.mysql.com/doc/refman/8.4/en/memory-use.html
For efficiency of high-volume read operations, the buffer pool is divided into pages that can potentially hold multiple rows. On systems with a large amount of memory, you can improve concurrency by dividing the buffer pool into multiple buffer pool ... MySQL allocates buffers and caches to improve performance of database ...
https://dev.mysql.com/doc/refman/8.4/en/miscellaneous-optimization-tips.html
This section lists a number of miscellaneous tips for improving query processing speed: If your application makes several database requests to perform related updates, combining the statements into a stored routine can help performance. Similarly, ...The resulting fast database operations are then available to be reused by other queries, applications, and even code written in different programming ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-api-definition.html
(NDB 8.4.0) For queries that are translated into full table scans or range scans on indexes, it is important for best performance to fetch records in properly sized batches. Time elapsed during node connection attempts is not taken into account when ... The [mysqld] and [api] sections in the config.ini file define the behavior of the MySQL servers (SQL nodes) and other applications (API nodes) used to access cluster ...
https://dev.mysql.com/doc/refman/8.4/en/nested-join-optimization.html
The result row is passed to the final check for the output or into the next nested loop, but only if the row satisfies the join condition of all embedded outer joins. The following discussion refers to the join syntax described in Section 15.2.13.2, ...
https://dev.mysql.com/doc/refman/8.4/en/pluggable-authentication.html
This section describes an authentication issue that protocol implementors should take into account. If the plugin is built into libmysqlclient, it is available by default. This enables the connector to support connections though accounts that ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-concepts.html
A range of GTIDs originating from the same server can be collapsed into a single expression, as shown here: 3E11FA47-71CA-11E1-9E33-C80AA9429562:1-5 The above example represents the first through fifth transactions originating on the MySQL server ...
https://dev.mysql.com/doc/refman/8.4/en/replication-setup-replicas.html
This method can also be used if you are setting up new servers but have an existing dump of the databases from a different server that you want to load into your replication configuration. By loading the data into a new source, the data is ...Before ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-backups-mysqldump.html
Using mysqldump to create a copy of a database enables you to capture all of the data in the database in a format that enables the information to be imported into another instance of MySQL Server (see Section 6.5.4, “mysqldump — A Database ...