PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/group-replication-use-cases.html
Group Replication enables you to create fault-tolerant systems with redundancy by replicating the system state to a set of servers. Depending on the number of servers which fail the group might have degraded performance or scalability, but it is ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-transaction-inconsistencies.html
CHANGE MASTER TO statements for that channel fail with an error, unless the applier threads are running and the CHANGE MASTER TO statement only sets receiver options. Thus issuing RESET SLAVE on a replica with gaps means the replica loses any ...To ... Inconsistencies in the sequence of transactions that have been executed from the relay log can occur depending on your replication ...
https://dev.mysql.com/doc/refman/5.7/en/starting-server-troubleshooting.html
This section provides troubleshooting suggestions for problems starting the server. For additional suggestions for Windows systems, see Section 2.3.5, “Troubleshooting a Microsoft Windows MySQL Server Installation”. Log files are located in the ...If you have problems starting the server, here are some things to try: Check the error log to see why the server does not ...
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/apis-python.html
MySQLdb is a third-party driver that provides MySQL support for Python, compliant with the Python DB API version 2.0. See MySQL Connector/Python Developer Guide for details on the Connector, as well as coding guidelines for Python applications and ...The new MySQL Connector/Python component provides an interface to the same Python API, and is built into the MySQL Server and supported by ...
https://dev.mysql.com/doc/refman/5.7/en/corrupted-myisam-tables.html
Even though the MyISAM table format is very reliable (all changes to a table made by an SQL statement are written before the statement returns), you can still get corrupted tables if any of the following events occur: The mysqld process is killed ...You are using an external program (such as myisamchk) to modify a table that is being modified by the server at the same ...
https://dev.mysql.com/doc/refman/5.7/en/create-function.html
The CREATE FUNCTION statement is used to create stored functions and loadable functions: For information about creating stored functions, see Section 13.1.16, “CREATE PROCEDURE and CREATE FUNCTION Statements”. For information about creating ...
https://dev.mysql.com/doc/refman/5.7/en/creating-spatial-columns.html
MySQL provides a standard way of creating spatial columns for geometry types, for example, with CREATE TABLE or ALTER TABLE. Spatial columns are supported for MyISAM, InnoDB, NDB, and ARCHIVE tables. See also the notes about spatial indexes under ...
https://dev.mysql.com/doc/refman/5.7/en/declare-cursor.html
DECLARE cursor_name CURSOR FOR select_statement This statement declares a cursor and associates it with a SELECT statement that retrieves the rows to be traversed by the cursor. Cursor declarations must appear before handler declarations and after ...The number of columns retrieved by the SELECT statement must match the number of output variables specified in the FETCH ...
https://dev.mysql.com/doc/refman/5.7/en/declare-local-variable.html
To provide a default value for a variable, include a DEFAULT clause. Permissible characters and quoting rules are the same as for other identifiers, as described in Section 9.2, “Schema Object Names”. For examples of variable declarations, see ...type [DEFAULT value] This statement declares local variables within stored ...