Databases
Reading the right MySQL Manual
I learned an extremely valuable lesson today on a client site. It’s important that users of MySQL read the right version of the manual for the product they are using. It’s very easy to just goto http://dev.
Read moreThe MySQL Conference recap
I recently had the opportunity to return and speak at the Brisbane MySQL Users Group . I spent some time talking about MySQL User Conference 2007 Summary and Life as a Consultant.
Read moreReading the MySQL Manual
I was asked the question today, “How do I show the details of a Stored Procedure in MySQL. The SHOW PROCEDURE ‘name’ didn’t work.”. The obvious answer was SELECT ROUTINE_NAME,ROUTINE_DEFINITION FROM INFORMATION_SCHEMA.
Read moreMySQL Cluster Certified
Jonathon Coombes recently blogged in MySQL Cluster Certified that he passed the MySQL Cluster DBA Certification as was the first Australian. Lucky for him I passed the exam after my presentation on the second day of the conference.
Read moreMySQL Conference – YouTube
MySQL Conference 2007 Day 4 rolled quickly into the second keynote Scaling MySQL at YouTube by Paul Tuckfield. The introduction by Paul Tuckfield was; “What do I know about anything, I was just the DBA at PayPal, now I’m just the DBA at youTube.
Read moreMySQL Conference – Get Behind Dorsal Source
In a community session yesterday at MySQL Conference 2007, I first heard about [Dorsal Source][1]. A collaboration between [Solid DB][2] and [Proven Scaling][3] that allows for community people to upload patches to [MySQL][4], get it compiled across multiple platforms, and have a downloadable distribution available on H/W individual contributors will never have access to.
Read moreMySQL Conference – PHP on Hormones
MySQL Conference 2007 Day 4 started early again at 8:20 am with PHP on Hormones by the father of PHP Ramus Lerdorf. A very funny man, one of the best insightful talks of the conference (rather scary actually).
Read moreMySQL Conference – Google
MySQL: The Real Grid Database Introduction Can’t work on performance problems until we solve the availability We want MySQL to fix our problems first. The problem Deploy a DBMS for a workload with too many queries to many transactions to much data A well known solution
Read moreQuote – 26 April 2007
“The web is broken you can all go home now.” Ramus Lerdorf — Father of PHP — MySQL Conference 2007
Read moreQuote – 25 April 2007
“Don’t complain, do something about it” Baron Schwartz – Creator of MySQL Toolkit — MySQL Conference 2007
Read moreMySQL Roadmap
Here are some notes from the MySQL Server Roadmap session at the MySQL Conference 2007. MySQL: Past and Future 2001: 3:23 2003: 4.0 UNION query Cache Embedded 2004: 41. Subqueries 2005: 5.
Read moreQuote – 25 April 2007
“What ever advice you got, keep it to yourself, your not the target market.” Red Hat & One Laptop Per Child UI Designer to bunch of suits – MySQL Conference 2007
Read moreMySQL Conference – For Oracle DBAs and Developers
I have just completed my presentation at the MySQL Conference 2007 on [MySQL for Oracle DBAs and Developers][1]. Not mentioned in my slides, but referenced during the presentation was what I consider the most important page to document from the MySQL Manual — 5.
Read moreMySQL Conference – Building a Vertical Search Engine in a Day
Moving into the user sessions on the first day at MySQL Conference 2007, I attended Building a Vertical Search Engine in a Day . Some of my notes for reference.
Read more