<s...@acts.hu>
> > cd /var/piler/tmp
> > runuser -u piler -- reindex -a (why this command didn't need to
> > specify /etc/piler/sphinx.conf?)
>
> Because it has nothing to with sphinx. The reindex tool retrieves the
> emails, parses them, and puts their contents to the sph_index table.
> Then the sphinx indexer reads and process this table.
I am really stupid. now I understand.
> sphinx 3.3.1 has some improvements over the 2.2 series. If you can find
> all your email, then don't worry.
>
> > /var/lib/mysql/piler/sph_index.ibd => become 1.9GB
>
> This is the before mentioned table. Since you put a huge volume of data
> during the reindex process this table has grown, and now it just doesn't
> want to shrink. Try running "optimize table sph_index;" at the mysql
> console to shrink it when the reindex has completed.
ok now I get it. after "reindex -a", I need to wait cron or run it manually:
"indexer.delta.sh", "indexer.main.sh". they will empty mysql
sph_index table and write to /var/piler/sphinx.
and finally I can optimize the mysql table and get back disk spaces.
thanks a lot for the detailed explain!!
