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-delayed.html
In MySQL 8.0, the method of delaying replication depends on two timestamps, immediate_commit_timestamp and original_commit_timestamp (see Replication Delay Timestamps). The output of mysqlbinlog displays these timestamps in two formats, microseconds ... MySQL supports delayed replication such that a replica server deliberately executes transactions later than the source by at least a specified amount of ...Use a CHANGE ...
https://dev.mysql.com/doc/refman/8.0/en/optimizer-statistics.html
The value is one of int, uint (unsigned integer), double, decimal, datetime, or string (includes character and binary strings). On the other hand, the statistics become progressively more out of date when table modifications occur, until the next ...
https://dev.mysql.com/doc/refman/8.0/en/index-condition-pushdown-optimization.html
ICP can reduce the number of times the storage engine must access the base table and the number of times the MySQL server must access the storage engine. Without ICP, the storage engine traverses the index to locate rows in the base table and ...
https://dev.mysql.com/doc/refman/8.0/en/windows-troubleshooting.html
When installing and running MySQL for the first time, you may encounter certain errors that prevent the MySQL server from starting. The following examples show other common error messages you might encounter when installing MySQL and starting the ...This section helps you diagnose and correct some of these ...Your ...
https://dev.mysql.com/doc/refman/8.0/en/charset-column.html
Every “character” column (that is, a column of type CHAR, VARCHAR, a TEXT type, or any synonym) has a column character set and a column collation. CREATE TABLE t1 ( col1 CHAR(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ) CHARACTER SET ...CREATE TABLE t1 ( col1 CHAR(10) CHARACTER SET utf8mb4 ) CHARACTER SET latin1 COLLATE latin1_bin; The character set is specified for the column, but the collation is ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-gtids.html
The settings gtid_mode=ON and enforce_gtid_consistency=ON are required on all group members. All the transactions received directly by the group can therefore be identified and are grouped together in GTID sets, and it does not matter which member ... Group Replication uses GTIDs (global transaction identifiers) to track exactly which transactions have been committed on every server ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndbxfrm.html
The ndbxfrm utility, introduced in NDB 8.0.22, can be used to decompress, decrypt, and output information about files created by NDB Cluster that are compressed, encrypted, or both. Options --compress, -c Command-Line Format --compress Introduced ...This is similar to entering a password after invoking mysql --password with no password following the ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-general.html
Why did MySQL version numbering skip versions 6 and 7 and go straight to 8.0? A.1.3. Which version of MySQL is production-ready (GA)? MySQL 9.4, 8.4, and 8.0 are actively supported for production use. It became a bugfix series as of MySQL 8.0.34 ...
https://dev.mysql.com/doc/refman/8.0/en/windows-restrictions.html
This is because the physical address limit on Windows 32-bit is 4GB and the default setting within Windows is to split the virtual address space between kernel (2GB) and user/applications (2GB). Some versions of Windows have a boot time setting to ... The following restrictions apply to use of MySQL on the Windows platform: Process memory On Windows 32-bit platforms, it is not possible by default to use more than 2GB of RAM within a single process, including ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-switch.html
Each MySQL replica (Replica 1, Replica 2, and Replica 3) is a replica running with binary logging enabled, and with --log-slave-updates=OFF. The replica does not check whether the databases on the source are compatible with those on the replica; it ... You can tell a replica to change to a new source using the CHANGE REPLICATION SOURCE TO statement (prior to MySQL 8.0.23: CHANGE MASTER ...