Dear Perl and MySQL developers, admins and enthusiasts, I'm please to announce the release of DBD::mysql 4.018! This release includes some code cleanups, added documentation as well as new features (database handle attributes) that allow you to be able to ascertain the server and client versions (Thank you to Robert M. Jansen). An example below, … [Read more...]
InnoDB tablespace fragmentation (find it and fix it!)
If you frequently delete rows (or update rows with variable-length data types), you can end up with a lot of wasted space in your data file(s), similar to filesystem fragmentation. If you're not using the innodb_file_per_table option, the only thing you can do about it is export and import the database, a time-and-disk-intensive procedure. … [Read more...]
Recovering a Schema From InnoDB .frm Files
Sometimes you find yourself in a bad situation where your only hope of recovering your InnoDB data lies in a handful of .frm and .ibd data files that were heretofore part of a working MySQL installation. It could be the case that someone thought backing up InnoDB tables was simply a matter of of copying the .ibd and .frm files somewhere safe. … [Read more...]
Velocity 2009
I've had the pleasure of being asked to speak at Velocity 2009 and tomorrow I go to San Francisco to participate the the Velocity Summit. I'll get to rub elbows with the cabal that is planning/producing and executing the mamouth undertaking that is running a conference. I gave four topic possibilities all focused on MySQL or 24/7 operational … [Read more...]
MySQL 5.1GA
As is usually the case with fresh versions of software, we advise clients to move forward judiciously. This release has a bit of a hubbub surrounding it on the internet regarding Monty Widenius' post titled "Oops we did it again". Monty's article is an excellent summary of what does and doesn't work as well as putting in an obligatory (though … [Read more...]
Managing databases and other stuff
Databases exist to store data. That said, a database is infrequently useful entirely on it's own. So, managing databases means that we're often interacting with applications that access that data. Some of the common applications that we work with include Oracle E-Business Suite, Tomcat, Apache and ColdFusion. We had an entertaining problem … [Read more...]
Busy couple of weeks
We've been working on lots of new customers and in our spare time writing a few scripts and white papers. I've added a link to the right to download Chuck Edwards' paper on encrypting Oracle traffic with SSH tunnels. Ed's been working hard on some handy Oracle scripts and I'll have that tarball published sometime this week. In the mean time, … [Read more...]