Home

OurSQL Episode 18: De-myth-tifying Indexes

Posted July 12th, 2007 by sheeri

Feedback:

Email podcast@technocation.org">podcast@technocation.org

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

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

Episode 18: De-Myth-tifying Indexes

Where I have been:
Wedding video (short) and photos:
http://www.sheeri.com/wedding

Honeymoon (and wedding) photos:
http://www.sheeri.com/photos

News:
FREE training for Oracle DBAs who want to learn MySQL
http://www.planetmysql.org/robin/?p=51
http://www.mysql.com/oracle/

mysqlnd (PHP native driver) needs testers and benchmarkers:
http://www.planetmysql.org/kaj/?p=117

Learning Resource:
The MySQL category at howtoforge.com:
http://www.howtoforge.com/taxonomy_menu/1/7

Podcast Promo:
http://www.themysqlguy.com

Feature:

Big O notation:
http://www.eecs.harvard.edu/~ellard/Q-97/HTML/root/node8.html

BTREE Index podcast:
http://technocation.org/index.php?option=com_content&task=view&id=51&Ite...

HASH Index podcast:
http://technocation.org/index.php?option=com_content&task=view&id=61&Ite...

Quote:
http://www.helpothers.org/story.php?sid=6784

Music:
The main theme used is Angry Red Dwarf’s “I Dream About You”
http://tinyurl.com/26hbg6

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

Trackback URL for this post:

http://technocation.org/trackback/88
OurSQL Episode 14: The MySQL Conference & Expo
from Technocation, Inc. on September 29, 2007 - 18:47
OurSQL Episode 22: Things To Avoid With MySQL Queries
from Technocation, Inc. on September 29, 2007 - 18:03
OurSQL Episode 15: Eben Moglen's Keynote at the 2007 MySQL Conf
from Technocation, Inc. on September 29, 2007 - 13:32

Please don't kill yourself,

On July 12th, 2007 technocation says:

Please don't kill yourself, it's only a podcast.

Try fast forwarding through the parts you don't like; I don't put much personal content in there, but I was asked by longtime listeners to put more personal stuff in there.

Also, try downloading other episodes and see how you like them. This episode has a few more administrative details because I've changed a few things about the podcast and have a few more features than usual. Plus there's a longer blooper that usual at the end, usually the bloopers are much shorter. In fact, this podcast is the longest yet, clocking in at over 21 minutes.

19 episodes that are anywhere from 10-20 minutes long, (let's say an average of 15 minutes) comes to 285 minutes. 33% of 21 minutes is 7 minutes. 7 minutes you don't like out of 285 means that 97.54% of what I do is OK and you don't like 2.46%.

2.46% is very small, so thanx for the compliment that you like 97.54% of what I do!

Post new comment

The content of this field is kept private and will not be shown publicly.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd> <object> <embed> <script>

  • You can use "object", "embed" and "script" tags from the following sites to add media from the following sites to your posts:

    • http://www.youtube.com
    • http://youtube.com

  • Lines and paragraphs break automatically.
  • You may use <swf file="song.mp3"> to display Flash files inline
  • Avast! This website be taken over by pirates on September 19th. Yarr!
  • Each email address will be obfuscated in a human readable fashion and replaced with a spamproof clickable link, without loosing the mailto URL scheme semantics and operations.
  • You may post code using <code>...</code> (generic) or <?php ... ?> (highlighted PHP) tags.

More information about formatting options

Captcha
This question is for testing whether you are a human visitor and to prevent automated spam submissions.
2 + 1 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.