… double caching by the file system vs the InnoDB caching. However, limited ARC size also limits ZFS file system’s internal metadata caching(which…) You need to sacrifice a little ram for ZFS metadata caching to make ZFS fast. NexentaStor recommends minimum 1-2GB ram…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… we did above. So we will suppose that we can read the binary logs of the crashed master. The first thing… slave will be the new master is to recover the missing events with mysqlbinlog. Let’s say that we want to…-b985-0800272864ba:1. How can I instruct mysqlbinlog to start reading from there? Unfortunately, there is no –start-gtid-position option…
Comment: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
@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
… cost difference. ZFS provides built in checksumming and double write buffering, so make sure these are turned off in InnoDB.
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 … and a very fast LSI MegaRaid backed storage with SSD Cache. Aurimas worked on that machine a month ago.
Post: Percona MySQL University @Portland next Monday!
June 12, 2013 By Leave a Comment
…, then this is an event you can’t afford to miss… 
So register now! Please also join the Portland MySQL Meetup…
Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 4 Comments
Hi Hrvoje, Few quick questions: 1. I have a large innodb database, do I have to export databases from mysql and…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
June 10, 2013 By 8 Comments
… possible to mix non-transactional tables (such as MYISAM) with innodb tables within the same transaction. The same issue can arise…
Comment: Percona Playback 0.6 for MySQL now available
June 10, 2013 By 1 Comment
I don’t see the reason for inventing such a tool – isn’t the overhead of reading/parsing query logs and tcp dumps very large? Doesn’t this affect the performance metrics? Why not just replay binary logs (simulating concurrent connections using script) or proxy live data to a second server.
Comment: MySQL and Percona Server in LinkBench benchmark
June 9, 2013 By 18 Comments
… I tested) might not be from PCI-e flash card (cached etc..). But it might be from LinkBench. The LinkBench (at…
