PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/range-optimization.html
During the extraction process, conditions that cannot be used for constructing the range condition are dropped, conditions that produce overlapping ranges are combined, and conditions that produce empty ranges are removed. The range access method ...
https://dev.mysql.com/doc/refman/8.0/en/replica-sql-thread-states.html
The Coordinator resumes scheduling when the size drops below this limit. The following list shows the most common states you may see in the State column for a replication SQL thread on a replica server. In MySQL 8.0.26, incompatible changes were ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-current-user.html
In some cases, such as statements that change passwords, the function reference is expanded before it is written to the binary log, so that the statement includes the user name. For all other cases, the name of the current user on the source is ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-memory.html
The safe way to restart a replica that is replicating MEMORY tables is to first drop or delete all rows from the MEMORY tables on the source and wait until those changes have replicated to the replica. When a replication source server shuts down ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-partitioning.html
DROP PARTITION) that act directly on partitions in such cases might produce different results on the source and the replica. Replication is supported between partitioned tables as long as they use the same partitioning scheme and otherwise have the ...
https://dev.mysql.com/doc/refman/8.0/en/slow-query-log.html
Administrative statements include ALTER TABLE, ANALYZE TABLE, CHECK TABLE, CREATE INDEX, DROP INDEX, OPTIMIZE TABLE, and REPAIR TABLE. The slow query log consists of SQL statements that take more than long_query_time seconds to execute and require ...
https://dev.mysql.com/doc/refman/8.0/en/solaris-installation.html
(By default mounting is done without this option.) Failing to do so causes a significant drop in performance when using the InnoDB storage engine on this platform. Note MySQL 8.0 supports Solaris 11.4 and higher MySQL on Solaris is available in a ...
https://dev.mysql.com/doc/refman/8.0/en/switchable-optimizations.html
Its value is a set of flags, each of which has a value of on or off to indicate whether the corresponding optimizer behavior is enabled or disabled. This variable has global and session values and can be changed at runtime. To see the current set of ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-setup-save.html
This enables you to alter the configuration temporarily for debugging or other purposes, then restore it to the previous state by invoking the ps_setup_reload_saved() procedure. To prevent other simultaneous calls to save the configuration, ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-redundant-indexes.html
The schema_redundant_indexes view displays indexes that duplicate other indexes or are made redundant by them. In the following column descriptions, the dominant index is the one that makes the redundant index redundant. The ...