PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.1Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-partitioning.html
There may be situations where you have a single source server and want to replicate different databases to different replicas. Figure 19.2 Replicating Databases to Separate Replicas You can achieve this separation by configuring the source and ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-scaleout.html
Because replication works from the distribution of one source to one or more replicas, using replication for scale-out works best in an environment where you have a high number of reads and low number of writes/updates. Updates only occur during ...
https://dev.mysql.com/doc/refman/8.0/en/start-group-replication.html
If super_read_only=ON is set and the member should join as a primary, super_read_only is set to OFF once Group Replication successfully starts. In MySQL 8.0.21 and later, you can specify user credentials for distributed recovery on the START ...
https://dev.mysql.com/doc/refman/8.0/en/stored-program-variables.html
System variables and user-defined variables can be used in stored programs, just as they can be used outside stored-program context. In addition, stored programs can use DECLARE to define local variables, and stored routines (procedures and ...To ...
https://dev.mysql.com/doc/refman/8.0/en/temporary-files.html
On Windows, MySQL checks in order the values of the TMPDIR, TEMP, and TMP environment variables. For the first one found to be set, MySQL uses it and does not check those remaining. Paths should be separated by colon characters (:) on Unix and ...
https://dev.mysql.com/doc/refman/8.0/en/thread-pool-installation.html
For general information about installing plugins, see Section 7.6.1, “Installing and Uninstalling Plugins”. The file name suffix differs per platform (for example, .so for Unix and Unix-like systems, .dll for Windows). Thread Pool Installation ... This section describes how to install MySQL Enterprise Thread ...
https://dev.mysql.com/doc/refman/8.0/en/using-mysqldump.html
Tip Consider using the MySQL Shell dump utilities, which provide parallel dumping with multiple threads, file compression, and progress information display, as well as cloud features such as Oracle Cloud Infrastructure Object Storage streaming, and ...Dumps can be easily imported into a MySQL Server instance or a MySQL HeatWave DB System using the MySQL Shell load dump ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations-partitioning-keys-unique-keys.html
This section discusses the relationship of partitioning keys with primary keys and unique keys. However, you can add a unique key that uses both c1 and c2. The rule governing this relationship can be expressed as follows: All columns used in the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-threads-monitor-worker.html
The message lists the following statistics for the relevant replication channel, or the default replication channel (which is not named): Seconds elapsed The difference in seconds between the current time and the last time this information was ...
https://dev.mysql.com/doc/refman/8.0/en/charset-mysql.html
For more complete information, see Section 12.10, “Supported Character Sets and Collations”. For example, the default collations for utf8mb4 and latin1 are utf8mb4_0900_ai_ci and latin1_swedish_ci, respectively. The INFORMATION_SCHEMA ... MySQL ...