PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/innodb-redo-log-buffer.html
Thus, if you have transactions that update, insert, or delete many rows, increasing the size of the log buffer saves disk I/O. The log buffer is the memory area that holds data to be written to the log files on disk. The contents of the log buffer ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-redo-log.html
The MySQL user running the backup utility or the MySQL user activating and deactivating redo log archiving manually must have this privilege. The redo log is a disk-based data structure used during crash recovery to correct data written by ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-system-tablespace.html
The system tablespace is the storage area for the change buffer. It may also contain table and index data if tables are created in the system tablespace rather than file-per-table or general tablespaces. In previous MySQL versions, the system ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-table-import.html
When importing a table from another MySQL server instance, both MySQL server instances must have General Availability (GA) status and must be the same version. This section describes how to import tables using the Transportable Tablespaces feature, ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-temporary-tablespace.html
Session temporary tablespace files are five pages in size when created and have an .ibt file name extension. InnoDB uses session temporary tablespaces and a global temporary tablespace. Session Temporary Tablespaces Session temporary tablespaces ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-transaction-isolation-levels.html
Transaction isolation is one of the foundations of database processing. Isolation is the I in the acronym ACID; the isolation level is the setting that fine-tunes the balance between performance and reliability, consistency, and reproducibility of ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-troubleshooting-datadict.html
The procedure assumes that you only have .ibd file backups, you are recovering to the same version of MySQL that initially created the orphan .ibd files, and that .ibd file backups are clean. Information about table definitions is stored in the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-troubleshooting.html
You can then see what mysqld prints to the console, and so have a better grasp of what is going on. The following general guidelines apply to troubleshooting InnoDB problems: When an operation fails or you suspect a bug, look at the MySQL server ...
https://dev.mysql.com/doc/refman/8.0/en/insert-optimization.html
To optimize insert speed, combine many small operations into a single large operation. Ideally, you make a single connection, send the data for many new rows at once, and delay all index updates and consistency checking until the very end. The size ...
https://dev.mysql.com/doc/refman/8.0/en/internal-temporary-tables.html
In some cases, the server creates internal temporary tables while processing statements. The server creates temporary tables under conditions such as these: Evaluation of UNION statements, with some exceptions described later. Evaluation of some ...