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 moreVirtualBox, 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 moreVirtual 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 moreChoosing 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 moreProject 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 moreWhat 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 moreFinding, 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 moreUltra 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 moreUsing 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 moreMySQL 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 moreInstalling 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 moreMySQL 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