Percona MySQL University @Portland: June 17
Portland is a well-recognized hub for Open Source technologies in the Northwest, home to conferences such as OSCON and Open Source Bridge as well as hosts of OpenSQL Camp in 2009. As such it is a very natural place for our next Percona MySQL University event scheduled for June 17. We run this event in partnership with MySQL Meetup at Portland organized by our own Daniel Nichter, who recently … [Read More]
MySQL and the SSB – Part 2 – MyISAM vs InnoDB low concurrency
This blog post is part two in what is now a continuing series on the Star Schema Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using only the InnoDB storage engine. In my testing I discovered that innodb_old_blocks_time had an effect on performance of the benchmark. There was some discussion in the comments and I promised to follow … [Read More]
Replication in MySQL 5.6: GTIDs benefits and limitations – Part 1
Global Transactions Identifiers are one of the new features regarding replication in MySQL 5.6. They open up a lot of opportunities to make the life of DBAs much easier when having to maintain servers under a specific replication topology. However you should keep in mind some limitations of the current implementation. This post is the first one of a series of articles focused on the implications … [Read More]
Webinar: SQL Query Patterns, Optimized
Next Friday, May 31 at 10 a.m. Pacific, I'll present Percona's next webinar, "SQL Query Patterns, Optimized." Based on my experiences solving tough SQL problems for Percona training and consulting, I'll classify several common types of queries with which developers struggle. I'll test several SQL solutions for each type of query objective, and show how you can use MySQL 5.6 built-in methods to … [Read More]
Percona XtraBackup 2.1.2 for MySQL available for download
Percona is glad to announce the release of Percona XtraBackup 2.1.2 for MySQL on May 18, 2013. Downloads are available from our download site here and Percona Software Repositories. This release fixes number of high-priority bugs since version 2.1 became GA. It’s advised to upgrade your latest 2.1 version to 2.1.2. This release is the latest stable release in the 2.1 series. Bugs … [Read More]
