Docunext

  • About

High Performance MySQL by Jeremy Zawodny

June 2nd, 2007

I'm reading Jeremy Zawodny's "High Performance MySQL" via Oreilly's online Safari service. Its quite good, and I really enjoyed the page on indexes I just read. I learned that you can index on sub-content in certain columns. For example, say I have a column that stores email addresses. Many email addresses share domain names, while the username, or the part that comes before the domain name, can be more unique. In this case, it may be just as effective to only store the first, say 8-10 characters of the email column rows in its index. That way, you'll save some space. Cool, huh?

Yearly Indexes: 2010 2003 2005 2006 2007 2008 2009 2004 2011 2012 2013 2015 2019 2020