Search Results
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, ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-tp-connections-table.html
This column and TP_PROCESSING_THREAD_NUMBER serve as a foreign key into the tp_thread_state table. The tp_connections table contains one row per connection managed by the Thread Pool plugin. Each row provides information about the current state of ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-tp-thread-group-state-table.html
In this case, they go into the reserved state and remain until needed again. The tp_thread_group_state table has one row per thread group in the thread pool. Each row provides information about the current state of a group. The ...
https://dev.mysql.com/doc/refman/8.4/en/point-in-time-recovery-binlog.html
To view events from the log, send mysqlbinlog output into a paging program: $> mysqlbinlog binlog_files | more Alternatively, save the output in a file and view the file in a text editor: $> mysqlbinlog binlog_files > tmpfile $> ... This section ...