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

XF 1.3 Large database

Discussion in 'XenForo Questions and Support' started by liko881, Sep 11, 2014.

  1. liko881

    liko881 Member

    I have a problem
    500 thousand in forum posts
    But the base weighs about 4 GB
    Why so?
  2. Brogan

    Brogan XenForo Moderator Staff Member

    Sort the tables in phpMyAdmin by size.

    I suspect the post table, search index, liked content, templates and IP tables will be some of the largest.
  3. AndyB

    AndyB Well-Known Member

    In addition to what Brogan said, I suggest you get the Enhanced Search which costs $50.00 dollars. This will allow you to empty the xf_search_index as it will no longer be needed.
  4. liko881

    liko881 Member

    I think all the images and pictures are saved in the database
    Is this possible?
  5. Brogan

    Brogan XenForo Moderator Staff Member


    They are stored in the file system.
  6. liko881

    liko881 Member

    where can I buy it?
  7. Amaury

    Amaury Well-Known Member

  8. liko881

    liko881 Member

  9. liko881

    liko881 Member

    plugin Elasticsearch
    does not work
    There is entered un server Is that right?
    Please tell me how to find out the correct ip?
    I entered the ip address of the server but nothing has changed
  10. liko881

    liko881 Member

    when you try to search writes The search could not be completed. Please try again later.
    XenForo_Exception: Elasticsearch server returned no response. Is it running? - library/XenES/Search/SourceHandler/ElasticSearch.php:850
  11. liko881

    liko881 Member

  12. Mike

    Mike XenForo Developer Staff Member

    I have responded to your ticket about this, but to reiterate: it doesn't sound like you've actually installed and setup elasticsearch. You need to confirm that it working (such as by accessing it via the command line). We can't really do that much to help there. If in doubt, contact as server admin to help get that setup.

Share This Page