PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/innodb-error-handling.html
To have the entire transaction roll back, start the server with --innodb-rollback-on-timeout enabled. A duplicate-key error rolls back the SQL statement, if you have not specified the IGNORE option in your statement. InnoDB sometimes rolls back only ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-system-tables.html
The first index is GEN_CLUST_INDEX, which is a clustered index created by InnoDB if the table does not have a user-defined clustered index. row *************************** TABLE_ID: 71 NAME: test/t1 STATS_INITIALIZED: Initialized NUM_ROWS: 1 ... You ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-locking.html
Shared and Exclusive Locks Intention Locks Record Locks Gap Locks Next-Key Locks Insert Intention Locks AUTO-INC Locks Predicate Locks for Spatial Indexes Shared and Exclusive Locks InnoDB implements standard row-level locking where there are two ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-locks-set.html
If you have no indexes suitable for your statement and MySQL must scan the entire table to process the statement, every row of the table becomes locked, which in turn blocks all inserts by other users to the table. It does have an effect for tables ... A locking read, an UPDATE, or a DELETE generally set record locks on every index record that is scanned in the processing of an SQL ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-benefits.html
For example, you can store the string value 2|4|6|8 in the memcached cache, and have InnoDB split the value based on a separator character, then store the result in four numeric columns. Because data consistency is enforced by mechanisms used for ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-developing.html
With the daemon_memcached plugin, instead of many traditional memcached servers running on low-powered machines, you have the same number of memcached servers as MySQL servers, running on relatively high-powered machines with substantial disk ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-porting-mysql.html
Note The daemon_memcached plugin supports inserts and reads on mapped InnoDB tables that have an INTEGER defined as the primary key. If the InnoDB column used as a key could have values longer than 250 bytes, hash the value to less than 250 bytes.
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-troubleshoot.html
Accessing an indexed virtual column requires a callback to the server, but a memcached connection does not have access to the server code. This section describes issues that you may encounter when using the InnoDB memcached plugin. If you encounter ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-next-key-locking.html
The so-called phantom problem occurs within a transaction when the same query produces different sets of rows at different times. For example, if a SELECT is executed twice, but returns a row the second time that was not returned the first time, ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-limitations.html
The transactions that hold metadata locks on the table may have been started before or during the online DDL operation. Tables created before MySQL 5.6 that include temporal columns (DATE, DATETIME or TIMESTAMP) and have not been rebuilt using ...