| Bug #72911 | Memcached plugins init sql should change to support storge large value size | ||
|---|---|---|---|
| Submitted: | 8 Jun 2014 9:20 | Modified: | 9 Jun 2014 11:37 |
| Reporter: | zhifeng hu hu | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | MySQL Server: Memcached | Severity: | S3 (Non-critical) |
| Version: | 5.6.17, 5.6.20, 5.7.5 | OS: | Linux (CentOS 6.5 x64) |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | memcached | ||
[9 Jun 2014 6:43]
MySQL Verification Team
Hello hu, Thank you for the feature request! As per wiki - "Keys are up to 250 bytes long and values can be at most 1 megabyte in size." See, http://en.wikipedia.org/wiki/Memcached Thanks, Umesh
[9 Jun 2014 11:37]
zhifeng hu hu
Got it , but now the memcached default init sql should be increase a bit more. Thanks.
Description: The memcached plugin is good , but the default init sql should be tune for support storage big value size. the default key and value lenght was 32 and 1024, that's not enought. I suggest increase them up to 128 and LONGBLOB CREATE TABLE demo_test (c1 VARCHAR(128), c2 LONGBLOB, c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1)) ENGINE = INNODB; How to repeat: install mysql with default setting and install memcached plugins as the official document told us. Suggested fix: I suggest increase them up to 128 and LONGBLOB CREATE TABLE demo_test (c1 VARCHAR(128), c2 LONGBLOB, c3 INT, c4 BIGINT UNSIGNED, c5 INT, primary key(c1)) ENGINE = INNODB;