How to know how much space a file with a Sphinx index? And how to reduce this file size?

As you can see the index file of the Sphinx, how it takes place, and where it is?

Is it possible to reduce the size of this file, for example, by archiving (even though it will be a loss of speed search)

Can this file be copied to another server without indexing it again, just plugging?

System is Ubuntu 18, is located on the server (only access through the terminal)
March 19th 20 at 08:59
2 answers
March 19th 20 at 09:01
Solution
Is located in the folder corresponding to the path in the config.
To archive only at the level of the virtual FS - Sphinx with compressed formats doesn't work. You can try to cut the functional index (expand_keywords, index_exact_words, remove unused fields and attributes) - but it depends on how the index is used.
You can copy to another server without reindexing.
You can read more about the virtual FS? This is a file system, right? It can be configured only for the folder index? - Bernice97 commented on March 19th 20 at 09:04
@Bernice97, Yes, something like "compressed folders" from Windows. Once in Windows you have analogues for nix servers are. - boris_Daugher commented on March 19th 20 at 09:07
@boris_Daugher, well, how to set compression for the folder? Couldn't find information about it( - Bernice97 commented on March 19th 20 at 09:10
https://superuser.com/a/886122 - boris_Daugher commented on March 19th 20 at 09:13
If You have no index on 10ТБ, the new optimal will be hard to put than to deal with distortions from the compression of the FS in this administration experience. - boris_Daugher commented on March 19th 20 at 09:16
@boris_Daugher, the folder index is about 15 GB. The server is on a VPS, I want to try to reduce the space to move on to a cheaper rate. If you can compress the folder, then do the same thing with MySQL (DB weighs 20 GB uncompressed), it may turn out to be.
Large amounts of data, which are generally almost not used
Experience no, but it is necessary to somehow obtain)) - Bernice97 commented on March 19th 20 at 09:19
The use of compression can greatly increase the overhead to access the data on the disk. Are you sure you are willing to endure 10 times the query execution time? x10 is, of course, from the bulldozer, but the slowdown will be exactly.
Plus, try to start the index gzip-Ohm to squeeze, maybe there is nothing to compress and there's no need to suffer. - boris_Daugher commented on March 19th 20 at 09:22
@boris_Daugher, tried to compress it (on Windows though), in 2 times less space occupied
As a temporary measure to save space - fit. When the project grows, remove the backup - Bernice97 commented on March 19th 20 at 09:25
March 19th 20 at 09:03
Go to the folder index and see the size
Use compressed file system will weigh less

Find more questions by tags UbuntuSphinx