Search Results
https://dev.mysql.com/doc/refman/9.7/en/innodb-redo-log.html
The directory selected for the redo log archive file must exist when redo log archiving is activated, or an error is returned. Otherwise, the following error is returned: ERROR 3844 (HY000): Redo log archive directory 'directory_path1' does not ...
https://dev.mysql.com/doc/refman/9.7/en/jdv-requirements.html
Attempting to insert NULL or an empty object is rejected with an error. If no value is specified for either column used in the join condition, the insert operation is rejected with an error. If an object or sub-object is defined on the same table at ... Review the following requirements and restrictions for table annotations and DML operations on JSON duality ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/en/mysql-configurator-cli.html
enable-error-log N/A enable-err-log bool true, false true configure, reconfigure N/A Enables the error log. The error log contains a record of mysqld startup and shutdown times. It also contains diagnostic messages such as errors, warnings, and ...
https://dev.mysql.com/doc/refman/9.7/en/mysqladmin.html
debug Tells 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 ...
https://dev.mysql.com/doc/refman/9.7/en/out-of-range-and-overflow.html
If strict SQL mode is enabled, an error occurs and the column remains unchanged. If no restrictive modes are enabled, MySQL clips the value to the appropriate endpoint of the column data type range and stores the resulting value instead. When an ...
https://dev.mysql.com/doc/refman/9.7/en/rewriter-query-rewrite-plugin-usage.html
If a rule cannot be loaded due to some error, calling flush_rewrite_rules() produces an error: mysql> CALL query_rewrite.flush_rewrite_rules(); ERROR 1644 (45000): Loading of some rule(s) failed. When this occurs, the plugin writes an error message ... To enable or disable the plugin, enable or disable the rewriter_enabled system ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/mysql-enterprise-backup/9.7/en/backup-repository-options.html
Unless the --with-timestamp option is used, the directory specified by --backup-dir must be empty, or the backup operation will fail with an error. If backup_innodb_data_home_dir is an absolute path, its value is used as-is, unless it points to a ...