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/replication-gtids-restrictions.html
Because GTID-based replication is dependent on transactions, some features otherwise available in MySQL are not supported when using it. This restriction is lifted in MySQL 8.0.21 on storage engines that support atomic DDL. From MySQL 8.0.13, when ...This section provides information about restrictions on and limitations of replication with ...
https://dev.mysql.com/doc/refman/8.0/en/replication-howto-repuser.html
Each replica connects to the source using a MySQL user name and password, so there must be a user account on the source that the replica can use to connect. The user name is specified by the SOURCE_USER | MASTER_USER option of the CHANGE ...Any ...
https://dev.mysql.com/doc/refman/8.0/en/replication-howto-slaveinit.html
You must be able to connect to the source MySQL server using TCP/IP. To set up the replica to communicate with the source for replication, configure the replica with the necessary connection information. The CHANGE REPLICATION SOURCE TO | CHANGE ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options.html
The following sections contain information about mysqld options and server variables that are used in replication and for controlling the binary log. server_uuid The MySQL server generates a true UUID in addition to the default or user-supplied ...
https://dev.mysql.com/doc/refman/8.0/en/reproducible-test-case.html
If you encounter corrupted MyISAM tables or if mysqld always fails after some update statements, you can test whether the issue is reproducible by doing the following: Stop the MySQL daemon with mysqladmin shutdown. Remove (or move away) any old log ...For information about steps to take when encountering InnoDB table corruption, see Section 1.5, “How to Report Bugs or ...
https://dev.mysql.com/doc/refman/8.0/en/reserved-accounts.html
One part of the MySQL installation process is data directory initialization (see Section 2.9.1, “Initializing the Data Directory”). During data directory initialization, MySQL creates user accounts that should be considered reserved: ...This ...
https://dev.mysql.com/doc/refman/8.0/en/security.html
When thinking about security within a MySQL installation, you should consider a wide range of possible topics and how they affect the security of your MySQL server and related applications: General factors that affect security. The security is ...
https://dev.mysql.com/doc/refman/8.0/en/selinux.html
MySQL SELinux policy modules, for example, define policy rules using type information. mysqld_db_t is the type associated with the MySQL data directory and its files. Security-Enhanced Linux (SELinux) is a mandatory access control (MAC) system that ...
https://dev.mysql.com/doc/refman/8.0/en/show-create-view.html
MySQL lets you use different sql_mode settings to tell the server the type of SQL syntax to support. For example, you might use the ANSI SQL mode to ensure MySQL correctly interprets the standard SQL concatenation operator, the double bar (||), in ... SHOW CREATE VIEW view_name This statement shows the CREATE VIEW statement that creates the named ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-geohash-functions.html
If any argument has a longitude or latitude that is out of range, an error occurs: If a longitude value is not in the range (−180, 180], an ER_GEOMETRY_PARAM_LONGITUDE_OUT_OF_RANGE error occurs (ER_LONGITUDE_OUT_OF_RANGE prior to MySQL 8.0.12). If ... Geohash is a system for encoding latitude and longitude coordinates of arbitrary precision into a text ...