Anyone who's been to an open source conference this year has probably been to the Apress Publishing booth. If you have, undoubtedly, you've seen the yellow and black Apress buttons with the hysterical slogans on them. Myself, have a few Apress connections of my own, I have a few of my favorite ones at home, and the local PHP and Linux User Groups know the buttons because I pass them out when I go to the meetings. The buttons are the brilliant brainchild of Apress chief, Gary Cornell. Some of my favorite slogans:

• "I rarely come out of my shell environment"
• "Enter any 128 bit prime number to continue"
• "Do not offend the geeks, for they are the keepers of your passwords"

Julie Miller, from Apress, has volunteered to have buttons made for MySQL Camp, coming up this Friday through Sunday in …

Until recently, the MySQL databases I work with contain data that can be retrieved from other sources. Most of the data is either batched in from flat files or another database. It would be inconvenient to reload a couple months worth of data, but since these databases are not mission critical, the business could operate without them for a couple days. Lately, we've been implementing some semi-critical systems that rely on a somewhat expedient recovery.

The requirements for the project were that the database must remain up during the backup and losing a day's worth of data was acceptable. All of my regular Oracle readers are cringing at the moment, but hey, that was the rules I was working with.

My first thought was to use mysqlhotcopy because it backed up the actual physical files. However, mysqlhotcopy only allows you to backup MyISAM tables and we extensively use InnoDB.

My next choice was mysqldump. …

MySQL Connector/Net 5.0.2 Beta has been released.  MySQL Connector/Net is an all-managed ADO.Net provider for MySQL.  While this release is suitable for any version of MySQL, it is strongly encouraged that this release not be used on any production data. 

It is now available in source and binary form from the Connector/Net download pages at http://dev.mysql.com/downloads/connector/net/5.0.html and mirror sites (note that not all mirror sites may be up to date at this point of time - if you can't find this version on some mirror, please try again later or choose another download site.)

Changes in this release (changelog):

Bugs fixed

• Bug #23268 System.FormatException when invoking procedure with ENUM input parameter
• Bug #23538 Exception thrown when GetSchemaTable is called and …

A Materialised View (MV) is the precalculated (materialised) result of a query. Unlike a simple VIEW the result of a Materialised View is stored somewhere, generally in a table. Materialised Views are used when immediate response is needed and the query where the Materialised View bases on would take to long to produce a result. Materialised Views have to be refreshed once in a while. It depends on the requirements how often a Materialised View is refreshed and how actual its content is. Basically a Materialised View can be refreshed immediately or deferred, it can be refreshed fully or to a certain point in time. MySQL does not provide Materialised Views by itself. But it is easy to build Materialised Views yourself.

I've done a multitude of benchmarks using various 2.6 IO schedulers. Hands down the Deadline I/O scheduler is the best for INNODB traffic or RANDOM IO. I use to have all this benchmark information in excel worksheets, but lost it when I left Friendster.

Here is how to figure out what IO scheduler your using in Linux 2.6

dmesg |grep -i sched

In most cases your probibly set up to use the cfq io scheduler. Change it to deadline in your PXE, lilo, or grub settings.


For example:

# For booting GNU/Hurd
title GNU/Hurd
root (hd0,0)
kernel /boot/gnumach.gz root=hd0s1
module /boot/serverboot.gz

append to it
kernel /boot/wtfe root=wtfe elevator=deadline

Thanks Peter N. for the linux config info!

Since Oracle announced their fork of Red Hat Linux most of the news coverage has been about the business implications for Red Hat and other Linux vendors.  To be honest, I don't think the impact is all that significant.  Decisions are made by one guy at Oracle (much to the chagrin of many of his executives) and if Larry decides he wants to fork with Red Hat, then he tells his guys to get it done.  So what do they do?  They post CentOS for download on the Oracle web site and call it their own.  And as part of that, Oracle is now distributing MySQL, which is ironic, but nonetheless appreciated. 

Maybe Oracle customers think that Oracle can do a better job supporting their OS than the guys who wrote …

We’ve been saying here and elsewhere that the Microsoft-Novell and Oracle-Red Hat announcements have been market changing events. Some ripples are at the fore: Microsoft has siezed an opportunity to simultaneously head off Oracle and irritate Red Hat. Novell has turned its greatest weakness (the spectre of irrelevancy as recently as last week) into what could prove to be a great strength (It’s a little creepy in its Karl-Rove-esqueness, actually).

And Red Hat itself now faces the real possibility of extinction … Overnight, Red Hat has become the flattest piece of land between two battling superpowers: the Poland of software vendors.

Less obvious is the effect on Ubuntu’s plans to burst onto the enterprise scene in the West. Ubuntu’s sponsor, Canonical’s, overriding strategy hinges on two key pillars. First, Ubuntu is feature-rich and easy-to-use, to appeal to non-fuddy-duddys - that next generation of young …

Friday the 3th of November I presented my work at the University of Twente to my fellow students and my supervisors. The slides of this presentation are available through this link:
Presentation at University of Twente, 3th of November 2006

All students and supervisors present that day are encouraged to post their comments.

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

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

Tim has written another insightful piece on where technology is going, based on the technology books people are buying.

With this in mind, take a look at the tree map for programming languages. (Keep in mind, as Tim notes, that "the size of a square indicates the relative size of the category, and its color indicates the rate of change. A category that is bright green is up significantly. One that is bright red is heading strongly in the other direction.")

What are the takeaways?

• Ruby has continued to grow apace, although its 255% growth rate is off last quarter's torrid 687% increase! Interestingly, PHP also picked up some steam, up 11% vs. last quarter's 6% YoY increase. Python's 27% YoY gain, up from last quarter's 6% gain, shows even more strength. In short, while Ruby has become the …

Released a new version of the procedure converter from SQL Server to MySQL. The changes are driven by user requests.

I have added support for temporary table creation: in SQL server you create a temporary table by adding INTO #temptable to your select. This is converted to MySQL CREATE TEMPORARY TABLE and the # is dropped.

Also some minor changes, like support for very large SQL statements, better pretty-printing and improved support for CASE statements.