PDF (US Ltr)
- 40.2Mb
PDF (A4)
- 40.3Mb
Man Pages (TGZ)
- 262.0Kb
Man Pages (Zip)
- 367.6Kb
Info (Gzip)
- 4.0Mb
Info (Zip)
- 4.0Mb
Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-parameters.html
innodb_flush_log_at_trx_commit Command-Line Format --innodb-flush-log-at-trx-commit=# System Variable innodb_flush_log_at_trx_commit Scope Global Dynamic Yes SET_VAR Hint Applies No Type Enumeration Default Value 1 Valid Values 012 Controls the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-unexpected-replica-halt.html
The innodb_flush_log_at_trx_commit=1 setting mentioned in the list below is a key setting for a replication setup that uses InnoDB with transactions. Set innodb_flush_log_at_trx_commit=1, which synchronizes the InnoDB logs to disk before each ... In ...
https://dev.mysql.com/doc/refman/8.4/en/atomic-ddl.html
Note The redo logs for changes to the mysql.innodb_ddl_log table are flushed to disk immediately regardless of the innodb_flush_log_at_trx_commit setting. An atomic DDL statement combines the data dictionary updates, storage engine operations, and ...
https://dev.mysql.com/doc/refman/8.4/en/dynamic-system-variables.html
Many server system variables are dynamic and can be set at runtime. For a description of the privilege requirements for setting system variables, see Section 7.1.9.1, “System Variable Privileges” The following table lists all dynamic system ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-redo-log-buffer.html
The innodb_flush_log_at_trx_commit variable controls how the contents of the log buffer are written and flushed to disk. The log buffer is the memory area that holds data to be written to the log files on disk. The contents of the log buffer are ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-acid.html
The ACID model is a set of database design principles that emphasize aspects of reliability that are important for business data and mission-critical applications. MySQL includes components such as the InnoDB storage engine that adhere closely to ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-transaction-management.html
If you can afford the loss of some of the latest committed transactions if an unexpected exit occurs, you can set the innodb_flush_log_at_trx_commit parameter to 0. To optimize InnoDB transaction processing, find the ideal balance between the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-shutdowns.html
For the greatest possible durability and consistency in a replication setup using InnoDB with transactions, you should also set innodb_flush_log_at_trx_commit=1. It is safe to shut down a replication source server and restart it later. When a ...
https://dev.mysql.com/doc/refman/8.4/en/replication-howto-masterbaseconfig.html
Note The following options also have an impact on the source: For the greatest possible durability and consistency in a replication setup using InnoDB with transactions, you should use innodb_flush_log_at_trx_commit=1 and sync_binlog=1 in the ... To ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-binary-log.html
Startup Options Used with Binary Logging System Variables Used with Binary Logging You can use the mysqld options and system variables that are described in this section to affect the operation of the binary log as well as to control which ...