Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-filtering.html
Events are processed in a producer/consumer fashion: Instrumented code is the source for events and produces events to be collected. The setup_instruments table lists the instruments for which events can be collected, whether they are enabled, and ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-firewall-groups-table.html
The firewall_groups table provides a view into the in-memory data cache for MySQL Enterprise Firewall. It lists names and operational modes of registered firewall group profiles. It is used in conjunction with the mysql.firewall_groups system table ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-functions.html
MySQL includes built-in SQL functions that format or retrieve Performance Schema data, and that may be used as equivalents for the corresponding sys schema stored functions. The built-in functions can be invoked in any schema and require no ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-memory-summary-tables.html
Operation counts help to understand or tune the overall pressure the server is putting on the memory allocator, which has an impact on performance. Allocating a single byte one million times is not the same as allocating one million bytes a single ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-mutex-instances-table.html
The mutex_instances table lists all the mutexes seen by the Performance Schema while the server executes. A mutex is a synchronization mechanism used in the code to enforce that only one thread at a given time can have access to some common ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-options.html
Performance Schema parameters can be specified at server startup on the command line or in option files to configure Performance Schema instruments and consumers. Runtime configuration is also possible in many cases (see Section 29.4, ...
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. Variables are persisted using ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-prepared-statements-instances-table.html
The Performance Schema provides instrumentation for prepared statements, for which there are two protocols: The binary protocol. This is accessed through the MySQL C API and maps onto underlying server commands as shown in the following table. C ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-queries.html
Pre-filtering limits which event information is collected and is independent of any particular user. By contrast, post-filtering is performed by individual users through the use of queries with appropriate WHERE clauses that restrict what event ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-applier-status-table.html
This table shows the current general transaction execution status on the replica. The table provides information about general aspects of transaction applier status that are not specific to any thread involved. Thread-specific status information is ...