Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-accounts-table.html
The accounts table contains a row for each account that has connected to the MySQL server. For each account, the table counts the current and total number of connections. To set the table size explicitly, set the performance_schema_accounts_size ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-hosts-table.html
The hosts table contains a row for each host from which clients have connected to the MySQL server. For each host name, the table counts the current and total number of connections. To set the table size explicitly, set the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-query-profiling.html
The following example demonstrates how to use Performance Schema statement events and stage events to retrieve data comparable to profiling information provided by SHOW PROFILES and SHOW PROFILE statements. The setup_actors table can be used to ...
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-tables.html
replication_group_member_stats: Provides statistical information about group members and transactions in which they participate. This is similar to the information available from the SHOW REPLICA STATUS statement, but representation in table form is ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-setup-meters-table.html
This column can be modified DESCRIPTION: A string describing the meter.
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-summary-tables.html
Summary tables provide aggregated information for terminated events over time. The tables in this group summarize event data in different ways. Each summary table has grouping columns that determine how to group the data to be aggregated, and ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-table-wait-summary-tables.html
A DDL operation that changes the index structure of a table may cause the per-index statistics to be reset. The following sections describe the table I/O and lock wait summary tables: table_io_waits_summary_by_index_usage: Table I/O waits per index ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-thread-pool-tables.html
The following sections describe the Performance Schema tables associated with the thread pool plugin (see Section 7.6.3, “MySQL Enterprise Thread Pool”). They provide information about thread pool operation: tp_connections: Information about ...
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. This number is incremented when a statement starts executing, not when it finishes. QUERIES_QUEUED The number of statements received that were queued for execution.