Search Results
https://dev.mysql.com/doc/refman/8.4/en/gpg-key-archived-packages.html
The following GPG public build key (keyID 3A79BD29) can be used to verify the authenticity and integrity of MySQL packages versions 8.0.28 through 8.0.35, 8.1.0, and 8.2.0. For signature checking instructions, see Section 2.1.4.2, “Signature ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management-hash-key.html
Tables which are partitioned by hash or by key are very similar to one another with regard to making changes in a partitioning setup, and both differ in a number of ways from tables which have been partitioned by range or list. For that reason, ...
https://dev.mysql.com/doc/internals/en/public-key-retrieval-example.html
set --default-auth=sha256_password for the MySQL client, don't provide it with the servers public-key and login with a user whose account uses sha256_password: 9f 00 00 01 85 a6 3f 00 00 00 00 01 21 00 00 00 ......?.....!... set ...
https://dev.mysql.com/doc/refman/8.4/en/key-cache-restructuring.html
A key cache can be restructured at any time by updating its parameter values. For example: mysql> SET GLOBAL cold_cache.key_buffer_size=4*1024*1024; If you assign to either the key_buffer_size or key_cache_block_size key cache component a value ...
https://dev.mysql.com/doc/refman/8.4/en/key-space.html
You can roughly calculate the size for the index file as (key_length+4)/0.67, summed over all keys. This is for the worst case when all keys are inserted in sorted order and the table doesn't have any compressed keys. Prefix compression is used on ...If the first index part is a string, it is also prefix ...
https://dev.mysql.com/doc/refman/8.4/en/searching-on-two-keys.html
An OR using a single key is well optimized, as is the handling of AND. The one tricky case is that of searching on two different keys combined with OR: SELECT field1_index, field2_index FROM test_table WHERE field1_index = '1' OR field2_index = '1' ...You can also solve the problem efficiently by using a UNION that combines the output of two separate SELECT ...
https://dev.mysql.com/doc/refman/8.4/en/key-cache-block-size.html
It is possible to specify the size of the block buffers for an individual key cache using the key_cache_block_size variable. But setting the size of key nodes equal to the size of the I/O buffer does not always ensure the best overall performance.
https://dev.mysql.com/doc/refman/8.4/en/shared-key-cache.html
Threads can access key cache buffers simultaneously, subject to the following conditions: A buffer that is not being updated can be accessed by multiple sessions. Shared access to the key cache enables the server to improve throughput significantly. A buffer that is being updated causes sessions that need to use it to wait until the update is ...
https://dev.mysql.com/doc/internals/en/public-key-retrieval.html
If the client doesn't have the public key it can ask for it by: sending 0x01 as auth response in the Protocol::HandshakeResponse41 server will send a Protocol::AuthMoreData with the keyfile client sends the encrypted password .
https://dev.mysql.com/doc/internals/en/creating-index-keys.html
As part of every table-write operation (INSERT, UPDATE, DELETE), the storage engine is required to update its internal index information. The method used to update indexes will vary from storage engine to storage engine, depending on the method ...