PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/group-replication-network-partitioning.html
This is the case for regular transactions but is also required for group membership changes and some internal messaging that keeps the group consistent. In practice, this means that a server that is leaving tells others that it is going away. This ... The group needs to achieve consensus whenever a change that needs to be replicated ...
https://dev.mysql.com/doc/refman/5.7/en/show-table-status.html
You can also get this list using the mysqlshow --status db_name command. For other storage engines, such as InnoDB, this value is an approximation, and may vary from the actual value by as much as 40% to 50%. (This is also true if the InnoDB table ... SHOW TABLE STATUS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLE STATUS works likes SHOW TABLES, but provides a lot of information about each non-TEMPORARY ...
https://dev.mysql.com/doc/refman/5.7/en/user-variables.html
This enables you to pass values from one statement to another. (This is the same coercibility as for table column values.) Hexadecimal or bit values assigned to user variables are treated as binary strings. This does not currently include contexts ... You can store a value in a user-defined variable in one statement and refer to it later in another ...
https://dev.mysql.com/doc/refman/5.7/en/x-plugin-options-system-variables.html
To control activation of X Plugin, use this option: --mysqlx[=value] Command-Line Format --mysqlx[=value] Introduced 5.7.12 Type Enumeration Default Value ON Valid Values ONOFFFORCEFORCE_PLUS_PERMANENT This option controls how the server loads X ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-nutshell.html
To use this capability to initialize a MySQL installation, if you previously invoked mysql_install_db manually, invoke mysqld with the --initialize or --initialize-insecure option, depending on whether you want the server to generate a random ...A ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-failover.html
This means that the ndb_apply_status table contains information for the replica on this host as well as for any other host which acts as a replica of the replication source server running on this host. In this case, you need to determine the latest ... In the event that the primary Cluster replication process fails, it is possible to switch over to the secondary replication ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-enterprise-backup.html
This section explains how to back up and subsequently restore a Group Replication member using MySQL Enterprise Backup. In this example, we assume the hosts are both Linux servers and use SCP to copy the files between them: s2/backups> scp ... MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-tables-table.html
For other storage engines, such as InnoDB, this value is an approximation, and may vary from the actual value by as much as 40% to 50%. (This is also true if the InnoDB table is partitioned.) AVG_ROW_LENGTH The average row length. Refer to the notes ...The TABLES table has these columns: TABLE_CATALOG The name of the catalog to which the table ...
https://dev.mysql.com/doc/refman/5.7/en/nested-join-optimization.html
This is a conservative extension if we consider each comma in a list of table_reference items as equivalent to an inner join. Suppose that a join query over 3 tables T1,T2,T3 has this form: SELECT * FROM T1 INNER JOIN T2 ON P1(T1,T2) INNER JOIN T3 ...The following discussion refers to the join syntax described in Section 13.2.9.2, “JOIN ...
https://dev.mysql.com/doc/refman/5.7/en/replication-mode-change-online-enable-gtids.html
This section describes how to enable GTID transactions, and optionally auto-positioning, on servers that are already online and using anonymous transactions. This procedure does not require taking the server offline and is suited to use in ...