General

A 5.1 QEP nicety – Using join buffer

I was surprised to find yesterday when using MySQL 5.1.26-rc with a client I’m recommending 5.1 to, some information not seen in the EXPLAIN plan before while reviewing SQL Statements.

Read more

VirtualBox, compiling Part 2

So I managed to find all dependencies after some trial and error for compiling VirtualBox 1.6.4 under Ubuntu 8.0.4, then finding the Linux build instructions to confirm. It was not successful however in building, throwing the following error:

Read more

Virtual Box, a world of hurt

I successfully installed Virtual box via a few simply apt-get commands under Ubuntu 8.04 via these instructions . It started fine, after two small annoying, install this module, add this group messages.

Read more

Drizzle has it’s own dedicated feed

For those that have been using Planet MySQL to follow the progress of Drizzle , we now have our own Planet Drizzle . You can also get a RSS feed directly from http://feeds.

Read more

Choosing MySQL 5.1 over 5.0

I have been asked twice this week what version of MySQL I would choose for a new project. As with most questions in life the answer is: It Depends? In general I would now recommend for a new project to select 5.

Read more

Project Darkstar

It may sound like either a astronomical research project or a Star Wars spin- off, but Project Darkstar is an open source infrastructure from Sun Microsystems that states “simplify the development and operation of massively scalable online games, virtual worlds, and social networking applications.

Read more

What are the best MySQL Design Practices?

Tonight I provided a scope in Best Design Practices for MySQL Applications – Part A of just how much there is to consider with a successful application. I only scratched the surface in some detail, a topic one could easily write a book on, and definitely provide a number more presentations.

Read more

Finding, exposing and referencing good material

I came across www.problogger.net by accident. Like many sites and information these days, you simply don’t find via search engines because your normally searching for something specific. I did find it via several levels of hyperlinks.

Read more

Ultra light startups NY meeting

I attended the Ultra light startup’s meeting last night for the first time. I found it most productive for the 2 hours of time to see a different approach talking about startups, to see a variety of approaches, concepts, ideas, ventures all at various stages and generally people with different and interesting ideas and goal.

Read more

Using consistent data types for columns

I came across this error recently when trying to modify the data type of a column. ERROR 1025 (HY000): Error on rename of './sakila/#sql-1d91_5' to './sakila/inventory' (errno: 150) Not the first time, and not the last time.

Read more

MySQL involvement in OSCON opening keynote

Before I get to post my OSCON reflection I see I didn’t post this (which I reference). At OSCON opening keynotes Tim O’Reilly Interviews Monty Widenius & Brian Aker . This provided some interesting answers in a Q & A session.

Read more

Where the happening community people now hang

Eric of Proven Scaling commented on a lack of IRC action in the normal mysql channels today when he visited the #drizzle channel on irc.freenode.net. ebergen: I'm still in #mysql-dev and #planet.

Read more

Installing Buildbot

BuildBot is a system to automate the compile/test cycle required by most software projects to validate code changes. Here is my environment. $ uname -a Linux app.example.com 2.6.18-53.el5 #1 SMP Mon Nov 12 02:14:55 EST 2007 x86_64 x86_64 x86_64 GNU/Linux $ python Python 2.

Read more

MySQL Proxy lua scripts from presentation

The following Lua scripts are the examples are from my MySQL Proxy @ OSCON 08 presentation. analyze_query.lua MySQL Proxy Analyze Query . Requires MySQL Proxy Logging Module . What is released is the Version for MySQL 5.

Read more