PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/miscellaneous-functions.html
Given this statement: CREATE TABLE t AS SELECT INET6_NTOA(expr) AS c1; The resulting table would have this definition: CREATE TABLE t (c1 VARCHAR(39) CHARACTER SET utf8mb3 DEFAULT NULL); The return string uses lowercase letters for IPv6 addresses.
https://dev.mysql.com/doc/refman/8.0/en/multiple-key-caches.html
By default, table indexes are assigned to the main (default) key cache created at the server startup. Note As of MySQL 8.0, the compound-part structured-variable syntax discussed here for referring to multiple MyISAM key caches is deprecated.
https://dev.mysql.com/doc/refman/8.0/en/multiple-windows-services.html
On Windows, a MySQL server can run as a Windows service. The procedures for installing, controlling, and removing a single MySQL service are described in Section 2.3.4.8, “Starting MySQL as a Windows Service”. To set up multiple MySQL services, ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-crash-recovery.html
myisamchk works by creating a copy of the .MYD data file row by row. If you use --quick, myisamchk does not create a temporary .MYD file, but instead assumes that the .MYD file is correct and generates only a new index file without touching the .MYD ... This section describes how to check for and deal with data corruption in MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-general-options.html
The temporary files needed to sort the keys would be more than twice as big as when creating the key file directly. The options described in this section can be used for any type of table maintenance operation performed by myisamchk. The sections ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-memory.html
This space is not needed if you do a repair with --quick; in this case, only the index file is re-created. This space must be available on the same file system as the original data file, as the copy is created in the same directory as the original.
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-other-options.html
If keys are packed (PACK_KEYS=1), myisamchk must unpack key blocks first, then re-create indexes and pack the key blocks again. (In this case, re-creating indexes is faster than updating offsets for each index.) . myisamchk supports the following ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-table-info.html
To obtain a description of a MyISAM table or statistics about it, use the commands shown here. The output from these commands is explained later in this section. myisamchk -d tbl_name Runs myisamchk in “describe mode” to produce a description ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-backup-configuration.html
In addition, CompressedBackup causes NDB to use compression when creating and writing to backup files. When this parameter is set to 1, backups cannot be created without specifying ENCRYPT PASSWORD=password as part of a START BACKUP command. Five ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-backup.html
The next few sections describe how to prepare for and then to create an NDB Cluster backup using the functionality for this purpose found in the ndb_mgm management client. NDB 8.0 makes it possible to create backups using multiple LDMs to achieve ...To distinguish this type of backup from a backup made using mysqldump, we sometimes refer to it as a “native” NDB Cluster ...