@JDempster: I could give the SSD to xfs also with Flashcache and the like. Don’t forget all these jbods have a raid controller write cache in front of them. I also did the Innodb tuning. @Nils: no fuse, direct kernel support. Look here: http://zfsonlinux.org/
Comment: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… write buffering, so make sure these are turned off in InnoDB.
Post: Percona XtraBackup 2.1.3 for MySQL available for download
May 22, 2013 By 3 Comments
… MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases. With Percona XtraBackup, you can achieve the…
Comment: How to calculate a good InnoDB log file size
May 22, 2013 By 38 Comments
…* && date && mysql -BNe’show engine innodb status\G’ | grep sequence && sleep 60 && date && mysql -BNe’show engine innodb status\G’ | grep sequence && ls -l…
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 22, 2013 By 32 Comments
Does Percona have improvements to keep the InnoDB insert buffer from getting full (as in do background reads for ibuf merges when it is getting full)? That is the key to sustaining good throughput for InnoDB on iibench.
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 22, 2013 By 32 Comments
Hi Vadim, I can confirm the steady downfall of InnoDB throughput down to ~1500 insert/sec (and counting) while TokuDB …
Comment: How to calculate a good InnoDB log file size
May 21, 2013 By 38 Comments
…* && date && mysql -BNe’show engine innodb status\G’ | grep sequence && sleep 60 && date && mysql -BNe’show engine innodb status\G’ | grep sequence && ls -l… is far cheaper in modern versions of InnoDB: https://blogs.oracle.com/mysqlinnodb/entry/innodb_recovery_is_now_faster And from the manual: http://dev.mysql.com/doc/refman/5.5/en/innodb-performance-recovery.html “If you kept the size of your…
Comment: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
https://kb.askmonty.org/en/xtradb-option-innodb-release-locks-early/history https://www.google.com/search?q=early+lock+release+mariadb https://bugs.launchpad.net/maria/+bug/798213
Comment: Implications of Metadata Locking Changes in MySQL 5.5
March 27, 2013 By 9 Comments
… you have row locks blocking the ALTER, while the post deals with metadata locks. If you can enable the InnoDB plugin on your… InnoDB, then you can further clarify to yourself that the ALTER in your test case is waiting on InnoDB row locks by setting innodb_lock…=3 for update; — session 2 set innodb_lock_wait_timeout=1; alter table t1 engine=innodb; And the alter will timeout after approximately…
Comment: Is Synchronous Replication right for your app?
May 16, 2013 By 18 Comments
… Innodb, let alone Galera. I had considered a job queue system in Innodb in the past that, in absence of a ‘SKIP LOCKED…
