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-instrument-naming.html
An instrument name consists of a sequence of elements separated by '/' characters. Example names: wait/io/file/myisam/log wait/io/file/mysys/charset wait/lock/table/sql/handler wait/synch/cond/mysys/COND_alarm ...
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-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-quick-start.html
This section briefly introduces the Performance Schema with examples that show how to use it. For additional examples, see Section 29.19, “Using the Performance Schema to Diagnose Problems”. To enable or disable it explicitly, start the server ...
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 ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-group-member-actions-table.html
This table lists the member actions that are included in the member actions configuration for replication group members. You can reset the member actions configuration using the group_replication_reset_member_actions() function. The ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-restrictions.html
The Performance Schema avoids using mutexes to collect or produce data, so there are no guarantees of consistency and results can sometimes be incorrect. If you save event information in another table, you should not assume that the original events ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-runtime-configuration.html
Specific Performance Schema features can be enabled at runtime to control which types of event collection occur. If you have the UPDATE privilege, you can change Performance Schema operation by modifying setup tables to affect how monitoring occurs. For additional details about these tables, see Section 29.12.2, “Performance Schema Setup ...
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: ...