PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replication-features-triggers.html
(Bug #45677) A trigger can have triggers for different combinations of trigger event (INSERT, UPDATE, DELETE) and action time (BEFORE, AFTER), and multiple triggers are permitted. It is sufficient to switch to statement-based replication only for ...
https://dev.mysql.com/doc/refman/8.0/en/string-functions-charset.html
MySQL has many operators and functions that return a string. This section answers the question: What is the character set and collation of such a string? For simple functions that take string input and return a string result as output, the output's ...WHEN a THEN b WHEN b THEN c COLLATE X END, the resulting collation ...
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/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 ...
https://dev.mysql.com/doc/refman/8.0/en/security-against-attack.html
All other information is transferred as text, and can be read by anyone who is able to watch the connection. If the connection between the client and the server goes through an untrusted network, and you are concerned about this, you can use the ...