by Ignacio Nin | Feb 21, 2013 | MySQL
Lately we’ve had many reports of the RPM packages for CentOS 5 (mostly) and CentOS 6 having issues when installing different combinations of our products, particularly with Percona Toolkit for MySQL. Examples of bugs related to these issues are lp:1031427 and...
by Martin.FarachColton | Feb 20, 2013 | MySQL
I’ve said it before, and, as is the nature of these things, I’ll almost certainly say it again: your database performance is only as good as your indexes. That’s the grand thesis, so what does that mean? In any DB system — SQL, NoSQL, NewSQL,...
by Peter Zaitsev | Feb 20, 2013 | Benchmarks, Insight for DBAs, MySQL
Based on a lot of surprising comments about my MySQL 5.5 vs 5.6 performance post I decided to perform deeper investigation to see where my results could go possibly wrong. I had set up everything to be as simple as possible to get maximally repeatable results. I did...
by Bill Karwin | Feb 18, 2013 | Insight for DBAs, MySQL, Percona Events, Percona Software
Next week I’m teaching an online Percona Training class, called Analyzing SQL Queries with Percona Toolkit. This is a guided tour of best practices for pt-query-digest, the best tool for evaluating where your database response time is being spent. This month we...
by Peter Zaitsev | Feb 18, 2013 | MySQL, Percona Events
Following our events in Raleigh, Montevideo, Buenos Aires, Percona MySQL University comes to Toronto on March 22nd. This is going to our most dense event yet, absolutely packed with information. Even though we have just 1 track we have 12 talks and 11 speakers. We had...
by Peter Boros | Feb 18, 2013 | MySQL
Do you have a query you never dared to touch? Do you know it’s bad, but it’s needed? Does it fit your screen? Does it really have to be that expensive? Do you want to do something about it? During the next Percona webinar on February 27, I will present...
by Peter Zaitsev | Feb 18, 2013 | MySQL
There have been a number reports/benchmarks showing MySQL 5.6 to be slower than MySQL 5.5 on variety of workloads. There are many possible reasons and I believe we will learn about many of them in the next few weeks and months as MySQL 5.6 is starting to get...
by Peter Zaitsev | Feb 16, 2013 | MySQL
One of the most useful tools if you’re working with multiple versions of MySQL Servers is MySQL Sandbox which allows you to maintain many different versions of MySQL, Percona Server, MariaDB. If you’re just working with single sandbox you can just use...
by Daniel Nichter | Feb 15, 2013 | Percona Events, Percona Software
About a month ago, we held a bug raffle for Percona Toolkit 2.1.9. The turnout was good and the resulting release is worth upgrading to, especially if you were affected by the backwards-incompatible changes to pt-heartbeat in 2.1.8. Here are the release notes for...
by Roman Vynar | Feb 15, 2013 | Percona Events, Percona Software
Percona is glad to announce the release of Percona Monitoring Plugins 1.0.2 — high-quality components to add enterprise-grade MySQL monitoring and graphing capabilities to your existing in-house, on-premises monitoring solutions. The components are designed to...
by Stephane Combaudon | Feb 15, 2013 | MySQL
MySQL 5.6 has an impressive list of improvements. Among them, replication checksums caught my attention as it seems that many people misunderstand the real added value of this new feature. I heard people think that with replication checksums, data integrity between...
by Terry Erisman | Feb 14, 2013 | Cloud, MySQL, Percona Events, Percona Live
We are very pleased to announce the addition of HP and Amazon Web Services as keynote speakers for the Simone Brunozzi, Senior Technology Evangelist, who will speak on “Databases in the Cloud: Present and Future.” HP will be represented by Early Bird...
by Hrvoje Matijakovic | Feb 13, 2013 | MySQL, Percona Software
Percona is glad to announce the release of Percona XtraDB Cluster 5.5.29-23.7.2 on February 13th, 2013. Binaries are available from downloads area or from our software repositories. Bugs fixed: DML operations on temporary tables would try to append the key for...
by Rich.Prohaska | Feb 12, 2013 | MySQL
With TokuDB v6.6 out now, I’m excited to present one of my favorite enhancements: fast updates with TokuDB. Update intensive applications can have their throughput limited by the random read capacity of the storage system. The cause of the throughput limit is the...
by Jay Janssen | Feb 12, 2013 | MySQL, Percona Events, Percona Live
I’ve been woefully neglectful of my responsibilities to post regularly about Percona Live MySQL Conference and Expo 2013 (PLCME 2013), but here’s some highlights of what I am planning to attend from the schedule. Read to the very bottom for the chance to...
by Stephane Combaudon | Feb 11, 2013 | MySQL
Some time ago, I had to convert all tables of a database from MyISAM to InnoDB on a new server. The plan was to take a logical dump on the master, exporting separately the schema and the data, then edit the CREATE TABLE statements to ensure all tables are created with...
by David Busby | Feb 11, 2013 | MySQL
One of our Remote DBA service clients recently had an issue with size on disk for a particular table; in short this table was some 25 million rows of application audit data with an on disk size of 345GB recorded solely for the purposes of debugging which may or may...
by Miguel Angel Nieto | Feb 8, 2013 | MySQL
MySQL 5.6 is GA! Now we have new things to play with and in my personal opinion, the most interesting one is the new Global Transaction ID (GTID) support in replication. This post is not an explanation of MySQL replication find query with GTID and how it works...
by Terry Erisman | Feb 7, 2013 | MySQL, Percona Events
The deadline is fast approaching to submit proposals for the Birds of a Feather Sessions (BOFs) and the Lightning Talks (presented during the Wednesday Evening Networking Reception) for the Percona Live MySQL Conference and Expo 2013. Applications for the DotOrg...
by Justin Swanhart | Feb 6, 2013 | MySQL, Percona Events
On Friday, February 15, 2013 10:00am Pacific Standard Time, I will be delivering a webinar entitled “Building a highly scaleable distributed row, document or column store with MySQL and Shard-Query” The first part of this webinar will focus on why...
