Optimizing vB database

[Whatah]

our site www.yugiohforums.com
currently running vB 3.8.4 patch level 2
Treads: 37,922, Posts: 562,787, Members: 15,793

According to our host, with our activity (100 online members + 300 guests) and our database size (2,000,000 lines) we are hitting the limit of shared box hosting.

We are starting to get "500 Server Error" from time to time, according to our error logs it is because we are exceeding max_user_connections (50) caused (according to our host) by the size of our database.

I figure that part of the issue is database size, and other part is number of queries.

We have a few major modifications like CybChatbox, v3 Arcade, vBExperience, and vB Optimize.

We also get some active "+++++ game" threads that hit 1k or 2k posts before the game ends. Would it be possible to improve the database performance by moving some of the very large threads to an non-active subforum where posting is not allowed?

Or should i focus on removing some forum modifications that are adding queries? My host is pointing primarily to the size of the database rather then number of queries so I would love a second opinion before i commit to removing the vBExperience or Chatbox mods.



Thanks for any insight.

[ChopSuey]

Run repair/optimize tables via admincp until all say OK

[Marco van Herwaarden]

Database size should hardly make a difference. The real problem here is that your host is limiting you to max 50 connections.

[Whatah]

usually i run repair whenever we get a database error.

this morning i logged into cpanel and saw that we were listed as having zero database instead of our normal 3. obviously the forum was not working lol

i went to the mysql link where we repair databases and there were none in the dropdown.

10 minutes later, while i was on the phone with hsot support, the site was working. the databases were selectable to be repaired in the drop-down. strange thing is that even now, on the main cpanel page, we are listed as "SQL Databases 0 / 50 " even though currently the site is working and when i go into mySQL databases they are of course there to be selected and repaired

host said that since the queries usually just take a few miliseconds that 50 connections is considered reasonable for a shared host solution. up until a week ago we didnt ave any trouble at all.

we have about 10k posts in our junkyard trash forum that we will clear out, that should provide a small database size reduction.

on the phone this morning i actually did get someone from host support to admit that they have been having issues with this box since friday. now all i need is for them to fix it would trying to blame it on our site



thanks a ton for the information and feedback

[Marco van Herwaarden]

Once more: Database size is not related to this.

Also you should only be repairin a database when it is really needed. Doing so on each DB error you get can even have the opposite effect and corrupt your database.!!