Msql Partitioning - Key vs Hash vs List vs Range
        Posted  
        
            by 
                Imran Omar Bukhsh
            
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by Imran Omar Bukhsh
        
        
        
        Published on 2011-06-28T05:47:25Z
        Indexed on 
            2011/06/28
            8:22 UTC
        
        
        Read the original article
        Hit count: 428
        
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?
Also we have the following table: How do we partition by forum_id?
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 ;
Thanking you
© Stack Overflow or respective owner