PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/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 ...Additionally, there cannot be a foreign key constraint between the table being truncated and other tables, otherwise the TRUNCATE TABLE operation ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-buffer-page-lru-table.html
The INNODB_BUFFER_PAGE_LRU table provides information about the pages in the InnoDB buffer pool; in particular, how they are ordered in the LRU list that determines which pages to evict from the buffer pool when it becomes full. The ...Do not query ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-buffer-page-table.html
The INNODB_BUFFER_PAGE table provides information about each page in the InnoDB buffer pool. For related usage information and examples, see Section 14.16.5, “InnoDB INFORMATION_SCHEMA Buffer Pool Tables”. The INNODB_BUFFER_PAGE table has these ...Do not query this table on a production system unless you are aware of the performance impact and have determined it to be ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-lock-waits-table.html
The INNODB_LOCK_WAITS table contains one or more rows for each blocked InnoDB transaction, indicating the lock it has requested and any locks that are blocking that request. The INNODB_LOCK_WAITS table has these columns: REQUESTING_TRX_ID The ID of ...Note This table is deprecated as of MySQL 5.7.14 and is removed in MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-fields-table.html
The INNODB_SYS_FIELDS table provides metadata about the key columns (fields) of InnoDB indexes, equivalent to the information from the SYS_FIELDS table in the InnoDB data dictionary. For related usage information and examples, see Section 14.16.3, ...POS The ordinal position of the key field within the index, starting from 0 and incrementing ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-foreign-cols-table.html
The INNODB_SYS_FOREIGN_COLS table provides status information about the columns of InnoDB foreign keys, equivalent to the information from the SYS_FOREIGN_COLS table in the InnoDB data dictionary. For related usage information and examples, see ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-foreign-table.html
The INNODB_SYS_FOREIGN table provides metadata about InnoDB foreign keys, equivalent to the information from the SYS_FOREIGN table in the InnoDB data dictionary. For related usage information and examples, see Section 14.16.3, “InnoDB ...FOR_NAME ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-autocommit-commit-rollback.html
Both COMMIT and ROLLBACK release all InnoDB locks that were set during the current transaction. If autocommit mode is enabled, each SQL statement forms a single transaction on its own. By default, MySQL starts the session for each new connection ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-doublewrite-buffer.html
The doublewrite buffer is a storage area where InnoDB writes pages flushed from the buffer pool before writing the pages to their proper positions in the InnoDB data files. If there is an operating system, storage subsystem, or unexpected mysqld ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-format-enabling.html
The innodb_file_format configuration option enables an InnoDB file format for file-per-table tablespaces. Note The innodb_file_format configuration option is deprecated and may be removed in a future release. You can set the value of ...You can ...