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/replication-options-gtids.html
If all binary logs on the server were generated using MySQL 5.7.8 or later and you are using MySQL 5.7.8 or later, binlog_gtid_simple_recovery=TRUE can always safely be used. With binlog_gtid_simple_recovery=TRUE, gtid_executed and gtid_purged might ... The MySQL Server system variables described in this section are used to monitor and control Global Transaction Identifiers ...
https://dev.mysql.com/doc/refman/5.7/en/data-masking-function-reference.html
Table 6.35 MySQL Enterprise Data Masking and De-Identification Functions Name Description gen_blacklist() Perform dictionary term replacement gen_dictionary_drop() Remove dictionary from registry gen_dictionary_load() Load dictionary into registry ...
https://dev.mysql.com/doc/refman/5.7/en/docker-mysql-getting-started.html
The --name option, for supplying a custom name for your server container, is optional; if no container name is supplied, a random one is generated. Warning The MySQL Docker images maintained by the MySQL team are built specifically for Linux ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options.html
server_uuid In MySQL 5.7, the server generates a true UUID in addition to the server_id value supplied by the user. If data_dir/auto.cnf is not found, generate a new UUID and save it to this file, creating the file if necessary. In MySQL 5.7, ...
https://dev.mysql.com/doc/refman/5.7/en/replace.html
If a generated column is replaced explicitly, the only permitted value is DEFAULT. For information about generated columns, see Section 13.1.18.7, “CREATE TABLE and Generated Columns”. The server recognizes but ignores the DELAYED keyword, ...
https://dev.mysql.com/doc/refman/5.7/en/upgrade-binary-package.html
Important If you have tables that contain generated columns, use the mysqldump utility provided with MySQL 5.7.9 or higher to create your dump files. The mysqldump utility provided in earlier releases uses incorrect syntax for generated column ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log-mixed.html
When one or more tables with AUTO_INCREMENT columns are updated and a trigger or stored function is invoked. Like all other unsafe statements, this generates a warning if binlog_format = STATEMENT. (Bug #39701) Note A warning is generated if you try ... When running in MIXED logging format, the server automatically switches from statement-based to row-based logging under the following conditions: When a DML statement updates an NDBCLUSTER ...
https://dev.mysql.com/doc/refman/5.7/en/create-view.html
A generated column in a view is considered updatable because it is possible to assign to it. For information about generated columns, see Section 13.1.18.7, “CREATE TABLE and Generated Columns”. For example, if a view is defined as SELECT * on a ...If the view does not exist, CREATE OR REPLACE VIEW is the same as CREATE ...
https://dev.mysql.com/doc/refman/5.7/en/replication-sbr-rbr.html
This is because the BLOB column value is logged, rather than the statement generating the data. SELECT, a CREATE statement is generated from the table definition and replicated using statement-based format, while the row insertions are replicated ...
https://dev.mysql.com/doc/refman/5.7/en/xa-statements.html
xid values are supplied by the client, or generated by the MySQL server. Values generated by one TM must be different from values generated by other TMs. To perform XA transactions in MySQL, use the following statements: XA {START|BEGIN} xid ...