Re: is 16 gb ram enough for handing mysql database of size 100 gb having myisam as storage engine ?
Thanks for the detailed explanation,
1) last time i used innodb with db of size 12 GB and RAM 8 gig server used to be bloated all the time i was using readymade CMS . i dont have much detial now , but i had set innodb_buffer_pool_size 70% of RAM
2) Wont it make system unstable if i set “innodb_buffer_pool_size” on MySQL smaller than DB size or bigger than RAM ?
what i mean is , isnt it necessary to use innodb_buffer_pool_size or RAM bigger than the database size ? in innodb
here is the create table
--
-- Table structure for table `content`
--
CREATE TABLE IF NOT EXISTS `content` (
`hash` char(40) COLLATE utf8_unicode_ci NOT NULL,
`title` char(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`og_name` char(255) COLLATE utf8_unicode_ci NOT NULL,
`keywords` char(255) COLLATE utf8_unicode_ci NOT NULL,
`files_count` int(11) NOT NULL DEFAULT '0',
`more_files` int(11) NOT NULL DEFAULT '0',
`files` char(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
`category` int(11) NOT NULL DEFAULT '600',
`sub_category` int(11) NOT NULL DEFAULT '607',
`size` bigint(19) NOT NULL DEFAULT '0',
`downloaders` int(11) NOT NULL DEFAULT '0',
`completed` int(11) NOT NULL DEFAULT '0',
`uploaders` int(11) NOT NULL DEFAULT '0',
`creation_date` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
`upload_date` datetime NOT NULL,
`last_updated` datetime NOT NULL,
`vote_up` int(11) unsigned NOT NULL DEFAULT '0',
`vote_down` int(11) unsigned NOT NULL DEFAULT '0',
`comments_count` int(11) NOT NULL DEFAULT '0',
`imdb` int(8) NOT NULL DEFAULT '0',
`verified` int(11) NOT NULL DEFAULT '0',
`uploader` int(11) NOT NULL DEFAULT '0',
`enabled` int(11) NOT NULL DEFAULT '1',
`tfile_size` int(11) NOT NULL DEFAULT '0',
`record_num` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`record_num`),
UNIQUE KEY `hash` (`hash`),
KEY `title_2` (`title`),
KEY `upload_date` (`upload_date`),
KEY `uploaders` (`uploaders`),
KEY `downloaders` (`downloaders`),
KEY `category` (`category`),
KEY `sub_category` (`sub_category`),
FULLTEXT KEY `title` (`title`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=FIXED AUTO_INCREMENT=5004 ;