Search Results
https://dev.mysql.com/doc/refman/8.4/en/component-loading.html
MySQL supports manual component loading at runtime and automatic loading during server startup. For example: INSTALL COMPONENT 'file://component_validate_password'; UNINSTALL COMPONENT 'file://component_validate_password'; A loader service handles ... Components must be loaded into the server before they can be ...
https://dev.mysql.com/doc/refman/8.4/en/declare-condition.html
DECLARE condition_name CONDITION FOR condition_value condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value } The DECLARE ... It can take the following forms: mysql_error_code: An integer literal indicating a MySQL error code. Do not ...CONDITION statement declares a named error condition, associating a name with a condition that needs specific ...
https://dev.mysql.com/doc/refman/8.4/en/document-store-concepts.html
This section explains the concepts introduced as part of using MySQL as a document store. JSON Document Collection CRUD Operations JSON Document A JSON document is a data structure composed of key-value pairs and is the fundamental structure for ...
https://dev.mysql.com/doc/refman/8.4/en/example-storage-engine.html
Its purpose is to serve as an example in the MySQL source code that illustrates how to begin writing new storage engines. To enable the EXAMPLE storage engine if you build MySQL from source, invoke CMake with the -DWITH_EXAMPLE_STORAGE_ENGINE option. To examine the source for the EXAMPLE engine, look in the storage/example directory of a MySQL source ...
https://dev.mysql.com/doc/refman/8.4/en/floating-point-types.html
MySQL uses four bytes for single-precision values and eight bytes for double-precision values. MySQL also supports this optional precision specification, but the precision value in FLOAT(p) is used only to determine storage size. MySQL permits a ...
https://dev.mysql.com/doc/refman/8.4/en/gis-wkt-functions.html
For example, both of the following function calls are valid: ST_MPointFromText('MULTIPOINT (1 1, 2 2, 3 3)') ST_MPointFromText('MULTIPOINT ((1 1), (2 2), (3 3))') Functions such as ST_GeomFromText() that accept WKT geometry collection arguments ...
https://dev.mysql.com/doc/refman/8.4/en/group-by-functional-dependence.html
The following discussion provides several examples of the ways in which MySQL detects functional dependencies. The examples use the world database, which can be downloaded from https://dev.mysql.com/doc/index-other.html. The examples use this ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-deploying-instances.html
The first step is to deploy at least three instances of MySQL Server, this procedure demonstrates using multiple hosts for the instances, named s1, s2, and s3. It is assumed that MySQL Server is installed on each host (see Chapter 2, Installing ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-distributed-recovery-connections.html
Important Distributed recovery can fail if a joining member cannot correctly identify the other members using the host name as defined by MySQL Server's hostname system variable. It is recommended that operating systems running MySQL have a properly ... When a joining member connects to an online existing member for state transfer during distributed recovery, the joining member acts as a client on the connection and the existing member acts as a ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-online-upgrade-methods.html
The primary cannot remain as the primary unless it is running the lowest MySQL Server version in the group. The group elects a new primary whenever necessary from among the members running the lowest MySQL Server version, following the election ...