Blog
My acceptance with Oracle
There have been a number of April fools jokes today so I thought I’d add my own to the list. While this sounds unexpected it’s actually no joke. I just accepted a position with Oracle yesterday but I can’t say any more about the details until the MySQL users conference in a few weeks.
Read moreUsing ROLLBACK with MyISAM
Using ROLLBACK with MyISAM is useless. A ROLLBACK command is used to undo any DML that occurs during a transaction (i.e. START TRANSACTION and COMMIT). The MySQL default storage engine MyISAM does not support transactions.
Read moreInstalling Ubuntu Desktop 10.04 with LVM
With a new quad core desktop with 8GB RAM & 1TB HDD I wanted to install the Ubuntu desktop version using LVM. This is not possible with the “Desktop CD”. You need to use the “alternative CD” which will easily allow you to configure LVM via a text/cursors installation and also give you a deskop GNOME environment.
Read moreNew linux desktop configuration
My purchase yesterday was a HP Pavilion p6340f Desktop PC with the following specs. Intel Core 2 Quad Q8400 2.66GHz Processor 4MB L2 Cache, 1333MHz FSB 8GB PC3-8500 DDR3 SDRAM (4 x 2GB) 1TB Serial ATA Hard Drive Intel Graphics Media Accelerator X4500 with 32MB Integrated shared graphics memory Lightscribe SuperMulti DVD±R/RW with Double Layer 10/100/1000 Base-T Network interface Wireless LAN 802.
Read moreHow to find MySQL developers?
Brian wrote recently Where did all of the MySQL Developers Go? , while over in Drizzle land they have been accepted for the Google Summer of code along with many other open source projects.
Read moreUnderstanding Drizzle user authentication options – Part 2
A key differentiator in Drizzle from it’s original MySQL roots is user based authentication. Gone is the host/user and schema/table/column model that was stored in the MyISAM based mysql.user table.
Read moreUnderstanding Drizzle user authentication options – Part 1
A key differentiator in Drizzle from it’s original MySQL roots is user based authentication. Gone is the host/user and schema/table/column model that was stored in the MyISAM based mysql.user table.
Read moreGearman examples under Mac OS X
Today I listened in on the O’Reilly webcast Introduction to Gearman by Eric Day of Rackspace. I thought I would follow through on the machine at hand; a Mac with OS X 10.
Read moreUsing ext4 for MySQL
This week with a client I saw ext4 used for the first time on a production MySQL system which was running Ubuntu 9.10 (Karmic Koala) . I observe today while installing 9.
Read moreDrizzle’s Data Dictionary and Global Status
With the recent news by Brian about the Data Dictionary in Drizzle replacing the INFORMATION_SCHEMA, I was looking into the server status variables (aka INFORMATION_SCHEMA.GLOBAL_STATUS) and I came across an interesting discovery.
Read moreUpgrading my Google G1 dev phone to Android 1.6
To update your Google G1 phone (mine is an Android developer unlocked phone) to Android 1.6 (Donut), I did the following. Download and unpack the Android SDK for Mac OS X from http://developer.
Read moreHow do I identify the MySQL my.cnf file?
If you are unfamiliar in administrating MySQL, the current MySQL configuration file generally found is named my.cnf (my.ini on windows). Where is that file. If only that question was easy to answer!
Read moreDon’t Assume – Per Session Buffers
MySQL has a number of global buffers, i.e. your SGA. There are also a number of per session/thread buffers that combined with other memory usage constitutes an unbounded PGA. One of the most common errors in mis-configured MySQL environments is the setting of the 4 primary per session buffers thinking they are global buffers.
Read moreFree advice on your my.cnf
Today, while on IRC in #pentaho I came across a discussion and a published my.cnf. In this configuration I found some grossly incorrect values for per session buffers (see below).
Read more