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/server-option-variable-reference.html
The following table lists all command-line options, system variables, and status variables applicable within mysqld. The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables ...
https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html
This is such a query: SELECT * FROM t1 WHERE t1.a IN (SELECT MAX(t1.b) FROM t2 WHERE ...); Here, MAX(t1.b) cannot aggregated in the outer query because it appears in the WHERE clause of that query. Strict mode produces an error for attempts to ...
https://dev.mysql.com/doc/refman/5.7/en/string-functions.html
The file must be readable by all and its size less than max_allowed_packet bytes. Any level greater than the maximum for the input string collation is treated as maximum for the collation. The maximum varies per collation, but is never greater than ...For functions that operate on string positions, the first position is numbered ...
https://dev.mysql.com/doc/refman/5.7/en/unix-signal-response.html
On Unix and Unix-like systems, a process can be the recipient of signals sent to it by the root system account or the system account that owns the process. Some command interpreters associate certain key sequences with signals, such as Control+C to ...
https://dev.mysql.com/doc/refman/5.7/en/x-plugin-options-system-variables.html
mysqlx_connect_timeout Command-Line Format --mysqlx-connect-timeout=# Introduced 5.7.12 System Variable mysqlx_connect_timeout Scope Global Dynamic Yes Type Integer Default Value 30 Minimum Value 1 Maximum Value 1000000000 Unit seconds The number of ... To control activation of X Plugin, use this option: --mysqlx[=value] Command-Line Format --mysqlx[=value] Introduced 5.7.12 Type Enumeration Default Value ON Valid Values ONOFFFORCEFORCE_PLUS_PERMANENT This option controls how the server loads X Plugin at ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-logs-cluster-log.html
LCPStoppedInCalcKeepGci Checkpoint 0 ALERT Node node_id: Table ID = table_id, fragment ID = fragment_id has completed LCP on Node node_id maxGciStarted: started_gci maxGciCompleted: completed_gci A table fragment has been checkpointed to disk on ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-disk-data-objects.html
NDB Cluster Disk Data storage is implemented using a number of Disk Data objects. These include the following: Tablespaces act as containers for other Disk Data objects. One or more undo log files are assigned to a log file group, which is then ...
https://dev.mysql.com/doc/refman/5.7/en/example-maximum-column-group-row.html
Task: For each article, find the dealer or dealers with the most expensive price. Other possibilities for solving the problem are to use an uncorrelated subquery in the FROM clause or a LEFT JOIN.
https://dev.mysql.com/doc/refman/5.7/en/myisamchk-repair-options.html
--data-file-length=len, -D len Command-Line Format --data-file-length=len Type Numeric The maximum length of the data file (when re-creating data file when it is “full”). --max-record-length=len Command-Line Format --max-record-length=len Type ...--correct-checksum Command-Line Format --correct-checksum Correct the checksum information for the ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-tp-thread-group-state-table.html
There can be a maximum of four connection threads per thread group; these threads expire after a period of inactivity. MAX_THREAD_IDS_IN_GROUP The maximum thread ID of the threads in the group. This is the same as MAX(TP_THREAD_NUMBER) for the ...