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/change-master-to.html
With MASTER_SSL=1, the connection attempt only succeeds if an encrypted connection can be established. It is recorded in the source metadata repository and shown in the replication_connection_configuration Performance Schema table. These values are ...] CHANGE MASTER TO changes the parameters that the replica uses for connecting to the replication source server, for reading the source's binary log, and reading the replica's relay ...
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-sets.html
A language name shown in the following table indicates a language-specific collation. If this is acceptable for your application, you should use utf8_general_ci because it is faster. If this is not acceptable (for example, if you require German ...
https://dev.mysql.com/doc/refman/5.7/en/connection-control-plugin-installation.html
To verify plugin installation, examine the Information Schema PLUGINS table or use the SHOW PLUGINS statement (see Section 5.5.2, “Obtaining Server Plugin Information”). In particular, installing only the CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS ... This section describes how to install the connection control plugins, CONNECTION_CONTROL and ...
https://dev.mysql.com/doc/refman/5.7/en/data-type-defaults.html
Examples: CREATE TABLE t1 ( i INT DEFAULT -1, c VARCHAR(10) DEFAULT '', price DOUBLE(16,2) DEFAULT '0.00' ); SERIAL DEFAULT VALUE is a special case. For nontransactional tables, an error occurs, but if this happens for the second or subsequent row ... Data type specifications can have explicit or implicit default ...
https://dev.mysql.com/doc/refman/5.7/en/downgrade-binary-package.html
For example: mysql_upgrade -u root -p mysql_upgrade examines all tables in all databases for incompatibilities with the current version of MySQL, and attempts to repair the tables if problems are found. Shut down and restart the MySQL server to ...
https://dev.mysql.com/doc/refman/5.7/en/extended-show.html
The IS_UPDATABLE flag may be unreliable if a view depends on one or more other views, and one of these underlying views is updated. Regardless of the IS_UPDATABLE value, the server keeps track of the updatability of a view and correctly rejects data ... Some extensions to SHOW statements accompany the implementation of INFORMATION_SCHEMA: SHOW can be used to get information about the structure of INFORMATION_SCHEMA ...
https://dev.mysql.com/doc/refman/5.7/en/function-loading.html
It registers the function in the mysql.func system table to make it persistent across server restarts. If the server is started with the --skip-grant-tables option, functions registered in the table are not loaded and are unavailable. With the ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-adding-instances.html
Checking the performance_schema.replication_group_members table again shows that there are now two ONLINE servers in the group. Create the configuration file [mysqld] # # Disable other storage engines # ... At this point, the group has one member in ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-limitations.html
Note For a group in multi-primary mode, unless you rely on REPEATABLE READ semantics in your applications, we recommend using the READ COMMITTED isolation level with Group Replication. The certification process does not take into account table locks ...Note that the limitations and issues described for multi-primary mode groups can also apply in single-primary mode clusters during a failover event, while the newly elected primary flushes out its applier queue from the old ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-requirements.html
Convert any tables in other storage engines to use InnoDB before using the instance with Group Replication. Every table that is to be replicated by the group must have a defined primary key, or primary key equivalent where the equivalent is a ...