Re: ERROR 1114 (HY000): The table /var/folder/... is full

[Vinay Reddy]

1) My innodb_data_file_path is set to auto-extend
2) The total size of my /var/folders is 1.4GB (but this is unrelated to mysql). That partition has 512GB+
3) Thank you for the link, that's exactly my problem. After setting these 3 variables, my queries now complete fine!

mysql> set global internal_tmp_mem_storage_engine=Memory;
mysql> set global temptable_max_mmap=12884901888;
mysql> set global temptable_max_ram=12884901888;

Thank you for your help!