Sphinx索引器错误：索引'PhoneNumbers2'：写入文件'/ tmp / MYbP6cIt时出错'（错误代码：28）

I have problem with sphinx indexer and large (over 1gb database). Seems that its running out of space and I am unable to change the /tmp folder it is using. Googling the error gives lot of mysql related errors, but I have changed all paths in /etc/mysql/* files to /var/tmp which has more available space. Current /tmp folder has 1,4 GB of space and that does not seem to be enough. So is there a way to change what folder /sphinx/bin/indexer is using for temp files or some other ways to go around this? (It is still possible that it is mysql related, machine has several mysql sockets, thou I tried to change tmp for them all and restarted)I have problem with sphinx indexer and large (o