1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Hello,is Xenforo good to supports more than 20GB database?

Discussion in 'XenForo Pre-Sales Questions' started by fingon, Mar 29, 2015.

  1. fingon

    fingon Member

    Hello i have a forum with 21GB database and it's increasing everyday and attachments is 120GB now.
    I want to know:
    Is it fast on Xenforo with this database? my database is too big and i can install other tools like Memcache(d)(or others ,you should tell me :D ) to make it fast.
    Is there a plugin that i can upload new attachments to another server(i have another server to save them)?

    sorry for my poor english.
    thanks : )
  2. Solidus

    Solidus Well-Known Member

  3. fingon

    fingon Member

  4. Brogan

    Brogan XenForo Moderator Staff Member

    It's worth pointing out that IGN's installation is likely non standard.

    Database size isnt that significant a factor.
    How many posts/threads/members are there?
  5. Slavik

    Slavik XenForo Moderator Staff Member

    A 20gb database will be ~20M posts (give or take a couple of million).

    XenForo can handle it easily :)

    You can also move your attachments elsewhere, though the web server needs to be able to read and write to the new location obviously.
  6. Xon

    Xon Well-Known Member

    Using table compression, you can get ~16M posts into ~9 gb or so. And in the future, the new page compression for MariaDB 10.1 should help reduce the CPU cost.
    Steve F likes this.
  7. fingon

    fingon Member

  8. fingon

    fingon Member

    you are right! almost 30M posts:D
  9. fingon

    fingon Member

    Hello ,i need these addons :
    1. Member Onlinetime.
    features:1,count member online time every 30minutes.
    2,Adminpage-Users-Users Group Promotions- Create new promotion-Apply This Promotion While...-Content and Achievements
    User has onlinetime at least X hours:
    2. Medals of Years
    features:1,Count how many years that member registered.
    For example,members who registered at 1/1/2005 - 12/31/2005, 2015-2005=10 years.
    2,When new year coming,delete the last year medal and award a new medal to all members.
    For example, 1/1/2016,remove the 10 years medal and award 11 years medal to members who registered at 2005.
    3.New Style
    I will give you my forum url.

    4. User Title Ladder
    User Title Ladder page,add image and shows below title .

    who can help me to do these things?
    I can pay you for them.
    I will buy XENFORO if them finish easily.
    Thanks :) :)

    plz PM me or give me your SKYPE ,thank you
    Last edited: Mar 31, 2015
  10. TDUBS

    TDUBS Active Member

    You can find all addons by clicking here. Most of them are free and some are paid. Alternatively, you can search for what you're looking for via search option or Google and just go with the plugin from this website. Also, double check the forum version it supports. Good luck! :)
  11. Brent W

    Brent W Well-Known Member

    Just an FYI, we ran into a bug with MariaDB 10.0.17 with a database of 46GB. We could not get it to import. We moved to Percona and had no issues.

Share This Page