| Option | TABLE_CACHE_MAX_STORAGE_FRACTION | |
| Description |
Fraction of disk space allowed for caching file data used for
query functions such as match() and
readFile().
| |
| Introduced Version | 1.148 | |
| Default | 0.001 (0.1%) | |
| Minimum | 0.0 (0% (disabled, not recommended)) | |
| Maximum | 0.08 (80%) | |
The file data used in functions like
match() and readFile()
is stored on disk for up to 24 hours after initial use in order
to speed up the execution time for queries. This parameter sets
the fraction of disk space on the node that will be used as the
cache value for this data.