Databases
Query Cache is deterministic
I was reading some points on a Blog post today here . I didn’t see it via Planet MySQL but via a Google Alert. The post has several good beginner points on MySQL Performance, but included the point “Literal current date is better than using the CURRENT_DATE() function because literals will use the query cache but functions won’t.
Read moreMy ‘Hourly’ MySQL Monitor Script Version 0.05
I’ve been able to steal some more time to work on my script following My ‘hourly’ MySQL monitor script Version 0.03 almost a month ago. The purpose of this script is simple.
Read moreWatching for Disk Based Tables being created
I didn’t know you could actually do this before addressing this problem in a benchmark using 5.0.36. MySQL allows you to update two tables with a single UPDATE statement. I knew you could reference two tables in an UPDATE statement but not update both.
Read moreThe 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 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 more