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/optimizing-innodb-many-tables.html
If you have configured non-persistent optimizer statistics (a non-default configuration), InnoDB computes index cardinality values for a table the first time that table is accessed after startup, instead of storing such values in the table. This ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-check-availability.html
Issue the SHOW ENGINES statement to view the available MySQL storage engines.
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl.html
The online DDL feature provides support for in-place table alterations and concurrent DML. Benefits of this feature include: Improved responsiveness and availability in busy production environments, where making a table unavailable for minutes or ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-storage-engine.html
...
https://dev.mysql.com/doc/refman/5.7/en/glossary.html
This glossary originated as a reference for terminology about the InnoDB storage engine, and the majority of definitions are InnoDB-related. (In InnoDB, the doublewrite buffer assists with durability.) See Also atomic, commit, concurrency, ... These ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-tablespace-encryption.html
What are the encryption algorithms used with InnoDB data-at-rest encryption? A.17.4. Is it possible to use 3rd party encryption algorithms in place of the one provided by the InnoDB data-at-rest encryption feature? A.17.5. What data types and data ...Is data decrypted for users who are authorized to see it? ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-format-compatibility.html
InnoDB incorporates several checks to guard against the possible crashes and data corruptions that might occur if you run an old release of the MySQL server on InnoDB data files that use a newer file format. Backward Compatibility You only need to ...These checks take place when the server is started, and when you first access a ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool.html
The buffer pool is an area in main memory where InnoDB caches table and index data as it is accessed. When InnoDB reads a page into the buffer pool, it initially inserts it at the midpoint (the head of the old sublist). A page can be read because ...The buffer pool permits frequently used data to be accessed directly from memory, which speeds up ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-transaction-isolation-levels.html
InnoDB offers all four transaction isolation levels described by the SQL:1992 standard: READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, and SERIALIZABLE. InnoDB supports each of the transaction isolation levels described here using different ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-space.html
The data files that you define in the configuration file using the innodb_data_file_path configuration option form the InnoDB system tablespace. In a newly created system tablespace, InnoDB allocates space starting from the first data file. To ...