Description:
Memcached plugin reject set comands after full usage innodb buffer pool + memcached memory pool.
Please check "How to repeat"
How to repeat:
1. Set cache policy "caching"
2. Reduced memcached memory to 61M
3. Set innodb_buffer_pool to 340M.
[root@centos65 ~]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.6.21 MySQL Community Server (GPL)
Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
mysql> use innodb_memcache
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> select * from cache_policies;
+--------------+------------+------------+---------------+--------------+
| policy_name | get_policy | set_policy | delete_policy | flush_policy |
+--------------+------------+------------+---------------+--------------+
| cache_policy | caching | caching | caching | caching |
+--------------+------------+------------+---------------+--------------+
1 row in set (0.00 sec)
mysql> show global variables like 'innodb_buffer_pool_size%';
+-------------------------+-----------+
| Variable_name | Value |
+-------------------------+-----------+
| innodb_buffer_pool_size | 356515840 |
+-------------------------+-----------+
1 row in set (0.00 sec)
mysql>
mysql> SELECT * FROM information_schema.GLOBAL_VARIABLES WHERE VARIABLE_NAME = 'DAEMON_MEMCACHED_OPTION';
+-------------------------+----------------+
| VARIABLE_NAME | VARIABLE_VALUE |
+-------------------------+----------------+
| DAEMON_MEMCACHED_OPTION | -m61 |
+-------------------------+----------------+
1 row in set (0.00 sec)
[root@centos65 ~]# memtier_benchmark -s localhost -p 11211 -P memcache_text --test-time=600 --distinct-client-seed -R --expiry-range=60-3600 --pipeline=3 --data-size-range=32-1024
[RUN #1] Preparing benchmark client...
[RUN #1] Launching threads now...
error: response parsing failed. 964503 ops, 2730 ops/sec, 206.82KB/sec, 219.62msec latency
error: response parsing failed.
error: response parsing failed.
error: response parsing failed.
error: response parsing failed.
error: response parsing failed.
error: response parsing failed.
error: response parsing failed.
error response: SERVER_ERROR out of memory storing object
error: response parsing failed.
error: response parsing failed.
error: response parsing failed.
error response: SERVER_ERROR out of memory storing object
error: response parsing failed.
error response: SERVER_ERROR out of memory storing object
error: response parsing failed.
error: response parsing failed.
error: response parsing failed.
error: response parsing failed.
error: response parsing failed.
error: response parsing failed.
error response: SERVER_ERROR out of memory storing object
error: response parsing failed.
error response: SERVER_ERROR out of memory storing object
error response: SERVER_ERROR out of memory storing object
error response: SERVER_ERROR out of memory storing object
error: response parsing failed.
error: response parsing failed.
.....
error: response parsing failed. 993184 ops, 2726 ops/sec, 206.37KB/sec, 217.17msec latency
error: response parsing failed.
error response: SERVER_ERROR out of memory storing object
error: response parsing failed.
error response: SERVER_ERROR out of memory storing object
error: response parsing failed.
error: response parsing failed.
error: response parsing failed.
^CUN #1, 1739 secs] 4 threads: 993558 ops, 571 ops/sec, 43.23KB/sec, 217.10msec latency
[root@centos65 ~]#
