view counter
Home

MySQL Feed

Oracle MySQL resources, news, and support articles.

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.

May 22, 2013 6:50am

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

May 21, 2013 11:08am

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.

May 21, 2013 3:00am

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

May 20, 2013 1:49pm

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.

May 20, 2013 10:37am

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.”

May 20, 2013 3:00am

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.

May 18, 2013 3:03pm

Why building a free service can be a disservice

Like many others, I don’t think that RSS is dead. It’s my favorite way to keep up with highly valuable content on the Web. So I’m in the market for a replacement for Google Reader, along with millions of others. As I’ve evaluated options, I’ve had to eliminate some of them because I’m not sure they’re serious about what they’re doing. This post is about my thought process and why I think entrepreneurs should challenge themselves to get serious, and signal that intent, by not building free services.

May 18, 2013 7:46am

Percona XtraBackup 2.1.2 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.2 for MySQL on May 17, 2013.

May 17, 2013 9:25pm

Virident vCache vs. FlashCache: Part 2

This is the second part in a two-part series comparing Virident’s vCache to FlashCache. The first part was focused on usability and feature comparison; in this post, we’ll look at some sysbench test results.

Disclosure: The research and testing conducted for this post were sponsored by Virident.

May 17, 2013 3:00am
view counter