MySQL Forums
Forum List  »  Newbie

Re: is 16 gb ram enough for handing mysql database of size 100 gb having myisam as storage engine ?
Posted by: Ronald Brown
Date: October 15, 2014 08:43PM

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 ;

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.