Open Query blog

This week we’ve been working on… The re-jigged build system, so we have a single patched baseline source tarball that’s then used for all the different builds, as well as being available for you to download and build yourself. Noarch distro rpm for all CentOS to more easily drop repo files into YUM. The repo/download [...]

Filed under: Uncategorized | by arjen
3 Comments »

When I left MySQL, my main machine was my old black 32-bit macbook which had to be kept attached to power supply (you know how difficult that is to guarantee, with the mag power adapter!) because of the earlier cordial-in-the-night incident (insurance covered that but the replacement was MySQL’s of course). I wanted a new [...]

Filed under: Uncategorized | by arjen
No Comments »

Off to Melbourne again, consulting for MySQL HA and performance tuning with a few different clients Mon-Thu. I was in Melbourne already last month, and will be there again in a few weeks for custom training. Hmm, is there a (flight)pattern there? Also visiting

Filed under: Uncategorized | by arjen
No Comments »

Ideas welcome! General idea… base: Delta symbol (with thicker line on right hand side – a delta it’s not a regular triangle), plus one or more of the following: something depicting deltas: incremental small changes; something depicting a river delta: where streams come together before flowing into ocean; something depicting community: people working together, participating, [...]

Filed under: Uncategorized | by arjen
2 Comments »

It’s been about a week since the initial launch of the first 5.0 packages and the OurDelta website, so it’s time for some first impressions and an update on what’s going on right now… Immediately lots of hits on the site (from 67 distinct countries), most downloads and repo retrieves started happening a few days [...]

Filed under: Uncategorized | by arjen
1 Comment »

In MySQL, not all keywords are reserved words, and because of the way function parentheses are handled by default, function names aren’t reserved words either. Reserved words are nasty, as they can’t simply be used for identifiers: database, table, and column names. I say “can’t simply” because you can of course backtick anything and use [...]

Filed under: Uncategorized | by arjen
3 Comments »

Build of MySQL 5.0.67.d6 for Debian Etch done and available, simply click to the new Debian page for the info to set up your repo. Thanks to Peter Lieverdink (cafuego on the #ourdelta IRC channel) for the fast work! Also, because sometimes instant banter is useful, there’s now a #ourdelta channel on Freenode. Naturally, real [...]

Filed under: Uncategorized | by arjen
No Comments »

With the build system, repos, patches and launchpad sorted, we can release! First up from OurDelta is a build of 5.0.67, using patchrev d6, for i386/x86_64. This is basically Percona patchset 5 with a few fixes plus the Sphinx storage engine. It even passes the testsuite RHEL/CentOS 4.6/5.2 RPMs and YUM repo info Ubuntu Hardy [...]

Filed under: Uncategorized | by arjen
13 Comments »

I’ve created a new community poll: Would you prefer InnoDB to be the default storage engine?, as I’m just curious how the community currently feels about this. Of course, anyone can put –default-storage-engine=InnoDB (and –sql_mode=NO_ENGINE_SUBSTITUTION) in their my.cnf to accomplish the same, but… as a friend of mine has been asking me for years, it [...]

Filed under: Uncategorized | by arjen
7 Comments »

Look, this could be hilarous, or dreadful. I haven’t got the book, so I don’t know which – but couldn’t resist writing about it since someone pointed it out to me The Manga Guide to Databases [ILLUSTRATED] (Paperback) by Mana Takahashi

Filed under: Uncategorized | by arjen
2 Comments »