Growing up in the world of linux uptime was always considered a good thing. On IRC every once in a while someone would post an uptime. Everyone else in that channel would then check their uptime and if it was greater or close they would post it in the channel. Most of these systems were home linux boxes used for compiling random programs or maybe hosting a webserver for experimenting. It was fun to see how long we could keep them running for. Since those days I have come to realize that high uptimes are a bad thing.
Keeping a server up for months or even years means that you aren’t maintaining it. It hasn’t been kept up to date with new kernels that have fixes for security holes. It doesn’t have new packages or new tools that can help it run more efficiently and have features that can make using it easier. It’s also not up to date with new servers that are being deployed which means that people logging into your server with a high …

cjcollier@norseth:~/Desktop$ sudo dd if=/dev/zero of=/dev/hda3

Time to return the computer to MySQL

Thanks for letting me keep it long enough to clean it up, folks!

Assume that you have a list of numeric values mixed with numeric 
values appended with characters - like 2a, 12, 5b, 5a, 10, 11, 1, 4b.



Sorting on a list like this would usually end up so:

mysql> SELECT version
-> FROM version_sorting
-> ORDER BY version;
+---------+
| version |
+---------+
| 1       |
| 10      |
| 11      |
| 12      |
| 2a      |
| 4b      |
| 5a      |
| 5b      |
+---------+
8 rows in set (0.03 sec)

To sort the list based on the numeric values, simply do this:

mysql> SELECT version
-> FROM version_sorting
-> ORDER BY CAST(version AS UNSIGNED), version;
+---------+
| version |
+---------+
| 1       |
| 2a      |
| 4b …

I've seen a lot of SQL code that uses an IN clause as a place to put a variable number of parameters, allowing the query to be more flexible. There are several downsides to this technique. This article discusses those downsides and explains how to avoid them.

Finally got to capturing, editing, and exporting the video from the June Boston MySQL meetup. This month Sheeri did a presentation on storing images in MySQL.

The video is up on Google, and here and here in Quicktime.

Thanks to Martin at kbglob for donating bandwidth.

This blog has been added to the MySQL developer zone!

You can reach it by going to the MySQL website and clicking Developer Zone -> blogs. This brings you to the Planet MySQL, which now contains this blog.

You can also go there directly by following this link: Planet MySQL

Blog: http://sqlbusrt.blogspot.com/

Project website: http://sqlbusrt.sourceforge.net/

Marc Fleury is giving the opening remarks at today's OSBC London, and is talking about the rise of open source. As Marc said, it's no longer a question of "Why?", but rather of "How?" with regard to open source. Open source is not going away - it's only going to thrive and dominate.

A few interesting points:

1. Debt to IBM. He talked a bit about the debt we owe to IBM for getting open source started with its $1 billion commitment to Linux, but noted that IBM seems conflicted now on that initial support for open source. It has a range of software businesses that compete with open source, rather than leverage it, in his words. True enough. In a company the size of IBM, you never get a single, consistent vision.

2. Bottom-up and top-down phenomenon: the system administrators are driving adoption from the "bottom," whereas CIOs are pushing for adoption …

Larry Ellison, billionaire CEO and founder of Oracle corporation has cancelled his $115 million gift to Harvard University.  Ellison, a college drop out, had pledged the funding to Harvard president Larry Summers in order to establish a global health foundation in his name.  Ellison is estimated by Forbes to be the 15th richest man with assets worth $16 billion. 

In late 2005, as part of an insider trading settlement, Ellison agreed to donate $100 million to a charity of his choice.  He chose his own Ellison Medical Foundation and has contributed $5 million to it, according to an Oracle spokesman.

• LA Times: Oracle's Ellison …

OK, anyone who's done any web development has eventually come across the choices one must make regarding how to handle sessions in your web applications. While there are a variety of methods of handling session interaction, file and cookie-based session management eventually reach a limit in the number of users that can be supported, as well as limitations involving web server farms, load balancing, and state management. To achieve scalability in session management, especially across a web server farm, a database is often used.

Jimmy Guerrero, senior product manager at MySQL, is giving a webinar tomorrow on scaling session management with MySQL Cluster. I, for one, am going to be attending, and I hope to see a number of community folks in the list of participants. It shoud be …

I recently was given a copy of O'Reilly's Baseball Hacks and have really enjoyed digging into a deeper level of understanding baseball. Yes, I watch a fair amount of baseball, but I'm only beginning to understand some of the strategies that come into play during the game (e.g. pitching to a batter or positioning the players on the field).

A few hacks of note:

• Hack #1: Score a Baseball Game - I never knew how scoring a game worked, very usefull to know how the stats are recorded.
• Hack #4: Follow Pitches During the Game - this is a great introduction to learning what goes on as the pitcher faces each batter, the hack also includes ways to identify the various types of pitches and pitch locations.
• Hack #8, 10, 16, 18 20 and many more - use MySQL to import, store, crunch, query and present your baseball data.
• Hack #13: …