It’s been over two years since I left MySQL to work for Message Systems and I’ve really been happy with things here. I work with a great team on interesting work for a good company who treats us well. Not much more you could ask for.

Except for more coworkers. We’re in need of a few new additions to the 2009 team:

We need engineers and tech trainers, scroll down for the details. If you’re interested send an email to mike@thisdomain!

Technical Trainer / Curriculum Developer

This position designs, develops and delivers online and in-person instructor led trainings on the Message Systems products and services for a variety of audiences including customers, partners and internal staff.
You will design courses and instructional material for everything ranging from short informational quick-
starts to multi-day workshops.
The audience for these training programs will primarily be mid-senior …

Until this week Infobright’s claim to open source fame was its partnership with MySQL that enabled its analytical data warehousing software to act as a storage engine for the open source database.

However, the company is now taking the open source route itself by releasing the code behind its Infobright data warehouse (formerly Brighthouse) as Infobright Community Edition.

Earlier this month the company announced that it was moving to a subscription model for the commercial version of the product, Infobright Enterprise Edition, which comes with “enhanced features, services and support, warranty” amongst other things.

The company has also announced a $10m Series C investment …

If you’re already building LAMP applications (linux/apache/mysql/php), and you’re looking to port them to Oracle, or you’re new to this technology stack, and you want to use Oracle as your database, this article is for you.  We cover the basics of gettings started, and where to look for more information.

Intro to PHP + Oracle - Database Journal - Aug 14, 2008

The Software Freedom Day 2008 is approaching. The event will take place wherever you want. If you are interested, just register a team, gather a few friends, and start organizing that in your street, at a local pub, in your university, or wherever you see fit.

MySQL people are very conscious about open source, and we decided to participate to the event somehow. For starters, Sun is a sponsor, and that is a good sign that we care. But we need also to make our presence known. So the initial plan was that every Sun community would encourage its members to create a local Software Freedom Day team and participate.

However, on September 20, the designated day, 250 Sun/MySQL engineers will be in Riga, Latvia, in the middle of our annual developers meeting.

Not a …

As usual, your cooperation is welcome. Test the new …

Talking with users at OSCON 2008, the biggest fear with new features was table corruption with partitioning. Until recently, this fear was substantiated by bug#20129, which reported inability of repairing corrupted partitions. The initial "fix" for this bug was to disable the offending commands.
After a while, especially when the Support department complained loudly, the bug was reopen and a proper fix implemented. Now you can maintain a partition using ALTER TABLE ... CHECK/ANALYZE/OPTIMIZE/REPAIR PARTITION.
I did some experiment, using MySQL sandbox and the employees test database, which supports partitioning.
You need to download the latest MySQL 5.1 release (5.1.28), where the patch is available.
To load the employees database …

Unless you’ve been on a desert island lately, you probably know that the area of data warehousing/analytics/business intelligence (BI) is going gangbusters these days. Not many years ago, when industry analyst groups polled CIO’s on their top priorities, BI was #10. Then it jumped to #2 in 2006, and today it’s #1 according to Gartner group. It’s no mystery as to why this is: it’s a cut-throat economy out there in all industries and smart businesses need to tap their internal data to make critical business decisions, both tactically and strategically, to stay ahead of the pack.

Infobright Inc., a technology leader in analytic data warehousing, today announced it has secured a (USD) $10 million Series C round of investment by Flybridge Capital Partners, RBC Venture Partners, and Sun Microsystems, Inc. The capital infusion will be used largely to fuel the growth of the new www.infobright.org open source community and the Infobright Community Edition (ICE) open source data warehouse.

The output from SHOW INNODB STATUS isn’t very pretty or easy to use. Seriously, other than Heikki who thinks in 16k block sizes? :-)

A few lines of bash magic fixes this problem.

Now I can quickly see buffer pool stats in the following format:

buffer pool size: 27999076352 bytes (27G)
used: 16563568640 bytes (16G) (59.00%)
modified db pages: 4747952128 bytes (4G) (16.00%)

Here’s what the code looks like:

#!/bin/sh

# Pretty print InnoDB buffer stats.
#
# SHOW INNODB STATUS looks like:
#
# Buffer pool size   1708928
# Free buffers       1142066
# Database pages     565676
# Modified db pages  123467

pp() {

    value=$1

    if [ $value -gt 1000000000 ]; then
        value=$(expr $value / 1000000000)G
    elif [ $value -gt 1000000 ]; then
        value=$(expr $value / 1000000)M
    elif [ $value -gt 1000 ]; then
        value=$(expr $value / 1000)K
    fi

    echo $value

}

perc() …