"Das dreieckige Rad hat gegenüber dem viereckigen einen gewaltigen Vorteil: Ein Rumms weniger pro Umdrehung!"

Translation:
"The triangular wheel has one enormous advantage over the quadrangular: One knock less per revolution!"

Maybe not new, but I have not heard it yet and I love it. It was about reinventing functionality in a well known product...

"Das dreieckige Rad hat gegenüber dem viereckigen einen gewaltigen Vorteil: Ein Rumms weniger pro Umdrehung!"

Translation:
"The triangular wheel has one enormous advantage over the quadrangular: One knock less per revolution!"

Maybe not new, but I have not heard it yet and I love it. It was about reinventing functionality in a well known product...

Yet another quiz inspired by Freenode#mysql IRC discussions. If you haven’t been around on the channel lately, you should have a peek. Lots of interesting discussions going on!

mysql> SELECT c1, c2 FROM t WHERE c2 LIKE 'a%';
+------+------+
| c1   | c2   |
+------+------+
| a    | abc  |
+------+------+

Is the following construct for the LIKE clause legal?

SELECT c1, c2 FROM t WHERE c2 LIKE CONCAT('a', '%');

And how about this one?

SELECT c1, c2 FROM t WHERE c2 LIKE CONCAT(c1, '%');

Bonus question: Suppose the table has many rows, several more columns and there’s an index on (c2, c1). Could that index be utilized when running the legal versions of the query — and if so, how?

[hint]Hint: Perhaps some parts of the statement are optimized away before evaluation? [/hint]

[answer]Answer:Both the constructs shown are legal. …

UPDATE at bottom.

I just wanted to extend my congratulations to the team at Greenplum, and our joint customers at Fox Interactive Media - the folks behind MySpace, Photobucket, IGN, FOXSports.com, and a whole series of web properties that together represent one of the single largest audiences on the web.

All three of us announced today that Fox is running a massive production data warehouse built atop Greenplum's data warehousing software on Sun's Solaris/ZFS based OpenStorage platforms (a sea of Thumpers, to be specific). That is to say, open source software is at the core of one of the world's largest - and most affordable - data warehouses.

…

Recently I am been testing few pieces of Storage projects of OpenSolaris with PostgreSQL. One of tests involves using an iSCSI disk  with PostgreSQL.  Unfortunately the storage that's available is  in Colorado  while my PostgreSQL server is  located in Massachusetts. Latency will definitely be one of my top problems since storage  is halfway across the country (in Colorado). Plus the fact that I will be running a database server on my end  doesn't really sound like a good idea. Come to think about it, this could be a more common problem nowadays since Cloud Storage (for example Amazon S3 Webservice ) could be  optimistically  half way across the country and pessimistically be on the other side of the world.

 So what are my options to solve such problems?  …

This bug (http://bugs.mysql.com/19027) was reported by Peter Zaitsev over two years ago... it may not be critical, but it's nasty and surely it can be fixed. This is the problem.

If InnoDB incurs a fatal error during initialisation, for instance changing logfile size, or from a typo in another parameter in the config, mysqld still starts but InnoDB will be disabled. According to Heikki, a storage engine cannot make mysqld not start at that stage, so the only option would be to chuck an assertion - frankly, I'd prefer that over the current misbehaviour!

So you can have a running server that kinda looks ok, but not have access to some or all of your tables.
In a word: ridiculous!

I attended OpenSolaris Storage Summit last weekend.  There are lot of efforts going on to make OpenSolaris into a feature rich storage operating system.  Some of the projects that are relevant to backup are NDMP, Storage de-duplication, Virus scanning, Disk encryption and ZFS hybrid storage pools.

I talked about Amanda network backup and recovery and how well it fits with OpenSolaris and ZFS plans. Amanda can backup ZFS filesystems taking advantage of ZFS snapshots. ZFS snapshots provides the ability to backup open files in Open Solaris. Amanda 2.6.1alpha OpenSolaris packages that are available for download takes advantage of this feature.  Amanda can also take advantage of ZFS send/recv …

After an amazing summer of getting married, graduating college, adopting a new dog, and taking a much needed extended vacation, I’m now back on track with where I left off. I’ve been making good progress on the asynchronous MySQL library I talked about in this post in the form of a new drizzle client library. This library is also compatible with MySQL since they share the same protocol, and if drizzle changes in the future I plan on supporting current and new MySQL protocols as well. All of the connection and I/O overhead is mostly done, and I’m just working through the protocol bits now. I’m hoping to have something ready to show and talk about for the OpenSQL camp.

In other news, I’ve recently started working with the …

Notice to readers:
This is an excerpt of my liveblogging of the Keynote where the Exadata Storage Server was announced.

It is a mix of my comments in real time, and my quotes from things Larry Ellison said that I felt were worthy of mention.

You may be interested in reading more about Oracle’s Exadata platform. I would suggest taking a gander at Oracle’s product page and also reading up on Christo Kutrovsky’s Analysis of the Exadata and Oracle Database Machine announcement from a different point of view.

You may also be interested in the complete liveblog transcript of …

I’ll be liveblogging the keynote here along with Marc Fielding, Christo Kutrovsky, Darrin Leboeuf and Luke Davies and Martin Wisniewski.

First observation: I can not believe I can not make this video full screen.

Even Pythian’s flash video player can go full screen.

Introduction time. Safra Katz.

Confirming HP is here as part of the announcement.

So presentation from HP is here first. Weird. Maybe this is a megabucks commercial keynote. Introducting Exec VP Anne Livermore.

“Very very very very very important event for HP. 100000 joint customers.”

Show of hands for HP adoption. A bit lame, she seems disappointed with how many hands are raised. :-)

The video stream is super saturated, the video is super skippy. Hopefully I can understand what’s going on well enough to do this liveblog.

So far it’s completely a vendor advertisement keynote.

…