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/checksum-table.html
During the checksum operation, the table is locked with a read lock for InnoDB and MyISAM. This row-by-row calculation is what you get with the EXTENDED clause, with InnoDB and all other storage engines other than MyISAM, and with MyISAM tables not ...[QUICK | EXTENDED] CHECKSUM TABLE reports a checksum for the contents of a ...
https://dev.mysql.com/doc/refman/5.7/en/constraint-foreign-key.html
SET DEFAULT is also supported by the MySQL Server but is currently rejected as invalid by InnoDB. Foreign keys let you cross-reference related data across tables, and foreign key constraints help keep this spread-out data consistent. MySQL supports ...
https://dev.mysql.com/doc/refman/5.7/en/data-directory-initialization.html
The server initializes the system tablespace and related data structures needed to manage InnoDB tables. Note After mysqld sets up the InnoDB system tablespace, certain changes to tablespace characteristics require setting up a whole new instance.
https://dev.mysql.com/doc/refman/5.7/en/downgrade-binary-package.html
If you use XA transactions with InnoDB, run XA RECOVER before downgrading to check for uncommitted XA transactions. Configure MySQL to perform a slow shutdown by setting innodb_fast_shutdown to 0. For example: mysql -u root -p --execute="SET GLOBAL ... This section describes how to downgrade MySQL binary and package-based installations on ...
https://dev.mysql.com/doc/refman/5.7/en/example-foreign-keys.html
MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data consistent. A foreign key relationship involves a parent table that holds the initial column ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-restrictions.html
Full-text searches are supported for InnoDB and MyISAM tables only. A character-based ngram full-text parser that supports Chinese, Japanese, and Korean (CJK), and a word-based MeCab parser plugin that supports Japanese are provided for use with ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-search-ngram.html
The ngram full-text parser is supported for use with InnoDB and MyISAM. Full-text-related configuration options, except for minimum and maximum word length options (innodb_ft_min_token_size, innodb_ft_max_token_size, ft_min_word_len, ... The ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-search.html
Full-text indexes can be used only with InnoDB or MyISAM tables, and can be created only for CHAR, VARCHAR, or TEXT columns. For more information about InnoDB FULLTEXT indexes, see Section 14.6.2.4, “InnoDB Full-Text Indexes”. MATCH ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-limitations.html
Group Replication's certification process for concurrent transactions does not take into account gap locks, as information about gap locks is not available outside of InnoDB. InnoDB does not use gap locks in READ COMMITTED, which aligns the local ...
https://dev.mysql.com/doc/refman/5.7/en/handler.html
This statement works for InnoDB tables as well, but there is no such concept because there is no separate data file. (See Section 14.21, “InnoDB memcached Plugin” for an alternative way to adapt applications that use the key-value store ...