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-error-handling.html
InnoDB sometimes rolls back only the statement that failed, other times it rolls back the entire transaction. If you run out of file space in a tablespace, a MySQL Table is full error occurs and InnoDB rolls back the SQL statement. A transaction ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-defragmenting.html
Another symptom of fragmentation is that a table scan such as this takes more time than it “should” take: SELECT COUNT(*) FROM t WHERE non_indexed_column <> 12345; The preceding query requires MySQL to perform a full table scan, the slowest type ... Random insertions into or deletions from a secondary index can cause the index to become ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html
This section discusses enabling InnoDB file formats for new InnoDB tables, verifying compatibility of different file formats between MySQL releases, and identifying the file format in use. As InnoDB evolves, data file formats that are not ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-space.html
For tables stored this way, there is less fragmentation within the disk file, and when the table is truncated, the space is returned to the operating system rather than still being reserved by InnoDB within the system tablespace. The data files ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-in-memory-structures.html
This section describes InnoDB in-memory structures and related topics. ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-indexes.html
This section covers topics related to InnoDB indexes. ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-tables.html
For related information and examples, see Section 14.16, “InnoDB INFORMATION_SCHEMA Tables”. INFORMATION_SCHEMA InnoDB tables can be used to monitor ongoing InnoDB activity, to detect inefficiencies before they turn into issues, or to ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-temp-table-info.html
Example 14.12 INNODB_TEMP_TABLE_INFO This example demonstrates characteristics of the INNODB_TEMP_TABLE_INFO table. INNODB_TEMP_TABLE_INFO provides information about user-created InnoDB temporary tables that are active in the InnoDB instance. It ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-understanding-innodb-locking.html
This table also contains one row describing each lock in a queue of locks pending for a given row or table. When a transaction updates a row in a table, or locks it with SELECT FOR UPDATE, InnoDB establishes a list or queue of locks on that row.
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema.html
This section provides information and usage examples for InnoDB INFORMATION_SCHEMA tables. InnoDB INFORMATION_SCHEMA tables provide metadata, status information, and statistics about various aspects of the InnoDB storage engine. You can view a list ...