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/trigger-syntax.html
It also includes clauses that specify the trigger action time, the triggering event, and what to do when the trigger activates: The keyword BEFORE indicates the trigger action time. It is possible to define multiple triggers for a given table that ... To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 15.1.22, “CREATE TRIGGER Statement”, and Section 15.1.34, “DROP TRIGGER ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-understanding-consistency-guarantees.html
With the first approach, the group takes the minimum time possible to secure a stable group membership after a primary failure by electing a new primary and then allowing data access immediately while it is still applying any possible backlog from ...The events that relate to the consistency of a system can be split into control operations, either manual or automatically triggered by failures; and data flow ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-search-ngram.html
The built-in MySQL full-text parser uses the white space between words as a delimiter to determine where words begin and end, which is a limitation when working with ideographic languages that do not use word delimiters. To address this limitation, ...Note MySQL also provides a MeCab full-text parser plugin for Japanese, which tokenizes documents into meaningful ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-encrypted-file-component.html
Warning For encryption key management, the component_keyring_file and component_keyring_encrypted_file components, and the keyring_file and keyring_encrypted_file plugins are not intended as a regulatory compliance solution. Security standards such ... Note component_keyring_encrypted_file is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/8.0/en/ldml-rules.html
MySQL recognizes a large enough subset of the syntax that, in many cases, it is possible to download a collation definition from the Unicode Common Locale Data Repository and paste the relevant part (that is, the part between the <rules> and ...This ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-column-indexes.html
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 two columns, the first three columns, and so on. If this column is short, reasonably unique, and indexed, ... MySQL can create composite indexes (that is, indexes on multiple ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-overview.html
The shared-nothing architecture enables the system to work with very inexpensive hardware, and with a minimum of specific requirements for hardware or software. In a shared-nothing system, each component is expected to have its own memory and disk, ... NDB Cluster is a technology that enables clustering of in-memory databases in a shared-nothing ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-tcp-definition.html
Normally it is not necessary to define TCP/IP connections; NDB Cluster automatically sets up such connections for all data nodes, management nodes, and SQL or API nodes. Each [tcp] section explicitly defines a TCP/IP connection between two NDB ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-consumer-configurations.html
The following discussion describes how consumers work, showing specific configurations and their effects as consumer settings are enabled progressively from high to low. The configuration descriptions occur in order of increasing functionality and ... The consumer settings in the setup_consumers table form a hierarchy from higher levels to ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rules-table-options.html
The only type of statement that can update both an included and an ignored table and still be replicated successfully is a DML statement that has been logged with binlog_format=ROW. The replica checks for and evaluates table options only if either ...First, as a preliminary condition, the replica checks whether statement-based replication is ...