Our forum's Database is around 1.4G and we have had issues of different kinds with each shared hosting company we have used. The last issue was with MySQL errors and the hosting provider suggested clearing the system cache (which seemed like a totally off the wall suggestion)...
Lately, the site has been slowing down when posting or moving messages. Clearing the cache may improve things for a while (perhaps a day) and then things start slowing down again...
I have the cache clearing task running every 5 minutes now, however, the cache itself does not appear all that large, compared to the total database size...
Is it time to consider a VPS? If yes, what specs should I be looking at for:
Cores
Ram
HD
Bandwidth
and, are there recommended settings for MySQL? Or, is MarinaDB a better choice, and does it have recommended settings for vBulletin?
FYI, we are running 5.3.4 at this time - is there anything in the later versions that addresses performance issues? We have avoided updates as we would prefer to not have to take the forum down for maintenance...
Thanks for any info anyone has about this!
Lately, the site has been slowing down when posting or moving messages. Clearing the cache may improve things for a while (perhaps a day) and then things start slowing down again...
I have the cache clearing task running every 5 minutes now, however, the cache itself does not appear all that large, compared to the total database size...
Is it time to consider a VPS? If yes, what specs should I be looking at for:
Cores
Ram
HD
Bandwidth
and, are there recommended settings for MySQL? Or, is MarinaDB a better choice, and does it have recommended settings for vBulletin?
FYI, we are running 5.3.4 at this time - is there anything in the later versions that addresses performance issues? We have avoided updates as we would prefer to not have to take the forum down for maintenance...
Thanks for any info anyone has about this!
Comment