PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression.html
Compression can be especially important for SSD storage devices, because they tend to have lower capacity than HDD devices. This section provides information about the InnoDB table compression and InnoDB page compression features. The page ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-fulltext-index.html
Most importantly, it stores the FTS_SYNCED_DOC_ID, which identifies documents that have been parsed and flushed to disk. Full-text indexes are created on text-based columns (CHAR, VARCHAR, or TEXT columns) to speed up queries and DML operations on ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-index-types.html
To get the best performance from queries, inserts, and other database operations, it is important to understand how InnoDB uses the clustered index to optimize the common lookup and DML operations. Each InnoDB table has a special index called the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-locking-transaction-model.html
To implement a large-scale, busy, or highly reliable database application, to port substantial code from a different database system, or to tune MySQL performance, it is important to understand InnoDB locking and the InnoDB transaction model. This ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-locks-set.html
It is important to create good indexes so that your queries do not scan more rows than necessary. 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 statement. It does ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-internals.html
containers Table The containers table is the most important of the three configuration tables. InnoDB API for the InnoDB memcached Plugin The InnoDB memcached engine accesses InnoDB through InnoDB APIs, most of which are directly adopted from ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-setup.html
mysql> USE innodb_memcache; mysql> SHOW TABLES; +---------------------------+ | Tables_in_innodb_memcache | +---------------------------+ | cache_policies | | config_options | | containers | +---------------------------+ mysql> USE test; mysql> SHOW ... This section describes how to set up the daemon_memcached plugin on a MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-txn.html
This option is less appropriate when accessing the same tables through both memcached and SQL, because it blocks CREATE INDEX statements on the tables, which could be important for running reporting queries. Unlike traditional memcached, the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-operations.html
DISCARD PARTITION No No Only permits ALGORITHM=DEFAULT, LOCK=DEFAULT IMPORT PARTITION No No Only permits ALGORITHM=DEFAULT, LOCK=DEFAULT TRUNCATE PARTITION Yes Yes Does not copy existing data. Online support details, syntax examples, and usage ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-persistent-stats.html
The number of columns in the table's primary key is also important to consider, as primary key columns are appended to each nonunique index. The persistent optimizer statistics feature improves plan stability by storing statistics to disk and ...