Advise dealing with large DB?
-
My buddypress site has a database that is now over 7 GB.
I’m moving the site to a new server as it’s getting pretty slow and wondering what if there are things I could do to make it more efficient?
It’s been tracking activity since 2009 – any way to trim that to just past few months?
(I already block most spiders from paginating through that via robot.txt)I occasionally get crashed tables, and the current server fails for memory problems if I run a repair DB via command line – so it must be repair single table to make it work – (DB too bit for me to use phpmyadmin as well which sucks)
Should I consider splitting the site being hosted on one server with files and then move the DB to a separate web server or something?
Do I need to have a system that can dedicated 8GB or Ram just for the DB or something to make it better?
Maybe the new server move will be better – the old server is stuck on older centos/php – I was planning to move to a debian box with nginx – but read some docs this week that make it look flimsy for doing a multi-site that way perhaps. Another distro and caddy perhaps?
Anything else I should consider to make it run better? Any advise would be appreciated.
- You must be logged in to reply to this topic.
