PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.8Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/entering-queries.html
Here is a simple query that asks the server to tell you its version number and the current date. The following queries are equivalent: mysql> SELECT VERSION(), CURRENT_DATE; mysql> select version(), current_date; mysql> SeLeCt vErSiOn(), ... Make ...
https://dev.mysql.com/doc/refman/8.0/en/event-scheduler.html
If you are upgrading to MySQL 8.0 from an earlier version, be sure to perform the upgrade procedure to make sure that your system database is up to date. The MySQL Event Scheduler manages the scheduling and execution of events, that is, tasks that ...
https://dev.mysql.com/doc/refman/8.0/en/events-overview.html
When you create an event, you are creating a named database object containing one or more SQL statements to be executed at one or more regular intervals, beginning and ending at a specific date and time. MySQL Events are tasks that run according to ...
https://dev.mysql.com/doc/refman/8.0/en/explain-output.html
No matching rows after partition pruning (JSON property: message) For DELETE or UPDATE, the optimizer found nothing to delete or update after partition pruning. The index map value N is a bitmask value that indicates which indexes are candidates.
https://dev.mysql.com/doc/refman/8.0/en/features.html
Data Types Many data types: signed/unsigned integers 1, 2, 3, 4, and 8 bytes long, FLOAT, DOUBLE, CHAR, VARCHAR, BINARY, VARBINARY, TEXT, BLOB, DATE, TIME, DATETIME, TIMESTAMP, YEAR, SET, ENUM, and OpenGIS spatial types. Support for DELETE, INSERT, ... This section describes some of the important characteristics of the MySQL Database ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-cloning.html
Using a remote cloning operation in the event of a large transaction gap lets you add new members to the group without transferring the group's data to the server manually beforehand, and also enables a member that is very out of date to catch up ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-distributed-recovery.html
When the joining member is up to date with all the group's transactions, it is declared online and can participate in the group as a normal member, and distributed recovery is complete. Whenever a member joins or rejoins a replication group, it ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-group-membership.html
If a server joins the group, it automatically brings itself up to date by fetching the missing state from an existing server. In MySQL Group Replication, a set of servers forms a replication group. A group has a name, which takes the form of a UUID. The group is dynamic and servers can leave (either voluntarily or involuntarily) and join it at any ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-performance.html
Expelled members automatically attempt to rejoin the group, and are brought up to date by distributed recovery. Group Replication is designed to create fault-tolerant systems with built-in failure detection and automated recovery. If a member ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-plugin-architecture.html
The recovery component manages distributed recovery, and is responsible for getting a server that is joining the group up to date by selecting the donor, managing the catch up procedure and reacting to donor failures. MySQL Group Replication is a ...