· 8 years ago · Aug 27, 2018, 08:46 AM
1Msql Partitioning - Key vs Hash vs List vs Range
2CREATE TABLE IF NOT EXISTS `posts_content` (
3 `id` int(11) NOT NULL AUTO_INCREMENT,
4 `post_id` int(11) NOT NULL,
5 `forum_id` int(11) NOT NULL,
6 `content` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
7 PRIMARY KEY (`id`)
8) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=79850 ;