hey is it possible to disable spill in shared-noth...
# questions-and-troubleshooting
k
hey is it possible to disable spill in shared-nothing
Copy code
StarRocks > show global variables like '%spill%';
+--------------------------------+-------+
| Variable_name                  | Value |
+--------------------------------+-------+
| disable_spill_to_local_disk    | false |
| enable_spill                   | false |
| enable_spill_to_remote_storage | false |
| spill_enable_direct_io         | false |
| spill_encode_level             | 7     |
| spill_mode                     | auto  |
| spill_revocable_max_bytes      | 0     |
| spill_storage_volume           |       |
+--------------------------------+-------+
8 rows in set (0.02 sec)
the spill is disabled but can see still spill being written to disk
Copy code
du -sh /opt/starrocks/be/* 2>/dev/null
224K	/opt/starrocks/be/bin
28K	/opt/starrocks/be/conf
17M	/opt/starrocks/be/datadog
2.2G	/opt/starrocks/be/lib
2.3G	/opt/starrocks/be/log
63G	/opt/starrocks/be/spill
46G	/opt/starrocks/be/storage
692K	/opt/starrocks/be/www
currently its being written to root dir and is causing pods to restart