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.
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.)
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
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.
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.
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)
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.
yes, 20MB of data is a lot of data (if it's text based).
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)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With