FlashCache increases performance by caching data in SSDs. It works even better when only hot data is cached. This feature prevents unwanted blocks of data to be cached.
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.1.49-12.0: Full functionality available.
The feature is a port of the original Facebook change.
Percona Toolkit and Maatkit UDFs
