Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-cond-instances-table.html
The cond_instances table has these indexes: Primary key on (OBJECT_INSTANCE_BEGIN) Index on (NAME) TRUNCATE TABLE is not permitted for the cond_instances table. The cond_instances table lists all the conditions seen by the Performance Schema while ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-connection-attribute-tables.html
Connection attributes are key-value pairs that application programs can pass to the server at connect time. For applications based on the C API implemented by the libmysqlclient client library, the mysql_options() and mysql_options4() functions ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-error-log-table.html
The error_log table has these indexes: Primary key on (LOGGED) Index on (THREAD_ID) Index on (PRIO) Index on (ERROR_CODE) Index on (SUBSYSTEM) TRUNCATE TABLE is not permitted for the error_log table. Of the logs the MySQL server maintains, one is ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-stages-current-table.html
The events_stages_current table has these indexes: Primary key on (THREAD_ID, EVENT_ID) TRUNCATE TABLE is permitted for the events_stages_current table. The table stores one row per thread showing the current status of the thread's most recent ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-statements-current-table.html
However, the display length of statement digests may be longer than the available buffer size due to encoding of statement elements such as keywords and literal values in digest buffer. The events_statements_current table has these indexes: Primary ...The table stores one row per thread showing the current status of the thread's most recent monitored statement event, so there is no system variable for configuring the table ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-transactions-current-table.html
(TRANSACTION does not appear because transactions cannot be nested.) The events_transactions_current table has these indexes: Primary key on (THREAD_ID, EVENT_ID) TRUNCATE TABLE is permitted for the events_transactions_current table. The table ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-waits-current-table.html
The events_waits_current table has these indexes: Primary key on (THREAD_ID, EVENT_ID) TRUNCATE TABLE is permitted for the events_waits_current table. The table stores one row per thread showing the current status of the thread's most recent ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-file-instances-table.html
The file_instances table has these indexes: Primary key on (FILE_NAME) Index on (EVENT_NAME) TRUNCATE TABLE is not permitted for the file_instances table. The file_instances table lists all the files seen by the Performance Schema when executing ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-host-cache-table.html
The host_cache table has these indexes: Primary key on (IP) Index on (HOST) TRUNCATE TABLE is permitted for the host_cache table. The MySQL server maintains an in-memory host cache that contains client host name and IP address information and is ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-hosts-table.html
The hosts table has these indexes: Primary key on (HOST) . The hosts table contains a row for each host from which clients have connected to the MySQL server. For each host name, the table counts the current and total number of connections. To set ...