PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations.html
This section discusses current restrictions and limitations on MySQL partitioning support. The following constructs are not permitted in partitioning expressions: Stored procedures, stored functions, loadable functions, or plugins. For a list of ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-frequently-asked-questions.html
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 request to join to be refused. This limit has been identified from testing and ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-summary.html
Group Replication is a technique that can be used to implement fault-tolerant systems. The replication group is a set of servers that each have their own entire copy of the data (a shared-nothing replication scheme), and interact with each other ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-ip-address-permissions.html
The Group Replication plugin has a configuration option to determine from which hosts an incoming Group Communication System connection can be accepted. If you set this option on a server s1, then when server s2 is establishing a connection to s1 ...If s2 is in the allowlist, then s1 accepts the connection, otherwise s1 rejects the connection attempt by ...
https://dev.mysql.com/doc/refman/5.7/en/group-by-handling.html
SQL-92 and earlier does not permit queries for which the select list, HAVING condition, or ORDER BY list refer to nonaggregated columns that are not named in the GROUP BY clause. SQL:1999 and later permits such nonaggregates per optional feature ...
https://dev.mysql.com/doc/refman/5.7/en/dba-dtrace-mysqld-ref.html
MySQL supports the following static probes, organized into groups of functionality. To identify each argument within the definitions they are provided with a descriptive name, but you must access the information using the corresponding argN ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table-partition-operations.html
Partitioning-related clauses for ALTER TABLE can be used with partitioned tables for repartitioning, to add, drop, discard, import, merge, and split partitions, and to perform partitioning maintenance. Simply using a partition_options clause with ...
https://dev.mysql.com/doc/refman/5.7/en/explain-output.html
The first condition is fulfilled when the query is implicitly grouped (contains an aggregate function but no GROUP BY clause). Consider the following implicitly grouped query: SELECT MIN(c1), MIN(c2) FROM t1; Suppose that MIN(c1) can be retrieved by ... The EXPLAIN statement provides information about how MySQL executes ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-background.html
Moreover, as servers are cooperating together to create the group several other classic distributed systems problems have to be dealt with, such as network partitioning or split brain scenarios. MySQL Group Replication provides distributed state ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-adding-instances.html
At this point, the group has one member in it, server s1, which has some data in it. It is now time to expand the group by adding the other two servers configured previously. The commands are the same as used when setting up server s1 as the user ...17.2.1.6.1 Adding a Second Instance In order to add a second instance, server s2, first create the configuration file for ...