“2008 is starting with a bang for open source,” wrote Mark Radcliffe last week, and he’s not wrong. Not only did we see Sun’s $1bn acquisition of MySQL, but we’ve also seen an extraordinary amount of venture capital funding. Today saw no fewer than three investments announced, with Greenplum landing $27m Series C, Zenoss closing a $11m Series B round, and Alfresco …

I've written before in the big Why not learn MySQL blog post, that comments in Stored Procedures in MySQL are useless.
The reason is simple - the backup/export/dump procedure does dump them into the file correctly, but when loading the file by piping it into the mysql command line client - the comments get stripped. This was a sort of an "optimization" in the client, which is now configurable.

The 5.1.23 change log says so:

mysql stripped comments from statements sent to the server. Now the --comments or --skip-comments option can be used to control whether to retain or strip comments. The default is --skip-comments. ( …

I commented on Jonathan Schwartz's blog on his "Helping Dolphins Fly" post. I was not surprised to find that the blog is moderated. I mean its well worth the manual time to keep the blog of your head honcho clean. I don't remember what I said exactly, but I did voice some concerns about the fact that I have not really seen participate much in the scripting world. Suffice it to say my post was never published. It seems I never have anything nice to say about big cooperations. So I want to try something new for a change: Saying something nice about big cooperations.

First up is MySQL err .. SUN. Since they got scooped up they qualify as a big cooperation (of course). I have really appreciated the bulk of the work that MySQL AB …

Last time I talked about point queries.  The conclusion was that big databases and point queries don’t mix.  It’s ok to do them from time to time, but it’s not how you’re going to use your database, unless you have a lot of time.  Today, I’d like to talk about range queries, which seem much more useful for the analysis of big databases, say in a business intelligence setting.

Recall that the focus is on the storage engine (a la MySQL) level, and a database on a single disk—the one we are using for illustration is the 1TB Hitachi Deskstar 7K1000.  It has a disk seek time 14ms and transfer rate of around 69MB/s [See tomshardware.com] Now imagine filling the disk with random pairs, each 8 bytes.  So that’s 62.5 billion pairs.

Range Queries

Suppose the above data is stored in a B-tree, and that you’d like to iterate over all the data in order by key.  Further suppose that the …

Diary: January 21st 2008 - Martin Luther King Day (Day doctor’s practices are closed BTW.)

“I have a dream”, poetic . Actually I have thumping 5 day straight headache but that’s another story.

I have a dream for MySQL Camp III. A 48 hour Global Hackfest. I ran this by Jay over Thanksgiving, to get back to more the purpose of the Camp, for hackers, coders and the very experience to get to together to share their skills, and for those at the top of our respective game to learn just a little more. MySQL Camp II was a success to attendees in general, but of little value to the experts.

I hope to get us middle to advanced ground. Here is an overview.

• 48 hour event
…

Sun acquires MySQL. Oracle acquires BEA. OpenAds obtains $15m in funding. (and more)

Sun Microsystems Announces Agreement to Acquire MySQL, Developer of the World’s Most Popular Open Source Database, Sun Microsystems (Press Release)

Oracle to Acquire BEA Systems , Oracle (Press Release)

Openads Closes $15.5 Million Series B Funding Led by Accel Partners, Openads (Press Release)

IBM Accelerates Desktop Customer Choice With Support for Ubuntu, Red Hat and Novell Software, IBM (Press Release) …

Last time I talked about point queries.  The conclusion was that big databases and point queries don’t mix.  It’s ok to do them from time to time, but it’s not how you’re going to use your database, unless you have a lot of time.  Today, I’d like to talk about range queries, which seem much more useful for the analysis of big databases, say in a business intelligence setting.

Recall that the focus is on the storage engine (a la MySQL) level, and a database on a single disk—the one we are using for illustration is the 1TB Hitachi Deskstar 7K1000.  It has a disk seek time 14ms and transfer rate of around 69MB/s [See tomshardware.com] Now imagine filling the disk with random pairs, each 8 bytes.  So that’s 62.5 billion pairs.

Range Queries

Suppose the above data is stored in a B-tree, and that you’d like to iterate over all the data in order by key.  Further suppose that the …

MySQL AB today announced that Flixster and NowPublic -- two of today's hottest Web 2.0 companies -- have selected the MySQL Enterprise database to power their rapidly growing businesses. MySQL continues to expand its presence as the database of choice among the new generation of online companies looking to cost-effectively manage the scalability of their high-growth businesses using proven, high-performance open source software.

I’m starting up a schema to hold stored procedures that automate common DBA tasks. SQL file for import is here: opsmonitor.sql

More SPs will be added in time… whenever I get the time to write them that is.

UPDATE: Jeff Stoner will be heading up this project to contain his scripts, of which the ones currently listed in the first link are written by himself.