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/gis-general-property-functions.html
The functions listed in this section do not restrict their argument and accept a geometry value of any type. Unless otherwise specified, functions in this section handle their geometry arguments as follows: If any argument is NULL, the return value ...If any geometry argument is not a syntactically well-formed geometry, an ER_GIS_INVALID_DATA error ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-compatibility-upgrade.html
From MySQL 8.0.17, this applies to upgrades between patch versions, and for lower releases, this only applies to upgrades between major versions. This must therefore only be used carefully in specific situations, and you must take additional ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-deploying-in-single-primary-mode.html
Figure 20.7 Group Architecture This tutorial explains how to get and deploy MySQL Server with the Group Replication plugin, how to configure each server instance before creating a group, and how to use Performance Schema monitoring to verify that ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-options.html
The next two sections contain information about MySQL server system and server status variables which are specific to the Group Replication plugin.
https://dev.mysql.com/doc/refman/8.0/en/group-replication-upgrade-with-mysqlbackup.html
As part of a provisioning approach you can use MySQL Enterprise Backup to copy and restore the data from a group member to new members. The solution is to restore the backup to a new server instance which is running the same version of MySQL as the ...However you cannot use this technique to directly restore a backup taken from a member running an older version of MySQL to a member running a newer version of ...
https://dev.mysql.com/doc/refman/8.0/en/if.html
The IF statement can have THEN, ELSE, and ELSEIF clauses, and it is terminated with END IF. [ELSE statement_list] END IF The IF statement for stored programs implements a basic conditional construct. Note There is also an IF() function, which ...
https://dev.mysql.com/doc/refman/8.0/en/index-preloading.html
Although the blocks stay in the cache, because there are enough buffers for all of them, they are fetched from disk in random order, and not sequentially. If there are enough blocks in a key cache to hold blocks of an entire index, or at least the ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-check-constraints-table.html
As of MySQL 8.0.16, CREATE TABLE permits the core features of table and column CHECK constraints, and the CHECK_CONSTRAINTS table provides information about these constraints. The CHECK_CONSTRAINTS table has these columns: CONSTRAINT_CATALOG The ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-foreign-cols-table.html
For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”. Use the INFORMATION_SCHEMA COLUMNS table or the SHOW COLUMNS statement to view additional information about the columns of this ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-foreign-table.html
For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”. 0 = ON DELETE/UPDATE RESTRICT, 1 = ON DELETE CASCADE, 2 = ON DELETE SET NULL, 4 = ON UPDATE CASCADE, 8 = ON UPDATE SET NULL, 16 = ...The INNODB_FOREIGN table has these columns: ID The name (not a numeric value) of the foreign key index, preceded by the schema (database) name (for example, ...