Changing the binary logging format within transactions-opracowanie

Nasza ocena:

3
Wyświetleń: 343
Komentarze: 0
Notatek.pl

Pobierz ten dokument za darmo

Podgląd dokumentu
Changing the binary logging format within transactions-opracowanie - strona 1

Fragment notatki:

Changing the binary logging format within transactions. Beginning with MySQL 5.5.3, the
binlog_format [2047] system variable is read-only as long as a transaction is in progress. (Bug
#47863)
Every transaction (including autocommit [479] transactions) is recorded in the binary log as though
it starts with a BEGIN statement, and ends with either a COMMIT or a ROLLBACK statement. In MySQL
5.6, this true is even for statements affecting tables that use a nontransactional storage engine (such
as MyISAM).
... zobacz całą notatkę



Komentarze użytkowników (0)

Zaloguj się, aby dodać komentarz