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-locking-transaction-model.html
This section discusses several topics related to InnoDB locking and the InnoDB transaction model with which you should be familiar. To implement a large-scale, busy, or highly reliable database application, to port substantial code from a different ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-porting-memcached.html
This is because InnoDB performs best for large-scale insertions if primary key values are added in sorted order (as they are with auto-increment values). Primary key values are included in secondary indexes, which takes up unnecessary space if the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached.html
This “NoSQL-style” interface uses the memcached API to speed up database operations, letting InnoDB handle memory caching using its buffer pool mechanism. The InnoDB memcached plugin (daemon_memcached) provides an integrated memcached daemon ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-monitors.html
InnoDB monitors provide information about the InnoDB internal state. This information is useful for performance tuning. ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-on-disk-structures.html
This section describes InnoDB on-disk structures and related topics. ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-failure-conditions.html
The failure of an online DDL operation is typically due to one of the following conditions: An ALGORITHM clause specifies an algorithm that is not compatible with the particular type of DDL operation or storage engine. A LOCK clause specifies a low ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-space-requirements.html
This option was introduced in MySQL 5.7.11 to help avoid temporary directory overflows that could occur as a result of large temporary sort files. Online DDL operations have the following space requirements: Temporary log files: A temporary log ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl.html
Benefits of this feature include: Improved responsiveness and availability in busy production environments, where making a table unavailable for minutes or hours is not practical. The online DDL feature provides support for in-place table ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-buffer-pool.html
This section provides configuration and tuning information for the InnoDB buffer pool.
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-ro-txn.html
In this case, attempting to make changes to the database (for InnoDB, MyISAM, or other types of tables) causes an error, and the transaction continues in read-only state: ERROR 1792 (25006): Cannot execute statement in a READ ONLY transaction.