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/range-optimization.html
MySQL tries to extract range conditions from the WHERE clause for each of the possible indexes. MySQL performs an additional check to filter out rows that satisfy the range condition but not the full WHERE clause. MySQL does not support merging ...
https://dev.mysql.com/doc/refman/8.0/en/replication-asynchronous-connection-failover.html
Beginning with MySQL 8.0.22, you can use the asynchronous connection failover mechanism to automatically establish an asynchronous (source to replica) replication connection to a new source after the existing connection from a replica to its source ...The list of potential source servers is stored on the replica, and in the event of a connection failure, a new source is selected from the list based on a weighted priority that you ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features.html
The following sections provide information about what is supported and what is not in MySQL replication, and about specific issues and situations that may occur when replicating certain statements. If you use a feature on the source server that is ...Statement-based replication depends on compatibility at the SQL level between the source and ...
https://dev.mysql.com/doc/refman/8.0/en/select-into.html
Example: SELECT * FROM t1 FOR UPDATE INTO @myvar; The INTO position at the end of the statement is supported as of MySQL 8.0.20, and is the preferred position. The position before a locking clause is deprecated as of MySQL 8.0.20; expect support for ...INTO form of SELECT enables a query result to be stored in variables or written to a file: SELECT ...
https://dev.mysql.com/doc/refman/8.0/en/show-create-table.html
row *************************** Table: t Create Table: CREATE TABLE `t` ( `id` int NOT NULL AUTO_INCREMENT, `s` char(60) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci As of MySQL 8.0.16, MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/source-installation-methods.html
There are two methods for installing MySQL from source: Use a standard MySQL source distribution. To obtain a standard distribution, see Section 2.1.3, “How to Get MySQL”. For instructions on building from a standard distribution, see Section ...Standard distributions are available as compressed tar files, Zip archives, or RPM ...
https://dev.mysql.com/doc/refman/8.0/en/upgrade-troubleshooting.html
A schema mismatch in a MySQL 5.7 instance between the .frm file of a table and the InnoDB data dictionary can cause an upgrade to MySQL 8.0 to fail. If problems occur, such as that the new mysqld server does not start, verify that you do not have ...To address this issue, dump and restore affected tables before attempting the upgrade ...
https://dev.mysql.com/doc/refman/8.0/en/windows-extract-archive.html
To install MySQL manually, do the following: If you are upgrading from a previous version please refer to Section 3.11, “Upgrading MySQL on Windows”, before beginning the upgrade process. If you do not install MySQL at C:\mysql, you must ...
https://dev.mysql.com/doc/refman/8.0/en/windows-symbolic-links.html
To do this, create a symbolic link in the MySQL data directory that points to D:\data\mydb. If the database does not already exist, issue CREATE DATABASE mydb in the mysql client to create it. Alternatively, on any version of Windows supported by ...
https://dev.mysql.com/doc/refman/8.0/en/xa-states.html
MySQL 8.0.29 and later supports detached XA transactions, enabled by the xa_detach_on_prepare system variable (ON by default). When detached XA transactions are disabled (xa_detach_on_prepare set to OFF), an XA transaction remains connected until it ... An XA transaction progresses through the following states: Use XA START to start an XA transaction and put it in the ACTIVE ...