… of production database servers and will perform the backups. The write load is not excessive so a single server can easily… many scripts ready for the task. Snapshots work best with InnoDB, with MyISAM you’ll have to start the snapshot while… record on disk has a checksum. If a cosmic ray flip a bit on a drive, instead of crashing InnoDB, it will…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… to 18000 tps, but InnoDB can’t make 5h run. After 3h the disk is full, and InnoDB data size is about 210GB…_group = 2 innodb_log_block_size=4096 #####plugin options innodb_read_io_threads = 16 innodb_write_io_threads = 4 innodb_io_capacity = 4000 innodb_use_native_aio=0 #not innodb options (fixed…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
… file cache and pre-allocate the innodb buffer pool with the innodb_buffer_pool_populate option. That …-stalk, vmstat, top, iostat, etc all saving to disk with the current time stamp in front …) but doing very little physical writes. The writes were cached and the write cache was causing the problem. …
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… plugin). As expected, there is a slowdown for write operations when using the InnoDB version. But there is also a slight increase… are no reads from disk. However, there is write activity stemming from the fact that this is using InnoDB under the hood (redo…, here are the relative differences: InnoDB store operation was 280% higher (~1.73 ms/op) InnoDB fetch operation was 20% higher (~.06…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… a 4GiB buffer pool. The cache devices were flushed to disk immediately prior to and immediately following each test run. With… sets of experiments. First, the baseline configuration plus: innodb_read_io_threads = 16 innodb_write_io_threads = 16 We call this configuration B…: #####fixed innodb options innodb_file_format = barracuda innodb_buffer_pool_size = 4G innodb_file_per_table = true innodb_data_file_path = ibdata1:100M innodb_flush_method…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… (innodb_flush_log_at_trx_commit != 1), or work around it with by fsyncing to memory (Battery or capacitor-backed write cache… to persist after a crash, it has to get to disk. This has no effect on standard MySQL replication from this… in the cluster the writes are coming from: From the same node: This will behave just like standard Innodb. The first transaction…
Comment: State of the art: Galera - synchronous replication for InnoDB
April 23, 2013 By 15 Comments
…now and don’t see the same kind of disk i/o on it that I have seen …slave. I wonder if it is writing as synchronous? I was able to write 100,000 queries in about 50…3 –auto-generate-sql –csv=/tmp/mysqlslap_3index_innodb.csv –engine=innodb –auto-generate-sql-add-autoincrement –auto-generate-sql…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
…as the buffer pool pages were loaded from disk. Replaying Queries Working with Groupon, we have …-query command-line option, we set the option innodb_fake_changes to prevent INSERTs, UPDATEs, and DELETEs…errors may be faster than an actual database write. The slow logs were split into chunks, each…
Comment: Open Source, the MySQL market (and TokuDB in particular)
May 11, 2013 By 13 Comments
For pure-disk servers the advantages of TokuDB versus InnoDB are limited to a few workloads. For pure-flash servers … universal — 2X better compression (compared to InnoDB compression on my data) and larger (more sequential) writes means that you will buy much…
Post: Percona XtraBackup 2.1.0 for MySQL alpha now available
April 2, 2013 By Leave a Comment
… the 2.0 series at the time of writing). This release contains all of the features and … the backups that will take less amount of disk space. Percona XtraBackup for MySQL has implemented Encrypted Backups… MySQL command line client. Support for InnoDB 5.0 and InnoDB 5.1-builtin has been removed from …
