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/charset-unicode-utf8mb4.html
The utf8mb4 character set has these characteristics: Supports BMP and supplementary characters. utf8mb4 contrasts with the utf8mb3 character set, which supports only BMP characters and uses a maximum of three bytes per character: For a BMP ...
https://dev.mysql.com/doc/refman/8.0/en/choosing-types.html
For optimum storage, you should try to use the most precise type in all cases. For example, if an integer column is used for values in the range from 1 to 99999, MEDIUMINT UNSIGNED is the best type. Of the types that represent all the required ...
https://dev.mysql.com/doc/refman/8.0/en/document-store-interfaces.html
To work with MySQL as a document store, you use dedicated components and a choice of clients that support communicating with the MySQL server to develop document based applications. You can use MySQL Shell to prototype applications, execute queries ...Installing MySQL Shell has instructions to download and install MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/event-scheduler.html
Section 27.4.4, “Event Metadata”, shows how to obtain information about events and how this information is stored by the MySQL Server. Stored routines require the events data dictionary table in the mysql system database. If you are upgrading to ... The MySQL Event Scheduler manages the scheduling and execution of events, that is, tasks that run according to a ...
https://dev.mysql.com/doc/refman/8.0/en/events-metadata.html
To obtain metadata about events: Query the EVENTS table of the INFORMATION_SCHEMA database. For representation of event information in the data dictionary, the execute_at, starts, and ends times are converted to UTC and stored along with the event ...This is the session time_zone value that is initialized from the server's global time_zone value when the session begins but may be changed during the ...
https://dev.mysql.com/doc/refman/8.0/en/firewall-information-schema-tables.html
The following sections describe the INFORMATION_SCHEMA tables associated with MySQL Enterprise Firewall (see Section 8.4.7, “MySQL Enterprise Firewall”). These tables are available only if the appropriate firewall plugins are enabled.
https://dev.mysql.com/doc/refman/8.0/en/getting-information.html
What if you forget the name of a database or table, or what the structure of a given table is (for example, what its columns are called)? MySQL addresses this problem through several statements that provide information about the databases and ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-changing-group-mode.html
This section explains how to change the mode which a group is running in, either single or multi-primary. The functions used to change a group's mode can be run on any member. Changing to Single-Primary Mode Use the ...Members running MySQL 8.0.16 ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-performance-xcom-cache.html
The group communication engine for Group Replication (XCom, a Paxos variant) includes a cache for messages (and their metadata) exchanged between the group members as a part of the consensus protocol. Note that the limit set using ...Among other ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-primary-secondary-replication.html
It is a shared-nothing system, where all servers have a full copy of the data by default. The source is the primary, and there are one or more replicas, which are secondaries. The source applies transactions, commits them and then they are later ...