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-rbr-usage.html
As noted in Section 16.4.1.29, “Replication and Temporary Tables”, temporary tables are not replicated when using row-based format. When using mixed format logging, “safe” statements involving temporary tables are logged using ... MySQL uses ...
https://dev.mysql.com/doc/refman/5.7/en/commit.html
To disable autocommit mode implicitly for a single series of statements, use the START TRANSACTION statement: START TRANSACTION; SELECT @A:=SUM(salary) FROM table1 WHERE type=1; UPDATE table2 SET summary=@A WHERE type=1; COMMIT; With START ...SET ...
https://dev.mysql.com/doc/refman/5.7/en/index-statistics.html
Storage engines collect statistics about tables for use by the optimizer. Table statistics are based on value groups, where a value group is a set of rows with the same key prefix value. The average value group size is related to table cardinality, ...For optimizer purposes, an important statistic is the average value group ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management-hash-key.html
Tables which are partitioned by hash or by key are very similar to one another with regard to making changes in a partitioning setup, and both differ in a number of ways from tables which have been partitioned by range or list. For that reason, ...
https://dev.mysql.com/doc/refman/5.7/en/timestamp-initialization.html
For any TIMESTAMP or DATETIME column in a table, you can assign the current timestamp as the default value, the auto-update value, or both: An auto-initialized column is set to the current timestamp for inserted rows that specify no value for the ...
https://dev.mysql.com/doc/refman/5.7/en/archive-storage-engine.html
The ARCHIVE storage engine produces special-purpose tables that store large amounts of unindexed data in a very small footprint. When you create an ARCHIVE table, the server creates a table format file in the database directory. The file begins ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log-mixed.html
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 table. When one or more tables with AUTO_INCREMENT columns ...Like all other unsafe statements, this generates a warning if binlog_format = ...
https://dev.mysql.com/doc/refman/5.7/en/firewall-reference.html
For information about MySQL Enterprise Firewall Information Schema tables, see Section 24.7, “INFORMATION_SCHEMA MySQL Enterprise Firewall Tables”. Each mysql system database table is accessible only by accounts that have the SELECT privilege ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-gtids.html
Only statements that can be logged using GTID safe statements can be logged when enforce_gtid_consistency is set to ON, so the operations listed here cannot be used with this option: CREATE TABLE ... SELECT statements CREATE TEMPORARY TABLE or DROP ... 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/replication-solutions-diffengines.html
It does not matter for the replication process whether the source table on the source and the replicated table on the replica use different engine types. For example, in a typical scale-out scenario (see Section 16.3.4, “Using Replication for ...