PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/innodb-benchmarking.html
If a table relies on a feature that is specific to another storage engine, you receive an error. In this case, add the ENGINE=other_engine_name clause to the CREATE TABLE statement to avoid the error. If InnoDB is not the default storage engine, ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-buffer-pool-in-core-file.html
mysql> SET GLOBAL innodb_buffer_pool_in_core_file=OFF; If the innodb_buffer_pool_in_core_file variable is disabled but MADV_DONTDUMP is not supported by the operating system, or an madvise() failure occurs, a warning is written to the MySQL server ... A core file records the status and memory image of a running ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-usage.html
When innodb_strict_mode is enabled (the default), CREATE TEMPORARY TABLE returns errors if ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE is specified. Compressed tables can be created in file-per-table tablespaces or in general tablespaces. The system ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-deadlocks.html
If frequent deadlocks highlight a problem with transaction structure or application error handling, enable innodb_print_all_deadlocks to print information about all deadlocks to the mysqld error log. A deadlock is a situation in which multiple ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-init-startup-configuration.html
If a tablespace file is not found, InnoDB logs an error and continues the startup sequence. The first decisions to make about InnoDB configuration involve the configuration of data files, log files, page size, and memory buffers, which should be ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-space-requirements.html
If the operation takes a long time and concurrent DML modifies the table so much that the size of the temporary log file exceeds the value of innodb_online_alter_log_max_size, the online DDL operation fails with a DB_ONLINE_LOG_TOO_BIG error, and ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-performance-ro-txn.html
In this case, attempting to make changes to the database (for InnoDB, MyISAM, or other types of tables) causes an error, and the transaction continues in read-only state: ERROR 1792 (25006): Cannot execute statement in a READ ONLY transaction.
https://dev.mysql.com/doc/refman/8.0/en/innodb-recovery.html
Doing so may eliminate errors that appeared to be database page corruption. If a hardware failure or severe system error corrupted InnoDB data, MySQL might refuse to start. To achieve point-in-time recovery after restoring a backup, you can apply ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-undo-tablespaces.html
An error message is reported at startup if an undo tablespace known to the data dictionary is not found. Attempting to drop an undo tablespace that is not empty returns an error. Undo tablespaces contain undo logs, which are collections of records ...
https://dev.mysql.com/doc/refman/8.0/en/internal-temporary-tables.html
If internal_tmp_disk_storage_engine=MYISAM, an error occurs for any attempt to materialize a CTE using an on-disk temporary table. When using internal_tmp_disk_storage_engine=INNODB, queries that generate on-disk internal temporary tables that ...