PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/replication.html
Analytics - live data can be created on the source, while the analysis of the information can take place on the replica without affecting the performance of the source. Long-distance data distribution - you can use replication to create a local copy ... Replication enables data from one MySQL database server (the source) to be copied to one or more MySQL database servers (the ...
https://dev.mysql.com/doc/refman/5.7/en/savepoint.html
A new savepoint level is created when a stored function is invoked or a trigger is activated. When the function or trigger terminates, any savepoints it created are released and the previous savepoint level is restored. SAVEPOINT identifier ...
https://dev.mysql.com/doc/refman/5.7/en/show-procedure-code.html
SHOW PROCEDURE CODE proc_name This statement is a MySQL extension that is available only for servers that have been built with debugging support. It displays a representation of the internal implementation of the named stored procedure. A similar ...
https://dev.mysql.com/doc/refman/5.7/en/show-warnings.html
Warnings are generated for DML statements such as INSERT, UPDATE, and LOAD DATA as well as DDL statements such as CREATE TABLE and ALTER TABLE. mysql> CREATE TABLE t1 (a TINYINT NOT NULL, b CHAR(4)); Query OK, 0 rows affected (0.05 sec) mysql> ...
https://dev.mysql.com/doc/refman/5.7/en/slow-query-log.html
The server creates the file in the data directory unless an absolute path name is given to specify a different directory. Administrative statements include ALTER TABLE, ANALYZE TABLE, CHECK TABLE, CREATE INDEX, DROP INDEX, OPTIMIZE TABLE, and REPAIR ... The slow query log consists of SQL statements that take more than long_query_time seconds to execute and require at least min_examined_row_limit rows to be ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-analysis-functions.html
MySQL provides functions to perform various operations on spatial data.
https://dev.mysql.com/doc/refman/5.7/en/spatial-convenience-functions.html
Given two points pt1 and pt2, ST_MakeEnvelope() creates the result geometry on an abstract plane like this: If pt1 and pt2 are equal, the result is the point pt1. According to Boost.Geometry, geometries might become invalid as a result of the ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-geohash-functions.html
The string might be shorter than max_length characters because the algorithm that creates the geohash value continues until it has created a string that is either an exact representation of the location or max_length characters, whichever comes ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-types.html
The specification describes a set of SQL geometry types, as well as functions on those types to create and analyze geometry values. The other storage engines support non-SPATIAL indexes, as described in Section 13.1.14, “CREATE INDEX Statement”.
https://dev.mysql.com/doc/refman/5.7/en/symbolic-links-to-databases.html
On Unix, the way to symlink a database is first to create a directory on some disk where you have free space and then to create a soft link to it from the MySQL data directory. $> mkdir /dr1/databases/test $> ln -s /dr1/databases/test ...