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/select.html
In this case, rows are selected only from the partitions listed, and any other partitions of the table are ignored. For example: SELECT id, * FROM t1 To avoid this problem, use a qualified tbl_name.* reference: SELECT id, t1.* FROM t1 Use qualified ... SELECT [ALL | DISTINCT | DISTINCTROW ] [HIGH_PRIORITY] [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT] [SQL_CACHE | SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS] select_expr [, select_expr] ...
https://dev.mysql.com/doc/refman/5.7/en/string-functions.html
This function does not work properly if the first argument contains a comma (,) character. (Multibyte characters therefore become more than two digits.) The inverse of this operation is performed by the UNHEX() function. mysql> SELECT ...For ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-innodb-cluster-introduction.html
This could involve making file copies, manually copying them, and so on. This chapter introduces MySQL InnoDB Cluster, which combines MySQL technologies to enable you to deploy and administer a complete integrated high availability solution for ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-storage-engine.html
This can also be changed by changing the source and recompiling. This is done by automatically combining adjacent deleted blocks and by extending blocks if the next block is deleted. myisamchk --fast checks only those tables that don't have this ...
https://dev.mysql.com/doc/refman/5.7/en/optimizer-hints.html
This occurs due to heuristic pruning during greedy search, which can be avoided by setting optimizer_prune_level=0. Changes to this variable affect execution of all subsequent queries; to affect one query differently from another, it is necessary to ... One means of control over optimizer strategies is to set the optimizer_switch system variable (see Section 8.9.2, “Switchable ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-tables.html
This is similar to the information available from the SHOW SLAVE STATUS statement, but representation in table form is more accessible and has usability benefits: SHOW SLAVE STATUS output is useful for visual inspection, but not so much for ...Query ...
https://dev.mysql.com/doc/refman/5.7/en/sorted-index-builds.html
The drawbacks of this “top-down” method of building an index are the cost of searching for an insert position and the constant splitting and merging of B-tree nodes. This method of index creation is also known as a sorted index build. This ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-buffer-page-table.html
Do not query this table on a production system unless you are aware of the performance impact and have determined it to be acceptable. This is an identifier to distinguish between multiple buffer pool instances. FIX_COUNT The number of threads using ... The INNODB_BUFFER_PAGE table provides information about each page in the InnoDB buffer ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-hash.html
This can simply be the name of a column whose type is one of MySQL's integer types. In addition, you most likely want to follow this with PARTITIONS num, where num is a positive integer representing the number of partitions into which the table is ... Partitioning by HASH is used primarily to ensure an even distribution of data among a predetermined number of ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-digests.html
This section describes how statement digesting occurs and how it can be useful. In this case, the difference in the second column name is lost and both statements are considered the same. This is a copy of the original normalized statement that was ... The MySQL server is capable of maintaining statement digest ...