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-administration-skip.html
You can use mysqlbinlog to retrieve and display the events that were logged around the time of the error. When you issue the START REPLICA statement for the next time following this SET statement, the new value for the system variable ...Details of ... If replication stops due to an issue with an event in a replicated transaction, you can resume replication by skipping the failed transaction on the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-file-space.html
To avoid the issues that come with storing all tables and indexes inside the system tablespace, you can enable the innodb_file_per_table configuration option (the default), which stores each newly created table in a separate tablespace file (with ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-storage-engine.html
Dynamic-sized rows are much less fragmented when mixing deletes with updates and inserts. MyISAM is based on the older (and no longer available) ISAM storage engine but has many useful extensions. Table 18.2 MyISAM Storage Engine Features Feature ...To specify explicitly that you want a MyISAM table, indicate that with an ENGINE table option: CREATE TABLE t (i INT) ENGINE = MYISAM; In MySQL 8.0, it is normally necessary to use ENGINE to specify the MyISAM storage engine because InnoDB is the default ...
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/group-replication-ipv6.html
To use IPv6 addresses, the operating system on the server host and the MySQL Server instance must both be configured to support IPv6. If a host name specified as the Group Replication local address for a server instance resolves to both an IPv4 and ... As of MySQL 8.0.14, Group Replication group members can use IPv6 addresses as an alternative to IPv4 addresses for communications within the ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-table-info.html
To obtain a description of a MyISAM table or statistics about it, use the commands shown here. The output from these commands is explained later in this section. If you start the MySQL server with external locking disabled, myisamchk may report an ...myisamchk -d tbl_name Runs myisamchk in “describe mode” to produce a description of your ...
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/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/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.5, 8.4, and 8.0 are actively supported for production use. It became a bugfix series as of MySQL 8.0.34 ...