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