…) Percona Server for MySQL will now be shipped with the libjemalloc library. Benchmark showing the impact of memory allocators on MySQL performance can be found in this blogpost. (Ignacio Nin) This release of Percona Server for MySQL has fixed a number of…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… the impact of memory allocators on MySQL performance can be found in this blogpost. This release of Percona XtraDB Cluster has fixed number of foreign… #1130888 (Seppo Jaakola). If MySQL replication threads were started before running wsrep recovery, this would lead to memory corruption and server crash…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
… from the old master, which can cause all kinds of data corruption. MySQL provides the handy RESET SLAVE command. But as we…: mysql_sandbox18676-relay-bin.000001 Relay_Log_Pos: 4 [...] As stated in the documentation, the connection parameters are still held in memory… are aware of the difference between RESET SLAVE and RESET SLAVE ALL, disconnecting a replication slave is much easier with MySQL 5…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
One major problem in terms of MySQL performance that still stands in the way of InnoDB scalability is the trx_list scan on consistent read view creation. It was originally reported as a part of MySQL… descriptors array. Creating a snapshot of transaction states is then a matter of copying a relatively small memory block which, depending on many…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…) Percona Server for MySQL will now be shipped with the libjemalloc library. Benchmark showing the impact of memory allocators on MySQL performance can be found in this blogpost. (Ignacio Nin) This release of Percona Server for MySQL has fixed a number of…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… for all of the benchmarks on both systems. The benchmark tool used was sysbench 0.5 and the version of MySQL used was…. vCache – MySQL parameter testing The first test was designed to look solely at vCache performance under some different sets of MySQL configuration parameters… themselves. When the working set outstrips the available buffer pool memory but still fits into the cache device, vCache shines. Compared…
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… no effect on standard MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication? It’s actually… requires tradeoffs. Most of us are used to the tradeoffs we take when deploying conventional stand-alone MySQL Innodb with asynchronous slaves…
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… fc_limit does however keep the certification index smaller in memory. It keeps the certification interval small, which minimizes replication conflicts…
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… S3 was especially puzzling since MySQL was not involved. The server was running with nearly 7GB of free memory but the push to S3 involves a split operation to create files of 5GB since the…
Comment: Virident vCache vs. FlashCache: Part 1
May 17, 2013 By 3 Comments
… card, not Virident, but there’s a comparison in TPCC-MySQL performance between that card and a traditional SSD – the PCIe…/vCache approach with this sort of use case, I’m effectively allowing my database to run in memory (not actual RAM, that’s true, but much closer to memory speed than a regular SSD…
