The latest from the MySQL community

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() …

My parents had found a box of old stuff which they delivered to me and I went through yesterday. For instance, did you know that I appeared on a photo of Kellogs Frosties (with Tony the Tiger) in 1995! We have several of those boxes still saved, empty of course. No, I'm not a celebrity. I was in the audience of a hockey game in Lillehammer Olympics which they used on their boxes in 1995. All the more memorable then, since 1995 is still the one and only year that Finland won the World Championships!

read more

[HoneyMonitor is a GUI for MySQL™. Server Administration, Database and Database Objects Administration, Code Development, Server Monitoring, Performance Monitoring, Performance Auditing. Read more on http://www.honeysoftware.com/]

This is a short tutorial on the features implemented in HoneyMonitor for the use and administration of Table Logs in MySQL™ 5.1 . It could be useful for Users who are new to the product and want to get start with it or to whom want to learn the basis of Table Logging in MySQL™ 5.1.

Contents

1. Introduction
2. Brief Introduction to the Server Logs Management Window
3. The General Log Table
4. General Log Administration
5. General Log Data: Selecting, Sorting, Filtering Log Data
6. Quick Tour of the other features of the Server Logs Management Window
7. Other Resources …

While working for a client, I had need to produce canned results of certain different criteria, recording the result in a table for later usage, and keep the position within each result.