by Jon Tobin | Jan 15, 2015 | MySQL
In my recent travels, I’ve been speaking with database users at various meetups and trade shows worldwide. Very often, I got questions centering around the best use cases for our products, be it TokuDB, our MySQL storage engine, or, TokuMX, our distribution of...
by Aurimas Mikalauskas | Jan 15, 2015 | Benchmarks, Insight for DBAs, MySQL
The other day a customer asked me to do capacity planning for their web server farm. I was looking at the CPU graph for one of the web servers that had Hyper-threading switched ON and thought to myself: “This must be quite a misleading graph – it shows 30%...
by Hrvoje Matijakovic | Jan 14, 2015 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona XtraBackup 2.2.8 on January 14, 2015. Downloads are available from our download site or Percona Software Repositories. Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for...
by Peter Zaitsev | Jan 14, 2015 | Benchmarks, MySQL
Over the past few months I’ve written a couple of posts about dangerous debt of InnoDB Transactional History and about the fact MVCC can be the cause of severe MySQL performance issues. In this post I will cover a related topic – InnoDB Transaction...
by Kortney Runyan | Jan 13, 2015 | MySQL, Percona Live
Today we announced the full conference sessions schedule for April’s Percona Live MySQL Conference & Expo 2015 and this year’s event, once again at the Hyatt Regency Santa Clara and Santa Clara Convention Center, looks to be the biggest yet with networking and...
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 Hrvoje Matijakovic | Jan 12, 2015 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona Server 5.5.41-37.0 on January 9, 2015. Based on MySQL 5.5.41, including all the bug fixes in it, Percona Server 5.5.41-37.0 is now the current stable release in the 5.5 series. Percona Server is open-source and free....
by Tim.Callaghan | Jan 12, 2015 | MySQL
UPDATE: Since the publication of this blog post, the first release candidate of TokuMXse was made available for testing. Learn more about v1.0.0.RC.0. In addition, MongoDB has decided to call the release formerly known as v2.8, v3.0. We’ve been working on...
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 Roman Vynar | Jan 7, 2015 | Insight for Developers, MySQL
This is yet another story of Django web-framework with time zone support and pain dealing with python datetimes and MySQL on the backend. In other words, offset-naive vs offset-aware datetimes. Shortly, more about the problem. After reading the official documentation...
by Miguel Angel Nieto | Jan 6, 2015 | Insight for DBAs, MySQL
We have been using SHOW ENGINE INNODB MUTEX command for years. It shows us mutex and rw-lock information that could be useful during service troubleshooting in case of performance problems. As Morgan Tocker announced in his blog post the command will be removed from...
by Przemysław Malkowski | Jan 5, 2015 | Insight for DBAs, MariaDB, MySQL, Percona Software
Sometimes it is desired to use particular software versions in production, and not necessary the latest ones. There may be several reasons for that, where I think the most common is when a new version should spend some time in testing or a staging environment before...
by Arunjith Aravindan | Jan 2, 2015 | MySQL, Percona Software
The MySQL query cache is one of the prominent features in MySQL and a vital part of query optimization. It is important to know how the MySQL query cache works, as it has the potential to cause significant performance improvements – or a slowdown – of your...
