PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/group-replication-plugin-architecture.html
The recovery component manages distributed recovery, and is responsible for getting a server that is joining the group up to date by selecting the donor, orchestrating the catch up procedure and reacting to donor failures. MySQL Group Replication ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-replication-group-member-stats.html
To use this table to monitor a Group Replication member, issue the following statement: mysql> SELECT * FROM performance_schema.replication_group_member_stats\G These columns are important for monitoring the performance of the members connected in ... Each member in a replication group certifies and applies transactions received by the ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-replication-group-members.html
The performance_schema.replication_group_members table is used for monitoring the status of the different server instances that are members of the group. The information in the table is updated whenever there is a view change, for example when the ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-secure-socket-layer-support-ssl.html
Once the donor is selected, the server joining the group establishes an asynchronous replication connection. Group communication connections as well as recovery connections, are secured using SSL. Configuring SSL for Group Replication Recovery ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-view-changes.html
Meanwhile, the server joining the group selects the donor from the list of online servers as stated by the membership service through the view abstraction. This section explains the process which controls how the view change identifier is ...
https://dev.mysql.com/doc/refman/5.7/en/index-condition-pushdown-optimization.html
If we know a person's zipcode value but are not sure about the last name, we can search like this: SELECT * FROM people WHERE zipcode='95054' AND lastname LIKE '%etrunia%' AND address LIKE '%Main Street%'; MySQL can use the index to scan through ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-character-sets-table.html
The following statements are equivalent: SELECT * FROM INFORMATION_SCHEMA.CHARACTER_SETS [WHERE CHARACTER_SET_NAME LIKE 'wild'] SHOW CHARACTER SET [LIKE 'wild'] . The CHARACTER_SETS table has these columns: CHARACTER_SET_NAME The character set name.
https://dev.mysql.com/doc/refman/5.7/en/information-schema-collations-table.html
The following statements are equivalent: SELECT COLLATION_NAME FROM INFORMATION_SCHEMA.COLLATIONS [WHERE COLLATION_NAME LIKE 'wild'] SHOW COLLATION [LIKE 'wild'] . The COLLATIONS table provides information about collations for each character set.
https://dev.mysql.com/doc/refman/5.7/en/information-schema-engines-table.html
The following statements are equivalent: SELECT * FROM INFORMATION_SCHEMA.ENGINES SHOW ENGINES . This is particularly useful for checking whether a storage engine is supported, or to see what the default engine is. The ENGINES table has these ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-buffer-page-lru-table.html
The INNODB_BUFFER_PAGE_LRU table provides information about the pages in the InnoDB buffer pool; in particular, how they are ordered in the LRU list that determines which pages to evict from the buffer pool when it becomes full. The ...