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/faqs-replication.html
On the source, issue the following statement to enable the source to begin processing updates again: mysql> UNLOCK TABLES; A.14.5. Thus, when the update of client A makes it to co-source 2, it produces tables that are different from what you have on ... In the following section, we provide answers to questions that are most frequently asked about MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-search.html
A FULLTEXT index definition can be given in the CREATE TABLE statement when a table is created, or added later using ALTER TABLE or CREATE INDEX. Full-text indexes can be used only with InnoDB or MyISAM tables, and can be created only for CHAR, ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-format-enabling.html
The innodb_file_format setting is not applicable when using the TABLESPACE [=] innodb_system table option with CREATE TABLE or ALTER TABLE to store a DYNAMIC table in the system tablespace. The innodb_file_format configuration option enables an ...
https://dev.mysql.com/doc/refman/5.7/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. Reserved words are permitted as identifiers if you quote them as described in Section 9.2, ...This ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-reserved-words.html
An example of this is using a table column named virtual on a 5.6 source that is replicating to a 5.7 or higher replica because VIRTUAL is a reserved word beginning in MySQL 5.7. Replication can fail in such cases with Error 1064 You have an error ... You can encounter problems when you attempt to replicate from an older source to a newer replica and you make use of identifiers on the source that are reserved words in the newer MySQL version running on the ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rules.html
For statements affecting databases only (that is, CREATE DATABASE, DROP DATABASE, and ALTER DATABASE), database-level options always take precedence over any --replicate-wild-do-table options. You should not use these options to control which ... If ...
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 ...