Search Results
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/mysql-shell/9.4/en/mysql-shell-output-table-format.html
The table format is used by default for printing result sets when MySQL Shell is in interactive mode. The results of the query are presented as a formatted table for a better view and to aid analysis. To get this output format when running in batch ...
https://dev.mysql.com/doc/refman/8.4/en/sql-mode.html
Changing the server SQL mode after creating and inserting data into partitioned tables can cause major changes in the behavior of such tables, and could lead to loss or corruption of data. It is strongly recommended that you never change the SQL ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-ndb-transid-mysql-connection-map-table.html
For this table to be created, the MySQL Server must be a binary supplied with the NDB Cluster distribution, or one built from the NDB Cluster sources with NDB storage engine support enabled. The ndb_transid_mysql_connection_map table provides a ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-memory-tables.html
Consider using MEMORY tables for noncritical data that is accessed often, and is read-only or rarely updated. Benchmark your application against equivalent InnoDB or MyISAM tables under a realistic workload, to confirm that any additional ...B-tree ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-thread-pool-tables.html
If the thread pool plugin is loaded but disabled, the tables are not created. The following sections describe the Performance Schema tables associated with the thread pool plugin (see Section 7.6.3, “MySQL Enterprise Thread Pool”). The ...They ...
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 .