PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html
The slow shutdown can take minutes, or even hours in extreme cases where substantial amounts of data are still buffered. InnoDB Startup Options InnoDB System Variables System variables that are true or false can be enabled at server startup by ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl.html
Benefits of this feature include: Improved responsiveness and availability in busy production environments, where making a table unavailable for minutes or hours is not practical. The online DDL feature provides support for instant and in-place ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-innodb_cmpmem.html
For example, if every 60 minutes you archived the output of INNODB_CMPMEM_RESET, it would show the hourly statistics. The INNODB_CMPMEM and INNODB_CMPMEM_RESET tables provide status information about compressed pages that reside in the buffer pool.
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-innodb_cmp.html
For example, if you archive the output of INNODB_CMP_RESET every 60 minutes, you see the statistics for each hourly period. The INNODB_CMP and INNODB_CMP_RESET tables provide status information about operations related to compressed tables, which ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-events-table.html
The EVENTS table provides information about Event Manager events, which are discussed in Section 27.4, “Using the Event Scheduler”. The EVENTS table has these columns: EVENT_CATALOG The name of the catalog to which the event belongs.
https://dev.mysql.com/doc/refman/8.0/en/group-replication-responses-failure.html
From MySQL 8.0.21, it makes three automatic attempts to rejoin the group (with 5 minutes between each attempt), and if this auto-rejoin procedure does not work, it then stops trying to rejoin the group. Group Replication's failure detection ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-functions-for-new-primary.html
You can set a timeout from 0 seconds (immediately) up to 3600 seconds (60 minutes). The following function enables you to set a member of a single-primary replication group to take over as the primary. The current primary becomes a read-only ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-frequently-asked-questions.html
The member makes the specified number of auto-rejoin attempts five minutes apart. What is the maximum number of MySQL servers in a group? A group can consist of maximum 9 servers. Attempting to add another server to a group with 9 members causes the ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-cloning.html
In earlier releases, if you do see this error, after the remote cloning operation completes, wait two minutes to allow a round of garbage collection to take place to reduce the size of the group's certification information. If you want to use remote ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-change-primary.html
As of MySQL 8.0.29, you can specify a timeout from 1 to 3600 seconds (60 minutes) for transactions that are running when you use the function. This section explains how to change which member of a single-primary group is the primary, using the ...