Shulou(Shulou.com)05/31 Report--

This article mainly shows you "what are the common options for mysql", the content is easy to understand, clear, hope to help you solve your doubts, the following let the editor lead you to study and learn "what are the common options for mysql" this article.

Available values for binlog-format: STATEMENT (default), ROW,MIXED. You must have a SUPER to change it. It is not recommended to modify the binlog-format value when replication is in progress.

Binlog-do-db (binlog-ignore-db, replicate-do-db, replicate-ignore-db) must use multiple rows for multiple databases. Because database names can contain commas, separating multiple database names with commas is considered the name of a database that contains commas.

No matter what binlog-format is, statements like create table and alter table are always recorded in the binary log in statement format.

The entry into force of binlog-do-db (binlog-ignore-db, replicate-do-db, replicate-ignore-db) is related to binlog-format:

When binlog-format is STATEMENT, the effective database is default database.

When binlog-format is ROW, the data that takes effect is the data of the table, regardless of default database.

Whether log-slave-updates records replicated updates. When used for cascading replication, it is necessary. In dual-master mode, FALSE should be taken.

Auto_increment_increment

Auto_increment_offset

Value: auto_increment_offset + N*auto_increment_increment

When the value of sync-binlog is 0, the file system of the operating system decides when to synchronize the binary log. When it is greater than 0, after N commit group, synchronize to the binary log. A value of 1 is the safest, but the performance is low.

Slave-ignore-errors ignores replication errors. The value all is not recommended. Under normal circumstances, there should be no mistakes; if there is an error, the error should be resolved rather than ignored.

Log-error log file, recording MySQL server startup, shutdown and other information. The Windows platform should note that paths are separated by "/" instead of "\".

Log-output (522 pages)

Location of the log: FILE TABLE NONE

The above is all the content of the article "what are the common options for mysql". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.