PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
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-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/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/replication-features-timeout.html
This data includes timestamps showing how long it took the applier thread to apply the last transaction from start to finish (and when the transaction currently in progress was started), and how long this was after the commit on the original source ... The global value of the system variable replica_transaction_retries (from MySQL 8.0.26) or slave_transaction_retries (before MySQL 8.0.26) sets the maximum number of times for applier threads on a single-threaded or multithreaded replica to automatically retry failed transactions before ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-params-api.html
The listing in this section provides information about parameters used in the [mysqld] and [api] sections of a config.ini file for configuring NDB Cluster SQL nodes and API nodes. For detailed descriptions and other additional information about ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-performance-spin_lock_polling.html
InnoDB mutexes and rw-locks are typically reserved for short intervals. On a multi-core system, it can be more efficient for a thread to continuously check if it can acquire a mutex or rw-lock for a period of time before it sleeps. If the mutex or ...However, too-frequent polling of a shared object such as a mutex or rw-lock by multiple threads can cause “cache ping pong”, which results in processors invalidating portions of each other's ...