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/explain-extended.html
<cache>(expr) The expression (such as a scalar subquery) is executed once and the resulting value is saved in memory for later use. For SELECT statements, the EXPLAIN statement produces extra (“extended”) information that is not part of EXPLAIN ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-variable-table-migration.html
Applications must be revised as follows to run properly: Selecting from the INFORMATION_SCHEMA tables produces an error. Producing an error in MySQL 5.7.9 and higher makes it more evident that an application is operating under conditions that ...
https://dev.mysql.com/doc/refman/5.7/en/mrr-optimization.html
Reading rows using a range scan on a secondary index can result in many random disk accesses to the base table when the table is large and not stored in the storage engine's cache. The MRR optimization is not supported with secondary indexes ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-stage-tables.html
The Performance Schema tables provide a container to store progress data, but make no assumptions about the semantics of the metric itself: A “work unit” is an integer metric that increases over time during execution, such as the number of ...
https://dev.mysql.com/doc/refman/5.7/en/create-procedure.html
The DEFINER and SQL SECURITY clauses specify the security context to be used when checking access privileges at routine execution time, as described later in this section. For statements that can be determined at function definition time to return a ...By default, MySQL automatically grants the ALTER ROUTINE and EXECUTE privileges to the routine ...
https://dev.mysql.com/doc/refman/5.7/en/index-btree-hash.html
In the second statement, only rows with 'Pat' <= key_col < 'Pau' are considered. In the second statement, the LIKE value is not a constant. WHERE index_part1=1 OR index_part2=10 Sometimes MySQL does not use an index, even if one is available.
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-index-stat.html
--connect-retries Command-Line Format --connect-retries=# Type Integer Default Value 12 Minimum Value 0 Maximum Value 12 Number of times to retry connection before giving up. --connect-retry-delay Command-Line Format --connect-retry-delay=# Type ...
https://dev.mysql.com/doc/refman/5.7/en/alter-event.html
Although an ALTER EVENT statement that contains another ALTER EVENT statement in its DO clause appears to succeed, when the server attempts to execute the resulting scheduled event, the execution fails with an error. When a user executes a ... ALTER ...
https://dev.mysql.com/doc/refman/5.7/en/charset-binary-collations.html
This section describes how the binary collation for binary strings compares to _bin collations for nonbinary strings. Binary strings (as stored using the BINARY, VARBINARY, and BLOB data types) have a character set and collation named binary.
https://dev.mysql.com/doc/refman/5.7/en/set-transaction.html
If executed between transactions, the statement overrides any preceding statement that sets the next-transaction value of the named characteristics. The statement is not permitted within transactions: mysql> START TRANSACTION; Query OK, 0 rows ...