> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/security/limiting-size-of-created-disk-temporary-files-and-tables/max_tmp_session_space_usage-system-variable.md).

# max\_tmp\_session\_space\_usage System Variable

Documentation for the system variable that limits the total size of temporary files and temporary tables that a single connection can use.

#### `max_tmp_session_space_usage`

* Description: The maximum total size in bytes of temporary file and temporary table usage for a single connection. Each connection is limited independently: this is not a server-wide limit, and it is not aggregated across the connections of one user account. To cap the total across all connections, use [max\_tmp\_total\_space\_usage](/docs/server/security/limiting-size-of-created-disk-temporary-files-and-tables/max_tmp_total_space_usage-system-variable.md). A statement that would exceed this limit fails with `Local temporary space limit reached`. A value of 0 disables this feature. Set in blocks of 65536, rounded down if not a multiple of 65536. See [Limiting Size of Created Disk Temporary Files and Tables Overview](/docs/server/security/limiting-size-of-created-disk-temporary-files-and-tables/limiting-size-of-created-disk-temporary-files-and-tables-overview.md) for details. Named max\_tmp\_space\_usage in [MariaDB 11.5.0](/docs/release-notes/community-server/old-releases/11.5/11.5.0.md) only.
* Commandline: `--max-tmp-session-space-usage=num`
* Scope: Global, Session
* Dynamic: Yes
* Data Type: `numeric` (bigint unsigned)
* Default Value: `1099511627776`
* Range: `0` to `18446744073709551615` (blocks of `65536`)
* Introduced: [MariaDB 11.5](/docs/release-notes/community-server/old-releases/11.5/what-is-mariadb-115.md)

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}