Stories
Slash Boxes
Comments

NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

use Perl

All the Perl that's Practical to Extract and Report

When MySQL Bites: Quirks to Watch Out For More | Login | Reply

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.

Without JavaScript enabled, you might want to use the classic discussion system instead. If you login, you can remember this preference.

longer than 2 years (Score:1)

by perrin (4270) on 2008.03.28 15:23 (#61859) Journal

Saying MySQL 5 has only been available for 2 years is a bit questionable. It's been out in production for 2.5 and in (widely-used) beta for 3. It's standard on any modern Linux distro at this point.
You seem to be implying that InnoDB tables are slower than MyISAM. For my workload it's been quite the opposite: InnoDB tables have been significantly faster.
The right way to do ENUMs with enforcement is to use a lookup table with foreign keys, just like you would in many other databases. You made a really big deal about the syntax for specifying foreign keys here, almost making it sound as if they don't work. They work just fine, and have since way before MySQL 5.

Reply to This

Get More Comments

Stories, comments, journals, and other submissions on use Perl; are Copyright 1998-2006, their respective owners.