PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.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
The available member actions are as follows: mysql_disable_super_read_only_if_primary This member action is available from MySQL 8.0.26. Example: SELECT group_replication_disable_member_action("mysql_disable_super_read_only_if_primary", ... The ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-replication-technologies.html
Before getting into the details of MySQL Group Replication, this section introduces some background concepts and an overview of how things work. This provides some context to help understand what is required for Group Replication and what the ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-responses-failure-partition.html
You can use the system variable group_replication_unreachable_majority_timeout to set a number of seconds for a member to wait after losing contact with the majority of group members, and then exit the group. Setting a timeout means you do not need ... By default, members that find themselves in a minority due to a network partition do not automatically leave the ...
https://dev.mysql.com/doc/refman/8.0/en/identifier-length.html
This applies to identifiers in table definitions and to identifiers stored in the grant tables in the mysql database. Values such as user name and host names in MySQL account names are strings rather than identifiers. The following table describes ...
https://dev.mysql.com/doc/refman/8.0/en/identifier-mapping.html
For the basic structure, MySQL represents each database as a directory in the data directory, and depending upon the storage engine, each table may be represented by one or more files in the appropriate database directory. MySQL encodes any ...
https://dev.mysql.com/doc/refman/8.0/en/implicit-commit.html
SELECT.) Statements that implicitly use or modify tables in the mysql database. The statements listed in this section (and any synonyms for them) implicitly end any transaction active in the current session, as if you had done a COMMIT before ...
https://dev.mysql.com/doc/refman/8.0/en/index-extensions.html
EXPLAIN for the query produces this result: mysql> EXPLAIN SELECT COUNT(*) FROM t1 WHERE i1 = 3 AND d = '2000-01-01'\G *************************** 1. In this case, it can use the leftmost index prefix (d, i1) to produce a better execution plan: ...
https://dev.mysql.com/doc/refman/8.0/en/index-merge-optimization.html
In addition to using the optimizer_switch system variable to control optimizer use of the Index Merge algorithms session-wide, MySQL supports optimizer hints to influence the optimizer on a per-statement basis. The Index Merge access method ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-cached-indexes-table.html
N_CACHED_PAGES The total number of index pages cached in the InnoDB buffer pool for a specific index since MySQL Server last started. Examples This query returns the number of index pages cached in the InnoDB buffer pool for a specific index: mysql> ... The INNODB_CACHED_INDEXES table reports the number of index pages cached in the InnoDB buffer pool for each ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-datafiles-table.html
If a file-per-table tablespace is created in a location outside the MySQL data directory, the path value is a fully qualified directory path. Example mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_DATAFILES WHERE SPACE = 57\G ... The ...