PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-error-summary-tables.html
Example error event summary information: mysql> SELECT * FROM performance_schema.events_errors_summary_global_by_error WHERE SUM_ERROR_RAISED <> 0\G *************************** 1. The Performance Schema maintains summary tables for aggregating ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-statements-current-table.html
Consequently, values selected from the DIGEST_TEXT column of statement event tables may appear to exceed the performance_schema_max_digest_length value. SELECT_FULL_JOIN Like the Select_full_join status variable, but specific to the statement. The ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-transactions-current-table.html
For example: mysql> SELECT * FROM performance_schema.events_transactions_current LIMIT 1\G *************************** 1. The table stores one row per thread showing the current status of the thread's most recent monitored transaction event, so ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-waits-current-table.html
Assume a join query of the following form that is executed using a table join order of t1, t2, t3: SELECT ... The table stores one row per thread showing the current status of the thread's most recent monitored wait event, so there is no system ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-host-cache-table.html
Because the host_cache table exposes the contents of the host cache, it can be examined using SELECT statements. The MySQL server maintains an in-memory host cache that contains client host name and IP address information and is used to avoid ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-instrumentation-checking.html
It is always possible to determine what instruments the Performance Schema includes by checking the setup_instruments table. Changes to this code occur often, which also affects the set of instruments. It is not practical to list all the ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-keyring-component-status-table.html
The keyring_component_status table (available as of MySQL 8.0.24) provides status information about the properties of the keyring component in use, if one is installed. The table is empty if no keyring component is installed (for example, if the ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-log-status-table.html
The BACKUP_ADMIN privilege, as well as the SELECT privilege, is required for access to the log_status table. The log_status table provides information that enables an online backup tool to copy the required log files without locking those resources ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-memory-model.html
This query shows the information associated with the memory instruments: SELECT * FROM performance_schema.memory_summary_global_by_event_name WHERE EVENT_NAME LIKE 'memory/performance_schema/%'; . Memory used depends on the load actually seen, not ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-memory-summary-tables.html
Example memory event summary information: mysql> SELECT * FROM performance_schema.memory_summary_global_by_event_name WHERE EVENT_NAME = 'memory/sql/TABLE'\G *************************** 1. Operation counts help to understand or tune the overall ...