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-format-conversion-functions.html
MySQL supports the functions listed in this section for converting geometry values from internal geometry format to WKT or WKB format, or for swapping the order of X and Y coordinates. Functions such as ST_GeomFromText() that accept WKT geometry ...
https://dev.mysql.com/doc/refman/8.0/en/gis-point-property-functions.html
mysql> SET @pt = ST_GeomFromText('POINT(45 90)', 4326); mysql> SELECT ST_Latitude(@pt); +------------------+ | ST_Latitude(@pt) | +------------------+ | 45 | +------------------+ mysql> SELECT ST_AsText(ST_Latitude(@pt, 10)); ... A Point consists of ...
https://dev.mysql.com/doc/refman/8.0/en/gis-polygon-property-functions.html
As of MySQL 8.0.13, ST_Area() handles its arguments as described in the introduction to this section, with these exceptions: If the geometry is geometrically invalid, either the result is an undefined area (that is, it can be any number), or an ...
https://dev.mysql.com/doc/refman/8.0/en/ldml-collation-example.html
To add a UCA collation for a Unicode character set without recompiling MySQL, use the following procedure. If you are unfamiliar with the LDML rules used to describe the collation's sort characteristics, see Section 12.14.4.2, “LDML Syntax ...The ...
https://dev.mysql.com/doc/refman/8.0/en/replication-privilege-checks-gr.html
From MySQL 8.0.19, as well as securing asynchronous and semi-synchronous replication, you may choose to use a PRIVILEGE_CHECKS_USER account to secure the two replication applier threads used by Group Replication. To secure one of these threads, ...
https://dev.mysql.com/doc/refman/8.0/en/selinux-file-context.html
The MySQL Server reads from and writes to many files. The instructions that follow use the semanage binary to manage file context; on RHEL, it's part of the policycoreutils-python-utils package: yum install -y policycoreutils-python-utils After ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-params-ndbd.html
HeartbeatIntervalDbDb: Time between data node-to-data node heartbeats; data node considered dead after 3 missed heartbeats. KeepAliveSendInterval: Time between keep-alive signals on links between data nodes, in milliseconds. LcpScanProgressTimeout: ... The listings in this section provide information about parameters used in the [ndbd] or [ndbd default] sections of a config.ini file for configuring NDB Cluster data ...
https://dev.mysql.com/doc/refman/8.0/en/backup-policy.html
A full backup (a snapshot of the data at a point in time) can be done in MySQL with several tools. For example, MySQL Enterprise Backup can perform a physical backup of an entire instance, with optimizations to minimize overhead and avoid disruption ...This backup operation acquires a global read lock on all tables at the beginning of the dump (using FLUSH TABLES WITH READ ...
https://dev.mysql.com/doc/refman/8.0/en/load-data.html
The mysqlimport utility provides another way to load data files; it operates by sending a LOAD DATA statement to the server. For example, if mysqld was started with the local_infile system variable disabled, LOCAL produces an error. For example, if ...The file can be read from the server host or the client host, depending on whether the LOCAL modifier is ...
https://dev.mysql.com/doc/refman/8.0/en/replication-delayed.html
MySQL supports delayed replication such that a replica server deliberately executes transactions later than the source by at least a specified amount of time. In MySQL 8.0, the method of delaying replication depends on two timestamps, ...This ...