Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-firewall-membership-table.html
The firewall_membership table provides a view into the in-memory data cache for MySQL Enterprise Firewall. It is used in conjunction with the mysql.firewall_membership system table that provides persistent storage of firewall data; see MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-persisted-variables-table.html
The persisted_variables table provides an SQL interface to the mysqld-auto.cnf file that stores persisted global system variable settings, enabling the file contents to be inspected at runtime using SELECT statements. The table contains a row for ...Variables are persisted using SET PERSIST or PERSIST_ONLY statements; see Section 15.7.6.1, “SET Syntax for Variable ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-applier-configuration-table.html
This table shows the configuration parameters that affect transactions applied by the replica. Parameters stored in the table can be changed at runtime with the CHANGE REPLICATION SOURCE TO statement. The replication_applier_configuration table has ...There is always a default replication channel, and more replication channels can be ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-applier-status-by-coordinator-table.html
For a multithreaded replica, the replica uses multiple worker threads and a coordinator thread to manage them, and this table shows the status of the coordinator thread. For a multithreaded replica, the replication_applier_status_by_worker table ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-applier-status-by-worker-table.html
This table provides details of the transactions handled by applier threads on a replica or Group Replication group member. A multithreaded replica also has a coordinator thread to manage the applier threads, and the status of this thread is shown ...For a single-threaded replica, data is shown for the replica's single applier ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-session-account-connect-attrs-table.html
For descriptions of common attributes, see Section 29.12.9, “Performance Schema Connection Attribute Tables”. The session_account_connect_attrs table contains connection attributes only for the current session, and other sessions associated with ... Application programs can provide key-value connection attributes to be passed to the server at connect ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-session-connect-attrs-table.html
For descriptions of common attributes, see Section 29.12.9, “Performance Schema Connection Attribute Tables”. To see connection attributes only for the current session, and other sessions associated with the session account, use the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-setup-consumers-table.html
The setup_consumers table has these indexes: Primary key on (NAME) TRUNCATE TABLE is not permitted for the setup_consumers table. For detailed information about the effect of enabling different consumers, see Section 29.4.7, “Pre-Filtering by ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-tp-thread-group-state-table.html
The tp_thread_group_state table has one row per thread group in the thread pool. The tp_thread_group_state table has these columns: TP_GROUP_ID The thread group ID. This is the same as MAX(TP_THREAD_NUMBER) for the threads when selected from the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-tp-thread-group-stats-table.html
The tp_thread_group_stats table has these columns: TP_GROUP_ID The thread group ID. TABLE_LOCK_WAITS The number of THD_WAIT_TABLE_LOCK waits for a table to be unlocked that the statement needs to access. The tp_thread_group_stats table has these ...