…:// binlog_format=ROW wsrep_slave_threads=2 wsrep_cluster_name=trimethylxanthine wsrep_sst_method=rsync wsrep_node_name=mysql1 innodb_locks_unsafe_for_binlog=1 innodb_autoinc_lock_mode=2 the wrong infomaton : 130221…
Comment: Percona XtraDB Cluster reference architecture with HaProxy
August 3, 2012 By 63 Comments
….3.3:4567,gcomm:// [mysqld] # # * Basic Settings # server_id=1 binlog_format=ROW wsrep_provider=/usr/lib64/libgalera_smm.so / wsrep…=node1 (this variable changes as per different nodes) innodb_locks_unsafe_for_binlog=1 innodb_autoinc_lock_mode=2 log_slave_updates wsrep_replicate…
Comment: INSERT INTO ... SELECT Performance with Innodb tables.
September 8, 2010 By 22 Comments
… got the exception : Transaction level ‘READ-COMMITTED’ in InnoDB is not safe for binlog mode ‘STATEMENT’(INSERT INTO XXX SELECT YYY…) It… that work if you don’t what to set innodb_locks_unsafe_for_binlog to 1. Sorry Peter. Does anyone have an extra…
Comment: MySQL on Amazon RDS part 2: Determining Peak Throughput
March 28, 2011 By 4 Comments
… O_DIRECT innodb_force_recovery 0 innodb_io_capacity 200 innodb_lock_wait_timeout 50 innodb_locks_unsafe_for_binlog OFF innodb_log_buffer_size 8388608 innodb_log_file_size 134217728 innodb_log…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… innodb_lock_wait_timeout = 300 innodb_thread_concurrency = 0 innodb_sync_spin_loops = 40 innodb_locks_unsafe_for_binlog = 1 innodb_max_dirty_pages_pct=15 innodb_support_xa=0 innodb_flush…
Comment: Concurrent inserts on MyISAM and the binary log
May 20, 2008 By 7 Comments
… the same for innodb. I don’t think you can get around the issue without running with “innodb_locks_unsafe_for_binlog=1″ which was mentioned here: http://www.mysqlperformanceblog.com/2006/07/12/insert-into-select-performance-with-innodb-tables…
