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/precision-math.html
For example, MySQL treats a number such as .0001 as an exact value rather than as an approximation, and summing it 10,000 times produces a result of exactly 1, not a value that is merely “close” to 1. MySQL provides support for precision math: ...Precision math is based on these two features: SQL modes that control how strict the server is about accepting or rejecting invalid ...
https://dev.mysql.com/doc/refman/8.0/en/replica-io-thread-states.html
In MySQL 8.0.26, incompatible changes were made to instrumentation names, including the names of thread stages, containing the terms “master”, which is changed to “source”, “slave”, which is changed to “replica”, and “mts” (for ... The following list shows the most common states you see in the State column for a replication I/O (receiver) thread on a replica ...
https://dev.mysql.com/doc/refman/8.0/en/adding-collation-simple-8bit.html
You can check the variable value as follows, although the path name might be different on your system: mysql> SHOW VARIABLES LIKE 'character_sets_dir'; +--------------------+-----------------------------------------+ | Variable_name | Value | ...
https://dev.mysql.com/doc/refman/8.0/en/adding-collation.html
A collation is a set of rules that defines how to compare and sort character strings. Every character set has at least one collation, and most have two or more collations. Characters with equal weights compare as equal, and characters with unequal ... Warning User-defined collations are deprecated; you should expect support for them to be removed in a future version of ...
https://dev.mysql.com/doc/refman/8.0/en/assigning-passwords.html
Operations that assign or modify passwords are permitted only to users with the CREATE USER privilege, or, alternatively, privileges for the mysql database (INSERT privilege to create new accounts, UPDATE privilege to modify existing accounts). For ... Required credentials for clients that connect to the MySQL server can include a ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-elements.html
System variables enable audit log configuration and status variables provide runtime operational information. MySQL Enterprise Audit is based on the audit log plugin and related elements: A server-side plugin named audit_log examines auditable ...
https://dev.mysql.com/doc/refman/8.0/en/cache-index.html
Creates 2 key caches named kc_fast and kc_slow Assigns the index for partition p0 to the kc_fast key cache and the index for partitions p1 and p3 to the kc_slow key cache; the index for the remaining partition (p2) uses the server's default key ...| ...
https://dev.mysql.com/doc/refman/8.0/en/charset-collation-information-schema.html
However, for values that correspond to objects that are represented in the file system, such as databases and tables, searches in INFORMATION_SCHEMA string columns can be case-sensitive or case-insensitive, depending on the characteristics of the ...
https://dev.mysql.com/doc/refman/8.0/en/comments.html
This syntax differs slightly from standard SQL comment syntax, as discussed in Section 1.6.2.4, “'--' as the Start of a Comment”. This syntax enables a comment to extend over multiple lines because the beginning and closing sequences need not be ... MySQL Server supports three comment styles: From a # character to the end of the ...
https://dev.mysql.com/doc/refman/8.0/en/comp-err.html
It compiles the errmsg.sys file from text-format error information in MySQL source distributions: As of MySQL 8.0.19, the error information comes from the messages_to_error_log.txt and messages_to_clients.txt files in the share directory. --help, -? ... comp_err creates the errmsg.sys file that is used by mysqld to determine the error messages to display for different error ...