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/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
If synchronization of the object fails due to a temporary error, it is picked up and added back to the queue (and to this table) the next time NDB performs mismatch detection; if the attempts fails due a permanent error, the object is added to the ... 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 ...
https://dev.mysql.com/doc/refman/8.0/en/replication-mode-change-online-disable-gtids.html
Before you start, ensure that the servers meet the following pre-conditions: All servers in your topology must use MySQL 5.7.6 or later. If you use binary logs for anything other than replication—for example, to perform point-in-time backup or ...