Flash Memory as Cache Extension for MySQL
Switch branches/tags
Nothing to show
Clone or download
Pull request Compare This branch is 2 commits ahead, 1 commit behind meeeejin:master.
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
BUILD
Docs
bin
client
cmake
cmd-line-utils/libedit
data/test
dbug
docs
extra
include
lib/plugin
libevent
libmysql
libmysqld
libservices
man
mysql-test
mysys
mysys_ssl
packaging
plugin
regex
scripts
share
sql-bench
sql-common
sql
storage
strings
support-files
tests
unittest
vio
win
zlib
.gitignore
BUILD-CMAKE
CMakeLists.txt
COPYING
Doxyfile-perfschema
INSTALL-BINARY
README
README.md
VERSION
config.h.cmake
configure.cmake
install_manifest.txt

README.md

MySQL with FaCE

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.

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