http://blog.plasticfish.info (even jon has a blog) Wed, 19 Dec 2007 08:33:44 +0000 http://backend.userland.com/rss092 en Giuseppe Maxia's new article at the MySQL DevZone rightly points out that using partitions doesn't work by magic; as with any other enhancement, it requires a bit of know-how to realise its value. MySQL 5.1 Partitions in Practice reviews some of the basics and points out a few gotchas (if ... http://blog.plasticfish.info/2007/12/19/no-silver-bullet/ I've written an article highlighting some recent developments with XML support in MySQL 5.1 and MySQL 6.0. Topics include: Outputting MySQL data in XML format; includes a look at the 3rd-party lib_mysqludf_xql library Getting XML into MySQL; includes a discussion of the LOAD XML statement (new in ... http://blog.plasticfish.info/2007/12/13/xml-article-on-mysql-devzone/ A little over a year since the project to write this book began, the MySQL 5.1 Cluster Certification Study Guide is now at long last available. It covers everything you'll need to know to pass the Certified MySQL Cluster 5.1 Database Administrator exam, including MySQL Cluster Concepts, Architecture, Configuration, Deployment, ... http://blog.plasticfish.info/2007/11/28/isbn-978-1-8479-9168-3/ A few days ago, Alexander Barkov pushed some changes to the MySQL 5.1 tree that I've been waiting to see for some time -- variable support for XPath functions used with ExtractValue() and UpdateXML(). (This was a fix for Bug #26518, BTW.) This will be available in MySQL 5.1.20 (or ... http://blog.plasticfish.info/2007/06/04/xpath-variables-in-mysql-5120/ Hej hej from Stockholm where I arrived about two weeks ago for a fun-filled two four six weeks of meetings and face-to-face contact with the MySQL Cluster developers. And the chance to check things out when it's not 2°C and raining, all the time, as it was when I was ... http://blog.plasticfish.info/2007/05/31/houses-in-motion-i/ Some people have been saying that MySQL will not provide any more binary releases for its Community users, and that from now on you'll have to build from source or pay up. Say it ain't so! It ain't so. Yes, it's true that MySQL 5.0.33-community is a source-only release. However, this does ... http://blog.plasticfish.info/2007/01/19/what-no-binaries/ ...have been posted in the gallery section. Fans everywhere of the Divine Miss "E" will rejoice. :) http://blog.plasticfish.info/2007/01/17/christmas-2006-photos/ Two weeks into the New Year, and four weeks since I got back from Thailand, I finally get round to updating this thing. By "updating", I don't just mean posting. Gojira the One-Lung Webserver has had an overhaul as well: I've added some more RAM, caught up with the last ... http://blog.plasticfish.info/2007/01/15/a-very-good-year/ Over the last two days, I've deleted about a dozen comments from the MySQL Manual -- and received emails from about a dozen friends -- all asking the same question: "When will 5.0.26 and/or 5.1.12 be released?" Here's how I answer the emails: "Even if I knew for sure... I could ... http://blog.plasticfish.info/2006/10/16/is-it-soup-yet/ I've just uploaded some more pictures to the Gallery. I've taken these over the last three or four weeks at the hotel where I've been staying (The Bedrooms on Sukhumvit 77 Soi On-Nut) and its immediate environs. This is a really nice place, and if you're looking for accomodation for ... http://blog.plasticfish.info/2006/10/16/more-photos-around-the-neighbourhood/