Updated on 2024-06-03 GMT+08:00

Disk Space

This section describes the disk space parameters, which are used to set limits on the disk space for storing temporary files.

sql_use_spacelimit

Parameter description: Specifies the space size for files to be flushed to disks when a single SQL statement is executed on a single DN. The managed space includes the space occupied by ordinary tables, temporary tables, and intermediate result sets to be flushed to disks. This parameter does not take effect for initial users.

This parameter is a USERSET parameter. Set it based on instructions provided in Table 1.

Value range: an integer ranging from –1 to 2147483647. The unit is KB. –1 indicates no limit.

Default value: –1

temp_file_limit

Parameter description: Specifies the limit on the size of a temporary file spilled to disk in a session. The temporary file can be a sort or hash temporary file, or the storage file for a held cursor. This is a session-level setting.

Parameter type: integer

Unit: KB

This parameter does not apply to disk space used for temporary tables during the SQL query process.

Value range: –1 to 2147483647. The value –1 indicates that there is no limit.

Default value: –1

Setting method: This is a SUSET parameter. Set it based on instructions provided in Table 1.

Setting suggestion: none