by Hrvoje Matijakovic | Jan 12, 2015 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona Server 5.6.22-71.0 on January 12, 2015. Download the latest version from the Percona web site or from the Percona Software Repositories. Based on MySQL 5.6.22, including all the bug fixes in it, Percona Server...
by Peter Zaitsev | Jan 8, 2015 | Insight for DBAs, MySQL, Percona Software, Webinars
Whether you’re looking at the overall MySQL ecosystem or the all-data management landscape, the choice of technologies has never been larger than it is in 2015. Having so many options is great but it also can be very hard to make a selection. I’m going to...
by Joel.Epstein | Dec 23, 2014 | MySQL
The MySQL 5.6 Release has introduced some changes to how two phase commit works and is managed. In particular, the commit phase of transactions to the binary log is now serialized and this behavior is something we identified fairly immediately. We implement a group...
by Rich.Prohaska | Dec 17, 2014 | MySQL
TokuDB offers high throughput for write intensive applications, and the throughput scales with the number of concurrent clients. However, when the binary log is turned on, TokuDB 7.5.2 throughput suffers. The throughput scaling problem is caused by a poor...
by Dave Rosenlund | Dec 16, 2014 | MySQL
UPDATE: Since the publication of this blog post, Tokutek subsequently published preliminary benchmark results for this new TokuMX sibling, now called TokuMXse. In addition, there have been a number of release candidates. Finally, MongoDB ultimately decided to call...
by Tim.Callaghan | Oct 16, 2014 | MySQL
In a few weeks I’m presenting “Performance Benchmarking: Tips, Tricks, and Lessons Learned” at Percona Live London 2014 (November 3-4). I continue to learn lessons and improve my benchmarking capabilities, so the content is a full upgrade from my...
by Peter Zaitsev | Oct 10, 2014 | MySQL, Percona Software
MySQL has information_schema.tables that contain information such as “data_length” or “avg_row_length.” Documentation on this table however is quite poor, making an assumption that those fields are self explanatory – they are not when it...
by Max Bubenick | Sep 26, 2014 | MySQL, Percona Software
We are pleased to announce the third release in the 0.6 series of mydumper, a tool for performing logical MySQL backups. In this release, we focused on simplifying compiling the code and added new features for making logical backups. These new features include...
by Tim.Callaghan | Sep 25, 2014 | MySQL
The biggest innovation in TokuDB v7.5 is Read Free Replication (RFR). I blogged a few days ago posting a benchmark showing how much additional throughput can be achieved on a replication slave, while at the same time lowering the read IO operations to almost zero. The...
by Przemysław Malkowski | Sep 25, 2014 | Insight for DBAs, Insight for Developers, MySQL
Recently I encountered a specific situation in which a customer was forced to stay with the MyISAM engine due to a legacy application using tables with over 1000 columns. Unfortunately InnoDB has a limit at this point. I did not expect to hear this argument for...
by Tim.Callaghan | Sep 23, 2014 | MySQL
New to TokuDB® v7.5 is a feature we’re calling “Read Free Replication” (RFR). RFR allows TokuDB replication slaves to process insert, update, and delete statements with almost no read IO. As a result, the slave can easily keep up with the master (no...
by Tim.Callaghan | Sep 18, 2014 | MySQL
Today we released TokuDB® v7.5, the latest version of Tokutek’s storage engine for MySQL and MariaDB. I’ll be publishing two blogs next week to go into more details about our new “Read Free Replication”, but here are high level descriptions of...
by Fernando Laudares Camargos | Aug 22, 2014 | Insight for DBAs, MySQL, Percona Services, Percona Software
In my last post, “
by Rich.Prohaska | Aug 6, 2014 | MySQL
Covering indexes can result in orders of magnitude performance improvements for queries. Bradley’s presentation on covering indexes describes what a covering index is, how it can effect performance, and why it works. However, the definition of a covering index...
by Peter Zaitsev | Jul 30, 2014 | Insight for DBAs, MySQL
As we know different storage engines in MySQL have different file structures. Every table in MySQL 5.6 must have a .frm file in the database directory matching the table name. But where the rest of the data resides depends on the storage engine. For MyISAM we have...
by Peter Zaitsev | Jul 23, 2014 | MySQL
If you try to install the TokuDB storage engine on a modern Linux distribution it might fail with following error message: 2014-07-17 19:02:55 13865 [ERROR] TokuDB will not run with transparent huge pages enabled. 2014-07-17 19:02:55 13865 [ERROR] Please disable them...
by Vadim Tkachenko | Jul 22, 2014 | Insight for DBAs, MySQL, Percona Software
We designed Percona Cloud Tools (both hardware and software setup) to handle a very high-intensive MySQL write workload. For example, we already observe inserts of 1bln+ datapoints per day. So I wanted to share what kind of hardware we use to achieve this result. Let...
by Vadim Tkachenko | Jul 15, 2014 | MySQL, Percona Software
In my recent post, “TokuDB gotchas: slow INFORMATION_SCHEMA TABLES,” I saw a couple questions and tweets asking if we use TokuDB in production. Actually I mentioned it in that post and we also blogged about it in a couple of other recent posts: Getting to...
by Vadim Tkachenko | Jul 9, 2014 | Insight for DBAs, MySQL, Percona Software
We are using Percona Server + TokuDB engine extensively in Percona Cloud Tools and getting real usage operational experience with this engine. So I want to share some findings we came across, in hope it may help someone in their work with TokuDB. So, one problem I...
by Fernando Laudares Camargos | Jun 26, 2014 | MySQL, Percona Software
My previous post was an introduction to the TokuDB storage engine and aimed at explaining the basics of its design and how it differentiates from InnoDB/XtraDB. This post is all about motivating you to give it a try and have a look for yourself. Percona Server is not...
