Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-error-log-table.html
If no such log sink exists, no additional error events are written to the error_log table. Of the logs the MySQL server maintains, one is the error log to which it writes diagnostic messages (see Section 7.4.2, “The Error Log”). Typically, the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-functions.html
PS_THREAD_ID(connection_id) Given a connection ID, returns a BIGINT UNSIGNED value representing the Performance Schema thread ID assigned to the connection ID, or NULL if no thread ID exists for the connection ID. MySQL includes built-in SQL ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-obtaining-parent-events.html
The data_locks table shows only existing locks, so these considerations apply regarding which table contains the parent event: For transactions, the only choice is events_transactions_current. Rows of this table have a THREAD_ID column indicating ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-pre-filtering.html
Modifications to any of these tables affect monitoring immediately, with the exception that modifications to the setup_actors table affect only foreground threads created subsequent to the modification, not existing threads. Pre-filtering is done ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-quick-start.html
For example, use either of these statements to see what Performance Schema tables exist: mysql> SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'performance_schema'; +------------------------------------------------------+ | ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-asynchronous-connection-failover-table.html
The asynchronous connection failover mechanism automatically establishes an asynchronous (source to replica) replication connection to a new source from the appropriate list after the existing connection from the replica to its source fails. This ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-tables.html
After STOP REPLICA, the THREAD_ID columns become NULL and the SERVICE_STATE columns for threads that no longer exist have a value of OFF. This is similar to the information available from the SHOW REPLICA STATUS statement, but representation in ...
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-setup-objects-table.html
For existing rows, only the ENABLED and TIMED columns can be modified, by users with the UPDATE privilege on the table. The setup_objects table controls whether the Performance Schema monitors particular objects. This table has a maximum size of ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-statement-digests.html
If the table becomes full, the Performance Schema groups statements that have SCHEMA_NAME and DIGEST values not matching existing values in the table in a special row with SCHEMA_NAME and DIGEST set to NULL. The MySQL server is capable of ...