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.

Version-Specific Information

System Variables

variable have_flashcache
Version Info:
Command Line:

Yes

Config File:

Yes

Scope:

Global

Dynamic:

No

Variable Type:

Boolean

Range:

Yes/No

This variable shows if the server was compiled with Flashcache support.

Status Variables

variable Flashcache_enabled
Scope:Global
Variable Type:Boolean
Range:OFF/ON

This status variable shows if the Flashcache support has been enabled.

Other Information

The feature is a port of the original Facebook change.

Percona Server
Call Us
+1-888-316-9775 (USA - Sales)
+1-208-473-2904 (USA - Sales)
+44-208-133-0309 (UK - Sales)
0-800-051-8984 (UK - Sales)
0-800-181-0665 (GER - Sales)
+1-877-862-4316 (Emergency)
+1-855-55TRAIN (Training)
+1-925-271-5054 (Training)

Table Of Contents

Previous topic

Expanded Fast Index Creation

Next topic

Percona Toolkit UDFs

This Page



© Copyright Percona LLC and/or its affiliates 2009-2014.
Except where otherwise noted, this documentation is licensed under the following license:
CC Attribution-ShareAlike 2.0 Generic
Created using Sphinx 1.1.3.
This documentation is developed in Launchpad as part of the Percona Server source code.
If you spotted innacuracies, errors, don't understood it or you think something is missing or should be improved, please file a bug.
]]>