python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - mysqlbinlog

MySQL: How to properly extract blob data from mysqlbinlog output

I am trying to restore a few erroneous updates to a customer MySQL 5.7 database. Binlogs are enabled (binlog_format=MIXED). I am trying to write a script that will go through the binlogs and restore t...
test-img

Jacket

mysql

data-recovery

mysqlbinlog

Votes: 0

Answers: 1

Latest Answer

Untested, but I'd grab the mysqlbinlog from MariaDB and use flashback to generate the SQL. In theory, being just DML, this should be MySQL compatible or only require small modification to achieve the ...
test-img

danblack

mysql : understanding innodb log operations

I am trying to understand these 3 variables when it comes to writing changes to the binary log in the innodb storage engine sync_binlog innodb_flush_log_at_trx_commit innodb_flush_log_at_timeout After...
test-img

Sync it

mysql

transactions

innodb

mysqlbinlog

Votes: 0

Answers: 1

Latest Answer

The sync_binlog only controls when the file is synced to disk. The transactions are still written to the logical file immediately when you commit a transaction, they're just buffered by the OS. If you...
test-img

Bill Karwin

Posts

Questions

Blogs

Jobs