Search Results
https://dev.mysql.com/doc/refman/8.4/en/fulltext-query-expansion.html
This is generally useful when a search phrase is too short, which often means that the user is relying on implied knowledge that the full-text search engine lacks. For example, a user searching for “database” may really mean that “MySQL”, ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-configuring-consistency-guarantees.html
Given the fact that the system detects failures and reconfigures itself automatically, the user may also expect that once the promotion takes place, the new primary is in the exact state, data-wise, as that of the old one. In other words, the user ... Although the Transaction Synchronization Points section explains that conceptually there are two synchronization points from which you can choose: on read or on write, these terms were a simplification and the terms used in Group Replication are: before and after transaction ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-responses-failure-exit.html
When the member is in offline mode, connected client users are disconnected on their next request and connections are no longer accepted, with the exception of client users that have the CONNECTION_ADMIN privilege (or the deprecated SUPER privilege). This exit action prevents both updates and stale reads (with the exception of reads by client users with the stated privileges), and enables proxy tools such as MySQL Router to recognize that the server is unavailable and redirect client ...
https://dev.mysql.com/doc/refman/8.4/en/macos-installation-launchd.html
Figure 2.6 MySQL Preference Pane: Location The Instances page includes an option to start or stop MySQL, and Initialize Database recreates the data/ directory. macOS uses launch daemons to automatically start, stop, and manage processes and ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-general-info.html
Instead, users of NDB Cluster binaries from Oracle should upgrade to the most recent binary release of NDB Cluster for supported platforms—these include RPMs that should work with most Linux distributions. NDB Cluster 8.4 users who build from ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-nodes-groups.html
(You should be aware that the number of LDM threads increases with the value of this parameter, but not in a strictly linear fashion, and that there are additional constraints on setting it; see the description of MaxNoOfExecutionThreads for more ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-metadata-locks-table.html
Metadata locking applies not just to tables, but also to schemas, stored programs (procedures, functions, triggers, scheduled events), tablespaces, user locks acquired with the GET_LOCK() function (see Section 14.14, “Locking Functions”), and ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin.html
Users communicate with the plugin by modifying the set of rules stored in this table. The plugin communicates with users by setting the message column of table rows. This plugin also supports a privilege (SKIP_QUERY_REWRITE) that protects a given ...
https://dev.mysql.com/doc/refman/8.4/en/server-configuration.html
Windows users may execute Section 2.3.2, “Configuration: Using MySQL Configurator” to help configure a MySQL server installation. This includes tasks such as configuring MySQL users, log files, the Windows service name, and sample databases.
https://dev.mysql.com/doc/refman/8.4/en/show-replicas.html
User: The replica server user name, as specified on the replica with the --report-user option. SHOW REPLICAS Displays a list of replicas currently registered with the source. SHOW REPLICAS should be executed on a server that acts as a replication ...