Speeding up InnoDB table imports

We switched to InnoDB tables a while ago. They offer transactions, foreign key constraints and a few other goodies that are missing from MyISAM. We knew writes would be slower due to foreign key checks, etc, but we didn’t imagine that importing a table with about 160,000 records would take almost an hour to import, while it only took about 15 seconds to import using MyISAM. I did some digging and figured out the solution. Add these lines to your dumps.

SET AUTOCOMMIT=0;
SET UNIQUE_CHECKS=0;
SET FOREIGN_KEY_CHECKS=0;

... Your dump here ...

COMMIT;
SET AUTOCOMMIT=1;
SET UNIQUE_CHECKS=1;
SET FOREIGN_KEY_CHECKS=1;

This sped up InnoDB imports to pretty much the same speed as MyISAM imports for the table in question.

2006 Kirkland Tri-It Triathlon

My heat in the water

Above is a picture of me as I and about 60 others start the 2006 Kirkland Tri-It Triathlon. The Tri-It differs from a regular sprint triathlon in that the swim is 0.25 miles instead of 0.50 miles. The race started off with a 0.25 mile open water swim in Lake Washington, followed by a 12 mile bike ride through the city of Kirkland, WA and finished with a 5k run along the shores of Lake Washington.

My training included miles and miles of running, biking and swimming. I’d bike 20 miles and then run 2.8 miles or I’d run 5.6 miles and throw a 0.25 mile swim in the middle for fun. Most of my training I did on my own, which I think makes this all the more of an accomplishment. I didn’t race because a friend of mine was racing and training. I trained and raced to prove to myself that I could do it. I did this for me.

I got out of bed at 5AM Sunday morning to get over to the race for registration. After setting up in the transition area I wandered around for a bit, chatted with a few of the other participants and got myself a coffee. At 6:45AM I went over for the pre-race briefing and watched the first of fifteen heats start, which was the “elite” heat. My heat, the Tri-It heat, which is for beginners like myself, was the last heat to take off at 8:00AM.

After meeting up with Carly and John to hand them my camera and phone I went off to wait for my heat. A short time later I was 50 yards from shore swimming for the first time in a wetsuit. I felt like I had a motor attached to me. The wetsuit kept me warm and boosted me out of the water, which I swear made me faster.

A short change later and I was running my bike out of the transition area starting my 12 mile bike ride. The ride was simply amazing. I was making decent time and taking full advantage of my aero bars on some of the flats and longer downhills. This was by far, for me, the most fun part of the race, but that’s probably because I like my bike so much.

The transition from biking to running was by far the worst. I’ve heard about your legs being all messed up during this transition and it’s true. My legs felt like putty and my left calf started cramping up. For the first few hundred yards I ran peg legged to get over the cramping. After that it was smooth sailing all the way to the finish.

So how did I do? Well, for my first triathlon I’d say first place is a pretty good way to start things off (No, it’s not April 1st, the original results proves that). Granted this is amongst a field of all beginners (including me) of all ages, but I’m still quite happy with the results. You can view the entire photo set over at Flickr.

I’d like to make a special thanks to John and Carly who climbed out of bed before 7AM on a Sunday morning to come to the race, take pictures and cheer me on. I’d also like to thank my training buddie, Ben, who introduced me to The Hill. The Hill made the run seem like a joke.

Crossing the finish line. I'm tired.

The triathlon has arrived

I recently mentioned that I was going to be participating in my first triathlon. A sprint triathlon to be specific. To be even more specific, I’ll be participating in the Kirkland Triathlon at Carillion Point. Since it’s my first triathlon I’m planning on doing the non-competitive version which I still find daunting. It starts with a 0.25 mile open water swim in Lake Washington followed by a 12 mile bike ride through the streets of Kirkland and finishes up with a 5k run.

I’ve been following a fairly stringent training program. I haven’t been drinking during the week, I’ve been bricking events, etc. My normal training routes include 13 miles on the bike and a 2.8 mile run around Green Lake or a 2.6 mile run down Madison to Madison Park, a 500 meter open water swim and then 2.6 miles back up Madison, which is about 400 feet of elevation difference. To gauge my training I ended up running the Lynnwood Hi-5 5k Fun Run. In early June I ran a 27:29 during my first 5k. During my second 5k a few weeks ago I ran a 23:44 and placed 12th out of a field of 77. Clearly, my training is going well.

Well, it was going well until about 1.5 weeks ago when condo projects and, in general, life started to get into the way. Recent attempts were foiled by a lack of a bike lock one day and a popped bike tire the next day. The condo projects have really put a damper on my back and my legs aren’t in great shape, but I’m resting for the rest of the weekend.

Overall, I’m a bit worried and really excited to compete in this race. It’s by far one of the most challenging physical tests I’ve ever put myself through. At the very least, I’ll complete it. I’m currently hoping to finish in 1:45:00. I shall post pictures and a followup on Monday if I don’t die.

My new ride

Trek 5200

To say that I’m excited to get this hot ass ride out onto the road would, quite possibly, be the understatement of the century. This is, essentially, the same bike that Lance Armstrong road to victory in the Tour de France. I found her on craigslist, of course, and snapper her up for a song. I’m a bit intimidated by the bike since I’ve never ridden a proper road bike and the aero bars pretty much freak me out, but you know I’m going to give it the ‘ol college try!

How to tell if you have great friends

I've got great friends

Dana, being the man that he is, sent me a special package overnight. The contents of which can only be truly appreciated by eating said contents. He sent me California burritos from Ramiro’s in San Diego. For the uninitiated, California burritos are regular cheese/meat burritos with french fries added to them. When mixed with the hot sauce provided they provide an absolutely orgasmic mixture of cheese, meat, grease and spices. Thanks D!

Stump does PDX

The last time I took days off was in April so it was definitely time to take a few days off and get out of town. I decided it was time to finally fully explore the wonders of Seattle’s little brother, Portland. I have to say I’m thoroughly impressed.

I met a bunch of new people, hung out with some current friends, and, oddly enough, re-connected with an old friend from college. Kate and I actually went to our dorm’s semi-formal together at the ripe old age of 19. The pictures are terrifying.

Looks like Garren and I will be making it down for the beer festival on the water this weekend as well. Now, rounding out the post is Kate singing karaoke.

Stem Cell Research

Today came the news that President Bush, for the first time in five years, has actually vetoed a bill presented to him. He finally broke down and used his veto power to veto a bill that would allow people to donate unused embryos to science.

“This bill would support the taking of innocent human life in the hope of finding medical benefits for others,” Bush said Wednesday afternoon. “It crosses a moral boundary that our decent society needs to respect. So I vetoed it.”

Currently, people can either donate their unused embryos to barren women (so called “snowflake” babies) or have them destroyed. How is that any different than the supposed taking of an innocent human life he talks about with regards to science?

Best. Obit. Evar.

Frederic Arthur (Fred) Clark, who had tired of reading obituaries noting other’s courageous battles with this or that disease, wanted it known that he lost his battle as a result of an automobile accident on June 18, 2006. True to Fred’s personal style, his final hours were spent joking with medical personnel while he whimpered, cussed, begged for narcotics and bargained with God to look over his wife and kids. He loved his family. His heart beat faster when his wife of 37 years Alice Rennie Clark entered the room and saddened a little when she left. His legacy was the good works performed by his sons, Frederic Arthur Clark III and Andrew Douglas Clark MD, PhD., along with Andy’s wife, Sara Morgan Clark. Fred’s back straightened and chest puffed out when he heard the Star Spangled Banner and his eyes teared when he heard Amazing Grace. He wouldn’t abide self important tight *censored*. Always an interested observer of politics, particularly what the process does to its participants, he was amused by politician’s outrage when we lie to them and amazed at what the voters would tolerate. His final wishes were “throw the bums out and don’t elect lawyers” (though it seems to make little difference). During his life he excelled at mediocrity. He loved to hear and tell jokes, especially short ones due to his limited attention span. He had a life long love affair with bacon, butter, cigars and bourbon. You always knew what Fred was thinking much to the dismay of his friend and family. His sons said of Fred, “he was often wrong, but never in doubt”. When his family was asked what they remembered about Fred, they fondly recalled how Fred never peed in the shower – on purpose. He died at MCV Hospital and sadly was deprived of his final wish which was to be run over by a beer truck on the way to the liquor store to buy booze for a double date to include his wife, Rush Limbaugh and Ann Coulter to crash an ACLU cocktail party. In lieu of flowers, Fred asks that you make a sizable purchase at your local ABC store or Virginia winery (please, nothing French – the *censored*) and get rip roaring drunk at home with someone you love or hope to make love to. Word of caution though, don’t go out in public to drink because of the alcohol related laws our elected officials have passed due to their inexplicable terror at the sight of a MADD lobbyist and overwhelming compulsion to meddle in our lives. No funeral or service is planned. However, a party will be held to celebrate Fred’s life. It will be held in Midlothian, Va. Email fredsmemory@yahoo.com for more information. Fred’s ashes will be fired from his favorite cannon at a private party on the Great Wicomico River where he had a home for 25 years. Additionally, all of Fred’s friend (sic) will be asked to gather in a phone booth, to be designated in the future, to have a drink and wonder, “Fred who?”

Via Richmond Times-Dispatch. Despite the Limbaugh/Coulter remark I give this obituary high marks. I’d like my friends to take note.

Operation Fat Ass Nearly Complete

fat_to_phat

It started about three years ago. My weight was out of control and it was time to do something about it. I dieted, exercised and, most importantly, changed my habits. I didn’t eat fast food nearly as much. I ate smaller portions. I exercised a few times a week as opposed to not exercising at all. What you see above is the current status of the infamous Operation Fat Ass. I’m down just under 45 pounds, just completed my first 5k and am currently training for my first triathlon.

War on drugs going well

I was reading an about recent drug busts at the Canadian border that utilized helicopters and planes. Buried within the article is some evidence on just how well the War on People Ingesting Stuff We Don’t Like Them Ingesting is going.

Despite the arrests, investigators this week conceded that they have not stopped the practice and are unlikely to ever do so.

So, let me get this straight, what you’re doing isn’t stopping this practice and it’s unlikely to do so? There’s a term for this: failure. Please insert my usual comment here about how drugs should be legalized, regulated and taxed like booze and cigarettes. Oh and the entire budget for War on People Ingesting Stuff We Don’t Like Them Ingesting could maybe go into education. Of course, we all know that only backwards third world countries with horrific crime rates and low life expectancies decriminalize drugs right? Places like Canada, Switzerland, the Netherlands and Mexico.

And don’t get me started on how much it costs to house potheads in prison. What a perfectly awesome way to waste my tax dollars.