by Laurynas Biveinis | May 9, 2016 | MySQL
In this blog post, we’ll discuss the ins and outs of Percona Server 5.7 parallel doublewrite.After implementing parallel LRU flushing as described in the previous post, we went back to benchmarking. At first, we tested with the doublewrite buffer turned... by Laurynas Biveinis | May 5, 2016 | MySQL
In this blog post, we’ll discuss how to use multi-threaded LRU flushing to prevent bottlenecks in MySQL.In the previous post, we saw that InnoDB 5.7 performs a lot of single-page LRU flushes, which in turn are serialized by the shared doublewrite buffer. Based... by Laurynas Biveinis | May 3, 2016 | MySQL
In this post, we’ll examine why in an initial flushing analysis we find that Performance Schema data is incomplete.Having shown the performance impact of Percona Server 5.7 patches, we can now discuss their technical reasoning and details. Let’s... by Laurynas Biveinis | Mar 17, 2016 | Benchmarks, MySQL, Percona Software
In this blog post, we’ll be discussing Percona Server 5.7 performance improvements.Starting from the Percona Server 5.6 release, we’ve introduced several significant changes that help address performance problems for highly-concurrent I/O-bound workloads.... by Laurynas Biveinis | May 22, 2014 | Insight for Developers, MySQL, Percona Software
The recent WebScaleSQL announcement has made quite a splash in the MySQL community over the last few weeks, and with a good reason. The collaboration between the major MySQL-at-scale users to develop a single code branch that addresses the needs of, well, web scale,... by Laurynas Biveinis | Jan 13, 2012 | MySQL
Percona is glad to announce the release of Percona Server 5.5.19-24.0 on January 13th, 2012 (Downloads are available here and from the Percona Software Repositories).Based on MySQL 5.5.19, including all the bug fixes in it, Percona Server 5.5.19-24.0 is now the... by Laurynas Biveinis | Nov 24, 2011 | MySQL
It is no secret that bugs related to multithreading–deadlocks, data races, starvations etc–have a big impact on application’s stability and are at the same time hard to find due to their nondeterministic nature. Any tool that makes finding such... by Laurynas Biveinis | Sep 6, 2011 | MySQL, Percona Software
The latest Percona Server release has one new feature: now MEMORY tables can have BLOB and TEXT columns, and VARCHAR columns will not waste space due to implicit extension to CHAR.The lack of these features in the MEMORY storage engine (also known as HEAP) in MySQL... by Laurynas Biveinis | May 3, 2011 | MySQL
Part of the InnoDB duties, being an MVCC-implementing storage engine, is to get rid of–purge–the old versions of the records as they become obsolete. In MySQL 5.1 this is done by the master InnoDB thread. Since then, InnoDB has been moving...