For some reason I always put the cart in front of the horse. In this case, I'm referring specifically to the use of MySQL and its database storage engines. Since I was excited to begin my development on the new site, I blindly chose MyISAM as my database engine of choice for MySQL.

At the time, I didn't really care because I just wanted to get things of the ground and everything seemed to work. Hey, if it ain't broke, don't fix it, right? Wrong!!! Once I got into testing and added more complexity to my web application, I needed transactional and foreign key support, something MyISAM doesn't support. I wasn't sure what I was getting myself into, but since I tend to be bothered when something isn't perfect, I decided to go for it and move from MyISAM to the InnoDB storage format.