PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
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 ...
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/monitor-innodb-mutex-waits-performance-schema.html
mysql> SELECT * FROM performance_schema.setup_instruments WHERE NAME LIKE '%wait/synch/mutex/innodb%'; +-------------------------------------------------------+---------+-------+ | NAME | ENABLED | TIMED | ... A mutex is a synchronization mechanism ...When two or more threads executing in the server need to access the same resource, the threads compete against each ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldumpslow.html
The MySQL slow query log contains information about queries that take a long time to execute (see Section 7.4.5, “The Slow Query Log”). mysqldumpslow parses MySQL slow query log files and summarizes their contents. Normally, mysqldumpslow ...It ...
https://dev.mysql.com/doc/refman/8.0/en/error-log-format.html
The ts (timestamp) key was added in MySQL 8.0.20 and is unique to the JSON-format log sink. The server handles error log messages that are generated early in the startup process as follows: Prior to MySQL 8.0.14, the server generates messages with ...For all log sinks, the thread ID included in error log messages is that of the thread within mysqld responsible for writing the ... Each error log sink (writer) component has a characteristic output format it uses to write ...