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-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 ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-reference-systems.html
The SRS denoted in MySQL by SRID 0 represents an infinite flat Cartesian plane with no units assigned to its axes. SRID 0 is the default SRID for spatial data in MySQL. MySQL maintains information about available spatial reference systems for ... A ...
https://dev.mysql.com/doc/refman/8.0/en/union.html
Compared to MySQL 5.7, several user-visible effects resulted from this work, which may require rewriting of certain statements: NATURAL JOIN permits an optional INNER keyword (NATURAL INNER JOIN), in compliance with standard SQL.
https://dev.mysql.com/doc/refman/8.0/en/using-mysqldump.html
Tip Consider using the MySQL Shell dump utilities, which provide parallel dumping with multiple threads, file compression, and progress information display, as well as cloud features such as Oracle Cloud Infrastructure Object Storage streaming, and ...A dump file can be used in several ways: As a backup to enable data recovery in case of data ...