Okay, so it turns out I don't need nearly as much RAM as I expected on my site's VPS, so I'm looking at using some of the extra funds on a MySQL VPS instead, as my site's main demand is a forum, so fairly database dependent.
Anyway, I have no idea what to expect from a MySQL VPS however, so I'm curious to know if anyone has any advice on how I should estimate what I would need? I believe you get a week long free trial for a MySQL VPS just like a regular one, but I'd like to have as much information going in as I don't really want to do the trial only to have to switch back if it doesn't work out.
However, I have no idea how I would go about getting an idea for how much RAM my MySQL server would need. That is if I even "need" more RAM at all, or does more simply mean a faster database?
So ehm… yeah, I know plenty about how to use a MySQL database, but next to nothing about how to run the actual MySQL server (aside from installing and starting one), so any advice on estimating what resources I need will be much appreciated!