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/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 ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-upgrade.html
Choosing between an in-place or logical upgrade depends on the amount of data stored in the group. The basic process of upgrading members of a group is the same as upgrading stand-alone instances, see Chapter 3, Upgrading MySQL for the actual ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-optimizer-trace-table.html
The OPTIMIZER_TRACE table provides information produced by the optimizer tracing capability for traced statements. The OPTIMIZER_TRACE table has these columns: QUERY The text of the traced statement. MISSING_BYTES_BEYOND_MAX_MEM_SIZE Each ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-column-indexes.html
For certain data types, you can index a prefix of the column (see Section 10.3.5, “Column Indexes”). MySQL can use multiple-column indexes for queries that test all the columns in the index, or queries that test just the first column, the first ... MySQL can create composite indexes (that is, indexes on multiple ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-interconnects.html
Even before design of NDBCLUSTER began in 1996, it was evident that one of the major problems to be encountered in building parallel databases would be communication between the nodes in the network. For this reason, NDBCLUSTER was designed from ...