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-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/innodb-temporary-tablespace.html
A large data file can also result from long running queries that use temporary tables. For example: [mysqld] innodb_temp_data_file_path=ibtmp1:12M:autoextend:max:500M When the data file reaches the maximum size, queries fail with an error indicating ... Non-compressed, user-created temporary tables and on-disk internal temporary tables are created in a shared temporary ...
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 ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-stage-tables.html
The Performance Schema instruments stages, which are steps during the statement-execution process, such as parsing a statement, opening a table, or performing a filesort operation. Stages correspond to the thread states displayed by SHOW ...
https://dev.mysql.com/doc/refman/5.7/en/row-subqueries.html
Scalar or column subqueries return a single value or a column of values. A row constructor is used for comparisons with subqueries that return two or more columns. A row subquery is a subquery variant that returns a single row and can thus return ...