Search Results
https://dev.mysql.com/doc/refman/8.4/en/fulltext-search-ngram.html
n=1: 'a', 'b', 'c', 'd' n=2: 'ab', 'bc', 'cd' n=3: 'abc', 'bcd' n=4: 'abcd' The ngram full-text parser is a built-in server plugin. As with other built-in server plugins, it is automatically loaded when the server is started. The built-in MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-functions-for-new-primary.html
The following function enables you to set a member of a single-primary replication group to take over as the primary. The current primary becomes a read-only secondary, and the specified group member becomes the read-write primary. The function can ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-getting-started.html
MySQL Group Replication is provided as a plugin for the MySQL server; each server in a group requires configuration and installation of the plugin. Tip To deploy multiple instances of MySQL, you can use InnoDB Cluster which enables you to easily ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-performance.html
If a member server instance leaves voluntarily or stops communicating with the group, the remaining members agree a reconfiguration of the group between themselves, and choose a new primary if needed. The information in this section is to help you ... Group Replication is designed to create fault-tolerant systems with built-in failure detection and automated ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-primary-secondary-replication.html
It is a shared-nothing system, where all servers have a full copy of the data by default. The arrows between the different instances represent messages exchanged between servers or messages exchanged between servers and the client application.
https://dev.mysql.com/doc/refman/8.4/en/implicit-commit.html
The statements listed in this section (and any synonyms for them) implicitly end any transaction active in the current session, as if you had done a COMMIT before executing the statement. Most of these statements also cause an implicit commit after ...
https://dev.mysql.com/doc/refman/8.4/en/index-condition-pushdown-optimization.html
Without ICP, the storage engine traverses the index to locate rows in the base table and returns them to the MySQL server which evaluates the WHERE condition for the rows. With ICP enabled, and if parts of the WHERE condition can be evaluated by ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-benefits.html
InnoDB tables have the following benefits: If the server unexpectedly exits because of a hardware or software issue, regardless of what was happening in the database at the time, you don't need to do anything special after restarting the database.
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-tuning-monitoring.html
It involves relatively low overhead on the server, so you might query it periodically on a production server to check the overall efficiency of the compression feature. Overall application performance, CPU and I/O utilization and the size of disk ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-introduction.html
InnoDB is a general-purpose storage engine that balances high reliability and high performance. Unless you have configured a different default storage engine, issuing a CREATE TABLE statement without an ENGINE clause creates an InnoDB table. Key ...