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/ipv6-local-connections.html
For example, put the following lines in the server option file and restart the server: [mysqld] bind_address = * Specifying * (or ::) as the value for bind_address permits both IPv4 and IPv6 connections on all server host IPv4 and IPv6 interfaces.
https://dev.mysql.com/doc/refman/8.0/en/json-function-reference.html
->> Return value from JSON column after evaluating path and unquoting the result; equivalent to JSON_UNQUOTE(JSON_EXTRACT()). You can see how much storage space a given JSON value takes up, and how much space remains for additional storage, using ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-component-plugin-comparison.html
This section briefly compares keyring components and plugins to provide an overview of their differences. Keyring components have fewer restrictions than keyring plugins with respect to key types and lengths. The sensitive data that can be protected ... The MySQL Keyring originally implemented keystore capabilities using server plugins, but began transitioning to use the component infrastructure in MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-file-plugin.html
As of MySQL 8.0.34, this plugin is deprecated and subject to removal in a future release of MySQL. Security standards such as PCI, FIPS, and others require use of key management systems to secure, manage, and protect encryption keys in key vaults or ... The keyring_file keyring plugin stores keyring data in a file local to the server ...
https://dev.mysql.com/doc/refman/8.0/en/load-index.html
When preloading indexes for multiple partitions, the partitions need not be contiguous, and you need not list their names in any particular order. To determine index block sizes for a table, use myisamchk -dv and check the Blocksize column.
https://dev.mysql.com/doc/refman/8.0/en/loadable-function-reference.html
The following table lists each function that is loadable at runtime and provides a short description of each one. For a table listing built-in functions and operators, see Section 14.1, “Built-In Function and Operator Reference” For general ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-windows-command-line-servers.html
The procedure for starting a single MySQL server manually from the command line is described in Section 2.3.4.6, “Starting MySQL from the Windows Command Line”. To start multiple servers this way, you can specify the appropriate options on the ...It is more convenient to place the options in an option file, but it is necessary to make sure that each server gets its own set of ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-ftdump.html
myisam_ftdump scans and dumps the entire index, which is not particularly fast. On the other hand, the distribution of words changes infrequently, so it need not be run often. Example: Suppose that the test database contains a table named ...It ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-backup-configuration.html
This should be the sum of the memory allocated for the backup data buffer and the backup log buffer. This applies for both the backup data buffer and the backup log buffer. This applies for both the backup data buffer and the backup log buffer. In ... Five configuration parameters are essential for backup: BackupDataBufferSize The amount of memory used to buffer data before it is written to ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-importing-data.html
When importing data from an SQL file, it is often not necessary to enforce transactions or foreign keys, and temporarily disabling these features can speed up the import process greatly. This can be done using the mysql client, either from a client ... It is common when setting up a new instance of NDB Cluster to need to import data from an existing NDB Cluster, instance of MySQL, or other ...