Four Year Strong Posted January 24, 2012 Share Posted January 24, 2012 My site is running 3.1.4 and according to my host,"MySQL is taking up more then 90% of the daily server processes. " Is there anyway of reducing this? Link to comment Share on other sites More sharing options...
Grumpy Posted January 25, 2012 Share Posted January 25, 2012 You can 1. Hire a sysadmin to help you. 2. get mysqltuner (google it) and follow it's advice. 2.5 or post results here asking for others advice. 3. Upgrade hardware 4. Upgrade IPB... I've seen few posts in this forum where people are saying 3.2 is faster. Link to comment Share on other sites More sharing options...
Clickfinity Posted January 25, 2012 Share Posted January 25, 2012 My site is running 3.1.4 and according to my host, [size=4]"MySQL is taking up more then 90% of the daily server processes. " [/size] Is there anyway of reducing this? Are you on a shared server (or VPS) or a dedicated server that is all your own? Link to comment Share on other sites More sharing options...
Four Year Strong Posted February 1, 2012 Author Share Posted February 1, 2012 Are you on a shared server (or VPS) or a dedicated server that is all your own? It's a VPS. We were previously on a cloud server with liquidweb that gave us no troubles at all. We will be switching servers soon, thus why I would like to get the size of the DB down. It's currently 800mb. :cry: Link to comment Share on other sites More sharing options...
bfarber Posted February 23, 2012 Share Posted February 23, 2012 You are trying to reduce the size of the database? Prune old members, old posts, and old logs. Those will net you the biggest gains if you are trying to get the actual size down. Start with logs, of course, since losing those doesn't generally affect anything else. Link to comment Share on other sites More sharing options...
.thumb.png.72c24494603afd7a572d55d4a71e4af2.png)
Recommended Posts
Archived
This topic is now archived and is closed to further replies.