MySQL
Using Innodb Primary Keys wisely
At a customer site recently I came across the following table definition for an Innodb table. 140 columns, 3 part primary key totally 44 bytes, 2 million rows giving over 900MB in data size.
Read moreMySQL Camp T-Shirts
For those that attended the MySQL Camp at Google HQ late last year you may have seen me with my own T-Shirt designs. A number of people inquired about getting them.
Read moreMySQL Predictions for 2007
I’m interested to know what people consider will behold MySQL in 2007? The announcement of “You” as Time person of the year can only considered a huge boost to the opportunities in 2007.
Read morePluggable Storage Engines – What is the potential?
I started this post a month ago, but after Kaj’s discussion on the same topic at the MySQL Camp I figured it was time to post. I had dinner with a friend recently (a very smart friend), and our conversation lead him to ask “What’s different with MySQL?
Read moreThe desire for Performance SQL Tips
It seems, people are clammering for a more consolidated help guide for SQL Performance tips. Jay Pipes at the MySQL Camp ran a session Interactive Top 10 SQL performance Tips .
Read moreThe MySQL Joust
At our MySQL Camp Jay and Brian pitted off in the Umbrella Joust. Not sure if there was a winner, or a looser, but in the end no blood was split (except Leslie, but that’s another story).
Read moreThe Falcon!
Some early notes by Brian Aker on Falcon as discussed at the MySQL Camp . Falcon is a transactional engine MySQL will be introducing. The first discussions were held about 3 years ago with Ann Harrison and about 1 1/2 years ago, MySQL started taking seriously the possibilities.
Read moreDoxygen Project
What the? Well this is the inheritance diagram of the Item Class in the MySQL 5.1 Source tree, nicely documented using the Doxygen tool as mentioned by Jay in his presentation at MySQL Camp .
Read moreThe joys of working at Google
So, mid morning especially after having a heavy and late night drinking with new friends in Palo Alto I was seeking at Day #3 of the [MySQL Camp][1] a high-caffeine pick me up drink.
Read moreReturn to Google Lobby – Camp Photo
Early on Sunday Day #3, I dragged a few willing participants out for a “different photo” based on the umbrellas in each Lobby. It worked out well. Special thanks to Kynan who ran around to other lobby’s to find additional umbrellas.
Read moreMySQL Replibeertion
MySQL Replibeertion was the last scheduled session on Day 2, but not withstanding there was free beer (a lot of), there was a serious side with a Replication Discussion. One of the first questions by Jeremy was “Are the any big replication users?
Read moreDay 2 – Memorable Quotes
Continuing on from my Day 1 – Memorable Quotes from the MySQL Camp . “Are there any big replication users” — Jeremy “Are you calling me fat again” — Sheeri
Read more