MySQL
MySQL – Testing failing non-transactional statements
I was asked recently to confirm a consistent state of data in a non-transactional MySQL table after a failing statement updating multiple rows did not complete successfully. Hmmm, this is what I did.
Read moreSome comments of ‘Five months with MySQL Cluster’
I recently saw the Planet MySQL post Five months with MySQL Cluster by Brian Moon. Thought I’d add my 5 cents worth (Australian’s don’t have 1 cent coins any more to make 2 cents worth)
Read moreAmp’d Mobile no more
Announced at the 2007 Conference as MySQL Applications of the Year – #1 in 3G Mobile Entertainment, Amp’d Mobile is no longer the poster boy within the US telecommunications. [Amp’d Mobile Implodes: Burns $360 million, Declares Bankruptcy][1].
Read moreInnodb Monitoring I didn’t know
Ok, so I knew about innodb_table_monitor and innodb_tablespace_monitor. I’ve tried them before, looked at the output and given up, partly because it didn’t serve the purpose I wanted it to at the time, and also because it’s format was a little cryptic.
Read moreLog 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 moreMy ‘hourly’ MySQL monitor script
Following my article Everything fails, Monitor Everything , and some inquiries, I’ve made some small modifications to my initially hourly script. This script is still a quick and dirty trial of what I’m wanting to develop, but in true Guy Kawasaki terms “5.
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 more