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/event-scheduler.html
The MySQL Event Scheduler manages the scheduling and execution of events, that is, tasks that run according to a schedule. The following discussion covers the Event Scheduler and is divided into the following sections: Section 27.4.1, “Event ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-limitations.html
Tables created before MySQL 5.6 that include temporal columns (DATE, DATETIME or TIMESTAMP) and have not been rebuilt using ALGORITHM=COPY do not support ALGORITHM=INPLACE. OPTIMIZE TABLE for an InnoDB table is mapped to an ALTER TABLE operation to ...An online DDL operation may briefly require an exclusive metadata lock on the table during its execution phase, and always requires one in the final phase of the operation when updating the table ...
https://dev.mysql.com/doc/refman/8.0/en/alter-logfile-group.html
An ALTER LOGFILE GROUP statement has one and only one ADD UNDOFILE clause. This means that each Disk Data object must be uniquely named (and not merely each Disk Data object of a given type). For example, you cannot have a tablespace and an undo log ... ALTER LOGFILE GROUP logfile_group ADD UNDOFILE 'file_name' [INITIAL_SIZE [=] size] [WAIT] ENGINE [=] engine_name This statement adds an UNDO file named 'file_name' to an existing log file group ...
https://dev.mysql.com/doc/refman/8.0/en/ansi-diff-foreign-keys.html
Use of an explicit MATCH clause does not have the specified effect, and it causes ON DELETE and ON UPDATE clauses to be ignored. The handling of foreign key references to nonunique keys or keys that contain NULL values is not well defined for ...For ...Cascading operations may not be nested more than 15 levels ...
https://dev.mysql.com/doc/refman/8.0/en/channels-with-prev-replication.html
When a replica has multiple channels and a FOR CHANNEL channel option is not specified, a valid statement generally acts on all available channels, with some specific exceptions. For example, the following statements behave as expected for all ...
https://dev.mysql.com/doc/refman/8.0/en/charset-conversion.html
If you use a binary column to store information in multiple character sets, MySQL has no way to know which values use which character set and cannot convert the data properly. If the contents are encoded in a different character set, you can convert ... To convert a binary or nonbinary string column to use a particular character set, use ALTER ...
https://dev.mysql.com/doc/refman/8.0/en/charset-metadata.html
Thus column names, database names, user names, version names, and most of the string results from SHOW are metadata. Otherwise, users would not be able to name columns and tables using their own languages. The metadata requirements mean that the ...
https://dev.mysql.com/doc/refman/8.0/en/components.html
The following sections describe how to install and uninstall components, and how to determine at runtime which components are installed and obtain information about them. A component provides services that are available to the server and other ...
https://dev.mysql.com/doc/refman/8.0/en/copying-databases.html
You can then transfer the file to the other machine and feed it as input to the mysql client. Check the description for mysqldump's --set-gtid-purged option to find what happens with the versions you are using, and how to change the behavior if the ... In cases where you need to transfer databases between different architectures, you can use mysqldump to create a file containing SQL ...
https://dev.mysql.com/doc/refman/8.0/en/create-server.html
server_name has a maximum length of 64 characters (names longer than 64 characters are silently truncated), and is case-insensitive. The wrapper_name is an identifier and may be quoted with single quotation marks. Character literals are UTF-8, ...