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/group-replication-primary-secondary-replication.html
Traditional MySQL Replication provides a simple source to replica approach to replication. Figure 20.1 MySQL Asynchronous Replication There is also semisynchronous replication, which adds one synchronization step to the protocol. This means that ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-page-compression.html
Hole punching size is the NTFS compression unit, which is 16 times the NTFS cluster size. Before downgrading to an earlier version of MySQL that does not support page compression, uncompress the tables that use the page compression feature. InnoDB ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-purge-configuration.html
From MySQL 8.0.26, if the innodb_max_purge_lag setting is exceeded, purge work is automatically redistributed among available purge threads. When the purge lag exceeds the innodb_max_purge_lag threshold, a delay is imposed on INSERT, UPDATE, and ...
https://dev.mysql.com/doc/refman/8.0/en/ndb-restore-different-number-nodes.html
Note When changing the total number of LCP threads or LQH threads per node group, you should recreate the schema from backup created using mysqldump. $> mysqldump --no-data --routines --events --triggers --databases > myschema.sql Important Once you ... It is possible to restore from an NDB backup to a cluster having a different number of data nodes than the original from which the backup was ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-build-configuration.html
\ -DDISABLE_PSI_STAGE=1 \ -DDISABLE_PSI_STATEMENT=1 For more information, see the descriptions of the DISABLE_PSI_XXX CMake options in Section 2.8.7, “MySQL Source-Configuration Options”. If you install MySQL over a previous installation that ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-connection-tables.html
When a client connects to the MySQL server, it does so under a particular user name and from a particular host. Suppose that clients named user1 and user2 each connect one time from hosta and hostb. They differ in that, for grant tables, the host ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-ndb-cluster-tables.html
Table 29.3 Performance Schema NDB Tables Table Name Description ndb_sync_excluded_objects NDB objects which cannot be synchronized ndb_sync_pending_objects NDB objects waiting for synchronization Beginning with NDB 8.0.16, automatic synchronization ... The following table shows all Performance Schema tables relating to the NDBCLUSTER storage ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-status-monitoring.html
For example, if a mutex is instrumented in the server source but the server cannot allocate memory for the instrumentation at runtime, it increments Performance_schema_mutex_classes_lost. Other mutexes have an instance per connection, or per page in ...Names for these variables have several forms: Performance_schema_xxx_classes_lost indicates how many instruments of type xxx could not be ...
https://dev.mysql.com/doc/refman/8.0/en/precision-math.html
For example, MySQL treats a number such as .0001 as an exact value rather than as an approximation, and summing it 10,000 times produces a result of exactly 1, not a value that is merely “close” to 1. MySQL provides support for precision math: ...Precision math is based on these two features: SQL modes that control how strict the server is about accepting or rejecting invalid ...
https://dev.mysql.com/doc/refman/8.0/en/replication-binlog-encryption-key-rotation.html
When binary log encryption is enabled, you can rotate the binary log master key at any time while the server is running by issuing ALTER INSTANCE ROTATE BINLOG MASTER KEY. When you rotate the binary log master key manually, MySQL Server takes the ...You can rotate the binary log master key on a regular basis to comply with your organization's security policy, and also if you suspect that the current or any of the previous binary log master keys might have been ...