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-mode.html
Example: SELECT group_replication_switch_to_multi_primary_mode() All members which belong to the group become primaries. Example: SELECT group_replication_switch_to_single_primary_mode(member_uuid); For more information, see Section 20.5.1.2, ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-group-write-consensus.html
This section explains how to inspect and configure the maximum number of consensus instances at any time for a group. This maximum is referred to as the event horizon for a group, and is the maximum number of consensus instances that the group can ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-limitations.html
From MySQL 8.0.19, you can use the options to configure client support for any selection of ciphersuites, including only non-default ciphersuites if you want. Limit on Group Size Limits on Transaction Size The following known limitations exist for ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-online-upgrade-combining-versions.html
Group Replication is versioned according to the MySQL Server version that the Group Replication plugin was bundled with. For example, if a member is running MySQL 5.7.26 then that is the version of the Group Replication plugin. For optimal ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-performance-xcom-cache.html
The same cache size limit should be set on all group members, because an unreachable member that is attempting to reconnect selects any other member at random for recovery of missed messages. When selecting a group_replication_message_cache_size ...
https://dev.mysql.com/doc/refman/8.0/en/help.html
URL: https://dev.mysql.com/doc/refman/8.0/en/mathematical-functions.html Examples: mysql> SELECT LOG(2); -> 0.69314718055995 mysql> SELECT LOG(-2); -> NULL List of topics. HELP 'search_string' The HELP statement returns online information from the ...
https://dev.mysql.com/doc/refman/8.0/en/host-cache.html
The Performance Schema host_cache table exposes the contents of the host cache so that it can be examined using SELECT statements. This table can be examined using SELECT statements, which may help you diagnose the causes of connection problems.
https://dev.mysql.com/doc/refman/8.0/en/identifier-case-sensitivity.html
The following statement would not work because it refers to a table both as my_table and as MY_TABLE: mysql> SELECT * FROM my_table WHERE MY_TABLE.col=1; Partition, subpartition, column, index, stored routine, event, and resource group names are not ... In MySQL, databases correspond to directories within the data ...
https://dev.mysql.com/doc/refman/8.0/en/implicit-commit.html
SELECT causes an implicit commit before and after the statement is executed when you are creating nontemporary tables. SELECT.) Statements that implicitly use or modify tables in the mysql database. The statements listed in this section (and any ...
https://dev.mysql.com/doc/refman/8.0/en/index-page-merge-threshold.html
For example: mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_INDEXES WHERE NAME='id_index' \G *************************** 1. If the “page-full” percentage for an index page falls below the MERGE_THRESHOLD value when a row is deleted or when a row ...