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/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 ...
https://dev.mysql.com/doc/refman/8.0/en/year.html
Note As of MySQL 8.0.19, the YEAR(4) data type with an explicit display width is deprecated and you should expect support for it to be removed in a future version of MySQL. MySQL 8.0 does not support the 2-digit YEAR(2) data type permitted in older ... The YEAR type is a 1-byte type used to represent year ...
https://dev.mysql.com/doc/refman/8.0/en/program-options.html
There are several ways to specify options for MySQL programs: List the options on the command line following the program name. This is common for options that you want the program to use each time it runs. This method is useful for options that you ...This is common for options that apply to a specific invocation of the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-change-buffer.html
Merging cached changes at a later time, when affected pages are read into the buffer pool by other operations, avoids substantial random access I/O that would be required to read secondary index pages into the buffer pool from disk. During this ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-storage-engine.html
Table 18.2 MyISAM Storage Engine Features Feature Support B-tree indexes Yes Backup/point-in-time recovery (Implemented in the server, rather than in the storage engine.) Yes Cluster database support No Clustered indexes No Compressed data Yes ...
https://dev.mysql.com/doc/refman/8.0/en/ibd2sdi.html
ibd2sdi can be run on file-per-table tablespace files (*.ibd files), general tablespace files (*.ibd files), system tablespace files (ibdata* files), and the data dictionary tablespace (mysql.ibd). ibd2sdi can be used at runtime or while the server ... ibd2sdi is a utility for extracting serialized dictionary information (SDI) from InnoDB tablespace ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-temporary-tablespace.html
Beginning with MySQL 8.0.16, the storage engine used for on-disk internal temporary tables is InnoDB. Because the pool of session temporary tablespaces is recreated each time the server is started, space IDs for session temporary tablespaces are not ... InnoDB uses session temporary tablespaces and a global temporary ...