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-transactions.html
In general, you should avoid transactions that update both transactional and nontransactional tables in a replication environment. A statement that references both nontransactional and transactional tables and updates any of the tables involved is ...You should also avoid using any statement that accesses both transactional (or temporary) and nontransactional tables and writes to any of ...The server uses ...
https://dev.mysql.com/doc/refman/8.0/en/validate-password-options-variables.html
validate_password.dictionary_file can be set at runtime and assigning a value causes the named file to be read without a server restart. This section describes the system and status variables that validate_password provides to enable its operation ...This applies only when changing an existing password, and has no effect when setting a user account's initial ...
https://dev.mysql.com/doc/refman/8.0/en/charset-introducer.html
A character string literal, hexadecimal literal, or bit-value literal may have an optional character set introducer and COLLATE clause, to designate it as a string that uses a particular character set and collation: [_charset_name] literal [COLLATE ...It tells the parser, “the string that follows uses character set charset_name.” An introducer does not change the string to the introducer character set like CONVERT() would ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-natural-language.html
MyISAM Limitation For very small tables, word distribution does not adequately reflect their semantic value, and this model may sometimes produce bizarre results for search indexes on MyISAM tables. For each row in the table, MATCH() returns a ...
https://dev.mysql.com/doc/refman/8.0/en/keyring.html
MySQL Server supports a keyring that enables internal server components and plugins to securely store sensitive information for later retrieval. The implementation comprises these elements: Keyring components and plugins that manage a backing store ...These keyring components are available: component_keyring_file: Stores keyring data in a file local to the server ...
https://dev.mysql.com/doc/refman/8.0/en/manual-info.html
The MySQL Database Software is under constant development, and the Reference Manual is updated frequently as well. This manual is not intended for use with older versions of the MySQL software due to the many functional and other differences between ... This is the Reference Manual for the MySQL Database System, version 8.0, through release ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-innodb-replicaset-introduction.html
This chapter introduces MySQL InnoDB ReplicaSet, which combines MySQL technologies to enable you to deploy and administer Chapter 19, Replication. An InnoDB ReplicaSet consists of at least two MySQL Server instances, and it provides all of the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-privilege-checks.html
The PRIVILEGE_CHECKS_USER account provides an additional layer of security in situations such as these: You are replicating between a server instance on your organization's network, and a server instance on another network, such as an instance ...
https://dev.mysql.com/doc/refman/8.0/en/tracing-example.html
Next, for every table in the query, we estimate the cost of, and number of records returned by, a table scan or a range access. Normally, greedy search is used, but since the statement uses a straight join, only the requested order is explored, and ...Now we can examine the trace, whose first column (QUERY), containing the original statement to be traced, is shown here: SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE\G *************************** ...
https://dev.mysql.com/doc/refman/8.0/en/slow-query-log.html
The slow query log can be used to find queries that take a long time to execute and are therefore candidates for optimization. The slow query log consists of SQL statements that take more than long_query_time seconds to execute and require at least ...However, examining a long slow query log can be a time-consuming ...By default, administrative ...