Search Results
https://dev.mysql.com/doc/refman/8.4/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 You can also use the following statement: mysql> TABLE ... Each member in a replication ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-replication-group-members.html
Shown in the table is each member's server_uuid, as well as the member's host name and port number, which clients use to connect to it. The performance_schema.replication_group_members table is used for monitoring the status of the different server ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-security.html
This section explains how to secure a group, securing the connections between members of a group, or by establishing a security perimeter using an IP address allowlist.
https://dev.mysql.com/doc/refman/8.4/en/group-replication-server-states.html
Other group members can connect to it, as can clients if applicable. This can happen if a member is disconnected involuntarily, for example. The state of a Group Replication group member shows its current role in the group. The Performance Schema ...
https://dev.mysql.com/doc/refman/8.4/en/history.html
We started out with the intention of using the mSQL database system to connect to our tables using our own fast low-level (ISAM) routines. However, after some testing, we came to the conclusion that mSQL was not fast enough or flexible enough for ...
https://dev.mysql.com/doc/refman/8.4/en/index-statistics.html
Setting the session value affects statistics collection only for the current client connection. Storage engines collect statistics about tables for use by the optimizer. Table statistics are based on value groups, where a value group is a set of ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-introduction.html
INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server such as the name of a database or table, the data type of a column, or access privileges. Other terms that are sometimes used for this information are data ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-table-reference.html
The following table summarizes all available INFORMATION_SCHEMA tables. For greater detail, see the individual table descriptions. Table 28.1 INFORMATION_SCHEMA Tables Table Name Description Deprecated ADMINISTRABLE_ROLE_AUTHORIZATIONS Grantable ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-tp-thread-state-table.html
For example, if an application uses this query: SELECT * FROM INFORMATION_SCHEMA.TP_THREAD_STATE; The application should use this query instead: SELECT * FROM performance_schema.tp_thread_state; The TP_THREAD_STATE table has one row per thread ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-data-encryption.html
The default_table_encryption variable can be set for an individual client connection or globally using SET syntax. InnoDB supports data-at-rest encryption for file-per-table tablespaces, general tablespaces, the mysql system tablespace, redo logs, ...