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/create-view.html
MySQL checks view privileges like this: At view definition time, the view creator must have the privileges needed to use the top-level objects accessed by the view. Beginning with MySQL 8.0.19, the SELECT statement can use a VALUES statement as its ...If the view does not exist, CREATE OR REPLACE VIEW is the same as CREATE ...
https://dev.mysql.com/doc/refman/8.0/en/version-tokens-reference.html
mysql> SELECT version_tokens_lock_exclusive('lock1', 'lock2', 10); +-----------------------------------------------------+ | version_tokens_lock_exclusive('lock1', 'lock2', 10) | +-----------------------------------------------------+ | 1 | ... The ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-optimization.html
Some INFORMATION_SCHEMA tables contain columns that provide table statistics: STATISTICS.CARDINALITY TABLES.AUTO_INCREMENT TABLES.AVG_ROW_LENGTH TABLES.CHECKSUM TABLES.CHECK_TIME TABLES.CREATE_TIME TABLES.DATA_FREE TABLES.DATA_LENGTH ...
https://dev.mysql.com/doc/refman/8.0/en/stored-programs-logging.html
Because MySQL does not check if a function really is deterministic at creation time, the invocation of a stored function with the DETERMINISTIC keyword might carry out an action that is unsafe for statement-based logging, or invoke a function or ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-usage-differences.html
As of MySQL 8.0, those tables are not used, so it is not possible to dump timestamps. Use of a data dictionary-enabled MySQL server entails some operational differences compared to a server that does not have a data dictionary: Previously, enabling ...The same principle applies to other table operations that require modifying data dictionary ...
https://dev.mysql.com/doc/refman/8.0/en/flow-control-functions.html
If all types are temporal, the result is temporal: If all temporal types are DATE, TIME, or TIMESTAMP, the result is DATE, TIME, or TIMESTAMP, respectively. Otherwise, for a mix of temporal types, the result is DATETIME. mysql> SELECT IF(1>2,2,3); ...The second syntax returns the result for the first condition that is ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-adding-instances.html
It is now time to expand the group by adding the other two servers configured previously. In other words, the transactions applied on s1 up to the point in time that s2 joined the group have been replicated to s2. [mysqld] # # Disable other storage ... At this point, the group has one member in it, server s1, which has some data in ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-limitations.html
Group Replication cannot be started following a MySQL Server upgrade that uses the MINIMAL option (--upgrade=MINIMAL), which does not upgrade system tables on which the replication internals depend. Up to and including MySQL 8.0.20, Group ... Limit ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-howto.html
This section describes a process for configuring and starting GTID-based replication in MySQL 8.0. This is a “cold start” procedure that assumes either that you are starting the source server for the first time, or that it is possible to stop ...For information about changing GTID mode on servers online, see Section 19.1.4, “Changing GTID Mode on Online ...
https://dev.mysql.com/doc/refman/8.0/en/caching-sha2-pluggable-authentication.html
For example: $> mysql --ssl-mode=DISABLED -u sha2user -p Enter password: password For this connection attempt by sha2user, the server determines that caching_sha2_password is the appropriate authentication plugin and invokes it (because that was the ... MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: caching_sha2_password: Implements SHA-256 authentication (like the deprecated sha256_password), but uses caching on the server side for better performance and has additional features for wider ...