…. Percona MySQL University is a daylong, free, fast-paced and very technical MySQL educational event for wide range of people interested in MySQL – Developers, System Administrators, DBAs, etc. It will be held at Portland State University’s Smith Memorial Student… in Portland and would like Percona MySQL University to come to your city, please fill out the form to let us know…
Comment: ZFS on Linux and MySQL
May 31, 2013 By 17 Comments
Nice to see this writeup on ZFS and MySQL. One question, why with 192GB of memory, did you limit the ARC to 4GB? Also wondering if any one is using ZFS and MySQL to thin… the MySQL side. Interesting that on Wikipedia Data Virtualization is talked about as data source aggregation but as someone pointed out aggregating…
Comment: Percona XtraBackup 2.1.3 for MySQL available for download
May 30, 2013 By 3 Comments
…size + sort_buffer_size)*max_threads = 4432877 K bytes of memory Hope that’s ok; if not, decrease some …backtrace. You can use the following information to find out where mysqld died. If you see no messages …56 mysqld_safe mysqld from pid file /var/lib/mysql/srv-d2-mysql02.pid ended in an another …
Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
… 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… Percona Live MySQL Conference and Expo in Santa Clara, Calif., April 22-25. Share a memory you have from past MySQL user conferences…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… or work around it with by fsyncing to memory (Battery or capacitor-backed write cache), etc… MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication… get less than 5 people who do out of 100). But, what to do? Retrying automatically…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
…of a replication feedback mechanism, unlike anything you find in standard async MySQL replication. It is my belief that the lack of understanding of… index smaller in memory. It keeps the certification…of time (out of 1.0) since the last SHOW GLOBAL STATUS that flow control is effect, regardless of…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
… here. In summary, you need to interleave the allocation of memory for the MySQL process using the numactl utility, drop the file cache… states. What was I missing? In order to figure out, I started of data gathering metrics like: pt-stalk, vmstat, top, iostat… S3 was especially puzzling since MySQL was not involved. The server was running with nearly 7GB of free memory but the push to…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… test run. With that out of the way, let’s look at some numbers. vCache vs. vCache – MySQL parameter testing The first test… HDD configuration for MySQL (configuration A, listed at the bottom of this post) and then tried three additional sets of experiments. First, the… themselves. When the working set outstrips the available buffer pool memory but still fits into the cache device, vCache shines. Compared…
Comment: Virident vCache vs. FlashCache: Part 1
May 17, 2013 By 3 Comments
…not Virident, but there’s a comparison in TPCC-MySQL performance between that card and a traditional SSD – … much closer to memory speed than a regular SSD or HDD RAID), I can write data out to spinning … is Facebook FlashCache. I’d never even heard of the STEC caching solution prior to your comment. …
Post: Getting MySQL Core file on Linux
August 26, 2011 By 1 Comment
… file will dump all MySQL Server memory content including buffer pool which can be tens on even hundreds GB of disk space. It… looking at many times the amount of memory MySQL consumes worth of disk space. You have to do couple of changes to enable core files… to run out of space, but the real reason is I could not really get core dumped to /var/lib/mysql (datadir) on…
