21.9.7.8. Change History

This change history is a high level summary of selected changes that may impact applications and/or break backwards compatibility.

See also the CHANGES file in the source distribution for a complete list of changes.

21.9.7.8.1. PECL/mysqlnd_qc 1.2 series

1.2.0 - alpha

Feature changes

1.1.0 - stable

Release date: 04/2012
Motto/theme: PHP 5.4 compatibility, schema pattern based caching and mysqlnd_ms support

1.1.0 - beta

Release date: 04/2012
Motto/theme: PHP 5.4 compatibility, schema pattern based caching and mysqlnd_ms support

1.1.0 - alpha

Release date: 04/2012
Motto/theme: PHP 5.4 compatibility, schema pattern based caching and mysqlnd_ms support

Feature changes

APC storage handler update
- Fix build for APC 3.1.9+
- Note: Use of the APC storage handler is currently not recommended due to stability issues of APC itself.
New PHP configuration directives
- mysqlnd_qc.collect_statistics_log_file. Aggregated cache statistics log file written after every 10th request served by the PHP process.
- mysqlnd_qc.ignore_sql_comments. Control whether SQL comments are ignored for cache key hash generation.
New constants and SQL hints
- MYSQLND_QC_SERVER_ID_SWITCH allows grouping of cache entries from different physical connections. This is needed by PECL/mysqlnd_ms.
- MYSQLND_QC_CONDITION_META_SCHEMA_PATTERN to be used with mysqlnd_qc_set_cache_condition.
New function mysqlnd_qc_set_cache_condition for built-in schema pattern based caching. Likely to support a wider range of conditions in the future.
Report valid_until timestamp for cache entries of the default handler through mysqlnd_qc_get_cache_info.
Include charset number for cache entry hashing. This should prevent serving result sets which have the wrong charset.

API change: get_hash_key expects new "charsetnr" (int) parameter after "port".
API change: changing is_select() signature from bool is_select() to mixed is_select(). Mixed can be either boolean or array(long ttl, string server_id). This is needed by PECL/mysqlnd_ms.

Other

Support acting as a cache backend for PECL/mysqlnd_ms 1.3.0-beta or later to transparently replace MySQL Replication slave reads with cache accesses, if the user explicitly allows.

Bug fixes

Fixed Bug #59959 (config.m4, wrong library - 64bit memcached handler builds) (Credits: Remi Collet)

1.0.1-stable

Added support for Prepared statements and unbuffered queries.

1.0.0-beta

Release date: 07/2010
Motto/theme: TTL-based cache with various storage options (Memcache, APC, SQLite, user-defined)

Initial public release of the transparent TTL-based query result cache. Flexible storage of cached results. Various storage media supported.