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/information-schema-innodb-tablespaces-table.html
SERVER_VERSION The MySQL version that created the tablespace, or the MySQL version into which the tablespace was imported, or the version of the last major MySQL version upgrade. The value is unchanged by a release series upgrade, such as an upgrade ... The INNODB_TABLESPACES table provides metadata about InnoDB file-per-table, general, and undo ...
https://dev.mysql.com/doc/refman/8.0/en/intersect.html
query_expression_body INTERSECT [ALL | DISTINCT] query_expression_body [INTERSECT [ALL | DISTINCT] query_expression_body] [...] query_expression_body: See Section 15.2.14, “Set Operations with UNION, INTERSECT, and EXCEPT” INTERSECT limits the ...
https://dev.mysql.com/doc/refman/8.0/en/ipv6-local-connections.html
The following procedure shows how to configure MySQL to permit IPv6 connections by clients that connect to the local server using the ::1 local host address. Start the MySQL server with an appropriate bind_address setting to permit it to accept ...
https://dev.mysql.com/doc/refman/8.0/en/ipv6-remote-connections.html
The following procedure shows how to configure MySQL to permit IPv6 connections by remote clients. Start the MySQL server with an appropriate bind_address setting to permit it to accept IPv6 connections. For example, put the following lines in the ...It is similar to the preceding procedure for local clients, but the server and client hosts are distinct and each has its own nonlocal IPv6 ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-encrypted-file-plugin.html
Note The keyring_encrypted_file plugin is an extension included in MySQL Enterprise Edition, a commercial product. As of MySQL 8.0.34, this plugin is deprecated and subject to removal in a future release of MySQL. The keyring_encrypted_file plugin ...The keyring_encrypted_file keyring plugin stores keyring data in an encrypted, password-protected file local to the server ...
https://dev.mysql.com/doc/refman/8.0/en/making-windows-dumps.html
Program Database files (with suffix pdb) are included in the ZIP Archive Debug Binaries & Test Suite distribution of MySQL. These files provide information for debugging your MySQL installation in the event of a problem. The PDB file contains more ...This is a separate download from the standard MSI or Zip ...
https://dev.mysql.com/doc/refman/8.0/en/optimizer-issues.html
In many cases, MySQL can calculate the best possible query plan, but sometimes MySQL does not have enough information about the data at hand and has to make “educated” guesses about the data. MySQL uses a cost-based optimizer to determine the ...Use ANALYZE TABLE tbl_name to update the key distributions for the scanned ...
https://dev.mysql.com/doc/refman/8.0/en/rebuilding-tables.html
This section describes how to rebuild or repair tables or indexes, which may be necessitated by: Changes to how MySQL handles data types or character sets. Required table repairs or upgrades reported by CHECK TABLE, mysqlcheck, or mysql_upgrade.
https://dev.mysql.com/doc/refman/8.0/en/replication-formats.html
This is called statement-based replication (which can be abbreviated as SBR), which corresponds to the MySQL statement-based binary logging format. You can also configure MySQL to use a mix of both statement-based and row-based logging, depending on ... Replication works because events written to the binary log are read from the source and then processed on the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-functions-async-failover.html
The following functions, which are available from MySQL 8.0.22 for standard source to replica replication and from MySQL 8.0.23 for Group Replication, enable you to add and remove replication source servers from the source list for a replication ...