Oracle 5.0, Reference Manual

Page: 2678 / 3232

Mysqlnd query result cache plugin (
mysqlnd_qc
)
2658
20.7.7.1. Key Features
Copyright 1997-2012 the PHP Documentation Group. [2230]
• Transparent and therefore easy to use
• supports all PHP MySQL extensions
• no API changes
• very little application changes required
• Flexible invalidation strategy
• Time-to-Live (TTL)
• user-defined
• Storage with different scope and life-span
• Default (Hash, process memory)
• APC
• MEMCACHE
• sqlite
• user-defined
• Built-in slam defense to prevent cache stampeding.
20.7.7.2. Limitations
Copyright 1997-2012 the PHP Documentation Group. [2230]
The current 1.0.1 release of PECL mysqlnd_qc does not support PHP 5.4. Version 1.1.0-alpha lifts this
limitation.
Prepared statements and unbuffered queries are fully supported. Thus, the plugin is capable of caching
all statements issued with
mysqli
or
PDO_MySQL
, which are the only two PHP MySQL APIs to offer
prepared statement support.
20.7.7.3. On the name
Copyright 1997-2012 the PHP Documentation Group. [2230]
The shortcut
mysqlnd_qc
stands for
mysqlnd query cache plugin
. The name was chosen for a
quick-and-dirty proof-of-concept. In the beginning the developers did not expect to continue using the
code base. Sometimes PECL/mysqlnd_qc has also been called
client-side query result set
cache
.
20.7.7.4. Quickstart and Examples
Copyright 1997-2012 the PHP Documentation Group. [2230]
The mysqlnd query cache plugin is easy to use. This quickstart will demo typical use-cases, and
provide practical advice on getting started.
It is strongly recommended to read the reference sections in addition to the quickstart. It is safe to
begin with the quickstart. However, before using the plugin in mission critical environments we urge
you to read additionally the background information from the reference sections.