Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-asynchronous-connection-failover-table.html
This table holds the replica's source lists for each replication channel for the asynchronous connection failover mechanism. The asynchronous connection failover mechanism automatically establishes an asynchronous (source to replica) replication ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-connection-status-table.html
This table shows the current status of the I/O thread that handles the replica's connection to the source, information on the last transaction queued in the relay log, and information on the transaction currently being queued in the relay log. The ...It contains values that change during the connection, whereas replication_connection_configuration contains values which define how the replica connects to the source and that remain constant during the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-group-member-stats-table.html
The replication_group_member_stats table has these columns: CHANNEL_NAME Name of the Group Replication channel VIEW_ID Current view identifier for this group. This has a different value for each member in the group. This also serves as a key because ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-group-members-table.html
This table shows network and status information for replication group members. The replication_group_members table has these columns: CHANNEL_NAME Name of the Group Replication channel. The network addresses shown are the addresses used to connect ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-user-variable-tables.html
The Performance Schema provides a user_variables_by_thread table that exposes user-defined variables. The user_variables_by_thread table has these columns: THREAD_ID The thread identifier of the session in which the variable is defined. The ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-tables-with-full-table-scans.html
These views display which tables are being accessed with full table scans. The schema_tables_with_full_table_scans and x$schema_tables_with_full_table_scans views have these columns: object_schema The schema name. rows_full_scanned The total number ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-rpd-column-id-table.html
The rpd_column_id table provides information about columns of tables that are loaded in the MySQL AI Engine. The rpd_column_id table has these columns: ID A unique identifier for the column. TABLE_ID The ID of the table to which the column belongs.
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-rpd-nodes-table.html
The rpd_nodes table has these columns: ID A unique identifier for the MySQL AI Engine (AI engine). The rpd_nodes table may not show the current status for a new node or newly configured node immediately. The rpd_nodes table is updated after the node ...If a query starts and finishes in the four seconds between refreshes, the memory used by the query is not accounted for in the reported ...
https://dev.mysql.com/doc/refman/8.4/en/firewall-reference.html
Typically, the MYSQL_FIREWALL server-side plugin stores its internal data (tables, stored procedures, and functions) in the mysql system database, but you can create and use a custom schema instead (see Installing MySQL Enterprise Firewall). For ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-restore-cluster.html
When performing ALTER TABLE operations, mysqld creates intermediate tables (whose names are prefixed with #sql-). To cause indexes to be ignored when restoring the table data, use the --disable-indexes option. When the --epoch option (short form: ...