… wsrep_sst_method=rsync wsrep_node_name=mysql1 innodb_locks_unsafe_for_binlog=1 innodb_autoinc_lock_mode=2 the wrong infomaton : 130221 17:59:00…
Comment: Percona XtraDB Cluster reference architecture with HaProxy
August 3, 2012 By 63 Comments
…=node1 (this variable changes as per different nodes) innodb_locks_unsafe_for_binlog=1 innodb_autoinc_lock_mode=2 log_slave_updates wsrep_replicate_myisam=1…
Post: Announcing Percona Server 5.1.65-14.0
September 4, 2012 By Leave a Comment
… being updated rather than inserted) with the default value of innodb_autoinc_lock_mode=1. Bug fixed #1035225 (Alexey Kopytov). Since the output file… #882653 (Stewart Smith). Server started with skip-innodb crashes on SELECT * FROM INNODB_TABLE_STATS or INNODB_INDEX_STATS. Bug fixed #896439 (Stewart…
Post: Announcing Percona Server 5.5.27-28.0
August 23, 2012 By 5 Comments
… Server supports tunable buffer size for fast index creation in InnoDB. This value was calculated based on the merge block size… default value of innodb_autoinc_lock_mode=1. Bug fixed #1035225 (Alexey Kopytov). Removed error log warnings that occured after enabling innodb_use_sys_stats…
Comment: Avoiding auto-increment holes on InnoDB with INSERT IGNORE
June 19, 2012 By 8 Comments
… the only way to fix this is to change the innodb_autoinc_lock_mode=0? Or is there another way. I dont want to…
Post: Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks
August 17, 2012 By 17 Comments
… engine innodb status Trx read view will not see trx with id >= 83C, sees < 83C TABLE LOCK table `test`.`autoinc` trx id 83B lock mode IX RECORD LOCKS space id 0 page no 823 n bits 72 index `PRIMARY` of table `test`.`autoinc` trx id 83B lock_mode X locks…
