Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-data-locks-table.html
The data_locks table has these indexes: Primary key on (ENGINE_LOCK_ID, ENGINE) Index on (ENGINE_TRANSACTION_ID, ENGINE) Index on (THREAD_ID, EVENT_ID) Index on (OBJECT_SCHEMA, OBJECT_NAME, PARTITION_NAME, SUBPARTITION_NAME) TRUNCATE TABLE is not ...
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-stages-history-long-table.html
The events_stages_history_long table contains the N most recent stage events that have ended globally, across all threads. Stage events are not added to the table until they have ended. When the table becomes full, the oldest row is discarded when ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-stages-history-table.html
The events_stages_history table contains the N most recent stage events that have ended per thread. Stage events are not added to the table until they have ended. When the table contains the maximum number of rows for a given thread, the oldest ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-statements-current-table.html
The events_statements_current table has these indexes: Primary key on (THREAD_ID, EVENT_ID) TRUNCATE TABLE is permitted for the events_statements_current table. The table stores one row per thread showing the current status of the thread's most ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-statements-history-long-table.html
The events_statements_history_long table contains the N most recent statement events that have ended globally, across all threads. Statement events are not added to the table until they have ended. When the table becomes full, the oldest row is ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-events-statements-history-table.html
The events_statements_history table contains the N most recent statement events that have ended per thread. Statement events are not added to the table until they have ended. When the table contains the maximum number of rows for a given thread, ...
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-transactions-history-long-table.html
The events_transactions_history_long table contains the N most recent transaction events that have ended globally, across all threads. Transaction events are not added to the table until they have ended. When the table becomes full, the oldest row ...