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/replication-rbr-safe-unsafe.html
If a large number of such statements were executed on the source, this could lead to excessively large error log files. When activated, this causes such warnings not to be written to the error log; instead, for each 50 warnings of this type, a note ... The “safeness” of a statement in MySQL replication refers to whether the statement and its effects can be replicated correctly using statement-based ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-fine-tuning.html
For example, to make two-character words searchable, you could put the following lines in an option file: [mysqld] innodb_ft_min_token_size=2 ft_min_word_len=2 Then restart the server and rebuild your FULLTEXT indexes. (InnoDB does not have an ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log-mixed.html
(Binary injection refers to logging a change that must be logged using ROW format.) Statements may be logged with or without a warning; failed statements are not logged, but generate errors in the log. (Bug #28086) When one of the tables involved is ... When running in MIXED logging format, the server automatically switches from statement-based to row-based logging under the following conditions: When a function contains ...
https://dev.mysql.com/doc/refman/8.0/en/unix-signal-response.html
The server response to SIGUSR1 is a subset of the response to SIGHUP, enabling SIGUSR1 to be used as a more “lightweight” signal that flushes certain logs without the other SIGHUP effects such as flushing the thread and host caches and writing a ... 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 ...
https://dev.mysql.com/doc/refman/8.0/en/replication-privilege-checks.html
It does not execute LOAD DATA INFILE instructions, and so does not attempt file operations to access or delete the temporary files associated with data loads (logged as a Format_description_log_event). The account can also be safely used by an ...
https://dev.mysql.com/doc/refman/8.0/en/x-plugin-connection-compression.html
required: Compression algorithm negotiation occurs as for preferred mode, but if no common algorithm is available, the connection request terminates with an error. As the compression level for an algorithm increases, the data compression ratio ...
https://dev.mysql.com/doc/refman/8.0/en/replication-privilege-checks-account.html
(If events access these tables explicitly for other purposes, you must grant the appropriate privileges on the tables.) Applying a binary log Table_map_log_event, which provides table metadata but does not make any database changes. The ... The user ...As explained in Section 19.3.3, “Replication Privilege Checks”, the account requires further privileges that are sufficient to apply all the expected transactions expected on the replication ...
https://dev.mysql.com/doc/refman/8.0/en/lock-tables.html
(An exception to this policy can occur for small values of the max_write_lock_count system variable; see Section 10.11.4, “Metadata Locking”.) If the LOCK TABLES statement must wait due to locks held by other sessions on any of the tables, it ...
https://dev.mysql.com/doc/refman/8.0/en/gone-away.html
This section also covers the related Lost connection to server during query error. The most common reason for the MySQL server has gone away error is that the server timed out and closed the connection. In this case, you normally get one of the ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-installation.html
To be usable by the server, the plugin library file must be located in the MySQL plugin directory (the directory named by the plugin_dir system variable). For remote cloning operations, the clone plugin must be installed on the donor and recipient ... This section describes how to install and configure the clone ...For general information about installing or uninstalling ...