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/keyring-system-variables.html
If an attempted runtime assignment to keyring_encrypted_file_data results in an error, the variable value remains unchanged. If an attempted runtime assignment to keyring_file_data results in an error, the variable value remains unchanged. If an ...
https://dev.mysql.com/doc/refman/8.0/en/lock-tables.html
With auto-reconnect disabled, if the connection drops, an error occurs for the next statement issued. The client can detect the error and take appropriate action such as reacquiring the locks or redoing the transaction. For example, if you attempt a ... LOCK {TABLE | TABLES} tbl_name [[AS] alias] lock_type [, tbl_name [[AS] alias] lock_type] ...
https://dev.mysql.com/doc/refman/8.0/en/mysqladmin.html
debug Prior to MySQL 8.0.20, tell the server to write debug information to the error log. Following the flush-logs command, you can provide a space-separated list of one or more of the following log types: binary, engine, error, general, relay, slow. This is 0 even in case of an error such as Access denied, because this means that the server is running but refused the connection, which is different from the server not ...
https://dev.mysql.com/doc/refman/8.0/en/pluggable-authentication-system-variables.html
If FIDO authentication is attempted and this value is not the one expected by the FIDO device, the device assumes that it is not talking to the correct server and an error occurs. authentication_ldap_sasl_log_status Command-Line Format ...Note As of ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-geojson-functions.html
Option Value Meaning 1 Reject the document and produce an error. If srid refers to an undefined spatial reference system (SRS), an ER_SRS_NOT_FOUND error occurs. For geographic SRS geometry arguments, if any argument has a longitude or latitude that ... This section describes functions for converting between GeoJSON documents and spatial ...
https://dev.mysql.com/doc/refman/8.0/en/using-systemd.html
This script assists in creating the error log file only if the log location matches a pattern (/var/log/mysql*.log for RPM platforms, /var/log/mysql/*.log for Debian platforms). In other cases, the error log directory must be writable or the error ...If you install MySQL from a source distribution on a platform that uses systemd, obtain systemd support for MySQL by configuring the distribution using the -DWITH_SYSTEMD=1 CMake ...
https://dev.mysql.com/doc/refman/8.0/en/cannot-create.html
If you get an error of the following type for some queries, it means that MySQL cannot create a temporary file for the result set in the temporary directory: Can't create/write to file '\\sqla3fe_0.ism'. The preceding error is a typical message for ...One fix is to start mysqld with the --tmpdir option or to add the option to the [mysqld] section of your option ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-troubleshoot.html
loose-daemon_memcached_option='-vvv' If columns specified to hold memcached values are the wrong data type, such as a numeric type instead of a string type, attempts to store key-value pairs fail with no specific error code or message. If you ...
https://dev.mysql.com/doc/refman/8.0/en/json-validation-functions.html
row *************************** Level: Error Code: 3934 Message: The JSON document location '#/latitude' failed requirement 'maximum' at JSON Schema location '#/properties/latitude'. row *************************** Level: Error Code: 3819 Message: ...If at least one of the arguments is not valid JSON, the function raises an error (ER_INVALID_TYPE_FOR_JSON) In addition, if the schema is not a valid JSON object, the function returns ...
https://dev.mysql.com/doc/refman/8.0/en/explain.html
You should be aware that while this makes the output easier to read, it also renders the JSON invalid, causing JSON functions to raise an error. If the value of explain_format is JSON, EXPLAIN ANALYZE returns an error unless FORMAT=TREE is specified ... {EXPLAIN | DESCRIBE | DESC} tbl_name [col_name | wild] {EXPLAIN | DESCRIBE | DESC} [explain_type] {explainable_stmt | FOR CONNECTION connection_id} {EXPLAIN | DESCRIBE | DESC} ANALYZE [explain_type] select_stmt explain_type: { FORMAT = format_name } format_name: { TRADITIONAL | JSON | TREE } explainable_stmt: { select_stmt | TABLE ...