Search Results
https://dev.mysql.com/doc/refman/8.4/en/group-replication-network-partitioning.html
The majority of the time the system does not run into partitioning, and therefore the table shows information that is consistent across all servers in the group. This information is exported by the local failure detector built into Group Replication. You can verify this by logging into s1 and looking at its replication_group_members performance schema ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-single-multi.html
Before the introduction of online DDL, it was common practice to combine many DDL operations into a single ALTER TABLE statement. For DDL operations that can be done online, you can separate them into individual ALTER TABLE statements for easier ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-preload-buffer-pool.html
After restarting a busy server, there is typically a warmup period with steadily increasing throughput, as disk pages that were in the buffer pool are brought back into memory (as the same data is queried, updated, and so on). You could also restore ... To reduce the warmup period after restarting the server, InnoDB saves a percentage of the most recently used pages for each buffer pool at server shutdown and restores these pages at server ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-functions-general-purpose.html
INTO @var_name and test the variable value: mysql> SELECT keyring_key_generate('', '', -1) INTO @x; ERROR 3188 (HY000): Function 'keyring_key_generate' failed because underlying keyring service returned an error. mysql> SELECT @x; +------+ | @x | ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-okv-plugin.html
Use this openssl command to decrypt the private key and create a file named key.pem: openssl pkcs8 -in private_key_pkcs8.pem -out key.pem Copy the key.pem file into the ssl directory. Note The keyring_okv plugin is an extension included in MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-service.html
The function stores into it a pointer to a null-terminated string that provides additional information about the key (stored when the key was added). The function stores into it a pointer to the buffer containing the fetched key data. key_len: The ... MySQL Server supports a keyring service that enables internal components and plugins to securely store sensitive information for later ...
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 ...