my database size seems 560 MB. Is there any chance to be have this much mb

Hello All,

I have forum site.

Name redchillyz. com

i'm using vbulletin 4.0.8

Only few member are still joined (115).

But my database size seems 560 MB.

Is there any chance to be have this much mb

i doubt that is there any virus ?



(Actually i have small knowledge in database)


Thanks.

 

I think it depends of the amount of post/threads you have there.

 

@Nerv is right.. btw,If you compress the db in zip or gzip while backing up, you could see about 10x reduced space.

 

Following are the stats of your forum:

Threads: 70,535 Posts: 70,541 Members: 116

Code (markup):

Thread / Post ratio is very less and most of threads are about torrents having long content in it. However, chances of having 560MB database with the amount of posts you have are very less.

Are you sure you checked database size only? How did you arrive at 560MB?

 

yes brother.
i checked

 

You can then try checking which table is using most of the space. Do it via phpMyAdmin and you can know the table having highest data size. May be there would be more than one tables.
If tables are temporary tables, then may be you can truncate them or delete old data.

 

Brother
searchcore_text is impotent table ?

 

check for things that you do not need and check for the largest table

 

If you store attachments and other files (like avatars) in the database, they may be the culprit.

 

You can read some more details about searchcore_text table at this link.

Mainly, you may have to alter table structure but I would advice you to have word with vBulletin support for this and get a solution from them.