view counter

MySQL Feed

Oracle MySQL resources, news, and support articles.

Percona XtraBackup 2.1.3 for MySQL available for download

href="http://www.mysqlperformanceblog.com/wp-content/uploads/2013/01/Percona_XtraBackup.jpg"> class="alignleft wp-image-12668" style="margin-top: 5px; margin-bottom: 5px;" alt="Percona XtraBackup for MySQL" src="http://www.mysqlperformanceblog.com/wp-content/uploads/2013/01/Percona_XtraBackup.jpg" width="206" height="78" /> Percona is glad to announce the release of href="http://www.percona.com/software/percona-xtrabackup">Percona XtraBackup 2.1.3 for MySQL on May 22, 2013.

New Launchpad project for tracking bugs on Chef cookbooks

Yesterday, I created a Launchpad project to be used for tracking bugs and feature requests for the new OpenStack Chef cookbooks house on Stackforge. Please do file bugs as you encounter issue with any of the cookbooks or the example OpenStack Chef Repository.

Percona MySQL University @Portland: June 17

id="attachment_12663" class="wp-caption alignleft" style="width: 310px"> href="http://www.mysqlperformanceblog.com/wp-content/uploads/2013/01/PMySQLU.jpg"> class="size-medium wp-image-12663" alt="Percona CEO Peter Zaitsev leads a track at the inaugural Percona MySQL University event in Raleigh, N.C. on Jan. 29, 2013." src="http://www.mysqlperformanceblog.com/wp-content/uploads/2013/01/PMySQLU-300x224.jpg" width="300" height="224" />
class="wp-caption-text">Peter Zaitsev leads a track at the inaugural Percona MySQL University event in Raleigh, N.C. on Jan. 29, 2013.

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  href="http://www.mysqlperformanceblog.com/2013/03/11/mysql-5-6-vs-5-5-on-the-star-schema-benchmark/" target="_blank">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 up with more SSB tests at a later date.

PHPTek

The PHPTek Conference bills itself as the premier professional PHP conference with a community flair. Having been to dozens of PHP conferences, I thought that was a pretty bold claim.


MySQL Boogiebot

Replication in MySQL 5.6: GTIDs benefits and limitations – Part 1

href="http://www.mysqlperformanceblog.com/wp-content/uploads/2013/05/data_replication2.jpg"> class="alignleft wp-image-15554" style="margin-left: 9px; margin-right: 9px;" alt="GTID-based replication" src="http://www.mysqlperformanceblog.com/wp-content/uploads/2013/05/data_replication2-300x204.jpg" width="270" height="184" />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.

Get the Best from Web, Cloud, and Embedded Applications as a MySQL DBA

After taking this MySQL for Database Administrators course, you will be equipped to use all the features of MySQL to get the best out of your Web, Cloud, and embedded applications, whether you work with the command line or graphical tools such as MySQL Workbench and MySQL Enterprise Monitor, whether your application uses complex queries or the NoSQL API, and whether your preferred challenge is replicated servers or h

Working with the OpenStack Code Review and CI system – Chef Edition

For too long, the state of the OpenStack Chef world had been one of duplicative effort, endless forks of Chef cookbooks, and little integration with how many of the OpenStack projects choose to control source code and integration testing. Recently, however, the Chef + OpenStack community has been getting its proverbial act together. Folks from lots of companies have come together and pushed to align efforts to produce a set of well-documented, flexible, but focused Chef cookbooks that install and configure OpenStack services.

Webinar: SQL Query Patterns, Optimized

href="http://www.mysqlperformanceblog.com/wp-content/uploads/2013/02/Percona-MySQL-Webinars.jpg"> class="alignleft wp-image-12964" alt="Using MySQL 5.6 Performance Schema to Troubleshoot Typical Workload Bottlenecks" src="http://www.mysqlperformanceblog.com/wp-content/uploads/2013/02/Percona-MySQL-Webinars-285x300.jpg" width="171" height="180" />This Friday, May 31 at 10 a.m. Pacific, I’ll present Percona’s next webinar, “ href="http://www.percona.com/webinars/mysql-query-patterns-optimized">SQL Query Patterns, Optimized.”

MySQL 5.6, InnoDB and fast storage

I used a simple workload with sysbench to determine the rate at which InnoDB can read blocks from disk. The workload is read-only and each query fetches 1 row by PK. The workload was IO-bound with a 2G InnoDB buffer pool and 32G database. Storage was fast courtesy of buffered IO and enough RAM to cache the database in the OS filesystem cache.

view counter