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/fulltext-search.html
For large data sets, it is much faster to load your data into a table that has no FULLTEXT index and then create the index after that, than to load data into a table that has an existing FULLTEXT index. The search string must be a string value that ...Full-text indexes can be used only with InnoDB or MyISAM tables, and can be created only for CHAR, VARCHAR, or TEXT ... MATCH (col1,col2,...) AGAINST (expr [search_modifier]) search_modifier: { IN NATURAL LANGUAGE MODE | IN NATURAL LANGUAGE MODE WITH QUERY EXPANSION | IN BOOLEAN MODE | WITH QUERY ...
https://dev.mysql.com/doc/refman/8.0/en/descending-indexes.html
For InnoDB full-text search, this means that the index required on the FTS_DOC_ID column of the indexed table cannot be defined as a descending index. Descending indexes also make it possible for the optimizer to use multiple-column indexes when the ... MySQL supports descending indexes: DESC in an index definition is no longer ignored but causes storage of key values in descending ...
https://dev.mysql.com/doc/refman/8.0/en/xml-functions.html
Do not output explicit error messages that might provide an unauthorized user with clues that could be used to compromise the system; log these to a file or database table instead. Just as SQL injection attacks can be used to obtain information ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-upgrade.html
mysql_upgrade saves the MySQL version number in a file named mysql_upgrade_info in the data directory. If the file does not exist or is otherwise inaccessible, an error occurs. If the file does not exist or is otherwise inaccessible, an error occurs. To ignore this file and perform the check regardless, use the --force ... Note As of MySQL 8.0.16, the MySQL server performs the upgrade tasks previously handled by mysql_upgrade ...
https://dev.mysql.com/doc/refman/8.0/en/large-page-support.html
In the event sysctl returns an error relating to the file name, check the name of the corresponding file in /proc/sys/vm and use that instead. Check any configuration files such as my.cnf used by the server, and make sure that ...Before large pages ... Some hardware and operating system architectures support memory pages greater than the default (usually ...Applications that perform a lot of memory accesses may ...
https://dev.mysql.com/doc/refman/8.0/en/replica-logs-status.html
The metadata in this repository includes the connection configuration, the replication user account details, the SSL settings for the connection, and the file name and position where the replication receiver thread is currently reading from the ...
https://dev.mysql.com/doc/refman/8.0/en/known-issues.html
To retain the same log file names if you change your host name to something else, you must explicitly use options such as --log-bin=old_host_name-bin. If these are binary logs, you must edit the binary log index file and fix the binary log file ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-install-linux-source.html
(This assumes that all data node hosts use the same architecture and operating system; otherwise you may need to compile separately for each different platform.) The data node binary need not be in any particular location on the host's file system, ...The archived source file should have a name similar to ... This section provides information about ...For ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-commands.html
ssl_session_data_print Serializes the current SSL session data to stdout or file. ssl_session_data_print [file_name] Fetches, serializes, and optionally stores the session data of a successful connection. The optional file name and arguments may be ...For a list of these commands, type help or \h at the mysql> prompt: mysql> help List of all MySQL commands: Note that all text commands must be first on line and end with ';' ? (\?) Synonym for ...
https://dev.mysql.com/doc/refman/8.0/en/persisted-system-variables.html
SET can also be used to persist certain global system variables to the mysqld-auto.cnf file in the data directory, to affect server operation for subsequent startups. To augment administrative capabilities for server configuration beyond what is ...