Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-session-connect-attrs-table.html
For descriptions of common attributes, see Section 29.12.9, “Performance Schema Connection Attribute Tables”. To see connection attributes only for the current session, and other sessions associated with the session account, use the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-setup-consumers-table.html
The setup_consumers table has these indexes: Primary key on (NAME) TRUNCATE TABLE is not permitted for the setup_consumers table. For detailed information about the effect of enabling different consumers, see Section 29.4.7, “Pre-Filtering by ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-tp-thread-group-state-table.html
The tp_thread_group_state table has one row per thread group in the thread pool. The tp_thread_group_state table has these columns: TP_GROUP_ID The thread group ID. This is the same as MAX(TP_THREAD_NUMBER) for the threads when selected from the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-tp-thread-group-stats-table.html
The tp_thread_group_stats table has these columns: TP_GROUP_ID The thread group ID. TABLE_LOCK_WAITS The number of THD_WAIT_TABLE_LOCK waits for a table to be unlocked that the statement needs to access. The tp_thread_group_stats table has these ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-variables-info-table.html
The variables_info table shows, for each system variable, the source from which it was most recently set, and its range of values. VARIABLE_SOURCE The source from which the variable was most recently set: COMMAND_LINE The variable was set on the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-repair-table.html
When used on a corrupted or otherwise damaged table, it is possible for the REPAIR TABLE statement to delete rows that cannot be recovered. However, any such modifications of table data performed by this statement are not replicated, which can ...
https://dev.mysql.com/doc/refman/8.4/en/table-corruption.html
If you have started mysqld with the myisam_recover_options system variable set, MySQL automatically checks and tries to repair MyISAM tables if they are marked as 'not closed properly' or 'crashed'. If this happens, MySQL writes an entry in the ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-views-table.html
You must have the SHOW VIEW privilege to access this table. The VIEWS table has these columns: TABLE_CATALOG The name of the catalog to which the view belongs. TABLE_SCHEMA The name of the schema (database) to which the view belongs. This column has ...VIEW_DEFINITION The SELECT statement that provides the definition of the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-columns-table.html
The rpd_columns table provides column encoding information for columns of tables loaded in MySQL HeatWave. The rpd_columns table has these columns: TABLE_ID A unique identifier for the table. DATA_PLACEMENT_INDEX The data placement key index ID ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-columns-extensions-table.html
The COLUMNS_EXTENSIONS table provides information about column attributes defined for primary and secondary storage engines. The COLUMNS_EXTENSIONS table has these columns: TABLE_CATALOG The name of the catalog to which the table belongs.