Look! I'm blogging!
I'm inspired to add a little twist to this. Lets give this 'blog-y' thing a try before I slink back into obscurity.

So, I'm limiting this list to my top five wishes for MySQL, that I have an ability or idea on how to influence.

1) Logical separation of connections from threads

If you do not have full control of the queries hitting your DB, you open a new world by allowing logic inbetween your connections and the query engine.

• First, this means that the connections != threads running, and an immediate benefit would be making queries over a limit 'queue' in some way. perlbal + apache MaxClients really smooths over throughput, why can't MySQL do the same?
  
• So many cool tricks! Want to rate limit by IO/s? Imagine having control of a query as it traverses …

While at the Linux Foundation meeting last week I spent some time
talking to Allison Randall. I told her about my recent vacation and
how I ditched my MySQL email during that period. Its the first time I
have ever done this, just shut off an email pipe. I went as far as
deleting my MySQL account from Mail.app so that I wouldn't be tempted
to even look at it.

We were talking for a bit about our experiences with receiving lots
of email and how to handle it. I noticed from our conversation that
we had both found coping skills that resulted in both of us treating
email as a very lossy environment.

I don't respond to all of my email. In fact, I don't even read CC'ed
email except for maybe once a week (and sometimes not even that). If
you want my attention then I assume you put me on the To: line, since
you are actually thinking of me. This …

MySQL AB today announced that the high-availability MySQL Cluster database conducts critical Web-centric, real-time data processing for Zillow.com, one of the Web's most-visited real estate sites, with 4.2 million unique visitors in May 2007.

Alfresco has a seminar next week in Munich, on Tuesday 26.6.2007 17:00-20:00 at the Hotel Excelsior close to Stachus. I’ll be talking about MySQL’s relationship to its communities.

I’m looking forward to meeting our joint users, and learning more about Alfresco Enterprise Content Management — including the case study from the Swiss Federal Court.

So you ran into some basic limitations with MyISAM when your site got busier. Even single row updates would lock the whole table and slow things down to a crawl. Then you updated to InnoDB to get the benefit of row-level locking, but now the site is even slower than before. What gives? Well, we [...]

I’ve been able to steal some more time to work on my script following My ?hourly? MySQL monitor script Version 0.03 almost a month ago.

The purpose of this script is simple. Create an hourly ‘cron’ job that records and monitors information against the OS and MySQL Server. This is most helpful when environments simply don’t have any monitoring in place. I’ve found it very productive when running a benchmark on site to simply enable for an hour. An amount of analysis is required, but I at least have a baseline of data collection. That is the first goal.

So hourly.0.05.tar.gz is taking some shape, and has the following new features:

• Provide configurable flag to enable/disable OS and MySQL tests
• Added MYSQL_SID support, allowing for running MySQL tests against …

Or, Why is My Transaction So Big? My team and I still use old-style rollback segments for one of my client’s 10g production databases. We just never found the need to switch to automatic undo management. There are a number of 1GB rollback segments. They are that size because they need to be able to support [...]

somewhere in these 1.6GB of debug log files and signal traces… somewhere… really.

It was just a matter of time. But eventually, it was bound to happen. Some in the industry have been playing fast and loose with the term "open source," and yesterday Michael Tiemann, president of the OSI, cried 'Foul!' on his blog. As Michael writes:

Starting around 2006, the term open source came under attack from two new and unanticipated directions: the first was from vendors who claimed that they have every bit as much right to define the term as does the OSI, and the second was from vendors who claimed that their license was actually faithful to the Open Source Definition (OSD), and that the OSI board was merely being obtuse (or worse) in not recognizing that fact. (At least one vendor has pursued both lines of attack.) This was certainly not the first attack we ever had to repel, but it is the first time we have …

While upgrading fom MySql 3 to Myql 5 our only real problem was with merge tables. We have two in the system, both did not work. Createing the merge table did not give an eror, bt when we tried to select from it, we get the error message 1168:
Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist

This kind of error message gives my the creeps. Or?? Why doesn't it say which one of the cases it is? Surely these are three different cases and it should be easy to separate them. Is it difficult to add error messages to MySql? Or a lazy programmer??

OK, we try to look at the table definition i MySql's own tool the Query browser. But if you try to do 'Edit Table' in the Query Browser, you get the following error message:
A MySql eror message was encountered. The eror message is:
Cannot fetch table information
The following error occurred:Unable to open …