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-disabling-tablespace-path-validation.html
At startup, InnoDB scans directories defined by the innodb_directories variable for tablespace files. The paths of discovered tablespace files are validated against the paths recorded in the data dictionary. If log_error_verbosity is set to 3, the ...If the paths do not match, the paths in the data dictionary are ...This ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-truncate-table-reclaim-space.html
To reclaim operating system disk space when truncating an InnoDB table, the table must be stored in its own .ibd file. For a table to be stored in its own .ibd file, innodb_file_per_table must enabled when the table is created. This is in contrast ...When a table is truncated, it is dropped and re-created in a new .ibd file, and the freed space is returned to the operating ...Additionally, there ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-background.html
Data compression enables smaller database size, reduced I/O, and improved throughput, at the small cost of increased CPU utilization. An InnoDB table created with ROW_FORMAT=COMPRESSED can use a smaller page size on disk than the configured ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-optimize-tablespace-page-allocation.html
Attempting to disable innodb_extend_and_initialize on those systems returns the following error: Changing innodb_extend_and_initialize not supported on this platform. As of MySQL 8.0.22, you can optimize how InnoDB allocates space to file-per-table ...As of MySQL 8.0.22, you can disable innodb_extend_and_initialize on Linux systems to avoid physically writing NULLs to newly allocated tablespace ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-performance-compression-oltp.html
Traditionally, the InnoDB compression feature was recommended primarily for read-only or read-mostly workloads, such as in a data warehouse configuration. If you are certain that the zlib version is not subject to change, disable ...These ...The ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-columns-table.html
PRTYPE The InnoDB “precise type”, a binary value with bits representing MySQL data type, character set code, and nullability. The INNODB_COLUMNS table has these columns: TABLE_ID An identifier representing the table associated with the column; ...For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object ...1 = VARCHAR, 2 = CHAR, 3 = FIXBINARY, 4 = BINARY, 5 = BLOB, ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-multiple-buffer-pools.html
When the InnoDB buffer pool is large, many data requests can be satisfied by retrieving from memory. Multiple buffer pool instances are configured using the innodb_buffer_pool_instances configuration option, and you might also adjust the ... For ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-performance-spin_lock_polling.html
That number is generated by randomly selecting an integer ranging from 0 up to but not including the innodb_spin_wait_delay value, and multiplying that value by 50. An innodb_spin_wait_delay setting of 5 results in a set of five possible values ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-limitations.html
Before an in-place online DDL operation can finish, it must wait for transactions that hold metadata locks on the table to commit or roll back. This is similar to the idea of a foreign key constraint check in InnoDB in which constraints must hold ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-autocommit-commit-rollback.html
By default, MySQL starts the session for each new connection with autocommit enabled, so MySQL does a commit after each SQL statement if that statement did not return an error. If a statement returns an error, the commit or rollback behavior depends ...If autocommit mode is disabled within a session with SET autocommit = 0, the session always has a transaction ...