Key Features

• 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.

Limitations

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.

On the name

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.