PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-unsupported.html
The NDB storage engine does not support indexes on virtual generated columns. As with other storage engines, you can create an index on a stored generated column, but you should bear in mind that NDB uses DataMemory for storage of the generated ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-differing-tables.html
A table on the source can have more or fewer columns than the replica's copy of the table. In addition, corresponding table columns on the source and the replica can use different data types, subject to certain conditions. (This is true even if both ... Source and target tables for replication do not have to be ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-log-statistics.html
A unique index read operation generates 2 primary key read operations—1 for the hidden unique index table, and 1 for the table on which the read takes place. Note A unique index update operation can generate multiple PK read and write operations ... The NDB management client's CLUSTERLOG STATISTICS command can provide a number of useful statistics in its ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rbr-safe-unsafe.html
When using statement-based logging, statements flagged as being unsafe generate a warning to this effect. To prevent this, MySQL 5.7 provides a warning suppression mechanism, which behaves as follows: Whenever the 50 most recent ... The ...
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/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/numeric-type-attributes.html
If you store values larger than the display width in an integer column that has the ZEROFILL attribute, you may experience problems when MySQL generates temporary tables for some complicated joins. Inserting NULL to generate AUTO_INCREMENT values ...