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/partitioning-info.html
From MySQL 8.0.16, when insertions, deletions, or updates are made to partitioned tables, the binary log records information about the partition and (if any) the subpartition in which the row event took place. The partition information is displayed ... This section discusses obtaining information about existing partitions, which can be done in a number of ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-key.html
Partitioning by key is similar to partitioning by hash, except that where hash partitioning employs a user-defined expression, the hashing function for key partitioning is supplied by the MySQL server. Note Tables using the NDB storage engine are ...NDB Cluster uses MD5() for this purpose; for tables using other storage engines, the server employs its own internal hashing ...
https://dev.mysql.com/doc/refman/8.0/en/pluggable-storage.html
MySQL Server uses a pluggable storage engine architecture that enables storage engines to be loaded into and unloaded from a running MySQL server. Plugging in a Storage Engine Before a storage engine can be used, the storage engine plugin shared ...
https://dev.mysql.com/doc/refman/8.0/en/precision-math-expressions.html
Prior to MySQL 8.0.31, for DECIMAL literals, in addition to the precision limit of 65 digits, there is a limit on how long the text of the literal can be. With the ERROR_FOR_DIVISION_BY_ZERO SQL mode enabled, MySQL handles division by zero ... With ...
https://dev.mysql.com/doc/refman/8.0/en/problems-with-float.html
Floating-point numbers sometimes cause confusion because they are approximate and not stored as exact values. For DECIMAL columns, MySQL performs operations with a precision of 65 decimal digits, which should solve most common inaccuracy problems.
https://dev.mysql.com/doc/refman/8.0/en/replication-binlog-encryption-encryption-keys.html
The binary log encryption keys used to encrypt the file passwords for the log files are 256-bit keys that are generated specifically for each MySQL server instance using MySQL Server's keyring service (see Section 8.4.4, “The MySQL Keyring”).
https://dev.mysql.com/doc/refman/8.0/en/replication-channels.html
In MySQL multi-source replication, a replica opens multiple replication channels, one for each source server. For instructions to configure sources and replicas for multi-source replication, to start, stop and reset multi-source replicas, and to ...
https://dev.mysql.com/doc/refman/8.0/en/replication-multi-source-reset-replica.html
The RESET REPLICA statement can be used to reset a multi-source replica. By default, if you use the RESET REPLICA statement on a multi-source replica all channels are reset. Optionally, use the FOR CHANNEL channel clause to reset only a specific ...
https://dev.mysql.com/doc/refman/8.0/en/replication-multi-source-stop-replica.html
The STOP REPLICA statement can be used to stop a multi-source replica. By default, if you use the STOP REPLICA statement on a multi-source replica all channels are stopped. Optionally, use the FOR CHANNEL channel clause to stop only a specific ...
https://dev.mysql.com/doc/refman/8.0/en/replication-privilege-checks-account.html
From MySQL 8.0.19, the REQUIRE_ROW_FORMAT setting can be applied to secured channels, which restricts the channel from executing events that would require these privileges. The REPLICATION_APPLIER privilege explicitly or implicitly allows the ...