Databases
Log Buffer #47: a Carnival of the Vanities for DBAs
Log Buffer #47: a Carnival of the Vanities for DBAs June 1st, 2007 – by Ronald Bradford Welcome to the 47th edition of Log Buffer , the weekly review of database blogs.
Read moreMy ‘hourly’ MySQL monitor script Version 0.03
I realized when I released my very crappy version of My ‘hourly’ MySQL monitor script I really should have included my standard logging. So I did that the night I wrote my original blog, but never published it.
Read moreUsing Perl with MySQL
NOTE: Problems presently exist, I’m seeking the expert help of the community and Perl Gurus I have the need to do some quick benchmarking, I use MyBench as it’s effective in being able to plug in a query, some randomness and 2 minutes later (with a correctly configured Perl/MySQL environment) you have multi-threaded load testing.
Read moreEverything fails, Monitor Everything
From the recent [MySQL Conference][1] a number of things resonate strongly almost daily with me. These included: Guy Kawasaki – Don’t let the bozos grind you down. Boy, the bozos have ground me down this week.
Read moreReading 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 more