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/group-replication-deploying-in-multi-primary-or-single-primary-mode.html
These checks can be deactivated by setting the option group_replication_enforce_update_everywhere_checks to FALSE. It is not possible to have members of the group deployed in different modes, for example one configured in multi-primary mode while ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-space-requirements.html
A large innodb_online_alter_log_max_size setting permits more DML during an online DDL operation, but it also extends the period of time at the end of the DDL operation when the table is locked to apply logged DML. If the MySQL temporary directory ... Online DDL operations have the following space requirements: Temporary log files: A temporary log file records concurrent DML when an online DDL operation creates an index or alters a ...
https://dev.mysql.com/doc/refman/5.7/en/loop.html
For the rules regarding label use, see Section 13.6.2, “Statement Labels”. Example: CREATE PROCEDURE doiterate(p1 INT) BEGIN label1: LOOP SET p1 = p1 + 1; IF p1 < 10 THEN ITERATE label1; END IF; LEAVE label1; END LOOP label1; SET @x = p1; END; .
https://dev.mysql.com/doc/refman/5.7/en/sys-list-add.html
This function and list_drop() can be useful for manipulating the value of system variables such as sql_mode and optimizer_switch that take a comma-separated list of values. Example mysql> SELECT @@sql_mode; +----------------------------------------+ ... Adds a value to a comma-separated list of values and returns the ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-deploying-locally.html
For more information on security settings, see Section 17.6, “Group Replication Security”. For example: [mysqld] # server configuration datadir=<full_path_to_data>/data/s1 basedir=<full_path_to_bin>/mysql-8.0/ port=24801 ...It is also possible ... The most common way to deploy Group Replication is using multiple server instances, to provide high ...
https://dev.mysql.com/doc/refman/5.7/en/help.html
Its proper operation requires that the help tables in the mysql database be initialized with help topic information (see Section 5.1.14, “Server-Side Help Support”). The following descriptions indicate the forms that the result set can take. The ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-types.html
For example, a system view named GEOMETRY_COLUMNS contains a description of geometry columns, one row for each geometry column in the database. The Open Geospatial Consortium publishes the OpenGIS® Implementation Standard for Geographic information ... The Open Geospatial Consortium (OGC) is an international consortium of more than 250 companies, agencies, and universities participating in the development of publicly available conceptual solutions that can be useful with all kinds of applications that manage spatial ...
https://dev.mysql.com/doc/refman/5.7/en/begin-end.html
END syntax is used for writing compound statements, which can appear within stored programs (stored procedures and functions, triggers, and events). Changing the ; end-of-statement delimiter (for example, to //) permit ; to be used in a program body. This means that no transactional savepoint is set at the start of the instruction block and the BEGIN clause used in this context has no effect on the current ...
https://dev.mysql.com/doc/refman/5.7/en/cursors.html
Cursors have these properties: Asensitive: The server may or may not make a copy of its result table Read only: Not updatable Nonscrollable: Can be traversed only in one direction and cannot skip rows Cursor declarations must appear before handler ...
https://dev.mysql.com/doc/refman/5.7/en/error-lost-connection.html
Sometimes the “during query” form happens when millions of rows are being sent as part of one or more queries. If you know that this is happening, you should try increasing net_read_timeout from its default of 30 seconds to 60 seconds or longer, ...Usually it indicates network connectivity trouble and you should check the condition of your network if this error occurs ...