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-information-schema-fulltext_index-tables.html
INNODB_FT_BEING_DELETED: Provides a snapshot of the INNODB_FT_DELETED table; it is used only during an OPTIMIZE TABLE maintenance operation. When OPTIMIZE TABLE is run, the INNODB_FT_BEING_DELETED table is emptied, and DOC_ID values are removed from ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-benefits.html
Data requested through the memcached protocol is transparently queried from an InnoDB table, without going through the MySQL SQL layer. You can access the underlying InnoDB table through SQL for reporting, analysis, ad hoc queries, bulk loading, ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-operations.html
Concurrent queries are permitted for tables partitioned by HASH or LIST. Concurrent queries are permitted for tables partitioned by HASH or LIST, as MySQL copies the data while holding a shared lock. Concurrent queries are permitted for tables ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-schema.html
This section provides a brief introduction to InnoDB integration with Performance Schema. For comprehensive Performance Schema documentation, see Chapter 25, MySQL Performance Schema. You can profile certain internal InnoDB operations using the ...
https://dev.mysql.com/doc/refman/5.7/en/json.html
The JSON data type provides these advantages over storing JSON-format strings in a string column: Automatic validation of JSON documents stored in JSON columns. JSON documents stored in JSON columns are converted to an internal format that permits ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-character.html
If a table contains string columns such as name and address, but many queries do not retrieve those columns, consider splitting the string columns into a separate table and using join queries with a foreign key when necessary. Such compact tables ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-columns-range.html
The SELECT statement in the preceding example could also have been written using explicit row constructors, like this: SELECT ROW(5,10) < ROW(5,12), ROW(5,11) < ROW(5,12), ROW(5,12) < ROW(5,12); For more information about the use of row constructors ... Range columns partitioning is similar to range partitioning, but enables you to define partitions using ranges based on multiple column ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-overview.html
Some queries can be greatly optimized in virtue of the fact that data satisfying a given WHERE clause can be stored only on one or more partitions, which automatically excludes any remaining partitions from the search. Because partitions can be ...
https://dev.mysql.com/doc/refman/5.7/en/pattern-matching.html
To demonstrate how extended regular expressions work, the LIKE queries shown previously are rewritten here to use REGEXP. MySQL provides standard SQL pattern matching as well as a form of pattern matching based on extended regular expressions ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-mutex-instances-table.html
The work performed while holding a mutex is said to be in a “critical section,” and multiple queries do execute this critical section in a serialized way (one at a time), which is a potential bottleneck. By performing queries on both of the ...