by Alexey Kopytov | Mar 11, 2014 | Insight for DBAs, MySQL, Percona Software
TL;DR version: The backup locks feature introduced in Percona Server 5.6.16-64.0 is a lightweight alternative to FLUSH TABLES WITH READ LOCK and can be used to take both physical and logical backups with less downtime on busy servers. To employ the feature with...
by Hrvoje Matijakovic | Mar 10, 2014 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona Server 5.6.16-64.0 on March 10th, 2014 (Downloads are available here and from the Percona Software Repositories. Based on MySQL 5.6.16, including all the bug fixes in it, Percona Server 5.6.16-64.0 is the current GA...
by Max Bubenick | Mar 10, 2014 | MySQL, Percona Events, Percona Services
One of the tasks within Percona Remote DBA is to ensure we have reliable backups with minimal impact. To accomplish this, one of the tools our team uses is called mydumper. We use mydumper for logical backups because of several nice features. Some of them are:...
by Hrvoje Matijakovic | Mar 10, 2014 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona Server 5.5.36-34.0 on March 10th, 2014 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.36, including all the bug fixes in it, Percona Server 5.5.36-34.0 is now the current...
by Bill Karwin | Mar 7, 2014 | Insight for Developers, MySQL, Webinars
On Wednesday I gave a presentation on “How to Avoid Common (but Deadly) MySQL Development Mistakes” for Percona MySQL Webinars. If you missed it, you can still register to view the recording and my slides. Thanks to everyone who attended, and especially to folks who...
by Hrvoje Matijakovic | Mar 6, 2014 | Percona Events, Percona Software
Percona is glad to announce the release of Percona XtraBackup 2.1.8 on March 6th, 2014. Downloads are available from our download site here and Percona Software Repositories. This release is the current GA (Generally Available) stable release in the 2.1 series....
by Stephane Combaudon | Mar 6, 2014 | Insight for DBAs, MySQL
I recently worked on an uncommon slow query: less than 100 rows were read and returned, the whole dataset was fitting in memory but the query took several seconds to run. Long story short: the query was a join involving 21 tables, running on MySQL 5.1. But by default...
by Tim.Callaghan | Mar 5, 2014 | MySQL
I’ve been a little behind in recent blogging efforts, and realized that in less than a month we’ll be back at Percona Live: MySQL Conference and Expo 2014, aka PLMCE. Last year’s PLMCE was my first, as well as the event where Tokutek announced the...
by Tom Diederich | Mar 5, 2014 | MySQL, Percona Live
Google senior systems engineer Jeremy Cole is once again teaming with LinkedIn senior software engineer Davi Arnaut for two InnoDB-focused sessions at the upcoming Percona Live MySQL Conference and Expo 2014 this April 1-4 in Santa Clara, California. The duo will...
by Hrvoje Matijakovic | Mar 4, 2014 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona Toolkit 2.1.11 on March 4th, 2013 (Downloads are available here). Bugs Fixed: Fixed bug 1279502: –version-check behaves like spyware The configuration for what information Percona Toolkit should retrieve is not...
by Tom Diederich | Mar 3, 2014 | Insight for DBAs, Insight for Developers, MySQL, Percona Live
MySQL Fabric is an integrated framework for managing farms of MySQL servers with support for both high-availability and sharding. Its development has been spearheaded by Mats Kindahl, senior principal software developer in MySQL at Oracle. Mats is leading the MySQL...
by Hrvoje Matijakovic | Mar 3, 2014 | MySQL, Percona Events, Percona Software
Percona is glad to announce the first ALPHA release of Percona Server 5.6.16-64.0 with TokuDB engine on March 3rd, 2014. Downloads are available here and from the Percona Software Repositories. Based on Percona Server 5.6.16-64.0 including all the features and bug...
by Bill Karwin | Feb 28, 2014 | Insight for DBAs, Insight for Developers, MySQL, Webinars
MySQL software developers are under pressure to do more in less time and create applications that adapt to ever-changing requirements. And it’s true that some of a developer’s time is wasted when his or her method of optimizing involves trying every...
by Peter Zaitsev | Feb 28, 2014 | Insight for DBAs, MySQL
When looking at queries that are candidates for optimization I often recommend that people look at rows_sent and rows_examined values as available in the slow query log (as well as some other places). If rows_examined is by far larger than rows_sent, say 100 larger,...
by Dave Rosenlund | Feb 27, 2014 | MySQL
It may be easy to choose a NoSQL database, but do you know which distribution is best for you? Which will perform better? Which will scale further? Look before you leap. Register Now! SPEAKER: John Schulz DATE: Wednesday, March 5th TIME: 1pm ET AOL, the well-known...
by Dimitri Vanoverbeke | Feb 27, 2014 | Insight for DBAs, MySQL
The MySQL client has some functionalities some of us never use. Why would you use them and what is the added value of this? Every DBA and developer has had a moment when he or she needs to connect to a MySQL database using the command line tool. Therefore I’ve written...
by Peter Boros | Feb 26, 2014 | Insight for DBAs, MySQL, Percona Services, Percona Software, Webinars
First of all we would like to thank all of you who attended the Feb. 19 MySQL webinar, “Performance Monitoring and Troubleshooting of Percona XtraDB Cluster.” We got some really good questions – many of which we didn’t have time to address...
by Nilnandan Joshi | Feb 26, 2014 | MySQL, Percona Services, Percona Software
While working on a recent support issue as a Percona Support Engineer, I got one question from a customer asking how to monitor ALTER TABLE progress. Actually, for MySQL 5.5 and prior versions, it’s quite difficult to ALTER the table in a running production...
by Leif.Walsh | Feb 25, 2014 | MySQL
We just released version 1.4.0 of TokuMX, our high-performance distribution of MongoDB. There are a lot of improvements in this version (release notes), the most of any release yet. In this series of blog posts, we describe the most interesting changes and how they’ll...
by Vadim Tkachenko | Feb 25, 2014 | MySQL
I’ve mentioned InfiniDB before in a previous post titled, “Star Schema Bechmark: InfoBright, InfiniDB and LucidDB,” but it’s been 4 years since that was published. Recently I evaluated column-storage solutions for Percona Cloud Tools and took...
