Re: Sphinx rotation and deleted messages

2018-01-24 Thread sj
Hello, On 2018-01-24 13:30, Konstantin wrote: I have index file with size over 200Gb and want to rotate main1 to main2 according to the wiki http://www.mailpiler.org/wiki/current:administering-piler Will sphinx clean data from main1 (old index) based on killist if i make change in indexer-ma

Re: Sphinx sql_query_killlist not applied ?

2018-01-24 Thread sj
Hello, On 2018-01-24 19:06, Konstantin wrote: I found that in my archive purged messages not removed from main1 index. Here are the query examples: # Get data from sphinx # mysql -h 127.0.0.1 -P 9306 mysql> show tables; +-+---+ | Index | Type | +-+---+

Sphinx sql_query_killlist not applied ?

2018-01-24 Thread Konstantin
Hello, I found that in my archive purged messages not removed from main1 index. Here are the query examples: # Get data from sphinx # mysql -h 127.0.0.1 -P 9306 mysql> show tables; +-+---+ | Index | Type | +-+---+ | dailydelta1 | local | | delta1 | loca

Sphinx rotation and deleted messages

2018-01-24 Thread Konstantin
Hello, I have index file with size over 200Gb and want to rotate main1 to main2 according to the wiki http://www.mailpiler.org/wiki/current:administering-piler Will sphinx clean data from main1 (old index) based on killist if i make change in indexer-main.sh ? Thank you. -- *This message was de