As the start of a bit of a delve into the various MySQL branches and patch sets that have been around, let’s start looking at the history of MySQL itself. This is how big MySQL has been over all of the major releases since the beginning (where beginning=3.23). (edit: These numbers were all gathered using sloccount and only counting C++ and C source files.)

Alongside SkySQL, we participate in SkySQL & MariaDB Meetups. These events are free to attend and you’ll get to meet & speak with SkySQL CEO Patrik Sallner and all round MariaDB man (& MySQL creator) Michael “Monty” Widenius. 

1. Roadshow in Amsterdam, the Netherlands – 21 March 2013
2. Roadshow in Paris, France – 27 March 2013

If you’re at the Percona Live MySQL Conference & Expo Santa Clara (many of us from Team MariaDB are speaking), you should consider spending the extra day there as on Friday April 26 2013, there exists the …

“MySQL 5.6: Advantages in a Nutshell.” March 6 at 10 a.m. PST with host Peter Zaitsev.

This Wednesday (March 6 at 10 a.m. PST) I’ll be presenting a webinar titled “MySQL 5.6: Advantages in a Nutshell.” In this presentation, I will provide a brief overview of the advantages MySQL 5.6 offers. My focus is a practical one – to identify the conditions in which one or another feature can be successfully used providing significant gain, explicitly or transparently. There has been a lot of pretty cool stuff done in MySQL 5.6 and my goal is to get you excited to learn more and try it out.

Reserve your spot now and join me on Wednesday by …

I was discussing how to avoid surprising users and someone pointed out that what seems intuitive and rational to one person is often complete insanity for others. The mental gap between a developer and a user can often be a chasm far too wide to cross. Of all the bug reports I’ve filed against MySQL, here is my all-time favorite:

select * from t where a >= 1.0order by a;

Does not cause an error. I believe it should, because there should be a whitespace before ORDER BY.

Similar syntax errors such as “select 1e0from dual” were also accepted as valid SQL. Much soul-searching later, the official reply from MySQL’s development team:

The server behaves properly here:
- “1″ alone can not be an identifier, because it’s followed by a “.”
- therefore, the lexer parses “1″ as the beginning of a …

The MariaDB Java Client 1.1.1 has been released. You can download it here.

See the Release Notes and Changelog for detailed information on this release and the About the MariaDB Java Client page in the AskMonty Knowledgebase for general information about the client.

New functionality in this release

• Implement tcpAbortiveClose option, for “hard” socket close (CONJ-27)
  • This option can be used in environments where connections are created …

In this post I provide some tips and advice on how to become a published auther for Oracle, MS SQL Server, and MySQL

With each release, the MySQL database brings you even better performance. To get the most from your MySQL servers, performance tuning is important. And what better route than to take the MySQL for Performance Tuning training course.

In this four-day instructor-led class you will learn to:

• Understand the basics of Performance Tuning
• Use the tools of performance tuning
• Tune the MySQL server instance to improve performance
• Improve performance of tables
• Implement proper Schema Design to improve performance
• Improve the performance of MySQL queries

This course is available as:

• Training-on-Demand: Start training within 24 hrs of registering and follow the course at your own pace and from your own desk.
…

InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

This is part 2 in a 3 part series. In part 1, we took a quick look at some initial configuration of InnoDB full-text search and discovered a little bit of quirky behavior; here, we are going to run some queries and compare the result sets. Our hope is that the one of two things will happen; either the results returned from a MyISAM FTS query will be exactly identical to the same query when performed against InnoDB data, OR that the results returned by InnoDB FTS will somehow be “better” (as much as it’s actually possible to do this in a single blog post) than what MyISAM gives us.

Recall that we have two different sets of …

Investigating MySQL Replication Latency in Percona XtraDB Cluster

I was curious to check how Percona XtraDB Cluster behaves when it comes to MySQL replication latency — or better yet, call it data propagation latency. It was interesting to see whenever I can get stale data reads from other cluster nodes after write performed to some specific node. To test it I wrote quite a simple script (you can find it in the end of the post) which connects to one node in the cluster, performs an update and then immediately does the read from second node. If the data has been already propagated — good, if not we’ll continue to retry reads until it finally propagates, and then measure the latency. This is used to see whenever application …

This week we interview Shlomi Noach about the upcoming Percona Live: MySQL Conference and Expo in Santa Clara April 22-25th, 2013. There are 2 organizations with new trainings, too! Ear Candy is a resource with data models, and At the Movies is how to setup and operate Tungsten replication.

Events
Upcoming MySQL tech tours

LinuxFest Northwest will take place in Bellingham, Washington on Sat Apr 27th and Sun Apr 28th.

read more