… writeup on ZFS and MySQL. One question, why with 192GB of memory, did you limit the ARC to 4GB? Also wondering if… talked about as data source aggregation but as someone pointed out aggregating data sources should be called data transparency meaning that… supports multiple virtual machines data virtualization is where one set of data supports multiple consumers and appears that each has an…
Comment: Percona XtraBackup 2.1.3 for MySQL available for download
May 30, 2013 By 3 Comments
… bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built…_buffer_size + sort_buffer_size)*max_threads = 4432877 K bytes of memory Hope that’s ok; if not, decrease some variables in… Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this…
Post: Percona MySQL University @Portland: June 17
May 22, 2013 By 1 Comment
… as OSCON and Open Source Bridge as well as hosts of OpenSQL Camp in 2009. As such it is a very… range of people interested in MySQL – Developers, System Administrators, DBAs, etc. It will be held at Portland State University’s Smith Memorial… Percona MySQL University to come to your city, please fill out the form to let us know. We’ll try to…
Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
… now CEO of Eucalyptus. Percona announces Percona XtraDB Cluster as GA – the new approach to MySQL High Availability in and out of the Cloud. MySQL 5.5.23 is GA and 5.6.5 is nonGA at the time of the… Expo in Santa Clara, Calif., April 22-25. Share a memory you have from past MySQL user conferences on Twitter – directing…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
… and here. In summary, you need to interleave the allocation of memory for the MySQL process using the numactl utility, drop the… states. What was I missing? In order to figure out, I started of data gathering metrics like: pt-stalk, vmstat, top, iostat… running with nearly 7GB of free memory but the push to S3 involves a split operation to create files of 5GB since the…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…_commit != 1), or work around it with by fsyncing to memory (Battery or capacitor-backed write cache), etc., but the principle… every node and not just a quorum? Well, it turns out transaction ordering really, really matters (really!). By enforcing replication to… logic (I usually get less than 5 people who do out of 100). But, what to do? Retrying automatically, or giving your…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… prior to and immediately following each test run. With that out of the way, let’s look at some numbers. vCache vs…. FlashCache – dirty page threshold Finally, we examine the impact of a couple of different dirty-page ratios on device performance, since this… themselves. When the working set outstrips the available buffer pool memory but still fits into the cache device, vCache shines. Compared…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… async MySQL replication. It is my belief that the lack of understanding of this system, or even that it exists, leads to… fc_limit does however keep the certification index smaller in memory. It keeps the certification interval small, which minimizes replication conflicts… – the fraction of time (out of 1.0) since the last SHOW GLOBAL STATUS that flow control is effect, regardless of which node caused…
Comment: Virident vCache vs. FlashCache: Part 1
May 17, 2013 By 3 Comments
…/vCache approach with this sort of use case, I’m effectively allowing my database to run in memory (not actual RAM, that…, but much closer to memory speed than a regular SSD or HDD RAID), I can write data out to spinning disk at… personally encountered is Facebook FlashCache. I’d never even heard of the STEC caching solution prior to your comment. Maybe another…
Comment: Why MySQL Performance at Low Concurrency is Important
March 27, 2013 By 8 Comments
… the motivation but I just did not want to single out Oracle materials linked in the post first which start from… on my memory. I personally always try to provide 1 thread baseline for the reasons mentioned, at least in case of performance…
