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/network-namespace-support.html
They must be invoked from within the network namespace of the server to which they are to connect.) Regular replication. The following sections describe how to use network namespaces in MySQL: Host System Prerequisites MySQL Configuration Network ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-boolean.html
The stopword list applies, controlled by innodb_ft_enable_stopword, innodb_ft_server_stopword_table, and innodb_ft_user_stopword_table for InnoDB search indexes, and ft_stopword_file for MyISAM ones. In the following query, the + and - operators ...
https://dev.mysql.com/doc/refman/8.0/en/drop-table.html
Be careful with this statement! For each table, it removes the table definition and all table data. If the table is partitioned, the statement removes the table definition, all its partitions, all data stored in those partitions, and all partition ...DROP TABLE causes an implicit commit, except when used with the TEMPORARY ...
https://dev.mysql.com/doc/refman/8.0/en/enterprise-encryption-installation.html
To install the component, issue an INSTALL COMPONENT statement: INSTALL COMPONENT "file://component_enterprise_encryption"; INSTALL COMPONENT requires the INSERT privilege for the mysql.component system table because it adds a row to that table to ... In releases before MySQL 8.0.30, the functions provided by MySQL Enterprise Encryption are installed by creating them individually, based on the openssl_udf shared ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-fine-tuning.html
For example, to make two-character words searchable, you could put the following lines in an option file: [mysqld] innodb_ft_min_token_size=2 ft_min_word_len=2 Then restart the server and rebuild your FULLTEXT indexes. (InnoDB does not have an ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-convenience-functions.html
An ER_GIS_INVALID_DATA error occurs for the additional condition that any coordinate value of the two points is infinite or NaN. If any geometry argument is not a syntactically well-formed geometry, an ER_GIS_INVALID_DATA error occurs. For functions ... The functions in this section provide convenience operations on geometry ...
https://dev.mysql.com/doc/refman/8.0/en/unix-signal-response.html
The server response to SIGUSR1 is a subset of the response to SIGHUP, enabling SIGUSR1 to be used as a more “lightweight” signal that flushes certain logs without the other SIGHUP effects such as flushing the thread and host caches and writing a ... On Unix and Unix-like systems, a process can be the recipient of signals sent to it by the root system account or the system account that owns the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-config-nodes.html
If HostName has not been set for a data node in the configuration file, localhost is used here. The config_nodes table shows nodes configured in an NDB Cluster config.ini file. For each node, the table displays a row containing the node ID, the ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table-problems.html
If you get a duplicate-key error when using ALTER TABLE to change the character set or collation of a character column, the cause is either that the new column collation maps two keys to the same value or that the table is corrupted. This is done ...In the latter case, you should run REPAIR TABLE on the ...
https://dev.mysql.com/doc/refman/8.0/en/online-ddl-parallel-thread-configuration.html
The number of parallel threads that sort and load data is controlled by the innodb_ddl_threads variable, introduced in MySQL 8.0.27. The actual number of threads that scan the clustered index is the number defined by the innodb_parallel_read_threads ...The maximum setting is 256, which is the maximum number for all ...