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/fulltext-stopwords.html
In a MySQL source distribution, you can find this list in the storage/myisam/ft_static.c file. The stopword list is loaded and searched for full-text queries using the server character set and collation (the values of the character_set_server and ...
https://dev.mysql.com/doc/refman/8.0/en/function-resolution.html
MySQL supports built-in (native) functions, loadable functions, and stored functions. The following list names the functions in MySQL 8.0 that are affected by the IGNORE_SPACE setting and listed as special in the sql/lex.h source file. ADDDATE ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-changing-group-mode.html
If any member is running a MySQL Server version between MySQL 8.0.13 and MySQL 8.0.16, this safeguard is not enforced for the group and you can specify any new primary member, but it is recommended to select a primary that is running the lowest ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-online-upgrade-methods.html
The primary cannot remain as the primary unless it is running the lowest MySQL Server version in the group. The group elects a new primary whenever necessary from among the members running the lowest MySQL Server version, following the election ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-read-only-instance.html
You can query InnoDB tables where the MySQL data directory is on read-only media by enabling the --innodb-read-only configuration option at server startup. To enable read-only mode for an entire MySQL instance, specify the following configuration ...How to Enable To prepare an instance for read-only operation, make sure all the necessary information is flushed to the data files before storing it on the read-only ...
https://dev.mysql.com/doc/refman/8.0/en/ipv6-support.html
Support for IPv6 in MySQL includes these capabilities: MySQL Server can accept TCP/IP connections from clients connecting over IPv6. For example, this command connects over IPv6 to the MySQL server on the local host: $> mysql -h ::1 To use this ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-data-directories.html
Each MySQL Instance on a machine should have its own data directory. Permitting multiple MySQL servers to access a common data directory over NFS is a very bad idea. Create a New Data Directory With this method, the data directory is in the same ...
https://dev.mysql.com/doc/refman/8.0/en/nonpersistible-system-variables.html
You must perform this step directly on the MySQL server host because persist_only_admin_x509_subject itself cannot be persisted at runtime. SET PERSIST and SET PERSIST_ONLY enable global system variables to be persisted to the mysqld-auto.cnf ...
https://dev.mysql.com/doc/refman/8.0/en/numeric-type-attributes.html
MySQL supports an extension for optionally specifying the display width of integer data types in parentheses following the base keyword for the type. If you store values larger than the display width in an integer column that has the ZEROFILL ...
https://dev.mysql.com/doc/refman/8.0/en/reloading-sql-format-dumps.html
To reload a dump file written by mysqldump that consists of SQL statements, use it as input to the mysql client.