Quickstart and Examples

Table of Contents

• Architecture and Concepts
• Setup
• Caching queries
• Setting the TTL
• Pattern based caching
• Slam defense
• Finding cache candidates
• Measuring cache efficiency
• Beyond TTL: user-defined storage

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.

Most of the examples use the mysqli extension because it is the most feature complete PHP MySQL extension. However, the plugin can be used with any PHP MySQL extension that is using the mysqlnd library.