Search Results
https://dev.mysql.com/doc/refman/8.4/en/spatial-analysis-functions.html
MySQL provides functions to perform various operations on spatial data.
https://dev.mysql.com/doc/refman/8.4/en/spatial-convenience-functions.html
A geometry collection is processed by giving its components one by one to the simplification algorithm, and the returned geometries are put into a geometry collection as result. The functions in this section provide convenience operations on ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-function-reference.html
The following table lists each spatial function and provides a short description of each one.
https://dev.mysql.com/doc/refman/8.4/en/spatial-geohash-functions.html
Geohash is a system for encoding latitude and longitude coordinates of arbitrary precision into a text string. Geohash values are strings that contain only characters chosen from "0123456789bcdefghjkmnpqrstuvwxyz". The functions in this section ...
https://dev.mysql.com/doc/refman/8.4/en/sql-replication-statements.html
Statements are split into a group which controls source servers, a group which controls replica servers, and a group which can be applied to any replication servers. Replication can be controlled through the SQL interface using the statements ...
https://dev.mysql.com/doc/refman/8.4/en/start-replica.html
In MySQL 8.4, this is no longer an issue, and SQL_AFTER_GTIDS can be used without causing the replica to fall back into single-threaded mode. START REPLICA [thread_types] [until_option] [connection_options] [channel_option] thread_types: ...
https://dev.mysql.com/doc/refman/8.4/en/storage-engines.html
(The CREATE TABLE statement in MySQL 8.4 creates InnoDB tables by default.) MySQL Server uses a pluggable storage engine architecture that enables storage engines to be loaded into and unloaded from a running MySQL server. Storage engines are MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/stored-routines-privileges.html
The MySQL grant system takes stored routines into account as follows: The CREATE ROUTINE privilege is needed to create stored routines. The ALTER ROUTINE privilege is needed to alter or drop stored routines. This privilege is granted automatically ...
https://dev.mysql.com/doc/refman/8.4/en/subquery-optimization.html
Note A limitation on UPDATE and DELETE statements that use a subquery to modify a single table is that the optimizer does not use semijoin or materialization subquery optimizations. As a workaround, try rewriting them as multiple-table UPDATE and ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema.html
Objects in this schema include: Views that summarize Performance Schema data into more easily understandable form. MySQL 8.4 includes the sys schema, a set of objects that helps DBAs and developers interpret data collected by the Performance Schema. sys schema objects can be used for typical tuning and diagnosis use ...