…, but as it needs to lock the table, long running transactions that lock (part of) the table can … when using the tool with or without innodb_file_per_table, and the first thing that comes… two (or more) servers, if using statement based replication, it is possible that new differences are introduced …
Comment: How to estimate time it takes Innodb to Recover ?
June 25, 2008 By 7 Comments
… MySQL replication slave the last master binlog file InnoDB: position 0 12501110, file name bin.000025 InnoDB: Last MySQL binlog file position 0 90914, file… | | +————+———-+——————————————-+——————+ 1 row in set (0.00 sec) *** All db in replicated mode are using INNODB OS (all): Linux 2.6.9… #innodb_log_file_size = 100M #innodb_log_buffer_size = 8M #innodb_flush_log_at_trx_commit = 1 #innodb_lock_wait_timeout = 50…
Post: Announcing Percona Server 5.1.66-14.2
January 15, 2013 By Leave a Comment
… #917942 (Mark Callaghan, Laurynas Biveinis). Crash-resistant replication would break with binlog XA transaction recovery… (X) row locks to shared (S) locks, these S locks prevent X locks from being taken …. Bug fixed #1076892 (Laurynas Biveinis). Temporary files created by binary log cache were …
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
…and a disaster recovery location replicated asynchronously? A: You can use asynchrounous replication between 2 PXC clusters,…or serve data. Q: Is the configuration file my.cnf ? A: Yes. Q: If the… xtrabackup itself while holding a lock using FLUSH TABLES WITH READ LOCK. MyISAM support is experimental….
Comment: MySQL on Amazon RDS part 2: Determining Peak Throughput
March 28, 2011 By 4 Comments
…_doublewrite ON innodb_fast_shutdown 1 innodb_file_format Antelope innodb_file_format_check Barracuda innodb_file_per_table ON innodb_flush_log… innodb_lock_wait_timeout 50 innodb_locks_unsafe_for_binlog OFF innodb_log_buffer_size 8388608 innodb_log_file_size 134217728 innodb_log_files…_time 0 innodb_open_files 300 innodb_read_ahead_threshold 56 innodb_read_io_threads 4 innodb_replication_delay 0 innodb_rollback…
Comment: Solving RPM installation conflicts in CentOS 5 and CentOS 6
February 21, 2013 By 6 Comments
…! i setup percona cluster in vm, if in file /etc/my.cnf,i add wsrep_cluster_address=… wsrep_node_name=mysql1 innodb_locks_unsafe_for_binlog=1 innodb_autoinc_lock_mode=2 the wrong infomaton :… = 0.25; gcs.sync_donor = NO; replicator.causal_read_timeout = PT30S; replicator.commit_order = 3 130221 17:59:…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…_slave_updates innodb_locks_unsafe_for_binlog=1 innodb_autoinc_lock_mode=2 innodb_buffer_pool_size=400M innodb_log_file_size=64M…-11e1-0800-ea53b7b12451): 1 (Operation not permitted) at galera/src/replicator_str.cpp:prepare_for_IST():439. IST will be unavailable… cluster nodes. This can be done, but because of optimistic locking at commit time, rollbacks can happen if we have conflicting…
Post: 10 things you need to know about backup solutions for MySQL
March 3, 2009 By 23 Comments
… by simply copying its files? Does the backup use FLUSH TABLES, LOCK TABLES, or FLUSH TABLES WITH READ LOCK? These all interrupt processing… seen systems that do a RESET MASTER, which immediately breaks replication. Are there any FLUSH commands at all, like FLUSH LOGS… binary log, InnoDB logs, and replication? Can you use the system to set up new MySQL replication slaves? How? Does the system…
Post: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
…! # Query_time: 0.503016 Lock_time: 0.000048 Rows_sent: 56 Rows_examined: 1113 LOGGING OF THE REPLICATED STATEMENTS Normally MySQL will…, while Disk_filesort means that sorting was done through temporary files. INNODB USAGE The final part are the InnoDB usage statistics…: macko[macko] @ localhost [] # Thread_id: 4 # Query_time: 0.503016 Lock_time: 0.000048 Rows_sent: 56 Rows_examined: 1113 # QC…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…-pool-instances=2 innodb-buffer-pool-size=5600M innodb-file-format=barracuda innodb-file-per-table innodb-flush-log-at-trx-commit…=16 innodb-recovery-stats innodb-recovery-update-relay-log innodb-replication-delay=# innodb-rollback-on-timeout innodb-rollback-segments=16 innodb… innodb-stats-sample-pages=256 innodb-stats-update-need-lock=0 innodb-status-file innodb-strict-mode innodb-thread-concurrency=0 innodb…
