Dear Diary, today I ventured into one of the darkest realms of the sysadmin profession: I started playing with SNMP. My goal was very simple and quite clearly stated: Make the output of "SHOW GLOBAL STATUS" available to a SNMP client. One would think that this is a reasonable and easily fulfilled wish.

Little did I know of the madness and despair that linger in the depths which are guarded by the dread named ASN.1 and where the noxious fumes of the organisation no longer called CCITT can still strongly be smelled.

But let us begin this story at the beginning - with a clean install of Suse Linux 10.0 and my trusty apt4rpm and me. It was my thought that the perl support of net-snmp might me handy to get me where I wanted to me: perl is easily the more convenient language for prototyping that C or C++ and getting to the data …

I got a lot of feedback on my question a few weeks back when pondering what I might choose for an OS to run MySQL. I also got a few "so what did you go with" questions.

A week ago I decided to give Ubuntu server a shot at winning my favor. I haven't used Ubuntu much, but all the fuss over it warrants giving it a shot.

I'm quite pleased so far. It meets at least two of the items on my list from that original post (minimal processes and minimal footprint). I'm not familiar with the philosophy behind building the Ubuntu kernel, but I'll accept the fact that there's nothing specifically tailored for MySQL.

Four clues that the server is installed minimal:

• 
  
• 17 minutes from start to finish (including times when it sits …

The sixteenth edition of Log Buffer, the weekly review of database blogs, has been published by Guy Bowerman on his blog, Informix Application Development. Log Buffer has a distributed editorship. If you’d like to share your POV on the database blogosphere, read the Log Buffer homepage and get involved. Take it away, Guy.

A bit ago ago I posted some optimizer hints and recommended using them to write more readable queries. Today I stumbled across an example of my own work that I changed. This is not quite a case of using BETWEEN instead of AND statements, but it sort of is. Basically, I needed to reuse this query:

SELECT count(*),city,
CASE WHEN lastLogin < now ()-interval 90 day THEN 90
WHEN lastLogin < NOW()-interval 60 day THEN 60
WHEN lastLogin < NOW()-interval 30 day THEN 30
WHEN lastLogin > NOW()-interval 30 day THEN 0
ELSE -1
END
FROM . . .

I wrote this query less than a month ago.

I looked at this query today and wondered, “why did I not put lastLogin < now ()-interval 60 AND lastLogin>NOW()-interval 90 in there?” I then realized what I did.

Because the CASE statement …

A bit ago ago I posted some optimizer hints and recommended using them to write more readable queries. Today I stumbled across an example of my own work that I changed. This is not quite a case of using BETWEEN instead of AND statements, but it sort of is. Basically, I needed to reuse this query:

SELECT count(*),city,
CASE WHEN lastLogin < now ()-interval 90 day THEN 90
WHEN lastLogin < NOW()-interval 60 day THEN 60
WHEN lastLogin < NOW()-interval 30 day THEN 30
WHEN lastLogin > NOW()-interval 30 day THEN 0
ELSE -1
END
FROM . . .

I wrote this query less than a month ago.

I looked at this query today and wondered, “why did I not put lastLogin < now ()-interval 60 AND lastLogin>NOW()-interval 90 in there?” I then realized what I did.

Because the CASE statement …

If foreign keys are a part of the database namespace, why is it that you have to ALTER TABLE to add and remove them? Why not alter the database? I suspect the issue is more in MySQL’s limitations that names of foreign keys be unique among tables in a database. . . but it does make me wonder.

If foreign keys are a part of the database namespace, why is it that you have to ALTER TABLE to add and remove them? Why not alter the database? I suspect the issue is more in MySQL’s limitations that names of foreign keys be unique among tables in a database. . . but it does make me wonder.

Joke of the day from our character sets ubergod:

10:59 < bar> mysql> set names utf8;
10:59 < bar> Query OK, 0 rows affected (0.00 sec)
10:59 < bar> mysql> create table t1 (a text,
10:59 < bar>     -> fulltext index `

So what am I up to?

I am taking a vacation.

What does that mean?

I am on a "Hacker Holiday"

In other words I am at staying at home and screwing around with some technology that I have been wanting to look at.

One of the things I am trying to do is see why my network goes down the tubes every so often (or am I supposed to now say the Tubes get full?). I use DD-WRT , http://www.dd-wrt.com/, on all of my routers. I got the brilliant idea of enabling QOS on Wednesday to see if I could get better bandwidth shaping. This pretty much broke everything... I disabled it suspecting that it was causing the router to max out its CPU only to discover that the network issues were related to the maximum number of open connections that my WRT54GL can handle. Which means that I need to find a faster box to run DD-WRT on. Problem is... I …

A week ago, I noted the following:

The MySQL 5.0.26 released 3 Oct 2006 contains an embarrassing ABI breakage. We?re fixing this bug right now, and making a new build including the first binaries which will carry the name ?MySQL Community Server? and ?MySQL Enterprise Server? (which obviously did not exist on 3 Oct 2006). We?ll notify both our community and our customers of the new builds when they?re available.

Sorry about the trouble. We?re also improving our internal QA and build processes, in order to avoid future, similar problems.

Now, we have fixed the ABI breakage and built new releases.

• MySQL Community Server 5.0.27 is built and the packages are being seeded to our mirrors. We will send a release announcement, as we’ve always done, to …