Skip to content

Flash Memory as Cache Extension for MySQL, with advanced cache admission policy.

License

Notifications You must be signed in to change notification settings

TanShiKai/mysql-with-face

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

13 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

MySQL with FaCE

Flash Memory as Cache Extension for MySQL 5.6.26.

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.

Documentation

Main features

  • Caching dirty pages
  • Multi-Vesion FIFO replacement
  • Group replacement
  • Group second chance

Configuration

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

Reference

Project Details

Powerpoint slide on SlideShare

About

Flash Memory as Cache Extension for MySQL, with advanced cache admission policy.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • C++ 57.0%
  • C 31.0%
  • Java 3.6%
  • Perl 2.8%
  • Assembly 1.0%
  • Objective-C 0.9%
  • Other 3.7%