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/outer-join-optimization.html
If there is a row in A that matches the WHERE clause, but there is no row in B that matches the ON condition, an extra B row is generated with all columns set to NULL. For a LEFT JOIN, if the WHERE condition is always false for the generated NULL ...
https://dev.mysql.com/doc/refman/5.7/en/converting-tables-to-innodb.html
autocommit=1 is suitable for InnoDB tables when running a sequence of queries for generating reports or analyzing statistics. File-per-table tablespaces also support the Barracuda file format and associated features such as table compression, ... If ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-memory-per-fragment.html
Every row having one or more variable-sized, one or more dynamic columns (or both) has a variable-sized part. Each row in an NDB table has a fixed-size part, consisting of a row header, and one or more fixed-size columns. The total free space ...
https://dev.mysql.com/doc/refman/5.7/en/group-by-modifiers.html
ROLLUP has a more complex effect when there are multiple GROUP BY columns. In this case, each time there is a change in value in any but the last grouping column, the query produces an extra super-aggregate summary row. These rows have the country ... The GROUP BY clause permits a WITH ROLLUP modifier that causes summary output to include extra rows that represent higher-level (that is, super-aggregate) summary ...
https://dev.mysql.com/doc/refman/5.7/en/ansi-diff-comments.html
In this case, the generated statement looks like this: UPDATE account SET balance=balance--1 WHERE account_id=5752; balance--1 is valid standard SQL, but -- is interpreted as the start of a comment, and part of the expression is discarded. Standard ...
https://dev.mysql.com/doc/refman/5.7/en/channels-with-prev-replication.html
When a replica has multiple channels and a FOR CHANNEL channel option is not specified, a valid statement generally acts on all available channels, with some specific exceptions. For example, the following statements behave as expected for all ...
https://dev.mysql.com/doc/refman/5.7/en/cursor-restrictions.html
A server-side cursor enables a result set to be generated on the server side, but not transferred to the client except for those rows that the client requests. You cannot use a cursor for a statement that generates a result set if the statement is ... Server-side cursors are implemented in the C API using the mysql_stmt_attr_set() ...
https://dev.mysql.com/doc/refman/5.7/en/error-message-elements.html
Client-side error messages are generated from within the MySQL client library, usually involving problems communicating with the server. Example server-side error messages written to the error log: This message produced during the startup process ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-enabling-monitors.html
InnoDB monitors should only be enabled when you actually want to see monitor information because output generation causes some performance decrement. The --innodb-status-file option is intended for temporary use, as output generation can affect ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-aws-plugin.html
The keyring_aws keyring plugin communicates with the Amazon Web Services Key Management Service (AWS KMS) as a back end for key generation and uses a local file for key storage. All keyring material is generated exclusively by the AWS server, not by ... Note The keyring_aws plugin is an extension included in MySQL Enterprise Edition, a commercial ...