… vCache with time-based flushing enabled actually produces better and more consistent performance than vCache without time-based flushing, but even… themselves. When the working set outstrips the available buffer pool memory but still fits into the cache device, vCache shines. Compared… the FlashCache configuration to produce better or more consistent results, or results that are more inline with the numbers put up by…
Comment: Virident vCache vs. FlashCache: Part 1
May 17, 2013 By 3 Comments
…’s pretty fast. But it’s still significantly slower (and more CPU-intensive under high load) than PCIe flash For example… my database to run in memory (not actual RAM, that’s true, but much closer to memory speed than a regular SSD…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… for download from our repositories. Benchmark showing the impact of memory allocators on MySQL performance can be found in this blogpost… were started before running wsrep recovery, this would lead to memory corruption and server crash. Bug fixed #1132974 (Seppo Jaakola). Conflicting… Transfer with Xtrabackup would fail if the tmpdir was specified more than once in the MySQL configuration file (my.cnf). Bugs…
Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
… will be separate from MySQL Server, providing a more scalable Innodb version with more features. Gearman and MemcacheD storage engine plugins are… Innodb Plugin. MySQL 5.5 is now GA with no more funky version differences for MySQL Enterprise, just certain features available… Expo in Santa Clara, Calif., April 22-25. Share a memory you have from past MySQL user conferences on Twitter – directing…
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 9, 2013 By 32 Comments
…. This could not be related to primary key worth distribution, memory or CPU as repeating the same test on uncompressed table… ? Add my vote on compression as we are facing more and more big data challenges where innoDB and TokuDB will have to…
Post: Virident vCache vs. FlashCache: Part 1
May 16, 2013 By 3 Comments
… building a separate kernel module in addition to whatever flash memory driver you’ve already had to install, and then further… appears that they do not. I find the vCache implementation more useful than the one present in FlashCache. Winner: vCache. Although…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
… supported from MySQL 5.5). If you want to know more details, please read on! MySQL 5.0/5.1 First… in the documentation, the connection parameters are still held in memory. In any case, you will be able to restart replication…
Comment: Testing the Micron P320h
April 16, 2013 By 7 Comments
… EXT4 is pretty surprising.. – did you monitor by chance the memory usage during your tests?.. – I’m asking about because in… also if on 13GB BP there was really x3 times more I/O ops on EXT4 than on XFS (as it…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
… the impact of the list scan by replacing it with more efficient operations. In a nutshell, it maintains an array of… states is then a matter of copying a relatively small memory block which, depending on many factors, can be from few…
Post: Should I buy a Fast SSD or more memory?
April 8, 2010 By 10 Comments
… To get the same improvement with memory, you would have needed to add 60% more memory -or- 260% more memory for a 5x improvement.Â… (are your memory slots already filled?) Does your budget allow to install SSD cards? (You may still need more than one, since… enough? There are more wins to be had if you can afford to buy all the memory that is required. The…
