MaisonBisson

The built-in tools don’t support secure POP3, but Gmail requires SSL POP3. The fix? Postie.

APM Marketplace: news of a British model home. Highly insulated, carbon neutral, just 40% more$. Not just a demo, it’s going to be the law: all new UK buildings to must be carbon neutral by 2016. Economies of scale are said to reduce or eliminate the added cost by then.

After being down for fifteen years straight, milk consumption is up. Up big, and prices are rising to meet it.

New 160GB AppleTV. How far away are we from a standalone unit that can download from iTunes store directly, sync iPods, and write to USB-attached burners?

WWDC: Safari for windows!?!? Leopard looks sweet, but delayed ’till October. iPhone apps = web apps.

Presidential candidates chasing rural votes? Worth remembering that 60% of US libraries serve towns of 10,000 or fewer people.

R-Fed defeated, K-Fed mourns.

I missed the paper airplane contest in Concord NH today!?!?

Who wouldn’t enjoy a frozen mud slide on a hot summer day? Typical recipes call for crushed ice and cream or ice cream. For some reason, we decided to try making them from ice cream, from scratch.

The MaisonBisson Frozen Mud Slide

This recipe requires an ice cream maker, we used the Deni Scoop Factory.

• 1.5 cups heavy cream
• 1 cup milk
• 1 cup sugar
• .5 cups Bailey’s
• dash vanilla

Mix ingredients in bowl, then pour into ice cream maker’s freezer container. Follow your ice cream maker’s directions about time to freeze. Our Deni Scoop Factory was done in about 30 minutes. Spoon frozen ingredients into glass, add appropriate amounts of vodka and Kahlua and stir. Top with whipped cream and a cherry. Enjoy.

50MPH wheelchair ride in Michigan

Okay, now that we all know what a muffin top is, let’s learn about schaedenfatte:

Schaedenfatte: shaw-den-FAH-tuh, etym. from the German, schaedenfraude. (n.) 1. the feeling of pleasure upon seeing someone for whom one once held unrequited romantic and/or lustful feelings who has now become fat. 2. the taking of such pleasure.

With summer being the season of weddings (and, along with reunions, weddings being the place where people people who haven’t seen eachother for years cross paths…), I suppose you might also call it the season of schaedenfatte.

But in saying that I’ve probably set myself up for problems at every wedding I go to this summer. Hrm.

iblee points out that students want libraries.

asdasd

They vaccinate ducks against H5N1 bird flu, but not enough. It’s active again in Vietnam, where the first human case since 2005 has now appeared.

Why isn’t the US supporting regime change and democracy in Packistan? We’ve given General Perv US$10B in aid since 2001!

Bush gets queasy stomach when facing other world leaders at G8. The poor fellow is being shamed by his peers.

“Prosecuting a woman for ‘staring’ at a police dog is absurd,” said her lawyer. “People are allowed to make faces at police dogs and officers to express their disapproval. It’s constitutional expression,” said public defender Kelly Green, who represented Jayna Hutchinson. More: What’s up with police?

What Liberal Media author Eric Alterman arrested, mocked at GOP debates.

Libby to scoot in for 30 months. Is it enough?

“What is an atomic bomb good for?”

Yes, I’m still trying to squeeze more performance out of MySQL. And since small changes to a query can make a big difference in performance…

Here are two really easy things to be aware of:

• Never do a COUNT(*) (or anything *, says Zach). Instead, replace the * with the name of the column you’re searching against (and is hopefully indexed). That way some queries can execute entirely in the keycache (while * forces MySQL to read every matching row from the table).
• When joining two large tables, but only searching against one, put the join statement at the end. Why join the two entire tables when you only have to join the matching rows?

I mention these because, well, I’ve known them forever, but upon seeing them again I realized I hadn’t really obeyed those simple rules in some of my queries.

Separately, there’s some pretty good info on what server variables affect what at mysqlperformanceblog too.