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

Discussion in 'Databases' started by ishaan786, Jun 13, 2011.

  1. #1
    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.
     
    ishaan786, Jun 13, 2011 IP
  2. Nerv

    Nerv Active Member

    Messages:
    568
    Likes Received:
    4
    Best Answers:
    1
    Trophy Points:
    70
    #2
    I think it depends of the amount of post/threads you have there.
     
    Nerv, Jun 13, 2011 IP
  3. builtSEO

    builtSEO Well-Known Member

    Messages:
    289
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    111
    #3
    @Nerv is right.. btw,If you compress the db in zip or gzip while backing up, you could see about 10x reduced space.
     
    builtSEO, Jun 14, 2011 IP
  4. mastermunj

    mastermunj Well-Known Member

    Messages:
    687
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    110
    #4
    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?
     
    mastermunj, Jun 14, 2011 IP
  5. ishaan786

    ishaan786 Peon

    Messages:
    22
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    yes brother.
    i checked

    [​IMG]
     
    ishaan786, Jun 14, 2011 IP
  6. mastermunj

    mastermunj Well-Known Member

    Messages:
    687
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    110
    #6
    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.
     
    mastermunj, Jun 14, 2011 IP
  7. ishaan786

    ishaan786 Peon

    Messages:
    22
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #7
    Brother
    searchcore_text is impotent table ?

    [​IMG]
     
    ishaan786, Jun 14, 2011 IP
  8. mohitvohra27@gmail.com

    mohitvohra27@gmail.com Peon

    Messages:
    117
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #8
    check for things that you do not need and check for the largest table
     
    mohitvohra27@gmail.com, Jun 14, 2011 IP
  9. TNL Nick

    TNL Nick Active Member

    Messages:
    27
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    58
    #9
    If you store attachments and other files (like avatars) in the database, they may be the culprit.
     
    TNL Nick, Jun 14, 2011 IP
  10. mastermunj

    mastermunj Well-Known Member

    Messages:
    687
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    110
    #10
    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.
     
    mastermunj, Jun 15, 2011 IP