… use similar patch as in Google Patches II, where InnoDB file writes can be altogether disabled using a global variable setting? For InnoDB based databases, this allows for immediate locking of writes, safe BINLOG position snapshot, no waiting on…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
… way InnoDB does the buffer pool flush. I think Yasufumi Kinoshita talked at Users’ Conference 2007 about his patch that makes InnoDB‘s… not think so. Sergei Golubchik serialized the MySQL binlog write and the InnoDB log flush with a mutex in 5.1, to…’s binlog and InnoDB‘s log must have the transactions in the same order, for a recovery based on MySQL’s binlog to…
Comment: Percona build7 with latest patches
December 2, 2008 By 26 Comments
…_patches.patch microslow_innodb.patch userstatv2.patch microsec_process.patch innodb_io_patches.patch mirror_binlog.patch mysqld_safe_syslog.patch innodb_locks_held.patch innodb_show_bp.patch innodb_check_fragmentation.patch innodb_io_pattern.patch innodb_fsync_source.patch innodb_show…
Post: Missleading Innodb message on recovery
February 15, 2010 By 2 Comments
… years ago the feature of Innodb to store copy of master’s position in Slave’s Innodb tablespace got broken. There is… Percona Patches) InnoDB: In a MySQL replication slave the last master binlog file InnoDB: position 0 10000000, file name mysql-bin.005000 InnoDB: Last MySQL binlog… on this master. What is going on ? The thing is Innodb does not update this information any more however if it…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
… very careful such as using sync-binlog innodb_flush_logs_at_trx_commit=1 and only using Innodb tables to be OK in… master failure you may loose transactions. Google semi-synchronous replication patches can help with it… but they are not yet in… or disk failure. Though it also can be things like Innodb corruption or soft crash which you can’t recover promptly…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
…_mutex patch). my.cnf is [mysqld] user=root binlog_cache_size=1M default_table_type=MYISAM ft_min_word_len=4 innodb_additional_mem_pool_size=16M innodb_buffer_pool…_group=2 innodb_log_file_size=512M innodb_status_file=0 innodb_thread_concurrency=0 innodb_io_capacity=1000 innodb_write_io_threads = 16 innodb_read…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… | Aborted_clients | 205174 | | Aborted_connects | 29 | | Binlog_cache_disk_use | 0 | | Binlog_cache_use | 9630066 | | Bytes_received | … InnoDB tables whose .frm files exist but have been dropped from InnoDB, for … server that has the Percona patches for microsecond logging and additional …
Post: Testing the Group Commit Fix
July 13, 2011 By 13 Comments
….3 and Mark Callaghan tested it recently . We ported this patch to Percona Server (it is not in the main branch… fsync (write-back cache is disabled), innodb_flush_log_at_trx_commit=1 and sync_binlog=1 or in tabular format: Threads… fix improves performance substantially when both innodb_flush_log_at_trx_commit=1 and sync_binlog=1 options are set and write…
Post: XtraDB storage engine release 1.0.2-3 (Spring edition) codename Sapporo
March 2, 2009 By 10 Comments
… to “1″ record order of binlog and InnoDB transaction log could be not same. But because InnoDB manages transactions in correct order most…. New parameters in the XtraDB io patches: innodb_ibuf_max_size — Restrict innodb-insert-buffer size innodb_ibuf_active_contract — Enabling it…
Comment: Pretending to fix broken group commit
February 6, 2009 By 11 Comments
…’t believe that my patch does have a problem with innobackup. It preserves the order of binlog and innodb commits, although it doesn’t preserve the order of innodb prepare and binlog. This isn’t a problem for crash recovery, since mysql scans the binlog and commits any…
