20bits.com — When I read the last list of 10 tips for optimizing MySQL queries I wanted to scream. They were really bad. So, I spent an hour or so and wrote up my own list. I think it fares much better. What do you think?
Apr 10, 2007 View in Crawl 4
vannApr 10, 2007Submitter
Great idea! I'll start writing that tonight.
apotropaicApr 10, 2007
Oh the irony!! Wordpress is so full of unoptimized queries and crashes the page thats supposed to display top 10 tips for optimizing queries!
kickersnyApr 10, 2007
For the record, Digg itself uses MySQL. And PHP.
anastropheApr 10, 2007
sheez, the 'funny how his database is down, how ironic' comment was funny (and not _that_ funny) when the first poster made it. can y'all stop playing carlos mencia for a few minutes?the biggest problem in this case is WORDPRESS, which is great blog software, poorly coded. these people can't even generate a unified diff to do updates for crying out loud - you have to install the entire new version on top of your current version, then go through a ridiculous number of contortions to make sure it all works right. but i digress. wordpress will fall over and play dead if you cross your eyes at it. best thing these folks could have done would to have been to install the WP-cache plugin so that the page wouldn't have to be generated on the fly for each new connection. but i digress again.
beermadApr 10, 2007
Dugg for the useful suggestion about splitting tables with variable-length data.I now have a page built using blobs loading in 1.5 seconds instead of about 15.
vannApr 11, 2007Submitter
Also, it comes off like you're criticizing me for being *too* comprehensive. Haha. If that's the kind of criticism my blog posts engender, well, keep the insults coming!
dexterhollandApr 12, 2007
I found a Google Tech Talk video that gives you mysql perfomance tips with examples - its pretty cool. Titled "Performance Tuning Best Practices for MySQL" <a class="user" href="http://blog.sherifmansour.com/?p=72">http://blog.sherifmansour.com/?p=72</a>
dexterhollandApr 12, 2007
@dgath Jay Pipe's video is the one I am talking about. Watch it: <a class="user" href="http://blog.sherifmansour.com/?p=72">http://blog.sherifmansour.com/?p=72</a>
silverrocketApr 13, 2007
While not a query tuning idea, a big missing element to all these articles that help you 'speed up' MySQL is turning on the MySQL Query Cache. This alone can be the one single optimization required to get your database as fast as the wind once again...
yogastoreJun 27, 2008
<a class="user" href="http://astore.amazon.com/flowtron.mosquito-20">http://astore.amazon.com/flowtron.mosquito-20</a><a class="user" href="http://astore.amazon.com/flowtron.insect.killer-20">http://astore.amazon.com/flowtron.insect.killer-20</a><a class="user" href="http://astore.amazon.com/evaporative.air.cooler-20">http://astore.amazon.com/evaporative.air.cooler-20</a><a class="user" href="http://astore.amazon.com/air.swamp.cooler-20">http://astore.amazon.com/air.swamp.cooler-20</a><a class="user" href="http://astore.amazon.com/braun.electric.kettle-20">http://astore.amazon.com/braun.electric.kettle-20</a><a class="user" href="http://astore.amazon.com/cordless.electric.kettle-20">http://astore.amazon.com/cordless.electric.kettle- ...</a><a class="user" href="http://astore.amazon.com/canon.battery.charger-20">http://astore.amazon.com/canon.battery.charger-20</a><a class="user" href="http://astore.amazon.com/12.volt.battery.charger-20">http://astore.amazon.com/12.volt.battery.charger-2 ...</a><a class="user" href="http://astore.amazon.com/furniture.chaise.lounge-20">http://astore.amazon.com/furniture.chaise.lounge-2 ...</a><a class="user" href="http://astore.amazon.com/outdoor.chaise.lounge-20">http://astore.amazon.com/outdoor.chaise.lounge-20</a>