Welcome to the 89th edition of Log Buffer, the weekly review of database blogs.

Welcome, welcome everyone.

In writing this week’s Log Buffer, I’ve had a chance to sit down and read some excellent posts on all sorts of platforms. The depth and breadth of what’s available to house and retrieve data is astonishing.

Many of you who have read my posts will know that I’m a fan of vegetables. They are something most of us don’t eat enough of. Come on DBAs! I think we need to make a collective effort to get healthy. We need you to keep all these systems alive. I say this because I have a new found appreciation for the work we do day in and day out.

Six months ago my wife and I said hello to our baby girl for …

Ah, the perils of working in a shared, client environment. One client has us using a login that is not exclusive to us. I prefer using bash; the client is set to use zsh. This is not a problem in and of itself.

However, there is a section in the .profile that is causing me issues:

if [ -f /usr/bin/ksh ]; then
        /usr/bin/ksh -o vi
        exit
fi

So, “If ksh exists, run it with some options to edit history with vi-like commands”. Except what we really want is “If you’re using the ksh as a shell, . . . .”

So I added a modification, and now all is fine.

if [ -f /usr/bin/ksh ]; then
        if [ "$SHELL" = "/usr/bin/ksh" ]; then
                /usr/bin/ksh -o vi
                exit
        fi
fi

(not all my problems are MySQL related!)

Myself and Larry had the great pleasure in opening a new market the other week. The Philippines marked our fifth new market that we opened together, we anticipate more markets in the upcoming quarter in 2008. Our new Philippine partner, Touch Solutions, Inc., the authorized Philippine distributor for MySQL and authorized Philippine MySQL education center has joined the MySQL family in the Philippines.

Overall I would say that the full day event was a great success, standing room only. It was a great chance to meet not only the variety of community users but also enterprise customers. Anson Uy (32), the young and savvy business man is the …

MySQL Users Conference is coming and with it my presentation about Innodb Scalability limits. We did bunch of tests but we surely could get benefit of some extra hardware for testing, so if you could provide us with dedicated remote access for benchmarks it would be great.

Here is what we're looking for in particular:

- More than Dual Core Opteron systems. Would be good to see how they scale
- More than 8 core systems
- Non x86 based systems (Niagara etc)
- Fancy IO subsystem - more than 8 hard drives
- SSD based storage.

If you have something of this sort available let me know.

Entry posted by peter | 8 comments

Add to: …

the march of progress continues, with the release of mysql connector/odbc 3.51.24. we are down to 33 bugs, most of which will not get fixed further 3.51 releases, but will be fixed in 5.1 or later. i think the two remaining issues we might fix in 3.51 are the crashes of the setup library on mac os x (which may just require a 10.5 build) and bug #12805.

Today I spent the larger part of the afternoon at the Sun office in Amersfoort. And, Yes, I signed ;-) and joined the now largest open source company in the world.

I was lucky enough to attend the JasperSoft Seminar held at their headquarters in San Francisco yesterday (March 19, 2008). There were basically 3 sessions and I personally did not get much from the seminar.

What I found interesting was that I was able to talk to Guilio Toffoli who created the iReport which is basically the GUI software to create JasperReport xml files. We talked about performance limits of the software, problems that I had with designing the queries using SQLeonardo, and other stuff.

Apologies to those on the MySQL Certification Mailing list but I am posting here what went out today to that list. But I wanted to make sure the information was available to all who may be interested. You may consider adding yourself to the list and a link is provided at the end of this entry to help. It is a very LOW bandwidth and heavily moderated list.

MySQL Certification News -- March 2008

2007 was a great year: MySQL Certifications had a great year last year. Over 45% more exams were delivered than in 2006 and certifications earned were up by almost a third! The new Associate Certification is proving to be very popular. Thank you on behalf of The Certification Team and MySQL.

Users Conference: Once again you can take a MySQL Certification Exam at the Users Conference for $25. We will have six exam sessions over the three days of the conference. This is in addition to the tutorials, sessions, and great …

As I mentioned a couple of entries ago, last weekend I was in Boston to attend the Free Software Foundation's annual members  meeting. 

It kicked off early Saturday morning amidst a flurry of wet snow.

It was 95 degrees in Austin on this day. 

The event was a day long affair held on the MIT campus and featured a dinner that evening at the Middle East.

 
The crowd mills about waiting for the event to start.  There was a very impressive buffet of fruit, juice, danishes etc to get things started right  -- Can't talk Free Software on an empty stomach.

Matt and Josh campaign to eliminate both DRM and yellow …

In Spotting the Wolf in Sheep’s Clothing, Frank Mash writes about a specific person who is spreading fear, uncertainty and doubt about MySQL.

Now, this always gets me, especially with MySQL. For how long will MySQL be the bastard stepchild of the database world? Because really, it’s been a full-fledged DBMS for at least 5 years. 10 years ago there were no transactions, but….that was 10 years ago! 10 years ago everyone made $100,000 per year, took 3 hour lunch breaks, played foosball in the office, coveting their IT stock and sat in massage chairs with Apple Cinema displays.

How much have *you* changed in 10 years? Your digital world? 10 years ago we paid for text messages by the character, which is why we came up with rlly abbr …