… mutex for the log reads needlessly, potentially limiting performance on write-intensive workloads. Bug fixed #1171699. Missing path separator between the…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
June 5, 2013 By
… have the luxury of not blocking the master from taking writes if bandwidth is constrained and the slaves lag for a…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… know it doesn’t though.) Why don’t you try writing a SQL query optimizer and see how easy it is…
Comment: ZFS on Linux and MySQL
May 31, 2013 By 17 Comments
… source database and provisioning clones from those snapshots. We are writing a book on Data Virtualization for Databases meaning using a…
Comment: ZFS on Linux and MySQL
May 28, 2013 By 17 Comments
… bottleneck (benchmark in progress), if I am right, I’ll write another blog post about it.
Comment: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… faster than the old drives. So fast, that for linear writes, like httpd logs, they are as fast as older SSDs…
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/
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
… (~150MB/s) but doing very little physical writes. The writes were cached and the write cache was causing the problem. It happened that… to 20 on a 48GB server, allowing nearly 10GB of “write cache”. A quick survey of the servers I have access…. I simply set the dirty_ratio to 2 (1GB of write cache) and the issue is gone since. So, add to…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… Simply speaking: flow control makes replication stop, and therefore makes writes (which are synchronous) stop, on all nodes until flow control… interval small, which minimizes replication conflicts on a cluster where writes happen on all nodes. On a master/slave cluster, therefore… nodes will be the slaves with no writes coming from them. However, with multi-node writing, larger queues will make certification more…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… the original node where the transaction is committed) Galera prevents writing conflicts to these pending transactions while they are inflight in… it with by fsyncing to memory (Battery or capacitor-backed write cache), etc., but the principle is basically the same. If… more latency waiting for a write to go through, and possibly some poor user experience. batch writes Instead of updating global counters…
