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/mysqldump.html
Before MySQL 8.0.32: Using this option with the --single-transaction option could lead to inconsistencies in the output. Before 8.0.32: Using --single-transaction together with the --set-gtid-purged option was not recommended; doing so could lead to ... The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table ...
https://dev.mysql.com/doc/refman/8.0/en/option-files.html
However, in an option file, you omit the leading two dashes from the option name and you specify only one option per line. Leading and trailing spaces are automatically deleted from option names and values. Most MySQL programs can read startup ...
https://dev.mysql.com/doc/refman/8.0/en/precision-math-decimal-characteristics.html
DECIMAL columns do not store a leading + character or - character or leading 0 digits. This section discusses the characteristics of the DECIMAL data type (and its synonyms), with particular regard to the following topics: Maximum number of digits ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-memory.html
This causes the replica to be out of synchrony with the source and may lead to other failures or cause the replica to stop: Row-format updates and deletes received from the source may fail with Can't find record in 'memory_table'. When a ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html
You can use the --log-bin option to specify an alternative location, by adding a leading absolute path name to the base name to specify a different directory. When MIXED is specified, statement-based replication is used, except for cases where only ... Startup Options Used with Binary Logging System Variables Used with Binary Logging You can use the mysqld options and system variables that are described in this section to affect the operation of the binary log as well as to control which statements are written to the binary ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-replica.html
The server writes the file in the data directory unless the base name is given with a leading absolute path name to specify a different directory. You can use the relay_log_index system variable to specify an alternative location, by adding a ...
https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html
Changing the server SQL mode after creating and inserting data into partitioned tables can cause major changes in the behavior of such tables, and could lead to loss or corruption of data. When replicating partitioned tables, differing SQL modes on ... The MySQL server can operate in different SQL modes, and can apply these modes differently for different clients, depending on the value of the sql_mode system ...
https://dev.mysql.com/doc/refman/8.0/en/time-zone-support.html
A leading zero can optionally be used for hours values less than 10; MySQL prepends a leading zero when storing and retrieving the value in such cases. This section describes the time zone settings maintained by MySQL, how to load the system tables ...
https://dev.mysql.com/doc/refman/8.0/en/timestamp-lookups.html
This phenomenon can lead to different results for a given TIMESTAMP column query, depending on whether the optimizer uses an index to execute the query. Under those conditions, the comparison in the WHERE clause occurs in different ways for ...
https://dev.mysql.com/doc/refman/8.0/en/using-systemd.html
One implication of the non-use of mysqld_safe on platforms that use systemd for server management is that use of [mysqld_safe] or [safe_mysqld] sections in option files is not supported and might lead to unexpected behavior. Note On systemd ...If ...