Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Is 20 MB generally enough for a blog database in SQL Server or MySQL?

I want to deploy my blog on AppHarbor. But the free size of the database is 20 MB. I am not yet ready to pay $10/month for the 10GB database. My question is: would this be sufficient for a simple blog with one post a week?

I am not going to use any blogging engine. I will write my own engine with just posts in the database. I plan to use Disqus for comments.

like image 647
Abdulsattar Mohammed Avatar asked Feb 18 '11 11:02

Abdulsattar Mohammed


People also ask

How much memory do SQL servers have?

How much memory do SQL Servers have? The median SQL Server has 19% of the data size as RAM. Meaning, if it’s hosting 100GB of data, it has 19GB RAM in the server. (Max memory size and file sizes are discussions for another blog post.)

How much memory does the InnoDB database have?

Our database is big (20 GB dump file) and our current server has 64 GB of memory of which 58 GB is allocated to InnoDB buffer pool, which is all used. Should I add more RAM on the machine - Quora

How much SQL Server data should you leave to the OS?

In our SQL Server Setup Guide, we tell folks to leave at least 4GB to the OS, and I think most sysadmins would consider 2GB to be the bare minimum. But still, the dropping percentages as data grows – that’s pretty steep.

Why is MY SQL Server using 47gb of memory?

SQL server tendency is to use all the memory but out of 50GB it is using 47GB, does that mean that there is a OS memory pressure that’s why SQL is releasing some memory..? Reply Jonathan Kehayiassays: March 2, 2021 at 1:08 pm The value you have set for Max Server Memory is higher than I would recommend.


4 Answers

That's basic math, really.

One post a week of say 10kB per post, would make you last 200 weeks. Mutatis mutandis:

          D bytes per database
---------------------------------------  = weeks per database
(N posts per week) x (S bytes per post)
like image 164
xtofl Avatar answered Nov 07 '22 15:11

xtofl


It should be enough. Consider that our blog (wordpress based) has almost 1000 posts and around 1000 comments. And the database is less than 5 MB.

like image 23
Matteo Alessani Avatar answered Nov 07 '22 13:11

Matteo Alessani


yes, 20MB of data is a lot of data (if it's text based).

like image 34
Augusto Avatar answered Nov 07 '22 13:11

Augusto


If you're just using text, no images or media, that should be fine. It takes a lot of text to reach 20MB...

Roughly it gives you 4,194,304 words to play with (given 1 byte per character, average of 5 characters per word)

like image 33
TimCodes.NET Avatar answered Nov 07 '22 14:11

TimCodes.NET