by Peter Zaitsev | Mar 27, 2013 | Benchmarks, MySQL, Percona Live
A few weeks ago I wrote about “MySQL Performance at High Concurrency” and why it is important, which was followed up by Vadim’s post on ThreadPool in Percona Server providing some great illustration on the topic. This time I want to target an...
by Miguel Angel Nieto | Mar 26, 2013 | MySQL
In a previous post I explained how to repair MySQL 5.6 GTID replication using two different methods. I didn’t mention the famous SET GLOBAL SQL_SLAVE_SKIP_COUNTER = n for a simple reason, it doesn’t work anymore if you are using MySQL GTID. Then the...
by Daniel Nichter | Mar 25, 2013 | Percona Software
A new Percona Toolkit series has been released: Percona Toolkit 2.2 for MySQL 5.6. Several months in the making and many new features, changes, and improvements make this a great new series. It replaces the 2.1 series for which we plan to do only one more bug fix...
by Stephane Combaudon | Mar 22, 2013 | MySQL, Percona Events, Percona Software
On April 3 at 10 a.m. PST, I’ll be giving a webinar titled “5 Percona Toolkit Tools for MySQL That Could Save Your Day.” In this presentation you’ll learn how to perform typical but challenging MySQL database administration tasks. My focus will...
by Vadim Tkachenko | Mar 21, 2013 | MySQL, Percona Events
I actually don’t remember exactly whether it was in 2006, 2007 or 2008 — but around that time the MySQL community had one of the greatest MySQL conferences put on by O’Reilly and MySQL. It was a good, stable, predictable time. Shortly thereafter, the MySQL...
by Ernie Souhrada | Mar 21, 2013 | Benchmarks
Approximately 11 months ago, Vadim reported some test results from the Virident FlashMax 1400M, an MLC PCIe SSD device. Since that time, Virident has released the FlashMAX II, which promises both increased capacity and increased performance over the previous model. In...
by Hrvoje Matijakovic | Mar 20, 2013 | MySQL
Percona is glad to announce the release of Percona XtraBackup 2.0.6 for MySQL 5.6 on March 20, 2013. 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.0...
by Tim.Callaghan | Mar 20, 2013 | MySQL
We recently resumed our discussion around bringing Fractal Tree indexes to MongoDB. This effort includes Tokutek’s interview with Jeff Kelly at Strata as well as my two recent tech blogs which describe the compression achieved on a generic MongoDB data set and...
by Peter Zaitsev | Mar 20, 2013 | Insight for DBAs, Insight for Developers, MySQL, Percona Events, Percona Live, Percona Software
Percona MySQL University, Toronto is taking place this Friday and I’m very excited about this event because it is a special opportunity to fit a phenomenal number of specific and focused MySQL technical talks all into one day, for free. Over the course of the...
by Terry Erisman | Mar 19, 2013 | Benchmarks, Cloud, Hardware and Storage, Insight for DBAs, Insight for Developers, MySQL, Percona Events, Percona Live, Percona Software
Facebook is a major user of MySQL and has pushed the performance limits of the technology. Their MySQL experts have deep, hands on knowledge of the technology. I’m pleased to welcome Mark Callaghan, Software Engineer for Database Infrastructure at Facebook, back again...
by Vadim Tkachenko | Mar 16, 2013 | MySQL
For this post I’m going to shamelessly exploit the litany of technical problems SimCity players encountered earlier this month and a few examples of how Thread Pool for MySQL and Percona Server for MySQL can help to prevent such incidents. Users of SimCity, a...
by Hrvoje Matijakovic | Mar 15, 2013 | MySQL, Percona Software
Percona is glad to announce the release of Percona Server for MySQL 5.1.68 -14.5 on March 15, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.1.68, including all the bug fixes in it, Percona Server 5.1.68 -14.5 is now...
by David Hildebrandt | Mar 15, 2013 | MySQL
Percona will be in Chicago and London the week of April 8th delivering two 2-day MySQL workshops. For our MPB readers, we are offering a 15% discount. Just use MPB15A when purchasing your tickets to one or both MySQL workshops. Scaling and Optimization for MySQL on...
by Hrvoje Matijakovic | Mar 14, 2013 | MySQL
Percona is glad to announce the release of Percona Server for MySQL 5.6.10-60.2 on March 14, 2013. (Downloads are available here and from the experimental Percona Software Repositories). Based on MySQL 5.6.10, including all the bug fixes in it, Percona...
by Tim.Callaghan | Mar 14, 2013 | MySQL
As we continue to test our Fractal Tree Indexing with MongoDB, I’ve been updating my benchmark infrastructure so I can compare performance, correctness, and resource utilization. Sysbench has long been a standard for testing MySQL performance, so I created a version...
by Jaime Crespo | Mar 14, 2013 | Insight for Developers, MySQL, Percona Events
While preparing the webinar I will deliver this Friday, I ran into a quite interesting (although not very impacting) optimizer issue: a “SELECT *” taking half the time to execute than the same “SELECT one_indexed_column” query in MySQL 5.6.10....
by Ryan Huddleston | Mar 13, 2013 | Cloud, Insight for DBAs, Insight for Developers, MySQL
As part of Percona Remote DBA for MySQL service we recognize that reliable backups are one of the most important things we can bring to the table. In my experience handling emergencies, the single worst thing that can happen is finding out you don’t have backups...
by Terry Erisman | Mar 12, 2013 | Benchmarks, Cloud, Hardware and Storage, Insight for DBAs, Insight for Developers, MySQL, Percona Events, Percona Live, Percona Software
I’m pleased to announce that Oracle is sending some of their top technical people to speak at the Oracle, will present an invited keynote talk on “MySQL 5.6: Performance Benchmarks, Tuning, and ‘Best’ Practices” by Dmitri Kravtchuk, MySQL Performance...
by Tokutek | Mar 11, 2013 | MySQL
During the second half of our CUBE discussion with Wikibon analyst Jeff Kelly at this year’s Strata Conference in Santa Clara, we talked about the tipping point for Big Data. Strata veterans could see at a glance that this year’s conference was markedly different. No...
by Justin Swanhart | Mar 11, 2013 | MySQL
So far most of the benchmarks posted about MySQL 5.6 use the sysbench OLTP workload. I wanted to test a set of queries which, unlike sysbench, utilize joins. I also wanted an easily reproducible set of data which is more rich than the simple sysbench table. The...
