PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-deadlock-example.html
First, client A creates a table containing one row, and then begins a transaction. Finally, client A also attempts to delete the row from the table: mysql> DELETE FROM t WHERE i = 1; Deadlock occurs here because client A needs an X lock to delete ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html
It supports the COMPACT and REDUNDANT row formats for InnoDB tables. The features associated with COMPRESSED and DYNAMIC row formats include compressed tables, efficient storage of off-page columns, and index key prefixes up to 3072 bytes ... As ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-intro.html
Direct access to InnoDB tables, bypassing the SQL parser, the optimizer, and even the Handler API layer. Although memcached has no concept of transactions, you can use this option to control how soon memcached sees changes caused by SQL statements ... The InnoDB memcached plugin implements memcached as a MySQL plugin daemon that accesses the InnoDB storage engine directly, bypassing the MySQL SQL ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-failure-conditions.html
A timeout occurs while waiting for an exclusive lock on the table, which may be needed briefly during the initial and final phases of the DDL operation. The operation takes a long time and concurrent DML modifies the table so much that the size of ... 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 ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-midpoint_insertion.html
The goal is to make sure that frequently accessed (“hot”) pages remain in the buffer pool, even as read-ahead and full table scans bring in new blocks that might or might not be accessed afterward. You can control the insertion point in the LRU ... Rather than using a strict LRU algorithm, InnoDB uses a technique to minimize the amount of data that is brought into the buffer pool and never accessed ...
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. You can enforce a high degree of consistency with the default REPEATABLE READ level, for ...
https://dev.mysql.com/doc/refman/5.7/en/key-space.html
This is for the worst case when all keys are inserted in sorted order and the table does not have any compressed keys. In MyISAM tables, you can also prefix compress numbers by specifying the PACK_KEYS=1 table option when you create the table. You ...
https://dev.mysql.com/doc/refman/5.7/en/ldml-rules.html
Orderings are given as a set of rules that begin with a reset rule that establishes an anchor point, followed by shift rules that indicate how characters sort relative to the anchor point. The following table shows the correspondence between ...This ...
https://dev.mysql.com/doc/refman/5.7/en/loadable-function-reference.html
The following table lists each function that is loadable at runtime and provides a short description of each one. For a table listing built-in functions and operators, see Section 12.1, “Built-In Function and Operator Reference” For general ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-api-definition.html
If no HostName is specified in a given [mysql] or [api] section of the config.ini file, then an SQL or API node may connect using the corresponding “slot” from any host which can establish a network connection to the management server host ...