PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-queries.html
Pre-filtering limits which event information is collected and is independent of any particular user. By contrast, post-filtering is performed by individual users through the use of queries with appropriate WHERE clauses that restrict what event ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-applier-status-by-worker-table.html
After STOP REPLICA, the THREAD_ID column becomes NULL, but the WORKER_ID value is preserved. This table provides details of the transactions handled by applier threads on a replica or Group Replication group member. For a single-threaded replica, ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-applier-status-table.html
This table shows the current general transaction execution status on the replica. The table provides information about general aspects of transaction applier status that are not specific to any thread involved. Thread-specific status information is ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-restrictions.html
If the values in this table for a given timer name are NULL, that timer is not supported on your platform. The Performance Schema avoids using mutexes to collect or produce data, so there are no guarantees of consistency and results can sometimes ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-rwlock-instances-table.html
WRITE_LOCKED_BY_THREAD_ID When a thread currently has an rwlock locked in exclusive (write) mode, WRITE_LOCKED_BY_THREAD_ID is the THREAD_ID of the locking thread, otherwise it is NULL. The rwlock_instances table lists all the rwlock (read write ...
https://dev.mysql.com/doc/refman/8.0/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 ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-summary-tables.html
Generally, the effect is to reset the summary columns to 0 or NULL, not to remove rows. Summary tables provide aggregated information for terminated events over time. The tables in this group summarize event data in different ways. Each summary ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-table-characteristics.html
Generally, the effect is to reset the summary columns to 0 or NULL, not to remove rows. The name of the performance_schema database is lowercase, as are the names of tables within it. Many tables in the performance_schema database are read only and ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-tp-thread-state-table.html
Note The Performance Schema table described here is available as of MySQL 8.0.14. Prior to MySQL 8.0.14, use the corresponding INFORMATION_SCHEMA table instead; see Section 28.5.4, “The INFORMATION_SCHEMA TP_THREAD_STATE Table”. The ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-users-table.html
This is NULL for an internal thread, or for a user session that failed to authenticate. The users table contains a row for each user who has connected to the MySQL server. For each user name, the table counts the current and total number of ...