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/group-replication-functions-for-member-actions.html
When this member action is enabled and taken, super read-only mode is disabled on the primary, so that the primary becomes read-write and accepts updates from a replication source server and from clients. The following functions can be used to ...
https://dev.mysql.com/doc/refman/8.0/en/connection-interfaces.html
Linux or Solaris should be able to support at least 500 to 1000 simultaneous connections routinely and as many as 10,000 connections if you have many gigabytes of RAM available and the workload from each is low or the response time target ...Network ... This section describes aspects of how the MySQL server manages client ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-limitations.html
Note that the limitations and issues described for multi-primary mode groups can also apply in single-primary mode clusters during a failover event, while the newly elected primary flushes out its applier queue from the old primary. The ... Limit on ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-check-constraints.html
CHECK constraints are evaluated for INSERT, UPDATE, REPLACE, LOAD DATA, and LOAD XML statements and an error occurs if a constraint evaluates to FALSE. Prior to MySQL 8.0.16, CREATE TABLE permits only the following limited version of table CHECK ...
https://dev.mysql.com/doc/refman/8.0/en/group-by-modifiers.html
In this case, each time there is a change in value in any but the last grouping column, the query produces an extra super-aggregate summary row. Following each set of rows for a given year, an extra super-aggregate summary row appears showing the ...
https://dev.mysql.com/doc/refman/8.0/en/installing-source-distribution.html
To install MySQL from a standard source distribution: Verify that your system satisfies the tool requirements listed at Section 2.8.2, “Source Installation Prerequisites”. Configure, build, and install the distribution using the instructions in ...Obtain a distribution file using the instructions in Section 2.1.3, “How to Get ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-install-linux-binary.html
We recommend that you do this when installing or upgrading NDB Cluster, even if you plan to use only one of them, since this saves time and trouble in the event that you later decide to change from one to the other. Change location to the directory ... This section covers the steps necessary to install the correct executables for each type of Cluster node from precompiled binaries supplied by ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-logs-cluster-log.html
LCPFragmentCompleted Checkpoint 11 INFO Node node_id: ACC Blocked num_1 and TUP Blocked num_2 times last second Undo logging is blocked because the log buffer is close to overflowing. The cause of the problem is given as one of Busy, Election with ...For information about the cluster log, log events, and event types, see Section 25.6.3, “Event Reports Generated in NDB ...
https://dev.mysql.com/doc/refman/8.0/en/invisible-columns.html
To update invisible columns for UPDATE statements, name them and assign a value, just as for visible columns. As an illustration of when invisible columns may be useful, suppose that an application uses SELECT * queries to access a table, and must ...An invisible column is normally hidden to queries, but can be accessed if explicitly ...
https://dev.mysql.com/doc/refman/8.0/en/identifier-case-sensitivity.html
Each table within a database corresponds to at least one file within the database directory (and possibly more, depending on the storage engine). Consequently, the case sensitivity of the underlying operating system plays a part in the case ... In ...