Hi Baron, I understand that the insights to the binlog would likely show what you’ve said and I do agree that turning off session binlog is the right strategy to go with. But can you…’s not what I’m seeing on our systems, with binlog left on at master when the command is issued)
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 10, 2012 By 28 Comments
Post: Percona Server 5.1.62-13.3 released!
April 26, 2012 By Leave a Comment
… SBR, because with RBR database name is encoded within the BINLOG ‘….’ statement. Release notes for Percona Server 5.1.62-13…
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 25, 2012 By 20 Comments
…. copy data files other than InnoDB. 3. get the binlog file and binlog postion information. And if we ensure the following requirements… engine, no other engines used. 3. get binlog file and binlog postion information from xtrabackup_binlog_pos_innodb file since InnoDB will wirte…
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 27, 2012 By 20 Comments
…: Last MySQL binlog file position 0 15906301, file name ../log/binlog.000290 … This is a slave, it has no binlog of its own. SHOW SLAVE STATUS says Master_Log_File: binlog.000062…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
…. [root@sb logs]# cat mysql-data-201202230157-binlog-info File Position Binlog_Do_DB Binlog_Ignore_DB mysql-bin.000022 336796712 Using the…
Comment: Percona XtraDB Cluster Feature 2: Multi-Master replication
April 2, 2012 By 16 Comments
… probably should compare single Galera node with plain mysql with binlog turned on. Having said that, 20% may be not really…
Post: InnoDB's gap locks
March 27, 2012 By 14 Comments
… to prevent that from happening. 2- innodb_locks_unsafe_for_binlog = 1. Disables the gap locks except for foreign-key constraint…
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
… based databases, this allows for immediate locking of writes, safe BINLOG position snapshot, no waiting on read-queries, and no actual…
Comment: ext4 vs xfs on SSD
March 20, 2012 By 23 Comments
Useful results for when we move to SSDs.. Were sync_binlog=1 and innodb_flush_at_trx_commit=1 ?
Comment: Too many connections? No problem!
March 15, 2012 By 28 Comments
… log-bin=/data/mysql/drbd expire_logs_days = 5 max_binlog_size = 100M [client] socket=/data/mysql/mysql.sock When I…
