title: Msql Partitioning - Key vs Hash vs List vs Range
body: <p>I went through some of the documentation of mysql but cannot understand the difference in the following ways of partitioning : Key vs Hash vs List vs Range.Can someone explain in pure english?</p>
  
  <p>Also we have the following table: How do we partition by forum_id?</p>
  
  <pre><code>CREATE TABLE IF NOT EXISTS `posts_content` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `post_id` int(11) NOT NULL,
    `forum_id` int(11) NOT NULL,
    `content` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=79850 ;
  </code></pre>
  
  <p>Thanking you</p>