Search Results
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/subquery-optimization.html
Note A limitation on UPDATE and DELETE statements that use a subquery to modify a single table is that the optimizer does not use semijoin or materialization subquery optimizations. As a workaround, try rewriting them as multiple-table UPDATE and ...
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/internals/en/opening-a-table.html
Before any read or write operations are performed on a table, the MySQL server will call the [custom-engine.html#custom-engine-api-reference-open handler::open()] method to open the table data and index files (if they exist). int open(const char ...
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.
https://dev.mysql.com/doc/refman/8.4/en/information-schema-connection-control-table-reference.html
Table 28.8 INFORMATION_SCHEMA Connection Control Tables Table Name Description CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS Current number of consecutive failed connection attempts per account .
https://dev.mysql.com/doc/refman/8.4/en/information-schema-events-table.html
The EVENTS table provides information about Event Manager events, which are discussed in Section 27.4, “Using the Event Scheduler”. The EVENTS table has these columns: EVENT_CATALOG The name of the catalog to which the event belongs. Times in ...EVENT_SCHEMA The name of the schema (database) to which the event ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-firewall-table-reference.html
Table 28.9 INFORMATION_SCHEMA Firewall Tables Table Name Description Deprecated MYSQL_FIREWALL_USERS Firewall in-memory data for account profiles Yes MYSQL_FIREWALL_WHITELIST Firewall in-memory data for account profile allowlists Yes .