MySQL
The Facebook effect
First it was the SlashDot effect, then it was the Digg effect, now it’s the Facebook effect. I have a friend at Facebook and he was talking about the effect of the Facebook Platform API that was released a few weeks ago.
Read moreTop 5 wishes for MySQL
Note: My views are just that: mine. 1. Real time Query Monitoring MySQL 5.0 GA provides only 3 ways to look at queries that are executed on a server in some way or another.
Read moreMySQL – Wikipedia
I was reading only last week the notes from [Wikipedia: Site Internals, Configuration and Code Examples, and Management Issues][1] Tutorial by Domas Mituzas at the recent [2007 MySQL Conference][2]. I didn’t attend this session, like a lot of sessions too much good stuff at the same time.
Read moreMySQL – 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 more