Search Results
https://dev.mysql.com/doc/refman/8.4/en/enterprise-encryption-installation.html
Note Installing the component installs all of its functions, so you do not need to create them using CREATE FUNCTION statements as in older releases of MySQL. The functions are provided by a MySQL component component_enterprise_encryption, and ...
https://dev.mysql.com/doc/refman/8.4/en/error-log-rotation.html
For example, assuming a log file name of host_name.err, use the following commands to rename the file and create a new one: mv host_name.err host_name.err-old mysqladmin flush-logs error mv host_name.err-old backup-directory On Windows, use rename ... If you flush the error log using a FLUSH ERROR LOGS or FLUSH LOGS statement, or a mysqladmin flush-logs command, the server closes and reopens any error log file to which it is ...
https://dev.mysql.com/doc/refman/8.4/en/examples.html
Here are examples of how to solve some common problems with MySQL. Some of the examples use the table shop to hold the price of each article (item number) for certain traders (dealers). Supposing that each trader has a single fixed price per ...
https://dev.mysql.com/doc/refman/8.4/en/federated-description.html
When you create a table using one of the standard storage engines (such as MyISAM, CSV or InnoDB), the table consists of the table definition and the associated data. When you create a FEDERATED table, the table definition is the same, but the ...A ...
https://dev.mysql.com/doc/refman/8.4/en/gis-class-geometry.html
It is a noninstantiable class but has a number of properties, described in the following list, that are common to all geometry values created from any of the Geometry subclasses. To ensure SRID 0 behavior, create geometry values using SRID 0.
https://dev.mysql.com/doc/refman/8.4/en/gis-format-conversion-functions.html
See Section 14.16.3, “Functions That Create Geometry Values from WKT Values”, and Section 14.16.4, “Functions That Create Geometry Values from WKB Values”. MySQL supports the functions listed in this section for converting geometry values ...
https://dev.mysql.com/doc/refman/8.4/en/gis-geometry-class-hierarchy.html
The geometry classes define a hierarchy as follows: Geometry (noninstantiable) Point (instantiable) Curve (noninstantiable) LineString (instantiable) Line LinearRing Surface (noninstantiable) Polygon (instantiable) GeometryCollection (instantiable) ...All classes have properties, and instantiable classes may also have assertions (rules that define valid class ...
https://dev.mysql.com/doc/refman/8.4/en/group-by-handling.html
SQL-92 and earlier does not permit queries for which the select list, HAVING condition, or ORDER BY list refer to nonaggregated columns that are not named in the GROUP BY clause. SQL:1999 and later permits such nonaggregates per optional feature ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-deploying-in-single-primary-mode.html
This section explains how to create a replication group with three MySQL Server instances, each running on a different host machine. Figure 20.7 Group Architecture This tutorial explains how to get and deploy MySQL Server with the Group Replication ... Each of the MySQL server instances in a group can run on an independent physical host machine, which is the recommended way to deploy Group ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-failure-detection.html
In a replication group, each member has a point-to-point communication channel to each other member, creating a fully connected graph. Group Replication’s failure detection mechanism is a distributed service which is able to identify that a ...