https://dev.mysql.com/performance-schema-startup-configuration.html
It is possible that a plugin installed later may create the instrument, at which time the name is recognized and configured. At runtime, SHOW VARIABLES displays the actual values that autosized parameters were set to. To use the MySQL Performance ...
https://dev.mysql.com/performance-schema-thread-pool-tables.html
They provide information about thread pool operation: tp_thread_group_state: Information about thread pool thread group states tp_thread_group_stats: Thread group statistics tp_thread_state: Information about thread pool thread states Rows in these ... Note The Performance Schema tables described here are available as of MySQL ...
https://dev.mysql.com/postinstallation.html
Optionally, populate time zone tables to enable recognition of named time zones. This section discusses tasks that you should perform after installing MySQL: If necessary, initialize the data directory and create the MySQL grant tables. For some ...
https://dev.mysql.com/prepared-statements-instances-table.html
These columns can be used to find stored programs that leak prepared statements: SELECT OWNER_OBJECT_TYPE, OWNER_OBJECT_SCHEMA, OWNER_OBJECT_NAME, STATEMENT_NAME, SQL_TEXT FROM performance_schema.prepared_statements_instances WHERE OWNER_OBJECT_TYPE ... The Performance Schema provides instrumentation for prepared statements, for which there are two protocols: The binary ...
https://dev.mysql.com/processlist-table.html
See Section 5.1.10, “Server Status Variables” TIME The time in seconds that the thread has been in its current state. For a slave SQL thread, the value is the number of seconds between the timestamp of the last replicated event and the real time ... The PROCESSLIST table provides information about which threads are ...
https://dev.mysql.com/replication-administration-status.html
The MASTER_HEARTBEAT_PERIOD setting on the master (set by the CHANGE MASTER TO statement) specifies the frequency of the heartbeat, which defaults to half of the connection timeout interval for the slave (slave_net_timeout). A high number (or an ...
https://dev.mysql.com/replication-applier-status-by-worker-table.html
The applier threads on a multithreaded slave are sometimes called workers. When the Performance Schema is disabled, local timing information is not collected, so the fields showing the start and end timestamps for applied transactions are zero. The ... This table provides details of the transactions handled by applier threads on a replication slave or Group Replication group ...
https://dev.mysql.com/replication-features-timeout.html
The global system variable slave_transaction_retries sets the maximum number of times for applier threads on a single-threaded or multithreaded replication slave to automatically retry failed transactions before stopping. Transactions are ...If a ...
https://dev.mysql.com/replication-mode-change-online-verify-transactions.html
Or wait for a day, or whatever time period you consider safe for your deployment. This section explains how to monitor a replication topology and verify that all anonymous transactions have been replicated. This is helpful when changing the ...
https://dev.mysql.com/replication-sbr-rbr.html
If there is an error in evaluation on the slave, particularly when executing complex statements, statement-based replication may slowly increase the margin of error across the affected rows over time. This also means that making and restoring a ...
