OurSQL Episode 2: Wild Performance Tips

Episode 2 of OurSQL: The MySQL Database Podcast is here! It’s a bit late due to a computer crash and the fact that I sprained my ankle, but I think it’s worth waiting for. Particularly since this week’s feature is everyone’s favorite — performance tips!

It’s best to subscribe to the podcast by clicking the “podcast” graphic at http://www.technocation.org , or searching for “mysql” in your favorite podcast directory (including iTunes). But if you want to play episode 2 in your browser, visit http://technocation.org/index.php?option=com_content&task=view&id=22&Ite...

Please consider promoting the show — we have a 40 second promo ready for download at:

http://www.technocation.org/podcasts/oursql/OurSQLpromo1.mp3
Show Notes:
News

http://www.mysqlconf.com/

Free Survey, win a free pass

http://www.zoomerang.com/recipient/survey-intro.zgi?p=WEB225WZRG2XU7

You can now find this podcast, OurSQL, on many podcast sites including:

http://www.itunes.com

http://www.podcastalley.com

http://www.podfeed.net

http://www.podcastblaster.com

http://www.pod-planet.com

just search for “mysql” on any of those sites and you’ll find the podcast. You can also find it at:

http://feeds.feedburner.com/oursql

Learning Resource

Promo

http://www.tech-in-sight.com/

Feature
Tip #1 - % near the beginning of a LIKE comparison

Tip #2 - count(*) and InnoDB Tables
Peter Zaitsev’s blog post about count for InnoDB tables:
http://www.mysqlperformanceblog.com/2006/12/01/count-for-innodb-tables/

Tip #3
SELECT * and INSERT without naming column names

Acknowledgements/Sponsors

http://www.technocation.org

http://music.podshow.com

http://www.russellwolff.com

http://www.smallfishadventures.com/Home.html “The Thank you song” — Smallfish

You can Direct download oursql podcasts at:
http://technocation.org/podcasts/oursql/

If you have any feedback about this podcast, or want to suggest topics to cover in future podcasts, please email

podcast@technocation.org

You can also:

Call the comment line at +1 617-674-2369

Or use Odeo to leave a voice mail through your computer:
http://odeo.com/sendmeamessage/Sheeri

Or use the Technocation forums:
http://www.technocation.org/forum


Fatal error: Class 'CToolsCssCache' not found in /home/sheeri/technocation/includes/cache.inc on line 32