In this episode we talk about string data types, comparing them to the ISO:2003 SQL standard.

Gerry has joined Tokutek - Congrats Gerry! We interviewed Martin from Tokutek in episode 86.

Conferences:
MySQL Innovation Day Schedule Tuesday June 5th, Redwood Shores, CA. Register here (free). Content will be available via live stream, so save the date!

read more

The explain statement can be an important tool for understanding how a query is being executed and what you can do to make it run better.  Although the output of EXPLAIN is relatively straightforward it can be confusing to inexperienced users or can be mangled by terminal wrapping.

To help with these problems as well as provide a pastebin for MariaDB developers to share explains during development we created The MariaDB/MySQL Explain Analyzer. This tool:

1. Helps unmangle explains (both vertical and tabular format)
2. Displays explains in an easy-to-read format.
3. Highlights and provides explanations for some terms.
4. Links to KB articles for different optimization techniques.
5. (Optionally) Allows you to save the explain for sharing.

This …

This week we present how to use pt-archiver and pt-find, two Percona Toolkit tools. We focus on the common usage of the tools and the gotchas we ran into using them.

News/Events/Feedback
Conferences:
MySQL Innovation Day Schedule Tuesday June 5th, Redwood Shores, CA. Register here (free). Content will be available via live stream, so save the date!

…

It feels like every minute a PHP developer somewhere on this planet starts implementing something aching to a CMS from scratch. Some do it because their project is "so big" it that it "obviously needs" a custom solution. Some do it because their project is "so small" it "obviously needs" just a few days of hacking .. to build a custom solution. Let me briefly focus on the later group. Working in a company with less than 10 people building websites for customers a project needs a bit of a CMS to manage those 10 "semi static" pages seems to be the poster child example of this group. The devs whip up a DB table, slap an ORM in front, maybe even use some generator for the admin UI. Done. Later the clients also wants versioning and luckily many ORMs provide some solution for that. Easy. Permissions? Most frameworks provide some ACL system. Child pages? ORM has some tree algorithm supported. Fulltext search? Integrate ElasticSearch. Custom page types? Uhm …

This week we talk about MariaDB - explaining features, and comparing to Percona's patched MySQL and Oracle's MySQL. MariaDB is touted as "a better MySQL, not a different MySQL". MariaDB is the 2nd most popular open source database, even more popular than Postgres.

Conferences:
MySQL Innovation Day Schedule Tuesday June 5th, Redwood Shores, CA. Register here (free). Content will be available via live stream, so save the date!

read more

On Friday last week, after the intensive days of the conference, Ars Technica wrote and published a nice article about MariaDB including many of the messages we had been delivering during the conference, http://arstechnica.com/business/news/2012/04/mysql-founders-latest-mariadb-release-takes-enterprise-features-open-source.ars.

MariaDB seals

Last year, when it became clear that O’Reilly wasn’t going to arrange the MySQL user conference in the future, there was a lot of discussion on who should arrange it. In the end Percona was pretty fast informing everyone that they had booked the convention center in Santa Clara to arrange the conference this year. Now with the …

We are pleased to announce the immediate availability of MariaDB 5.5.23. This stable (GA) release incorporates MariaDB 5.3.6 and MySQL 5.5.23, some performance improvements, and bug fixes.

• MariaDB 5.5.23 Release Notes
• MariaDB 5.5.23 Changelog
• MariaDB 5.5.23 Downloads

Please see the What is MariaDB 5.5 page for an overview of MariaDB 5.5.

Sources, binaries, and package downloads are available from our …

We are pleased to announce the immediate availability of MariaDB 5.3.6. This stable (GA) release incorporates MySQL 5.1.62, some performance improvements, and several bug fixes.

Most importantly, MariaDB 5.3.6 includes a fix for a bug which, under certain rare circumstances, allowed a user to connect with an invalid password. This is a serious security issue. We recommend upgrading from older versions as soon as possible.

• MariaDB 5.3.6 Release Notes
• MariaDB 5.3.6 Changelog
• MariaDB 5.3.6 …

We are pleased to announce the immediate availability of MariaDB 5.1.62 and MariaDB 5.2.12. Both of these stable (GA) releases incorporate MySQL 5.1.62 and several bug fixes.

Most importantly, MariaDB 5.1.62 and 5.2.12 include a fix for a bug that under certain rare circumstances allowed a user to connect with an invalid password. This is a serious security issue. We recommend upgrading from older versions as soon as possible.

Please see the What is MariaDB 5.1 page for an overview of MariaDB 5.1, and the What is MariaDB …

Update: MariaDB 5.1.62 and 5.2.12 have been released. They contain an important security fix.

We are pleased to announce the immediate availability of MariaDB 5.1.61 and MariaDB 5.2.11. Both of these stable (GA) releases incorporate MySQL 5.1.61 and several bug fixes.

Please see the What is MariaDB 5.1 page for an overview of MariaDB 5.1, and the What is MariaDB 5.2 page for an overview of MariaDB 5.2.

Sources, binaries, …