In December I covered the topic The state of MySQL forks: co-operating without co-operating (which was also a response to Giuseppe Maxia's take on the same topic). Since half a year has now passed, I was wondering if I should follow up with an update. (Drizzle having a GA release would be the major news in such an update.)

But I see that Peter Zaitsev covered this topic in the opening keynote of their Percona Live conference. Since I agree with Peter's view on this topic, I just recommend you watch the talk on Percona.TV. He also uses the same categorizations of the forks, and includes "community patches" as its separate …

If you run Debian or Ubuntu, and want a way to auto-generate a sources.list entry, then you should definitely look at: Setting up Repositories for Ubuntu/Debian. Its very simple: choose a distribution, then a release, then choose what version of MariaDB you would like to track and a mirror of your choice, and voila! it generates the sources.list for you.

Virtual and persistent columns are a feature of MariaDB 5.2+, and HeidiSQL's table editor now fully supports them. Just update your HeidiSQL to the latest build to see this in action.



Also, if you are on a MariaDB server, a brown seal icon in the tree and in the status bar now indicates the right server vendor:

I have a bunch of notes from the O’Reilly MySQL Conference & Expo 2011, and I figure its about time I started blogging it. These are notes from the panel on the SkySQL Reference Architecture, led by Kaj Arno and Ivan Zoratti. The notes are raw (read their FAQ for more), and I talk a little bit about the SkySQL Configurator at the end (a tool I immediately used, and submitted some bugs/improvements for – 7 at last count, which I hear got fixed in the 0.02 release, which got pushed last night!).

There were 7 panelists. The MySQL world needs:

• technical support
• monitoring & administration tools
• simplified …

A lot is happening in the world of MySQL lately. If you’re in Asia, SkySQL has been organising roadshows. On May 18, there was a captive audience in Singapore, listening to David Axmark (advisor to SkySQL, co-founder of MySQL Ab), Daniel Saito (SkySQL), and Colin Charles (Monty Program). On May 20, there was a huge audience in Manila, and I was totally bummed to have missed out on it.

I’m told there’s going to be an awesome audience tomorrow, May 27, in Seoul, South Korea. Lotte Hotel will be abuzz with all things SkySQL, Monty Program, and MariaDB, and it will feature Kaj Arno and Daniel Saito from SkySQL, and Colin Charles from Monty Program.

May 30 brings upon the SkySQL Roadshow in Tokyo, hosted at the Yurakucho International Forum.

If you plan to attend any of these events (Daniel tells me they’re also reaching capacity) and are in the area, don’t …

In the #maria IRC channel the other day I fielded a question someone had about a DATETIME column where they wanted to SELECT by the year. The answer (which is probably obvious to many of you) is to use the YEAR() function like so:

select * from t1 where YEAR(d) = 2011;

(The above assumes the table is named “t1” and the DATETIME column is named “d“.)

In my reply I provided a link to the Date and Time Functions section of the AskMonty Knowledgebase, but when I looked at the entry for the …

Are you rebooting your MySQL server at night?

I'de like to share input send to me by a leading MySQL provider, mostly deploying ecommerce and telco applications on Linux.

One instance is up since 1414 days not bad ....

 
18:13:02 up 355 days,  4:50,  0 users,  load average: 0.00, 0.00, 0.00
18:13:03 up 594 days,  5:04,  0 users,  load average: 1.20, 1.25, 1.26
18:13:03 up 48 days, 22:10,  0 users,  load average: 0.48, 0.38, 0.29
18:13:03 up 936 days,  7:50,  0 users,  load average: 0.00, 0.00, 0.00
18:13:03 up 173 days,  2:39,  0 users,  load average: 1.90, 1.79, 1.79
18:13:04 up 244 days,  3:25,  0 users,  load average: 3.96, 3.66, 3.90
18:13:04 up 643 days, 15:50,  0 users,  load average: 0.09, 0.08, 0.07
18:13:04 up 642 days,  5:15,  0 …

In March I posted a series of blog posts on my paternity leave MepSQL project, which I called MepSQL. There was still one piece created in the MepSQL buildsystem that I didn't publish or blog about. Since it is generally useful, I wanted to generalize and polish it and publish it separately. I finally had that done last week, when I also found that somebody else, namely alestic.com already published a similar solution 2 years ago. So yesterday I ported my BuildBot setup to use that system instead and am happy to publish it at the Open DB Camp 2011 in Sardinia.

Ok, so let's go back a little... What is the problem we are solving?

Let's …

Friendly and without drama

That's a good way to summarize the MySQL conference 2011. Nobody acquired nobody. There were no volcanoes keeping men away from their wives, dads away from soon to be born babies. I had packed extra underwear just in case, but it wasn't needed.

read more

Over the past few weeks I’ve been working on porting the per table and per session row stats from the tivo patch into mariadb. This is the show table_statistics functionality. I’ve been pushing the code to a branch on lanchpad as I get features working. Up to revision 2953 the row stats are working but the index stats aren’t. I think I have a reasonable implementation of the row stats code given my level of C++ skill. I’m changing the syntax a bit from how it worked in the tivo patch to make it be more compatible with how the original row stats code worked that was ported into mariadb.

In MariaDB 5.2 there are show table_statistics show index_statistics, and show user_statistics functions that return global stats collected by the server when …