MySQL
Innodb 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.
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.
My ‘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.
My ‘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.
Using 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.
Everything 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.
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.
The 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.
Reading 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.
MySQL 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.
MySQL 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.
MySQL 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.
MySQL 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).
MySQL 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