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/windows-extract-archive.html
If you do not install MySQL at C:\mysql, you must specify the path to the install directory during startup or in an option file. Extract the install archive to the chosen installation location using your preferred file-compression tool. To install ...Make sure that you are logged in as a user with administrator ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-functions.html
When database db2 is copied to server1, the GTIDs of the transactions committed on server2, which are not in the binary log files on server1, must be added to gtid_purged for server1 to make the set complete. Example 19.2 Backup and restore scenario ... This section provides examples of stored functions (see Chapter 27, Stored Objects) which you can create using some of the built-in functions provided by MySQL for use with GTID-based replication, listed here: GTID_SUBSET(): Shows whether one GTID set is a subset of ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-key.html
Any columns used as the partitioning key must comprise part or all of the table's primary key, if the table has one. If you define an explicit partitioning scheme for an NDB table, the table must have an explicit primary key, and any columns used in ... Partitioning by key is similar to partitioning by hash, except that where hash partitioning employs a user-defined expression, the hashing function for key partitioning is supplied by the MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/group-by-optimization.html
The column must be in the index and must immediately follow the columns in the GROUP BY. Any other parts of the index than those from the GROUP BY referenced in the query must be constants (that is, they must be referenced in equalities with ... The ...In some cases, MySQL is able to do much better than that and avoid creation of temporary tables by using index ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-ipv6.html
To use IPv6 addresses, the operating system on the server host and the MySQL Server instance must both be configured to support IPv6. When specified with a port number, an IPv6 address must be specified in square brackets, for example: ... As of ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations-functions.html
(Bug #54483) See Section 14.6.2, “Mathematical Functions”, for more information about the return types of these functions, as well as Section 13.1, “Numeric Data Types”. Each of these functions returns an integer only if it is passed an ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-management-hash-key.html
Tables which are partitioned by hash or by key are very similar to one another with regard to making changes in a partitioning setup, and both differ in a number of ways from tables which have been partitioned by range or list. For that reason, ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-group-members-table.html
RECOVERING: The server has joined a group from which it is retrieving data. ERROR: The member has encountered an error, either during applying transactions or during the recovery phase, and is not participating in the group's transactions. The ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-timing.html
For example, the standard gettimeofday() function can take hundreds of cycles, which is an unacceptable overhead for data gathering that may occur thousands or millions of times per second. Their accuracy is subject to the usual forms of error ...It ...
https://dev.mysql.com/doc/refman/8.0/en/creating-spatial-indexes.html
For InnoDB and MyISAM tables, MySQL can create spatial indexes using syntax similar to that for creating regular indexes, but using the SPATIAL keyword. For storage engines that support nonspatial indexing of spatial columns, the engine creates a ...A B-tree index on spatial values is useful for exact-value lookups, but not for range ...