… atomic snapshot of many volumes. Lets speak a bit about how LVM and snapshotting in general works. Really there are different…. With read-only snapshot you need to make sure filesystem synchronizes device before snapshot is taken so no journal replay is… you have any long running queries. If you’re using only Innodb tables and do not need to synchronize binary log position with backup…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
…underlying data changes. This loss of synchronization is sometimes called drift. This … database, instead of replaying binary logs directly. Selecting a refresh method … to execute, because that is how long it takes to create the monthly… It is used to prevent wide innodb primary keys on the MV. mysql…
Post: How multiple disks can benefit for single client workload ?
April 26, 2008 By 4 Comments
… of one. Let us first look how single query is executed for Innodb storage engine to be more … to flush transactional log. In case innodb_flush_log_at_trx_commit=1 (default) this will be synchronous operation and … up cache so this wait is not long. In case innodb_flush_log_at_trx_commit is set to …
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
…synchronously. Although write performance is comparable with InnoDB, I am not entirely convinced that PBXT’s implementation of the log… PBXT does not normally need to maintain long lists of row-level locks. This … that then have to be fixed. How to optimize the program without compromising …
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
…Innodb performance problems come however. We should however see how “compact” they would be in real world cases and how… you need multiple log flushes on commit, plus ether you use XA to synchronize these which … sides such as no problem with very long rollbacks on recovery but also means you …
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
…sync-binlog innodb_flush_logs_at_trx_commit=1 and only using Innodb tables to…MySQL server or at least synchronously replicated master binary logs. If you can’t…large backup in timely fashion over long distance network, meaning it is best…ironed out so they can answer how they would handle at least …
Post: Making replication a bit more reliable
March 4, 2009 By 14 Comments
… problem is that InnoDB transaction state and replication state are not synchronized. If we…client side OS/NFS cache for long time. As solution we can do…write, but I can’t predict how much performance penalty we will see… store the state of replication in InnoDB transactional log file, in this case we…
