Blog
The MySQL documentation is not always right
Let me premise this post with the statement I think the MySQL documentation is an excellent and highly accurate resource. I think the MySQL docs team do a great job, however like software and people, documentation is not perfect.
Read moreThe Drizzle Census
One thing I have often wondered is just how many MySQL instances exist in the world and what MySQL versions and architectures are in use. We hear of 50,000 windows downloads per day but this is misleading because MySQL is basically bundled with Linux by default or installed from various repositories.
Read moreInstallation issues with MySQL 5.5.4 and resolveip
I was installing the latest MySQL 5.5.4 on a new machine and I came across the following issues during installation, steps I generally perform on other versions without any incidents.
Read more2010 MySQL Conference Presentations
I have uploaded my three presentations from the 2010 MySQL Users Conference in Santa Clara, California which was my 5th consecutive year appearing as a speaker. IGNITION – MySQLCamp for Oracle DBA – Volume I LIFTOFF – MySQLCamp for Oracle DBA – Volume 2 10x Performance Improvements – A Case Study A full history of my MySQL presentations can be found on the Presenting page.
Read moreMy acceptance with Oracle as ACE Director
I hinted last week of my acceptance with Oracle before the formal announcement this week at the MySQL Users Conference, not for a job but as Oracle ACE Director . In today’s State of the MySQL Community keynote by Kaj Arnö I was one of the first three MySQL nominees that are now part of this program.
Read moreState of the Dolphin – Opening keynote
Edward Screven – Chief Corporate Architect of Oracle provided the opening keynote at the 2010 MySQL Users Conference . Overall I was disappointed. The first half was more an Oracle Sales pitch, we had some product announcements, we had some 5.
Read moreMy 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 more