Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-host-cache-table.html
The MySQL server maintains an in-memory host cache that contains client host name and IP address information and is used to avoid Domain Name System (DNS) lookups. The host_cache_size system variable controls the size of the host cache, as well as ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-miscellaneous-tables.html
The following sections describe tables that do not fall into the table categories discussed in the preceding sections: component_scheduler_tasks: The current status of each scheduled task. user_defined_functions: Loadable functions registered by a ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-applier-configuration-table.html
This is escaped so that it can be copied into an SQL statement to execute individual transactions. This table shows the configuration parameters that affect transactions applied by the replica. Parameters stored in the table can be changed at ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-group-member-actions-table.html
CRITICAL means that the member moves into ERROR state, and takes the action specified by the group_replication_exit_state_action system variable. This table lists the member actions that are included in the member actions configuration for ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-restrictions.html
For example, if you select events from a performance_schema table into a temporary table, intending to join that table with the original table later, there might be no matches. The Performance Schema avoids using mutexes to collect or produce data, ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-runtime-configuration.html
Put the statements for each monitoring configuration into their own file and specify the appropriate file as the init_file value when you start the server. Specific Performance Schema features can be enabled at runtime to control which types of ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-setup-instruments-table.html
The setup_instruments table lists classes of instrumented objects for which events can be collected: mysql> SELECT * FROM performance_schema.setup_instruments\G *************************** 1. row *************************** NAME: ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-statement-summary-tables.html
Statement Digest Aggregation Rules If the statements_digest consumer is enabled, aggregation into events_statements_summary_by_digest occurs as follows when a statement completes. The Performance Schema maintains tables for collecting current and ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-table-descriptions.html
These do not fall into any of the other table groups. Tables in the performance_schema database can be grouped as follows: Setup tables. The events_waits_current table contains the most recent event for each thread. Other similar tables contain ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-timing.html
Processor cycle rate might change, such as when a laptop goes into power-saving mode or when a CPU slows down to reduce heat generation. Events are collected by means of instrumentation added to the server source code. Instruments time events, ...