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/group-replication-limitations.html
Therefore we recommend setting group_replication_enforce_update_everywhere_checks=ON on server instances used in multi-primary mode groups to avoid undetected conflicts. Note that the limitations and issues described for multi-primary mode groups ...
https://dev.mysql.com/doc/refman/8.0/en/backup-policy.html
If long updating statements are running when the FLUSH statement is issued, the backup operation may stall until those statements finish. With binary logging enabled, the server writes each data change into a file while it updates data. This ...A ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-shutdowns.html
It is safe to shut down a replication source server and restart it later. Shutting down a replica cleanly is safe because it keeps track of where it left off. Unclean shutdowns might produce problems, especially if the disk cache was not flushed to ...When a replica loses its connection to the source, the replica tries to reconnect immediately and retries periodically if that ...
https://dev.mysql.com/doc/refman/8.0/en/miscellaneous-functions.html
The function return value and type are the same as the return value and type of its argument, but the function result is not checked for the ONLY_FULL_GROUP_BY SQL mode. mysql> UPDATE t SET i = DEFAULT(i)+1 WHERE id < 100; FORMAT(X,D) Formats the ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-transaction-tables.html
INSERT INTO t2 VALUES (1), (2), (3); -- Update nontransactional table 7. Transaction 2 does not start until a transactional table is accessed, despite the intervening updates to nontransactional tables. To selectively examine transaction history, ...
https://dev.mysql.com/doc/refman/8.0/en/type-conversion.html
The following rules describe how conversion occurs for comparison operations: If one or both arguments are NULL, the result of the comparison is NULL, except for the NULL-safe <=> equality comparison operator. To be safe, always use complete ...
https://dev.mysql.com/doc/refman/8.0/en/batch-mode.html
Batch mode can also be useful while you're developing a query, particularly for multiple-line statements or multiple-statement sequences. The default output format is different (more concise) when you run mysql in batch mode than when you use it ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-type-syntax.html
(This differs from the standard SQL default of 6, for compatibility with previous MySQL versions.) Any TIMESTAMP or DATETIME column in a table can have automatic initialization and updating properties; see Section 13.2.5, “Automatic Initialization ... The date and time data types for representing temporal values are DATE, TIME, DATETIME, TIMESTAMP, and ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-internals.html
InnoDB API for the InnoDB memcached Plugin The InnoDB memcached engine accesses InnoDB through InnoDB APIs, most of which are directly adopted from embedded InnoDB. InnoDB API functions are passed to the InnoDB memcached engine as callback ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-persistent-stats.html
row *************************** database_name: sakila table_name: actor last_update: 2014-05-28 16:16:44 n_rows: 200 clustered_index_size: 1 sum_of_other_index_sizes: 1 ...mysql> SELECT * FROM innodb_index_stats \G *************************** 1. row ... The persistent optimizer statistics feature improves plan stability by storing statistics to disk and making them persistent across server restarts so that the optimizer is more likely to make consistent choices each time for a given ...