Search Results
https://dev.mysql.com/doc/refman/8.4/en/correlated-subqueries.html
The predicate must employ the equality operator = for making the comparison; the null-safe <=> operator is not supported in this context. A correlated subquery is a subquery that contains a reference to a table that also appears in the outer query.
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary.html
MySQL Server incorporates a transactional data dictionary that stores information about database objects. In previous MySQL releases, dictionary data was stored in metadata files, nontransactional tables, and storage engine-specific data ...
https://dev.mysql.com/doc/refman/8.4/en/delete-optimization.html
Truncate operations are not transaction-safe; an error occurs when attempting one in the course of an active transaction or active table lock. The time required to delete individual rows in a MyISAM table is exactly proportional to the number of ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-stored-procs.html
This hybrid form of replication “knows” whether statement-level replication can safely be used, or row-level replication is required. Where can I find documentation for MySQL stored procedures and stored functions? A.4.3. Where can I find the ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-bootstrap.html
The process of starting a group for the first time is called bootstrapping. The bootstrap should only be done by a single server, the one that starts the group and only once. This is why the value of the group_replication_bootstrap_group option was ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-restarting-group.html
Follow this procedure to restart a replication group safely after every member shuts down. Group Replication is designed to ensure that the database service is continuously available, even if some of the servers that form the group are currently ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-throttling.html
This means that every member has an established write quota based on the available capacity, in other words a number of transactions it can safely issue for the next period. Based on the metrics gathered across all servers in the group, a ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-upgrade.html
Group Replication includes compatibility policies that enable you to safely combine members running different versions of MySQL in the same group during the upgrade procedure. This section explains how to upgrade a Group Replication setup. The ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-tuning.html
Given that the maximum row size for an InnoDB table is around 8K, KEY_BLOCK_SIZE=8 is usually a safe choice. Most often, the internal optimizations described in InnoDB Data Storage and Compression ensure that the system runs well with compressed ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-table-close.html
In this setup, it is safe to use CHECK TABLE, although you might get the warning from other servers. Each MyISAM index file (.MYI file) has a counter in the header that can be used to check whether a table has been closed properly. If you get the ...