Prevent Caching to FlashCache¶
FlashCache increases performance by caching data on SSDs. It works even better when only hot data is cached. This feature prevents the caching of the unwanted blocks of data.
Better utilization of FlashCache partitions is achieved when caching of rarely used data is avoided. Use of this feature prevents blocks of data from being cached to FlashCache during a query.
Usage of the feature is as follows:
SELECT /* sql_no_fcache */ ...
The mysqldump binary was changed to use this option.
- 5.5.27-29.0 – Variable introduced
This variable shows if the server was compiled with Flashcache support.
Scope: Global Variable Type: Boolean Range: OFF/ON
This status variable shows if the Flashcache support has been enabled.
The feature is a port of the original Facebook change.