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-file-format.html
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 (innodb_large_prefix). As InnoDB evolves, data file formats that are not ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-per-table-tablespaces.html
A file-per-table tablespace contains data and indexes for a single InnoDB table, and is stored on the file system in a single data file. File-per-table tablespace characteristics are described under the following topics in this section: ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-init-startup-configuration.html
For example, if you use MyISAM tables, consider the amount of memory allocated for the key buffer (key_buffer_size). innodb_buffer_pool_size + key_buffer_size + max_connections*(sort_buffer_size+read_buffer_size+binlog_cache_size) + ... The first ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-locking-reads.html
If you query data and then insert or update related data within the same transaction, the regular SELECT statement does not give enough protection. Other transactions can update or delete the same rows you just queried. InnoDB supports two types of ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-locking-transaction-model.html
Section 14.7.4, “Phantom Rows” describes how InnoDB uses next-key locking to avoid phantom rows. To implement a large-scale, busy, or highly reliable database application, to port substantial code from a different database system, or to tune ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-txn.html
With the caching setting, if memcached cannot find a key in memory, it searches for the value in an InnoDB table. Unlike traditional memcached, the daemon_memcached plugin allows you to control durability of data values produced through calls to ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached.html
The InnoDB memcached plugin (daemon_memcached) provides an integrated memcached daemon that automatically stores and retrieves data from InnoDB tables, turning the MySQL server into a fast “key-value store”. Instead of formulating queries in ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-failure-conditions.html
For example, you might insert duplicate values into a column while a unique index is being created, or you might insert NULL values into a column while creating a primary key index on that column. The failure of an online DDL operation is typically ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl.html
For example: ALTER TABLE tbl_name ADD PRIMARY KEY (column), ALGORITHM=INPLACE, LOCK=NONE; The LOCK clause is useful for fine-tuning the degree of concurrent access to the table. The online DDL feature provides support for in-place table alterations ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-page-compression.html
InnoDB supports page-level compression for tables that reside in file-per-table tablespaces. Page compression is enabled by specifying the COMPRESSION attribute with CREATE TABLE or ALTER TABLE. Supported Platforms Page compression requires sparse ...