D.S

dev.mysql.com

MySQL :: MySQL 5.7 Reference Manual :: 17.2.5 memcached FAQ

MySQL :: MySQL 5.7 Reference Manual :: 17.2.5 memcached FAQ Contact MySQL  |  Login  |  Register The world's most popular open source database MySQL.com Downloads Documentation Developer Zone Developer Zone Downloads MySQL.com Documentation MySQL Server MySQL Enterprise Workbench Router Utilities/Fabric MySQL NDB Cluster Connectors More MySQL.com Downloads Developer Zone Section Menu:   Documentation Home MySQL 5.7 Reference Manual Preface and Legal Notices General Information Installing and Upgrading MySQL Using MySQL as a Document Store Tutorial MySQL Programs MySQL Server Administration Security Backup and Recovery Optimization Language Structure Globalization Data Types Functions and Operators SQL Statement Syntax The InnoDB Storage Engine Alternative Storage Engines High Availability and Scalability Using ZFS Replication Using ZFS for File System Replication Configuring MySQL for ZFS Replication Handling MySQL Recovery with ZFS Using MySQL with memcached Installing memcached Using memcached memcached Command-Line Options memcached Deployment Using Namespaces Data Expiry memcached Hashing/Distribution Types Using memcached and DTrace Memory Allocation within memcached memcached Thread Support memcached Logs Developing a memcached Application Basic memcached Operations Using memcached as a MySQL Caching Layer Using libmemcached with C and C++ Using MySQL and memcached with Perl Using MySQL and memcached with Python Using MySQL and memcached with PHP Using MySQL and memcached with Ruby Using MySQL and memcached with Java Using the memcached TCP Text Protocol Getting memcached Statistics memcached General Statistics memcached Slabs Statistics memcached Item Statistics memcached Size Statistics memcached Detail Statistics Using memcached-tool memcached FAQ Replication MySQL NDB Cluster 7.5 Partitioning Stored Programs and Views INFORMATION_SCHEMA Tables MySQL Performance Schema MySQL sys Schema Connectors and APIs Extending MySQL MySQL Enterprise Edition MySQL Workbench MySQL 5.7 Frequently Asked Questions Errors, Error Codes, and Common Problems Restrictions and Limits Indexes MySQL Glossary Related Documentation MySQL 5.7 Release Notes Download this Manual PDF (US Ltr) - 35.7Mb PDF (A4) - 35.7Mb PDF (RPM) - 34.7Mb EPUB - 8.7Mb HTML Download (TGZ) - 8.5Mb HTML Download (Zip) - 8.5Mb HTML Download (RPM) - 7.3Mb Eclipse Doc Plugin (TGZ) - 9.3Mb Eclipse Doc Plugin (Zip) - 11.5Mb Man Pages (TGZ) - 203.5Kb Man Pages (Zip) - 308.9Kb Info (Gzip) - 3.3Mb Info (Zip) - 3.3Mb Excerpts from this Manual MySQL Backup and Recovery MySQL Globalization MySQL Information Schema MySQL Installation Guide MySQL and Linux/Unix MySQL and OS X MySQL Partitioning MySQL Performance Schema MySQL Replication Using the MySQL Yum Repository MySQL Restrictions and Limitations Security in MySQL MySQL and Solaris Building MySQL from Source Starting and Stopping MySQL MySQL Tutorial MySQL and Windows MySQL Cluster NDB 7.5 version 5.7 8.0 5.6 5.5 5.6  Japanese MySQL 5.7 Reference Manual  /  ...  /  High Availability and Scalability  /  Using MySQL with memcached  /  memcached FAQ 17.2.5 memcached FAQ 17.2.5.1. Can memcached be run on a Windows environment? 17.2.5.2. What is the maximum size of an object you can store in memcached? Is that configurable? 17.2.5.3. Is it true memcached will be much more effective with db-read-intensive applications than with db-write-intensive applications? 17.2.5.4. Is there any overhead in not using persistent connections? If persistent is always recommended, what are the downsides (for example, locking up)? 17.2.5.5. How is an event such as a crash of one of the memcached servers handled by the memcached client? 17.2.5.6. What is a recommended hardware configuration for a memcached server? 17.2.5.7. Is memcached more effective for video and audio as opposed to textual read/writes? 17.2.5.8. Can memcached work with ASPX? 17.2.5.9. How expensive is it to establish a memcache connection? Should those connections be pooled? 17.2.5.10. How is the data handled when the memcached server is down? 17.2.5.11. How are auto-increment columns in the MySQL database coordinated across multiple instances of memcached? 17.2.5.12. Is compression available? 17.2.5.13. Can we implement different types of memcached as different nodes in the same server, so can there be deterministic and non-deterministic in the same server? 17.2.5.14. What are best practices for testing an implementation, to ensure that it improves performance, and to measure the impact of memcached configuration changes? And would you recommend keeping the configuration very simple to start? 17.2.5.1. Can memcached be run on a Windows environment? No. Currently memcached is available only on the Unix/Linux platform. There is an unofficial port available, see http://www.codeplex.com/memcachedproviders . 17.2.5.2. What is the maximum size of an object you can store in memcached? Is that configurable? The default maximum object size is 1MB. In memcached 1.4.2 and