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

Large Size of MySQL Database

Discussion in 'Server Configuration and Hosting' started by SuchMuch, Feb 26, 2016.

  1. SuchMuch

    SuchMuch Member

    Hi,
    My forum consists of:
    Members: 69
    Discussions: 231
    Messages: 1,714
    MySQL database size is 347,7 Mb

    It seems to me the MySQL database size is too large. What should be done to keep it optimized?
     
  2. RoldanLT

    RoldanLT Well-Known Member

    I guess your large tables are:
    xf_search_index and xf_bb_code_parse_cache
    and that's normal.
     
    SuchMuch likes this.
  3. SuchMuch

    SuchMuch Member

    How can I reduce those tables?
     
  4. SuchMuch

    SuchMuch Member

    By the way, could smiles be a reason of larger database size?
     
  5. Martok

    Martok Well-Known Member

    No. Smilies are stored as files on your server, not in your database.
     
    SuchMuch likes this.
  6. SuchMuch

    SuchMuch Member

    Thnks Martok!

    Should I ever be concerned about MySQL database maintenance? or should I leave it alone?
     
  7. Brogan

    Brogan XenForo Moderator Staff Member

    You can disable 'Cache BB Code output' in the options.
     
  8. SuchMuch

    SuchMuch Member

    Are these Xenforo Forum options or should they be disabled in PHPadmin panel? What affects disabling 'Cache BB Code output' will bring to the forum?
     
  9. Brogan

    Brogan XenForo Moderator Staff Member

    It's an XF option in the ACP.

    Disabling it won't cause any noticeable difference to the operation of the forum.
    In some cases it can speed up displaying pages which have a lot of bb code.
     
    BassMan and SuchMuch like this.
  10. SuchMuch

    SuchMuch Member

    I checked it, this option was not enabled.
     
  11. Brogan

    Brogan XenForo Moderator Staff Member

    There's likely not much more you can do to reduce the size then.
    You could disable some of the logging options (APC -> Options -> Logging Options) but it's not going to make a significant difference.
     

Share This Page