Need Input with a forum Database vbulletin

[Googledeez]

My board was recently taken off line because I am "draining a lot of resources from my shared hosting."

My database is 430 MB and this is the problem. Is is "too large" according to my hosting company.


What am I to do or what should i do?

This is the message I got


Upon further investigation, it turned out that the following queries in your account are slow and heavily consume server resources:

# Time: 070722 17:16:05
# User@Host: ****[*******] @ localhost []
# Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
use **********;
SELECT title, template
FROM template
WHERE templateid IN (4983,5188,5024,5025,5191,5026,5193,5018,5196,5197,5198,5199,5200,5195,5527,5523,5048,5296,4984,5263,5433,5436,5445,5282,5283,5284,5285,5396,5450,5449,5451,5454,5533,4757,4988,4993,2271,0,5515,5517,5520,3530,4940,4791,4792,4793,4794,4795,4796,4797,4798,4799,4800,4801,4802,5034,4859,4909,4910,5045,5044,5455,5489,5490,5491);
# User@Host: ******[************] @ localhost []
# Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
SELECT moderator.*, user.username,
--
# Time: 070722 17:18:57
# User@Host: ******[**********] @ localhost []
# Query_time: 4 Lock_time: 0 Rows_sent: 1 Rows_examined: 39761
select userid from user where username regexp "^(&[\#0-9a-z]*;|[^a-z0-9])*[c�]([u���|u|��r[i����][o������]([u���|u|��[s](&[\#0-9a-z]*;|[^a-z0-9])+t(&[a-z]*;|[^a-z0-9])*$" limit 1;
# Time: 070722 17:21:34
# User@Host: *******[******] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
SELECT title, template
--
# Time: 070722 17:21:36
# User@Host: ******[*********] @ localhost []
# Query_time: 2 Lock_time: 0 Rows_sent: 32 Rows_examined: 64
SELECT *******.*, user.username,
--
# Time: 070722 17:29:54
# User@Host: *******[****] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 1 Rows_examined: 46973
use ******;
SET timestamp=1185143394;
SELECT count(*) AS 'JoinsThisMonth'


This means that your case is the one having a large database, approximately 430MB. In order to have the limitations removed, please optimize your script or reduce the size of the database.



What can I do to optimize this or maybe solve my problem? Should I get better hosting?

[cyanide]

The problem, is most hosts don't create enough room in the database partition to accomodate large databases like yours. Most people don't need it :)

How much bandwidth are you using? And how many concurrent visitors?
What's your budget.?

I might be able to help you out as we have alot of clients with large databases, so we have the room.

[Googledeez]

Bandwidth is at 20,000 MB (average) monthly

Concurrent visitors is about 20 on a good day.

I do, however, get a ton of guests and I have guest replies enabled. So a lot of my guests are replying, and staying browsing the forum, but not with user names.

Well, the budget is is fine, but already got hosting that accommodated my issues. I'm hoping they didn't tell me that just to get my business.

I'll keep you in mind if hosting does not work with the new host.

Where is your hosting link

[cyanide]

oh, i see..
well, if you have more issues, shoot me a pm and I'll give you the link.

Good luck

[Googledeez]

oh, i see..
well, if you have more issues, shoot me a pm and I'll give you the link.

Good luck

Will do thanks.