PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/connection-control-plugin-variables.html
connection_control_max_connection_delay Command-Line Format --connection-control-max-connection-delay=# Introduced 5.7.17 System Variable connection_control_max_connection_delay Scope Global Dynamic Yes Type Integer Default Value 2147483647 Minimum ... This section describes the system and status variables that the CONNECTION_CONTROL plugin provides to enable its operation to be configured and ...
https://dev.mysql.com/doc/refman/5.7/en/selinux-checking.html
SELinux is enabled by default on some Linux distributions including Oracle Linux, RHEL, CentOS, and Fedora.
https://dev.mysql.com/doc/refman/5.7/en/example-user-variables.html
You can employ MySQL user variables to remember results without having to store them in temporary variables in the client.
https://dev.mysql.com/doc/refman/5.7/en/charset-collate.html
With the COLLATE clause, you can override whatever the default collation is for a comparison.
https://dev.mysql.com/doc/refman/5.7/en/channels-startup-options.html
--max-relay-log-size=size Maximum size of the individual relay log file for each channel; after reaching this limit, the file is rotated. This section describes startup options which are impacted by the addition of replication channels. The ...
https://dev.mysql.com/doc/refman/5.7/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 12.2, “Loadable Function Reference”. ->> Return value ...
https://dev.mysql.com/doc/refman/5.7/en/subquery-errors.html
Incorrect number of rows from subquery: ERROR 1242 (ER_SUBSELECT_NO_1_ROW) SQLSTATE = 21000 Message = "Subquery returns more than 1 row" This error occurs for statements where the subquery must return at most one row but returns multiple rows.
https://dev.mysql.com/doc/refman/5.7/en/table-scan-avoidance.html
Start mysqld with the --max-seeks-for-key=1000 option or use SET max_seeks_for_key=1000 to tell the optimizer to assume that no key scan causes more than 1,000 key seeks. The output from EXPLAIN shows ALL in the type column when MySQL uses a full ...
https://dev.mysql.com/doc/refman/5.7/en/two-digit-years.html
Some functions like MIN() and MAX() convert a YEAR to a number. Date values with 2-digit years are ambiguous because the century is unknown. Such values must be interpreted into 4-digit form because MySQL stores years internally using 4 digits. For ...
https://dev.mysql.com/doc/refman/5.7/en/union.html
Example: SELECT 1 AS foo UNION SELECT 2 ORDER BY MAX(1); UNION Restrictions In a UNION, the SELECT statements are normal select statements, but with the following restrictions: HIGH_PRIORITY in the first SELECT has no effect. [UNION [ALL | DISTINCT] ...