PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/start-group-replication.html
If super_read_only=ON and the member should join as a primary, super_read_only is set to OFF once Group Replication successfully starts. A server that participates in a group in single-primary mode should use skip_replica_start=ON. Otherwise, the ...
https://dev.mysql.com/doc/refman/5.7/en/stop-group-replication.html
As soon as you issue STOP GROUP_REPLICATION the member is set to super_read_only=ON, which ensures that no writes can be made to the member while Group Replication stops. To be completely safe, ensure that your applications can no longer connect to ...Any other replication channels running on the member are also ...
https://dev.mysql.com/doc/refman/5.7/en/subquery-errors.html
Incorrect number of rows from subquery: ERROR 1242 (ER_SUBSELECT_NO_1_ROW) SQLSTATE = 21000 Message = "Subquery returns more than 1 row" This error occurs for statements where the subquery must return at most one row but returns multiple rows.
https://dev.mysql.com/doc/refman/5.7/en/subquery-restrictions.html
For example, this limitation applies to statements of the following forms: DELETE FROM t WHERE ... FROM t ...); Exception: The preceding prohibition does not apply if for the modified table you are using a derived table and that derived table is ...
https://dev.mysql.com/doc/refman/5.7/en/sys-format-path.html
Prior to MySQL 5.7.14, backslashes in Windows path names are converted to forward slashes in the result. Example mysql> SELECT sys.format_path('/usr/local/mysql/data/world/City.ibd'); +---------------------------------------------------------+ | ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-truncate-all-tables.html
Truncates all Performance Schema summary tables, resetting all aggregated instrumentation as a snapshot. Parameters in_verbose BOOLEAN: Whether to display each TRUNCATE TABLE statement before executing it. Example mysql> CALL ...
https://dev.mysql.com/doc/refman/5.7/en/table-corruption.html
If you have started mysqld with the myisam_recover_options system variable set, MySQL automatically checks and tries to repair MyISAM tables if they are marked as 'not closed properly' or 'crashed'. If you get a lot of these errors, without mysqld ...If this happens, MySQL writes an entry in the hostname.err file 'Warning: Checking table ...' which is followed by Warning: Repairing table if the table needs to be ...
https://dev.mysql.com/doc/refman/5.7/en/tracing-memory-usage.html
The optimizer_trace_max_mem_size server system variable sets a limit on the total amount of memory used by all traces currently being stored. Each stored trace is a string, which is extended (using realloc()) as optimization progresses by appending ...
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 ...