Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-redo-log.html
During normal operations, the redo log encodes requests to change table data that result from SQL statements or low-level API calls. Data that is written to redo log files is encoded in terms of records affected, and this data is collectively ...
https://dev.mysql.com/doc/refman/8.4/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.4/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/8.4/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/8.4/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.4/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/8.4/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 ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-function-descriptions.html
Unless specified otherwise, functions returning a pointer return a non-NULL value to indicate success or a NULL value to indicate an error, and functions returning an integer return zero to indicate success or nonzero to indicate an error. When a ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-trace-source.html
12 Warning: level, code, message 13 Error: error number, error message Although this example uses the ConsoleTraceListener, any of the other standard listeners can be used. This value is defined by the MySqlTraceEventType public enum contained in ...
https://dev.mysql.com/doc/workbench/en/wb-preferences-sql-editor.html
Figure 3.7 Preferences: SQL Editor: Query Editor Productivity Enable Code Completion in Editors The SQL Editor offers autocomplete functionality by either pressing the keyboard shortcut (Modifier + Space), or it will start automatically if the ...