The latest from the MySQL community

People across North-America are scrambling to update their servers, in order to deal with the upcoming timezone changes.

I'll tell you a little secret that has served me well... ever since the C libraries were a pest in the mid eighties (the ones on DOS defaulted to GMT-5, US EST, or something in that realm), and since with layers of libraries you easily risk missing a timezone conversion, or get double/triple conversions, I decided to never use timezones on servers again.

In the old DOS days, the library issues were resolved by making an app do setenv("TZ=GMT0"); tzset(); on startup. No more conversion problems, regardless of the system time.

But in essense I do the same on Internet servers that I manage. They all simply run in GMT and therefore never need to change timezones - and they're immune to dst funnies invented by George W Bush, too ;-)

On display, an application simply converts …

Sourcefire prices IPO…OpenLogic adds support for Solaris…Krugle offers Eclipse code search plugin…and more…

Sourcefire, Inc. Prices Initial Public Offering of Common Stock, Sourcefire (Press Release)

OpenLogic Adds Open Source Packages on Sun Solaris To Certified Library, OpenLogic (Press Release)

New Eclipse Plug-in From Krugle Offers Code Search For Enterprise Developers, Krugle (Press Release)

Oregon State University Joins Eclipse Foundation, Announces Global Open Source Health Project, Oregon State University (Press Release)

…

I spotted Edin's blog post about PHP 4.4.6 now being linked against MySQL 5.0.36 on Windows and decided to see what is new in that release in comparison to the 5.0.33 I am currently running.

A quick visit to the MySQL's downloads page revealed a distinct absence of said release however. There are however release notes about MySQL 5.0.37, which lists some compelling fixes. Unfortunately, this release is nowhere to be found as well, even though the release notes claim it was released on 27 February 2007.

A simple question comes to mind, WTF?

I'm continuing to add new tools to the MySQL Toolkit. MySQL Deadlock Logger is for extracting and storing information about the latest recorded InnoDB deadlock. It's not only easy to view the information from the command line, it's dead simple to store it back into a MySQL table for analysis. I think most users will find it handy to create a cron job to record the deadlocks automatically for later analysis.

A week or so ago, I posted a journal entry about MySQL replication titled "Changing hats". The fruit of the effort in setting up this replication system can be seen at http://www.grazr.com. This is a really cool system we built at Grazr provides users free upload and hosting of their own Feeds (RDF, RSS, OPML, ATOM), displaying those feeds into the nifty Grazr widget. I was never a feed junky, but am becoming one! The idea (as I see it), in this information-overflow world, is to organise or distill your information sources. At least one part of my life could certainly use that. Still much more to learn, and Grazr.com also includes a great tutorial about feeds, OPML, and how to use Grazr.

This was a great experience, and I learned more in depth about so many things that I thought I knew …

TDWI Conference, Las Vegas - Infobright, supplier of a market leading software-only data warehousing appliance, today announced that True North Corporation has selected the Infobright BrightHouse data warehouse platform.

And so last night Arsenal's Champions League season ended in a brilliant match which ended the completely wrong way. Arsenal's problem is clear: it's incredibly slick passing and footwork results in too few goals. (Stay with me here - this really is an open source post.)

But that doesn't really tell the story. The real story behind Arsenal's problems sounds eerily similar to Clay Christensen's Innovator's Dilemma. And, hence, Arsenal's problem is much like the software industry's problem.

Arsenal has dominated (off and on) English football for nearly 100 years. In 2004-05, the team went 49 games without being beaten. At the heart of its recent success is Thierry Henry, the world's best forward. In years past, Henry put in more goals than anyone else in the league, in striking and beautiful fashion.

This year? Not even a …

Been hacking on the MySQL Forge over the last week or so... The biggest change is that, thanks to many folks, notably Peter Gultzan and Lenz Grimmer, our internal Worklog system is now publicly available — and commentable — on MySQL Forge.

What's the Big Deal With That, Jay?

Well, lots of folks want to see the "roadmap" which the MySQL development team follows. Worklog, and specifically the Worklog (WL) tasks, are about the closest thing to a fluid, documented internal development roadmap that you can get.

Right now, there are 854 public tasks available for searching and commenting on the Forge, and more will be popping up every day, as development teams within MySQL open up their tasks for public commenting.

Got An Idea? Tell a Dev!

If you've got ideas, or …

By Tim O'Reilly

As some of you have probably already noted, I recently joined the MySQL board. There are a couple of good reasons.

First, MySQL has a unique position at the juncture of two of my abiding interests, open source and Web 2.0. As I wrote in the quote that I provided for the press release: "The platforms powering the Web today are the enterprise infrastructure of tomorrow. What we learn from those platforms is the enormous power of open source, open standards, and user involvement ... and one more thing -- that the future belongs to data. Every killer app on the Internet is a database application. And that makes MySQL the 'Intel Inside' of the next-generation of computer applications."

It's not every open source project that gets to be part of the acronym …

Are you seeing a MySQL error that says InnoDB support isn't enabled, even though it is? This article explains why it happens and how to fix it.