| Variable | TABLE_CACHE_MAX_STORAGE_FRACTION | |
| Introduced Version | 1.148 | |
| Description |
Fraction of disk space allowed for caching file data used for
query functions such as match() and
readFile().
| |
| 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.