In this episode we tackle what a hash looks like in terms of a data structure, in preparation for next episode’s discussion on the difference between hashes and btree indexes, and what kind of indexes are good for what kind of optimizations.
Show Notes:
Direct play this episode at:
http://technocation.org/content/oursql-episode-17%3A-hashing-it-out-0
Download all podcasts at:
http://technocation.org/podcasts/oursql/
Subscribe to the podcast at:
http://feeds.feedburner.com/oursql
News:
MySQL Connector/NET 5.1.1 released:
http://tinyurl.com/23a9ax
Download the new Connector/NET version:
http://dev.mysql.com/downloads/connector/net/5.1.html
MySQL 5.0.x security vulnerability:
http://bugs.mysql.com/bug.php?id=27513
Solution: upgrade to 5.0.40. This bug is not known to affect major versions 3 or 4.
Learning Resource:
http://onlinesolutionsmysql.blogspot.com/
The dates for the all the sessions:
* 27th March: Part 1 – High Availability and Scalability Architectures
* 19th April: Part 2 – Advanced Scalability Solutions
* 2nd May: Part 3 – MySQL Enterprise To Control Mission Critical Online Services
* 23rd May: Part 4 – 99.999% High Availability solutions
* 13th June: Part 5 – MySQL Enterprise performance and benchmarking
* 27th June: Part 6 – Advanced HA solutions
Find all the material and documentation for past webinars at:
http://onlinesolutionsmysql.blogspot.com/2007/03/links-to-material-and-documentation.html
Feature: Hash tables explained.
http://www.sparknotes.com/cs/searching/hashtables/section1.html
http://www.cs.sunysb.edu/~algorith/lectures-good/node7.html (search for “Hash Tables” on the page)
Feedback:
Email 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://technocation.org/forum