Oracle's MySQL team is running/participating to a number of events during the upcoming weeks and months. Don't miss this chance to learn about the latest developments straight from the source and to get all your questions answered!

Additional events will likely be scheduled down the road and posted on our events page, but you can already register for the following ones:

MySQL Tech Tour: Big Data and High Availability with MySQL– Pleasanton, California

January 22

MySQL Tech Tour: Big Data and High Availability with MySQL– Belmont, California

January …

This article discusses about the approach taken by InnoDB Storage Engine of MySQL to provide the repeatable read isolation level.  First, an example is presented to demonstrate the two different designs that are possible.  Then the design used in InnoDB is presented followed by a short discussion about the advantages and disadvantages of this design choice.  As part of this discussion, we also present a performance optimization done in MySQL 5.6. 
An Example Scenario

I used MySQL 5.5 for this purpose.  Let us create the following tables t1 and t2 in the test database that is available by default. Even though the default storage engine in MySQL 5.5 is InnoDB, I explicitly specify it for clarity.  

mysql> use test;
mysql> create table t1 (f1 int) engine=innodb;
mysql> create …

In On learning InnoDB: A journey to the core, I introduced the innodb_diagrams project to document the InnoDB internals, which provides the diagrams used in this post. Later on in A quick introduction to innodb_ruby I walked through installation and a few quick demos of the innodb_space command-line tool.

The physical structure of InnoDB’s INDEX pages was described in The physical structure of InnoDB index pages, and the logical structure was described in B+Tree …

I've created a graph about the MySQL version history.

It's mysql-graph-history on github.


Please let me know if this is correct or if I'm forgetting some versions.

Update: Recording!

Finally, the end of year madness is over and we're in a fresh new year. That must mean it's time to get back into #DBHangops! Tune in on Wednesday, 1/16/13 at 5:00pm PST to get in on the fun and share your experiences.

Check back on this blog post tomorrow or check this twitter search to grab the link to join the Google Hangout.

Topics for this weeks hangout include: * triggers: maintenance, problems, etc. * Oracle MySQL utilities (similar to Percona toolkit) ** Slideshow of MySQL utilities * Database caching and cache expiration * InnoDB log file size ** …

The authentic MySQL for Developers course will introduce you to tools used by MySQL development professionals and you get the opportunity to work through examples specific to Java and PHP development cases.

In this course you will learn to:

• Use MySQL tools to connect to databases.
• Examine database structure and contents.
• Generate database structure diagrams.
• Execute complex queries.
• Manipulate numeric, text, spatial and temporal data.
• Execute complex subqueries and joins.

You can take this 5 day live-instructor course via these two delivery methods:

• Live-Virtual Class: Take this class from your own desk by choosing from the many events already on the schedule.
• In-Class: Travel to a training center to take …

In May of last year I blogged about MariaDB 10.0 for the first time. We received some feedback, digested it, and I further explained MariaDB 10.0. Now, with the first Alpha of MariaDB 10.0 out and a new year just beginning, now is a good time to explain a little bit more, especially about MariaDB 10.0 and MySQL 5.6 as I and others in the MariaDB project get asked a lot about the differences between them.

First, here are some details as to why we didn’t just take MySQL 5.6 as a base and create something that would have been called MariaDB 5.6. These details haven’t been widely shared before:

1. The file structure of the codebase in MySQL 5.6 has changed. Single code files have been split into several and code has been …

Our customised training courses for the MySQL & MariaDB databases help your team learn exactly what they need to know

Since SkySQL’s inception, training has been an integral part of the services we provide. Training isn’t just something we offer, but an intrinsic aspect of our business model as we evolve into an all-inclusive service and product provider. And customized onsite training is the best way your team learns what your specific team needs to know.

read more

Percona Live MySQL Conference and Expo 2013 – the largest MySQL Conference event of the year is getting close and we’re now announcing two community activities which are going to happen at this event.

Call of DotOrg Pavilion exhibitors is open – DotOrg pavilion is a free expo hall space for non commercial projects relevant for MySQL community. If you’re working on the project which you would like to get in front of a larger community but can’t afford expo hall exhibitor price tag because of non commercial nature of the project it is a great opportunity to do so. In the previous years participants included projects like …

In a few hours I’m leaving for my “SouthEast Meetup Tour” first going to Charlotte where I’m speaking Today, Jan 14, about MySQL Indexing: Best practices on local MySQL Meetup and then going to Atlanta to give the same talk on Atlanta MySQL Meetup Jan 15th. If you’re in the area please come by, I’ll have some Books and T-shirts to give away!

The post Reminder: Speaking at MySQL Meetups in Charlotte and Atlanta today and tomorrow. appeared first on MySQL Performance Blog.