Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-options-binary-log.html
Suppose that the server is started with --binlog-do-db=db1, and the following statements are executed: USE db1; UPDATE db1.table1, db2.table2 SET db1.table1.col1 = 10, db2.table2.col2 = 20; If you are using statement-based logging, the updates to ...
https://dev.mysql.com/doc/refman/8.4/en/join.html
A table reference (when it refers to a partitioned table) may contain a PARTITION clause, including a list of comma-separated partitions, subpartitions, or both. INNER JOIN and , (comma) are semantically equivalent in the absence of a join ... MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-replica.html
Suppose that the replica is started with --replicate-do-db=db1, and the following statements are executed on the source: USE db1; UPDATE db1.table1, db2.table2 SET db1.table1.col1 = 10, db2.table2.col2 = 20; If you are using statement-based ... This ...
https://dev.mysql.com/doc/connectors/en/connector-net-8-0-connection-options.html
Connector/NET 8.0 exposes the options in this section as properties in both the MySql.Data.MySqlClient.MySqlConnectionStringBuilder and MySqlX.XDevAPI.MySqlXConnectionStringBuilder classes. An error is raised if both dns-srv=false and the URI scheme ... This chapter describes the full set of MySQL Connector/NET 8.0 connection ...
https://dev.mysql.com/doc/connector-net/en/connector-net-8-0-connection-options.html
Connector/NET 8.0 exposes the options in this section as properties in both the MySql.Data.MySqlClient.MySqlConnectionStringBuilder and MySqlX.XDevAPI.MySqlXConnectionStringBuilder classes. An error is raised if both dns-srv=false and the URI scheme ... This chapter describes the full set of MySQL Connector/NET 8.0 connection ...
https://dev.mysql.com/doc/refman/8.4/en/connection-compression-control.html
Compressed connections originate on the client side but affect CPU load on both the client and server sides because both sides perform compression and decompression operations. For successful connection setup, both sides of the connection must agree ... Connections to the server can use compression on the traffic between client and server to reduce the number of bytes sent over the ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-foreign-keys.html
If the CONSTRAINT symbol clause is not defined, or a symbol is not included following the CONSTRAINT keyword, both InnoDB and NDB storage engines ignore FOREIGN_KEY index_name. If a FOREIGN KEY clause is defined on both tables in a foreign key ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-schema.html
ndb_apply_status Table ndb_binlog_index Table ndb_replication Table Replication in NDB Cluster makes use of a number of dedicated tables in the mysql database on each MySQL Server instance acting as an SQL node in both the cluster being replicated ...This is true regardless of whether the replica is a single server or a ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-0.html
(Bug #36357181) Some of the files in extra/libbacktrace contained incorrect licensing information, copyright information, or both. --old and --new: Both deprecated in MySQL 8.0.35 and MySQL 8.2.0, and now removed. (Bug #36312880) Replication: In ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-partial-options.html
--include-tables=REGEXP Command-Line Format --include-tables=REGEXP Type String Include for backup or restoration only those tables (both Innodb and non-Innodb) whose fully qualified names (in the form of db_name.table_name) match the regular ... To ...