The latest from the MySQL community

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 …

These were my notes from the “Where is MariaDB today?” session at the Lisbon MariaDB Developers Meeting that happened in March 2011. I just realised I hadn’t posted it; also note that it is really raw.

Where is MariaDB today?

5.3 – look at the KB article titled “MariaDB 5.3 TODO“. A lot of things are in the review state at the moment.

Sergei has all the phone home code for the server working; what is missing is a host to collect the data, and also have a website to display things (Holyfoot will work on this).

Mark Callaghan says there are at least two different implementations of group commit work now, and Percona might have a third. This is in relation to Kristian Nielsen’s work. World’s largest workload on group commit is probably at Facebook — Mark’s implementation is in the Facebook patch. Mark wants to make sure that …

As is tradition after the O’Reilly MySQL Conference & Expo, there tends to be a storage engine summit right afterwards. This year it was expanded to also include plugins. I must graciously thank Facebook for hosting us at their campus, and giving us a rather healthy lunch, plus fueling us with all those drinks, caffeine and snacks that we needed to keep us going. While standing in the doorway, Mark (Callaghan) pointed to us that a certain other Mark (Zuckerberg) was walking into the campus, just like the rest of us.

The very raw notes are up on the Knowledgebase - Plugins & Storage Engines Summit for MySQL/MariaDB/Drizzle 2011. We definitely did not discuss anything Drizzle related, and we barely had time to focus on plugins, so the …

Jonathan Levin has an excellent blog post titled How to make MySQL cool again. It is almost word for word something I've wanted to write for a long time. Now I don't need to, thanks Jonathan.

Once again Blogger failed to post my comments to his site, so I will make some comments as a new post of my own instead. Jonathan actually lists things that exist already but isn't getting used enough. My list contains also a few things that I don't know if they exist or not.

Hi Jonathan

read more

Some of you already know since you helped us move, we recently shifted Open Query’s main office to Fifth Avenue, next door to Elizabeth’s. The new place is comfortable, I really like it so far. Anna is also happy with her new admin space and cat Figaro has found an empty spot on a bookshelf to stretch out on!

The lease costs are a bit steep, as is common these days… chances are we’ll just buy our next place.

Follow-Up yes this was an April 1st post. But, everything in the above post is the truth, it’s just phrased to be very open for a bit of mis-interpretation

I find that the real world provides plenty of fun and unbelievable yet true tidbits, so why bother making up nonsense!