Differences

This shows you the differences between two versions of the page.

--- reference:memcached [2015/12/19 17:11] – mnewnham
+++ v5:userguide:memcached [2017/04/18 10:32] – [Using Debug Mode] fix formatting (use code block) dregad
@@ Line 1: / Line 1: @@
 ====== Memcached Setup ======
 <WRAP tip>
-There are 2 pear modules for connection to a Memcached server, the older [[https://pecl.php.net/package/memcache|PEAR Memcache library]] and the newer [[https://pecl.php.net/package/memcached|PEAR Memcached library]].
+There are 2 PEAR modules for connecting to a [[wp>Memcached]] server: the [[https://pecl.php.net/package/memcache|Memcache]] library and the [[https://pecl.php.net/package/memcached|Memcached]] library.
-  * Windows support is only available for the older Memcache library.
+  * Windows support is only available for the //Memcache// library.
-  * ADOdb has only been tested against the older library
+  * //Memcache// should be used in PHP 5.x environments on UNIX platforms.
+  * //Memcached// should be used in PHP 7.x environments on UNIX platforms.
+  * If both libraries are available, //Memcache// will be used.
 </WRAP>
 ===== Description =====
-This section describes connection to an already configured Memcache server. Information about installation and configuration of Memcached servers can be found [[https://memcached.org/|here]].
+This section describes connecting to an already configured Memcache server. Information about installation and configuration of Memcached servers can be found [[https://memcached.org/|here]].
 ===== The Memcache Library =====
@@ Line 14: / Line 18: @@
 $db = NewADOConnection($driver='mysqli');
 /*
-* Enable memcache
+ * Enable memcache
-*/
+ */
 $db->memCache = true;
 /*
-* Add one or more servers, for use in distributed systems
+ * Add one or more servers, for use in distributed systems
-*/
+ */
 $db->memCacheHost = array('192.168.0.78', '192.168.0.79', '192.168.0.80');
 /*
-* Optionally add the server port if it differs from the default
+ * Optionally add the server port if it differs from the default
-*/
+ */
 $db->memCachePort = 11211;
 /*
-* Use 'true' to store the item compressed (uses zlib)
+ * Use 'true' to store the item compressed (uses zlib)
-*/
+ * Note; Compression is only supported using the memcache library. This
-$db->memCacheCompress = false;
+ *       parameter will be ignored when using the memcached library
+ */
+$db->memCacheCompress = false;
 /*
-* We connect to the database, not the memcache server
+ * We connect to the database, not the memcache server
-*/
+ */
 $db->Connect('localhost','mysql-user','mysql-password','employees');
 /*
-* look for a cached query with a life of 2400 seconds
+ * look for a cached query with a life of 2400 seconds
-*/
+ */
 $sql = 'SELECT code,description FROM xref_table';
 $db->cacheExecute(2400,$sql);
@@ Line 44: / Line 54: @@
 </code>
 ===== Using Debug Mode  =====
-The size of query results that can be cached by the memcached server is limited by server configuration. The default is quite small. If the query is too large, and [[reference:debug|debugging]] is enabled, then an error is displayed.
+The size of query results that can be cached by the memcached server is limited by server configuration. The default is quite small. If the query is too large, and [[v5:userguide:debug|debugging]] is enabled, then an error is displayed.
-  3849805e4e026b9e7c485999a24a95c6 cache failure: Item with such key doesn't exists on the memcached server.
+<code>
-  (this is a notice and not an error)
+3849805e4e026b9e7c485999a24a95c6 cache failure: Item with such key doesn't exists on the memcached server.
-  -----<hr>
+(this is a notice and not an error)
+-----<hr>
-  (mysqli): SELECT * FROM employees
-  -----<hr>
-  Notice: MemcachePool::set(): Server 192.168.0.78 (tcp 11211, udp 0) failed with:
-  SERVER_ERROR object too large for cache
-  (3) in C:\dev\github\mssqlnative-fixes\adodb-memcache.lib.inc.php on line 94
-  Failed to save data at the memcached server!
-  Cache write error
-  PHP Notice:  MemcachePool::set(): Server 192.168.0.78 (tcp 11211, udp 0) failed with:
-  SERVER_ERROR object too large for cache (3)
-  in C:\dev\github\mssqlnative-fixes\adodb-memcache.lib.inc.php on line 94
-ADOdb currently has no mechanism for splitting large queries into smaller chunks.
-===== Using a memcached server with metacaching =====
-with the introduction of the [[dictionary:metacasing#the_metacache|MetaCache]] in ADOdb version 6, the performance can be enhanced further by using a memcached server to store data from the metacache. This enhancement works best with small procedures that access multiple tables. The procedure flow is as follows:
+(mysqli): SELECT * FROM employees
+------<hr>
+Notice: MemcachePool::set(): Server 192.168.0.78 (tcp 11211, udp 0) failed with:
+SERVER_ERROR object too large for cache
+(3) in C:\dev\github\mssqlnative-fixes\adodb-memcache.lib.inc.php on line 94
+Failed to save data at the memcached server!
+Cache write error
+PHP Notice:  MemcachePool::set(): Server 192.168.0.78 (tcp 11211, udp 0) failed with:
+SERVER_ERROR object too large for cache (3)
+in C:\dev\github\mssqlnative-fixes\adodb-memcache.lib.inc.php on line 94
+</code>
+ADOdb currently has no mechanism for splitting large queries into smaller chunks.
-  - A request is made for metadata
-  - If the metadata is available from the local metacache, serve the request from there
-  - Check the metacache on the memcached server. If available there, copy to the local metacache and serve the request.
-  - If not available from the memcached server, request from the database, and store in both the local cache and on the memcached server for later use.
-The functionality can be enabled by calling the following method ''$db->setMetaCachingByMemcached()''.
+{{tag>[memcached cache]}}
-{{tag>[cache]}}