Search Results
MySQL 8.4 Reference Manual :: A.11 MySQL 8.4 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
https://dev.mysql.com/doc/refman/8.4/en/faqs-cjk.html
The collation used for a Unicode character set determines the ability to sort (that is, distinguish) characters in the set: Collations based on Unicode Collation Algorithm (UCA) 4.0.0 distinguish only BMP characters. This set of Frequently Asked ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-mysql-cluster.html
These distributed algorithms and protocols include global checkpointing, DDL (schema) changes, and node restart handling. In the following section, we answer questions that are frequently asked about MySQL NDB Cluster and the NDB storage engine.
https://dev.mysql.com/doc/refman/8.4/en/faqs-security.html
Where can I find documentation that addresses security issues for MySQL? A.9.2. Is SSL support built into MySQL binaries, or must I recompile the binary myself to enable it? A.9.5. Does MySQL include support for Roles Based Access Control (RBAC)? ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-background.html
At the very core of this technology lies an implementation of the Paxos algorithm. The most common way to create a fault-tolerant system is to resort to making components redundant, in other words the component can be removed and the system should ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-distributed-recovery-connections.html
The group_replication_recovery_compression_algorithms and group_replication_recovery_zstd_compression_level system variables determine permitted compression algorithms, and the zstd compression level used when carrying out state transfer from a ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-fault-tolerance.html
MySQL Group Replication builds on an implementation of the Paxos distributed algorithm to provide distributed coordination between servers. As such, it requires a majority of servers to be active to reach quorum and thus make a decision. This has ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-understanding-consistency-guarantees.html
Although Group Replication is written using Group Communication System (GCS) protocols that implement the Paxos algorithm, some parts of Group Replication are asynchronous, which implies that data is asynchronously applied to secondaries. In terms ...
https://dev.mysql.com/doc/refman/8.4/en/index-btree-hash.html
LIKE '%string%' and string is longer than three characters, MySQL uses the Turbo Boyer-Moore algorithm to initialize the pattern for the string and then uses this pattern to perform the search more quickly. Understanding the B-tree and hash data ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-tables-table.html
The allocation algorithm reserves memory in large amounts to reduce the number of allocation operations. The information_schema_stats_expiry system variable defines the period of time before cached table statistics expire. If there are no cached ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-analyze-table-complexity.html
ANALYZE TABLE complexity for InnoDB tables is dependent on: The number of pages sampled, as defined by innodb_stats_persistent_sample_pages. The number of indexed columns in a table The number of partitions. If a table has no partitions, the number ...