PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-error-log-table.html
LOGGED corresponds to the time field of error events, although with certain potential differences: time values in the error log are displayed according to the log_timestamps system variable setting; see Early-Startup Logging Output Format. The ...
https://dev.mysql.com/doc/refman/8.0/en/point-in-time-recovery-positions.html
Because the output of mysqlbinlog includes SET TIMESTAMP statements before each SQL statement recorded, the recovered data and related MySQL logs reflect the original times at which the transactions were executed. The last section, Section 9.5.1, ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-functions.html
(You can consider the function execution timestamp and random number seed as implicit inputs that are identical on the source and replica.) The FOUND_ROWS() and ROW_COUNT() functions are not replicated reliably using statement-based replication.
https://dev.mysql.com/doc/refman/8.0/en/replication-options-reference.html
replica_parallel_type: Tells replica to use timestamp information (LOGICAL_CLOCK) or database partitioning (DATABASE) to parallelize transactions. slave_parallel_type: Tells replica to use timestamp information (LOGICAL_CLOCK) or database partioning ... The following two sections provide basic information about the MySQL command-line options and system variables applicable to replication and the binary ...
https://dev.mysql.com/doc/refman/8.0/en/storage-requirements.html
Leftover Digits Number of Bytes 0 0 1 1 2 1 3 2 4 2 5 3 6 3 7 4 8 4 Date and Time Type Storage Requirements For TIME, DATETIME, and TIMESTAMP columns, the storage required for tables created before MySQL 5.6.4 differs from tables created from 5.6.4 ... InnoDB Table Storage Requirements NDB Table Storage Requirements Numeric Type Storage Requirements Date and Time Type Storage Requirements String Type Storage Requirements Spatial Type Storage Requirements JSON Storage Requirements The storage requirements for table data on disk depend on several ...
https://dev.mysql.com/doc/refman/8.0/en/using-date.html
MySQL also permits a “relaxed” string format when updating and in a WHERE clause that compares a date to a DATE, DATETIME, or TIMESTAMP column. When you compare a DATE, TIME, DATETIME, or TIMESTAMP to a constant string with the <, <=, =, >=, >, ...You should use this format in UPDATE expressions and in the WHERE clause of SELECT ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table-examples.html
For NDB tables, it is also possible to change the storage type used for a table or column. row *************************** Table: t1 Create Table: CREATE TABLE `t2` ( `c1` int(11) DEFAULT NULL ) /*!50100 TABLESPACE ts_1 STORAGE DISK */ ...
https://dev.mysql.com/doc/refman/8.0/en/create-procedure.html
For NOW(), the binary log includes the timestamp and replicates correctly. (You can consider the routine execution timestamp and random number seed as implicit inputs that are identical on the source and replica.) Several characteristics provide ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-usage-differences.html
Previously, it was possible to dump stored routine and event definitions together with their creation and modification timestamps, by dumping the proc and event tables. As of MySQL 8.0, those tables are not used, so it is not possible to dump ...
https://dev.mysql.com/doc/refman/8.0/en/docker-mysql-more-topics.html
A MySQL Docker installation is different from a common, non-Docker installation in the following aspects: Only a limited number of binaries are included. Warning Any software updates or installations users perform to the Docker container (including ...