Some of the NoSQL vendors seemed to have stirred up a mild controversy with their reactions to the launch of NoSQL access to InnoDB in MySQL 5.6 and their suggestions that NoSQL access is only a part of the NoSQL story.

Mark Leith, software development senior manager at Oracle has described the criticism as laughable and Oracle’s director of MySQL product marketing, Mat Keep, accused the NoSQL vendors of “trying to stand on the shoulders of giants” (which is pretty ironic given we are talking about Oracle adding NoSQL capabilities to one of its databases).

In any case I don’t see what the fuss is all about.

Sure, Couchbase and DataStax laid it on a bit thick, but these are corporate blog posts – it goes with the territory.

Besides …

I’m pleased to announce that my first book, the InnoDB Quick Reference Guide, is now available from Packt Publishing and you can download it by clicking here. It covers the most common topics of InnoDB usage in the enterprise, including: general overview of its use and benefits, detailed explanation of seventeen static variables and seven dynamic variables, load testing methodology, maintenance and monitoring, as well as troubleshooting and useful analytics for the engine. The current version of MySQL ships with InnoDB as the default table engine, so whether you program your MySQL enabled applications with PHP, Python, Perl or otherwise, you’ll likely benefit from this concise but comprehensive reference guide for InnoDB databases.

Here are the chapter overviews …

Oracle has now launched MySQL-5.6.10-GA, so it is time to come up with some new benchmark results. The test candidates in this benchmark run are

• MySQL-5.5.29
• MySQL-5.6.10
• MariaDB-5.5.28a
• MariaDB-10.0.1

The 5.5 versions are in because I wanted to check for any regressions. In the past we have often seen performance regressions in newer versions which were caused by new features.

This time the benchmark was run on a different box. The main difference is that this box does not have SSD but a high performance RAID-5 with 512M of battery-backed cache. Besides that the machine has 16 cores out of which 12 were used for mysqld and the other 4 for sysbench.

The benchmark uses sysbench-0.5 OLTP with 8 tables and 10G worth of data. InnoDB buffer pool was 16G, InnoDB log group capacity 4G (the maximum for MySQL-5.5). The different disk system required different InnoDB …

I’m really looking forward to this year’s Percona Live MySQL Conference. This is always THE event of the year for me in the MySQL conference circuit. It’s also the first year I haven’t been a speaker! I’ve been a speaker since 2007 but this year things were too uncertain for me to submit a proposal in time.

As usual, the real highlight of the conference is seeing and talking to everyone. Technical sessions are also great, but honestly I can usually study up on technical things without going to a conference. However, nothing can replace the benefit of meeting all the dedicated MySQL community members in the hallways and at meals, and talking to MySQL-related businesses in the expo hall. Year after year, this conference has been what makes things happen: technical innovations, product launches, business initiatives, career changes, you name it — …

It’s not too soon to be thinking about what sessions you’ll be attending while at Percona Live: MySQL Conference & Expo 2013. SkySQL’s team of MySQL and MariaDB database experts will be headed to Santa Clara in full force as sponsors and speakers of this annual meeting for MySQL database users. As you plan out your week, be sure to check out some of SkySQL’s talks, including:

• Ivan Zoratti speaks about "Big Data & MySQL"
• Ralf Gebhardt speaks about "Creating MySQL Test-Environments using the SkySQL Cloud Data Suite"
• …

Virtual Developer Day: MySQL is a one-stop shop for you to learn all the essential MySQL skills. With a combination of presentations and hands-on lab experience,  you’ll have the opportunity to practice in your own environment and sharpen your skills to:

    •   Develop your new applications cost-effectively using MySQL     •   Improve performance of your existing MySQL databases     •   Manage your MySQL environment more efficiently
We offer two tracks of content - one targeting the beginners and the other for the advanced users, and both include presentations and hands-on lab experience.
Don’t miss this exclusive opportunity to learn tips and tricks from the MySQL experts at Oracle who will be moderating the event during the dates and times listed below:
Americas and Canada - March 12th, 2013 9:00 a.m – 1:00 p.m PST  /  12:00 p.m. – 4:00 p,m …

Hi,

64 bit SQLyog is here. It’s no secret that you can make the most out of your PC only when you have the right combination of software, operating system and hardware. You can now take full advantage of your 64 bit environment for your MySQL needs. We are proud to offer the first 64 bit GUI client for Windows.

Additionally, if you are using 64 bit Microsoft Office 2013, SQLyog 11 will work out of the box with the 64 bit drivers shipped with it. Importing from Access, Excel or Text/CSV has never been easier.

Please refer the following posts for detailed release notes:

• SQLyog 11.0 Beta 2 Released
• …

When MySQL gets a query, it is the job of the optimizer to find the cheapest way to execute that query. Decisions include access method (range access, table scan, index lookup etc), join order, sorting strategy etc. If we simplify a bit, the optimizer first identifies the different ways to access each table and calculate their cost. After that, the join order is decided.

However, some access methods can only be considered after the join order has been decided and therefore gets special treatment in the MySQL optimizer. For join conditions, e.g. "WHERE table1.col1 = table2.col2",  index lookup can only be used in table2 if table1 is earlier in the join sequence. Another class of access methods is only meaningful for tables that are first in the join order. An example is queries with ORDER BY ... LIMIT. Prior to MySQL 5.6.10 there was a bug in MySQL that made the optimizer choose inefficient execution plans for this query type. …

I’m really looking forward to this year’s Percona Live MySQL Conference. This is always THE event of the year for me in the MySQL conference circuit. It’s also the first year I haven’t been a speaker! I’ve been a speaker since 2007 but this year things were too uncertain for me to submit a proposal in time. As usual, the real highlight of the conference is seeing and talking to everyone.

MySQL uses the concept of SQL_MODE to "define what SQL syntax MySQL should support and what kind of data validation checks it should perform". This post is about one of those modes, ONLY_FULL_GROUP_BY, and why I use it.

Roland Bouman wrote a great post a few years ago that debunks some myths about using GROUP BY in MySQL. His post has a lot of detail and examples, and does a very good job detailing the way GROUP BY works in MySQL with and without ONLY_FULL_GROUP_BY enabled. I recommend that you go and read that post now. Among other things, Roland points out one case where query performance is improved by …