mysqlreport v2.7a has been released. It only fixes one bug: –host was completely ignored if a socket was available. Thanks to Sam for pointing this out to me.

Any bets on whether or not I remember to commit this patch?

For the record its the forth time I have written this field type (I've also done MACADDR and UUID before as well).

mysql> create table foo (a ipv4);
Query OK, 0 rows affected (0.02 sec)

mysql> show create table foo;
+------- +----------------------------------------------------------------------- --------------+
| Table | Create Table |
+------- +----------------------------------------------------------------------- --------------+
| foo | CREATE TABLE `foo` (
`a` ipv4 DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 |
+------- +----------------------------------------------------------------------- --------------+
1 row in set (0.00 sec)


mysql> insert into foo VALUES ("10.0.2.1");
Query OK, 1 row affected (0.00 sec)

…

I noticed on Monday PeterZ's post:
http://www.mysqlperformanceblog.com/2006/11/12/trying-archive-storage-engine/

I thought I would take a look for myself at what he found. From what I can tell he was working with accesslogs from Apache, so I did the same :)

So first result is MyISAM:

mysql> show table status \G
*************************** 1. row ***************************
Name: accesslog
Engine: MyISAM
Version: 7
Row_format: Dynamic
Rows: 3885977
Avg_row_length: 122
Data_length: 476739780
Max_data_length: 4294967295
Index_length: 102916096
Data_free: 0
Auto_increment: 3885978
Create_time: 2004-06-28 19:01:13
Update_time: 2006-11-12 22:59:46
Check_time: 2006-11-12 23:11:58
…

This tutorial gives you a practical introduction to MySQL 5 Application Development using the MYSQL Connector for .NET with Microsoft Visual Studio.NET 2005 and how to build a simple Database Application using VC# and MySQL 5.

SugarCRM Inc., the world's leading provider of commercial open source customer relationship management (CRM) software, today announced the availability of Sugar FastStack, a software support and delivery service that provides a fast and simple way to install a complete open source software solution, including Sugar software, the Apache Web Server, PHP and the MySQL database.

Some early notes by Brian Aker on Falcon as discussed at the MySQL Camp.

Falcon is a transactional engine MySQL will be introducing. The first discussions were held about 3 years ago with Ann Harrison and about 1 1/2 years ago, MySQL started taking seriously the possibilities.

Falcon is not an InnoDB replacement. It’s a different way of looking at the problem of how it looks at and manages transactions, and how it’s designed. It flips around the way data is stored. Some points:

• It uses as much memory as possible, like Oracle SGA or InnoDB pool.
• It has a row cache not a page cache for more optimal memory use.
• No locking at all. Jim doesn’t believe in it for concurrency control. It has total versioning.
• Falcon has to keep all changes in memory, so not great for user transactions that may take longer
…

If you've read this blog in the past, you may have wondered where I've been all these past five months. In truth, I often wonder myself--the last five months have gone by like a blur, as we've been doing a tremendous amount of work for both the opentaps open source ERP + CRM project and for the soon-to-graduate-from-incubation Apache OFBiz project.

Happily, all is for naught. opentaps and OFBiz have both come a long way in these past months, with better features and stability and more users and contributors.

The down-and-dirty work of making an open source ERP system work for real users is not necessarily glamorous, but it's definitely given me a better perspective on the how and why of open source ERP. Some of it falls in line with what we had expected, but some of it were quite surprising--in a good way. I hope to …

It is not worth salvaging at this point. I got a lot of use out of it in the time I've had it, and it's been very dependable, considering that I bought it used. It had failed before, and I replaced the hard drive, but now the display has failed. In retrospect it's probably been giving me warnings for a good six months or so. These flat-panel LCD displays have a fluorescent light in them, and it's been doing what aging fluorescent lights do— flickering at first, taking time to get to full brightness, etc. Now it lights up dimly for a few seconds and goes out. I can faintly see the image still on the display. I've never had a display fail like this, but as CRTs continue to go by the wayside, and flat-panel displays are pretty much the norm now, I expect we'll see more of this as time goes on. I opened up the display, hoping maybe I'd find a bulb I could replace, but no such luck. It actually turns out to be a Samsung monitor tucked in there, and …

Despite a hard stop for new features in 5.0, we are adding IF EXISTS syntax to DROP TRIGGER statement.
I wonder what needs to happen to have basic SIGNAL functionality added. I tried to implement it a few months ago and it didn't seem bigger than a task for a few days.
So, I'm looking for ideas how to make addition of SIGNAL to 5.0 a no-brainer decision. Should our community run a charity auction with this feature on stake?
Finding a customer from Fortune 500 that would declare they can't use our product without it might prove more effective :)

I am happy to announce that version 0.2 of the mylvmbackup tool is now available!

mylvmbackup is a Perl script for quickly performing backups of a MySQL server's databases using the Linux Logical Volume Manager (LVM). It creates a consistent LVM snapshot of the server's data directory which is then backed up without further blocking the server's operation.

After version 0.1 was published in May this year, I did not really get much feedback about it. I had some ideas for improvements (see the TODO file included in the package), but never got around to actually start working on them.

Thanks to Robin H. Johnson from the Gentoo project for contributing a number of new options and features as well as some code …