Databases
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 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 moreMySQL Camp – Introductions & Comments
The great thing about this unconference, is the lack of total formal structure. For now , our first session we are having an open introduction of people, there are at good 60+ people here already, and people rolling in, and it’s great to hear people’s background, and also to bag Jeremy Cole at every opportunity.
Read moreMySQL Quotes
Frank was on a role with MySQL quotes (it’s 1am here in New York – All that Red Bull & Vodka). Here are some of them: Let me scale you!
Read moreThe impact of Mathematics in our RDBMS world
We sometimes forget the impact of early mathematicians. Take for example John Venn who introduced the Venn diagram in 1881. This is fundamental for Set Theory, and also fundamental for SQL, the basis of retrieving data in a RDBMS.
Read moreLog Buffer #13: a Carnival of the Vanities for DBAs
Unlike fellow author Giuseppe of last week’s Log Buffer #12 I volunteered for the job of this week’s Log Buffer . Lots to say, so little time, so lets get started with Log Buffer #13.
Read moreIf you can’t beat them, join them!
Like fellow friends and MySQL’ers before me Morgan, Roland, Giuseppe, Markus and Sean , I’ve joined the MySQL juggernaut on the ride of my life, achieving two of my short/medium term professional goals in one step.
Read moreLogical Data Modelling (LDM)
Following my User Group Presentation I was asked by fellow MySQLer Kim about Logical Data Modelling (LDM), in relation to Physical Data Modelling. Well, first the brain had to work overtime to remember when was the last time I worked on a Logical Data Model.
Read moreThe Hobbyist and the Professional
I first coined this term in February 2006 in a paper titled “Overcoming the Challenges of Establishing Service and Support Channels” for the conference “Implementing Open Source for Optimal Business Performance” View Paper.
Read moreSlow Queries aren’t always that bad!
Well, now I have your attention, Slow Queries are bad (unless it’s a single user system and you don’t care). However there are worse things then slow queries in a large enterprise system.
Read more