Search Results
https://dev.mysql.com/doc/refman/8.4/en/spatial-geohash-functions.html
These geohash functions are available: ST_GeoHash(longitude, latitude, max_length), ST_GeoHash(point, max_length) Returns a geohash string in the connection character set and collation. Geohash is a system for encoding latitude and longitude ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-geojson-functions.html
This section describes functions for converting between GeoJSON documents and spatial values. Feature and FeatureCollection objects are not supported, except that geometry objects are extracted from them. MySQL also supports a native JSON data type ...
https://dev.mysql.com/doc/refman/8.4/en/sql-mode.html
The MySQL server can operate in different SQL modes, and can apply these modes differently for different clients, depending on the value of the sql_mode system variable. DBAs can set the global SQL mode to match site server operating requirements, ...
https://dev.mysql.com/doc/refman/8.4/en/start-group-replication.html
To gain the security benefits of specifying user credentials on START GROUP_REPLICATION, ensure that group_replication_start_on_boot is set to OFF (the default is ON), and clear any user credentials previously set for the group_replication_recovery ... START GROUP_REPLICATION [USER='user_name'] [, PASSWORD='user_pass'] [, DEFAULT_AUTH='plugin_name'] Starts group ...
https://dev.mysql.com/doc/refman/8.4/en/storage-requirements.html
It connects to a current MySQL (not NDB Cluster) database and creates a report on how much space that database would require if it used the NDB storage engine. InnoDB Table Storage Requirements NDB Table Storage Requirements Numeric Type Storage ...
https://dev.mysql.com/doc/refman/8.4/en/stored-program-restrictions.html
(See also Bug #16522.) Each execution of the statements contained in the body of an event takes place in a new connection; thus, these statements have no effect in a given user session on the server's statement counts such as Com_select and ...Some ...
https://dev.mysql.com/doc/refman/8.4/en/stored-routines-syntax.html
The client should also specify the CLIENT_MULTI_RESULTS option when it connects. For C programs, this can be done with the mysql_real_connect() C API function. A stored routine is either a procedure or a function. Stored routines are created with ...
https://dev.mysql.com/doc/refman/8.4/en/string-functions.html
TO_BASE64(str) Converts the string argument to base-64 encoded form and returns the result as a character string with the connection character set and collation. For functions that operate on string positions, the first position is numbered 1. For ...
https://dev.mysql.com/doc/refman/8.4/en/sys-host-summary-by-file-io-type.html
The host_summary_by_file_io_type and x$host_summary_by_file_io_type views have these columns: host The host from which the client connected. These views summarize file I/O, grouped by host and event type. By default, rows are sorted by host and ...
https://dev.mysql.com/doc/refman/8.4/en/sys-host-summary-by-file-io.html
The host_summary_by_file_io and x$host_summary_by_file_io views have these columns: host The host from which the client connected. By default, rows are sorted by descending total file I/O latency. Rows for which the HOST column in the underlying ...