I am working on the design of a Wordpress blog which when finished will almost-always serve pages from disk cache and this is because all posts will be published in batch and then cached, with at least 5 hours between batches.
Database size is only 30MB at the moment as this is a new blog.
My server options are two:
a. Either a 4GB RAM server with an SSD or
b. An 8GB RAM server with a normal HDD.
Am I right in assuming that since pages will almost-always be served from disk cache, SSD is a better option?
Or maybe I should still go for more RAM?
I ask because years ago I worked on a blog generating almost 2m pageviews per month and when it was crashing we identified the heavy HDD usage as the problem. In fact after tweaking innodb_buffer_pool_size so as to use more RAM and less disk, we never had any more issues.
Edit By RolandoMySQLDBA
Please run this query
select var,concat(numunit,' ',unit) size from ( select var,format(num/power(1024,ex),2) numunit,SUBSTR(units,ex*2+1,2) unit from ( select var,num,FLOOR(LOG(IF(num=0,1,num))/LOG(1024)) ex from ( select variable_name var,variable_value*pagesize num from information_schema.global_status AAA, ( select variable_value pagesize from information_schema.global_status where variable_name='innodb_page_size' ) BBB where AAA.variable_name like 'innodb_buffer_pool_pages%' ) AA ) A,(select 'B KBMBGBTB' units) B ) M;
and post its output so was can see the Buffer Pool's current usage.
Also, please run
The blog is still on the development machine so I believe the first query is of no use. I can provide the result of the second though:
+------------+ | VERSION() | +------------+ | 5.6.16-log | +------------+ 1 row in set (0.03 sec)
It will be the very latest version when we go in Production.