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: 317

Filed under:
|
|

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

Related posts about mysql

Related posts about scaling