Sphinx indexer ERROR: index 'PhoneNumbers2': Error writing file '/tmp/MYbP6cIt' (Errcode: 28)

view story

http://stackoverflow.com – 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 trie (HowTos)