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-threads.html
The source creates a thread to send the binary log contents to a replica when the replica connects. When a START SLAVE statement is issued on a replica server, the replica creates an I/O thread, which connects to the source and asks it to send the ... MySQL replication capabilities are implemented using three main threads, one on the source server and two on the replica: Binary log dump ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-type-overview.html
MySQL has spatial data types that correspond to OpenGIS classes. The basis for these types is described in Section 11.4.2, “The OpenGIS Geometry Model”. Some spatial data types hold single geometry values: GEOMETRY POINT LINESTRING POLYGON ...
https://dev.mysql.com/doc/refman/5.7/en/stored-routines-syntax.html
Stored routines are created with the CREATE PROCEDURE and CREATE FUNCTION statements (see Section 13.1.16, “CREATE PROCEDURE and CREATE FUNCTION Statements”). A stored routine is either a procedure or a function. A procedure is invoked using a ...
https://dev.mysql.com/doc/refman/5.7/en/sys-table-exists.html
Tests whether a given table exists as a regular table, a TEMPORARY table, or a view. If both a temporary and a permanent table exist with the given name, TEMPORARY is returned. Parameters in_db VARCHAR(64): The name of the database in which to ...
https://dev.mysql.com/doc/refman/5.7/en/view-algorithms.html
The optional ALGORITHM clause for CREATE VIEW or ALTER VIEW is a MySQL extension to standard SQL. A reason to specify TEMPTABLE explicitly is that locks can be released on underlying tables after the temporary table has been created and before it ...For MERGE, the text of a statement that refers to the view and the view definition are merged such that parts of the view definition replace corresponding parts of the ...
https://dev.mysql.com/doc/refman/5.7/en/all-subqueries.html
The expression is TRUE if table t2 contains (-5,0,+5) because 10 is greater than all three values in t2. The expression is FALSE if table t2 contains (12,6,NULL,-100) because there is a single value 12 in table t2 that is greater than 10. The ...
https://dev.mysql.com/doc/refman/5.7/en/analyze-table.html
This makes ANALYZE TABLE fast on InnoDB tables but not 100% accurate because it does not take all rows into account. ANALYZE TABLE performs a key distribution analysis and stores the distribution for the named table or tables. For MyISAM tables, ...
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-type-conversion.html
Conversion of DATETIME and TIMESTAMP values: Conversion to a DATE value takes fractional seconds into account and rounds the time part. To some extent, you can convert a value from one temporal type to another. However, there may be some alteration ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-tuning-recovery.html
mysql> SET GLOBAL group_replication_recovery_retry_count= 10; Note that this accounts for the global number of attempts that the server joining the group makes connecting to each one of the suitable donors. Whenever a new member joins a replication ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-connection-control-table-reference.html
Table 24.9 INFORMATION_SCHEMA Connection Control Tables Table Name Description CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS Current number of consecutive failed connection attempts per account .