XF 1.3 Large database

[liko881]

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

 

[Paul B]

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.

 

[AndyB]

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.

 

[liko881]

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

 

[Paul B]

No.

They are stored in the file system.

 

[liko881]

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.

where can I buy it?

 

[Amaury]

where can I buy it?

https://xenforo.com/purchase/

Under Extras.

 

[liko881]

https://xenforo.com/purchase/

Under Extras.

thanks you my bro

 

[liko881]

plugin Elasticsearch
does not work
There is entered un server 127.0.0.1:9200 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

 

[liko881]

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

 

[liko881]

Sort the tables in phpMyAdmin by size.

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

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

 

[Mike]

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.