Flash Memory as Cache Extension for MySQL.
FaCE is a new low-overhead caching strategy that uses flash memory as an extension to the RAM buffer of database systems. FaCE aims at improving the transaction throughput as well as shortening the recovery time from a system failure.
You can see the previous version of FaCE in here.
- Caching dirty pages
- Multi-Vesion FIFO replacement
- Group replacement
- Group second chance
You can add and set the value of parameter related to the SSD cache in the MySQL option file (my.cnf).
| innodb_use_ssd_cache | Specifies whether to use SSD cache. true or false. |
| innodb_ssd_cache_file | The paths to SSD cache. |
| innodb_ssd_cache_size | The size in bytes of the SSD cache. The default value is 2GB. |
my.cnf example:
#ssd cache settings
innodb_use_ssd_cache=true
innodb_ssd_cache_file=/home/mijin/test_data/ssd_cache.db
innodb_ssd_cache_size=10G- Woon-Hak Kang, Sang-Won Lee, Bongki Moon, "Flash-based Extended Cache for Higher Throughput and Faster Recovery", Proceedings of the VLDB Endowment (PVLDB), Vol. 5, No. 11, pp. 1615-1626 (2012)
- Woon-Hak Kang, Sang-Won Lee, Bongki Moon, "Flash as cache extension for online transactional workloads", The VLDB Journal, Special Issue, Online ( 2015-11-30, pp 1-22 )
- Detailed presentaion