Need to post more regularly... once I have posting from the plam sorted out.
Actually, just posting more regularly would be a big plus.
(Sounds like a good new year's resolution)

Plugins... Nearing completion. Yay! Quite a reasonably tidy server variables declarations and implementation now. Just one variable which I may eliminate and free (potentially a few kilobytes) as it is no longer strictly necessary.
Right now, only InnoDB has been modified to take advantage of it - easily make MyISAM make use of it for it's few variables.
Need to concider splitting out more subsystems so that more globals can be removed.

Solid Information Technology, best known to the open source community as the providers of a new enterprise storage engine for MySQL, announced this week that it secured four million euros for the expansion of its open source initiatives (press release). The investors participating in this financing were Apax Partners and CapMan.

Although Solid is based in the United States, its investors are both European. I guess this explains why the press release lists the funding amount in euros and not dollars. I wonder if we will see more funding announcements preferring the euro as the currency of record. I left the euro symbol out of this post due to some character set issues.

As 2006 nears its close, Dave and I decided to try to do a "Year in Review" sort of post or two. You can find Dave's here.

This has been an exceptional year for open source (and for me, personally, though Arsenal didn't contribute much to that). I was with Alfresco all year, as well as the advisory boards for SugarCRM, JasperSoft, Specifix, MuleSource (sort of - still waiting for my paperwork, Dave :-), Intoto, and Bungee Labs, as well as the board of OSI and the Open Source Business Conference. These gave me a bird's eye view into different sectors of the industry, so as to separate hype from reality in open source.

Guess what? All signs are positive for open source, no …

Welcome to the 24th edition of Log Buffer, the weekly review of the database blogosphere. To begin, some news about that other open source RDMBS, Firebird. Foremost is an item on Firebird News pointing to the Firebird development roadmap for 2007. On the same site, a link to a summary on Wikibooks of SQL dialect differences [...]

MySQL has today refined its licensing scheme from “GPLv2 or later” to “GPLv2 only“, in order to make it an option, not an obligation for the company to move to GPLv3.

Specifically, this means that copyright notice in the MySQL source code files will change from referring to “either version 2 of the License, or (at your option) any later version” to “version 2” only, in the MySQL 5.0 and MySQL 5.1 code bases.

Six years ago in the summer of 2000, when MySQL AB licensed its software under the GPL, our founders David Axmark and Michael Widenius made this choice because the GPL was a license followed and respected by everyone. We have kept to it, because the GPL is the most palatable license, and poses the least friction for our user base.

MySQL has been part of the GPLv3 Committee …

To get the status of the replication slave, it is possible to check the Last_Error and Last_Errno fields from SHOW SLAVE STATUS. Unfortunately, they only give information about the status of the SQL thread (and not always that either). If the I/O thread fails, for example, because the server configuration is not correctly set up, or if the connection to the master is lost due to a network outage, it is necessary to dig through the error log to find out the reason. This might be possible, although annoying, for a DBA to do since he has access to the files on the machine where the server is running, but when using automatic recovery applications that watch the status of the replication, this is not practical. It is also easier to see the status of the server through a normal client connection, …

Everyone has heard of being slashdotted or maybe dugg. But have you ever been Yahoo!ed?

Phones started beeping, mayhem ensued. The first thing we looked at was the database. Is some MyISAM table locked? Is there a hung log processor running? The database was busy, but it looked odd. The web servers were going nuts.

As we soon discoverd, we (dealnews.com) were mentioned in an article on Yahoo!. At 5Pm Eastern, that article made it to be the featured article on the Yahoo! front page. It was there for an hour. We went from our already high Christmas traffic of about 80 req/s for pages and 200 req/s for images to a 130 req/s for pages and 500 req/s for images. We survived with a little tinkering. We have been working on a …

Today, I encountered a very weird problem.

Consider the following similar queries (one run with LIMIT clause and the other without it). The result set has been truncated for convenience.

mysql> SELECT 'photo_Q'  AS db, year_of_account_created,month_of_account_created, year_of_date_uploaded, month_of_date_uploaded, COUNT(distinct user_name) FROM photo_Q1.photo GROUP BY year_of_account_created, month_of_account_created ;
+---------+-------------------------+--------------------------+-----------------------+------------------------+---------------------------+
| db      | year_of_account_created | month_of_account_created | year_of_date_uploaded | month_of_date_uploaded | COUNT(distinct user_name) |
+---------+-------------------------+--------------------------+-----------------------+------------------------+---------------------------+
| photo_Q |                    NULL |                     NULL …

Matt Asay tagged me with a blog meme (sounds worse than it is) to write 5 things that most people probably don't know about me.  Let me apologize in advance for such a self-centered posting; I swear I'm just following orders!  Here are few little known facts, though people who read this blog regularly may know a couple of these already. 

1. I'm a marathon runner
   Running a marathon is harder than almost anything else you can do. Harder than working in a startup, harder than writing humor, harder than marriage.  But it's also a very rewarding experience.  I learned more in running my first marathon than almost anything else in life.  I've run 10 marathons in ten years as well as …