PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/preventing-use-of-optimizer-trace.html
If, for some reason, you wish to prevent users from seeing traces of their queries, start the server with the options shown here: --maximum-optimizer-trace-max-mem-size=0 --optimizer-trace-max-mem-size=0 This sets the maximum size to 0 and prevents ...
https://dev.mysql.com/doc/refman/8.0/en/select.html
You can use SET max_seeks_for_key=value as an alternative way to force MySQL to prefer key scans instead of table scans. When you use ORDER BY or GROUP BY to sort a column in a SELECT, the server sorts values using only the initial number of bytes ... SELECT [ALL | DISTINCT | DISTINCTROW ] [HIGH_PRIORITY] [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT] [SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS] select_expr [, select_expr] ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/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/8.0/en/x-plugin-options-system-variables.html
Use the algorithm-specific system variables to adjust the default and maximum compression level for each permitted algorithm. mysqlx_connect_timeout Command-Line Format --mysqlx-connect-timeout=# System Variable mysqlx_connect_timeout Scope Global ... To control activation of X Plugin, use this option: --mysqlx[=value] Command-Line Format --mysqlx[=value] 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/8.0/en/added-deprecated-removed.html
clone_max_concurrency: Maximum number of concurrent threads used to perform cloning operation. clone_max_data_bandwidth: Maximum data transfer rate in MiB per second for remote cloning operation. clone_max_network_bandwidth: Maximum network transfer ... Options and Variables Introduced in MySQL 8.0 Options and Variables Deprecated in MySQL 8.0 Options and Variables Removed in MySQL 8.0 This section lists server variables, status variables, and options that were added for the first time, have been deprecated, or have been removed in MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/adding-character-set.html
To find the maximum of the currently used collation IDs, use this query: SELECT MAX(ID) FROM INFORMATION_SCHEMA.COLLATIONS; This step depends on whether you are adding a simple or complex character set. This section discusses the procedure for ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-reference.html
max_array_length: The maximum number of events to read from the log. audit_log_filter_id System Variable audit_log_filter_id Scope Global, Session Dynamic No SET_VAR Hint Applies No Type Integer Default Value 1 Minimum Value 0 Maximum Value ...
https://dev.mysql.com/doc/refman/8.0/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 14.2, “Loadable Function Reference”. ->> Return value ...
https://dev.mysql.com/doc/refman/8.0/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 ...