Search Results
https://dev.mysql.com/doc/refman/9.7/en/solaris-installation-pkg.html
The pkg installer copies a suitable startup script for MySQL into /etc/init.d/mysql. You can install MySQL on Solaris using a binary package of the native Solaris PKG format instead of the binary tarball distribution. To use this package, download ...
https://dev.mysql.com/doc/refman/9.7/en/source-installation.html
We put a great deal of effort into ensuring that our binaries are built with the best possible options for optimal performance. Building MySQL from the source code enables you to customize build parameters, compiler optimizations, and installation ...
https://dev.mysql.com/doc/refman/9.7/en/spatial-analysis-functions.html
MySQL provides functions to perform various operations on spatial data.
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/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/9.7/en/storage-engines.html
(The CREATE TABLE statement in MySQL 9.7 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/9.7/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/9.7/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 ...