## Pre-requisites - pls install memtier_benchmark, steps outlined here - https://github.com/RedisLabs/memtier_benchmark

## 5.6.22

## Build used

[ushastry@cluster-repo mysql-advanced-5.6.22]$ more docs/INFO_SRC
revision-id: thirunarayanan.balathandayuth@oracle.com-20141121052002-u0rj3jaqb1i4sv5o
date: 2014-11-21 10:50:02 +0530
build-date: 2014-11-21 06:25:36 +0100
revno: 6235
branch-nick: mysql-5.6.22-release

MySQL source 5.6.22


## Startup
scripts/mysql_install_db --basedir=/data/ushastry/server/mysql-advanced-5.6.22 --datadir=/data/ushastry/server/mysql-advanced-5.6.22/75149 --user=mysql
bin/mysqld --basedir=/data/ushastry/server/mysql-advanced-5.6.22 --datadir=/data/ushastry/server/mysql-advanced-5.6.22/75149 --innodb_buffer_pool_size=340M --core --socket=/tmp/mysql_ushastry.sock  --port=3306 --log-error=/data/ushastry/server/mysql-advanced-5.6.22/75149/log.err --user=mysql 2>&1 &


## Installing and Configuring the InnoDB memcached Plugin - http://dev.mysql.com/doc/refman/5.6/en/innodb-memcached-installing.html

## Update innodb_memcache.cache_policies and use cache_only

mysql> select * from innodb_memcache.cache_policies;
+--------------+------------+------------+---------------+--------------+
| policy_name  | get_policy | set_policy | delete_policy | flush_policy |
+--------------+------------+------------+---------------+--------------+
| cache_policy | cache_only | cache_only | cache_only    |              |
+--------------+------------+------------+---------------+--------------+

## Uninstall/install memcached plugin

mysql> uninstall plugin daemon_memcached;
mysql> install plugin daemon_memcached soname "libmemcached.so";

## restart MySQL server with --daemon_memcached_option="-m61"

bin/mysqld --basedir=/data/ushastry/server/mysql-advanced-5.6.22 --datadir=/data/ushastry/server/mysql-advanced-5.6.22/75149 --innodb_buffer_pool_size=340M --core --socket=/tmp/mysql_ushastry.sock  --port=3306 --log-error=/data/ushastry/server/mysql-advanced-5.6.22/75149/log.err --user=mysql --daemon_memcached_option="-m61" 2>&1 &

// Using CLI, confirm the settings

mysql> show variables like '%version%';
+-------------------------+---------------------------------------------------------+
| Variable_name           | Value                                                   |
+-------------------------+---------------------------------------------------------+
| innodb_version          | 5.6.22                                                  |
| protocol_version        | 10                                                      |
| slave_type_conversions  |                                                         |
| version                 | 5.6.22-enterprise-commercial-advanced                   |
| version_comment         | MySQL Enterprise Server - Advanced Edition (Commercial) |
| version_compile_machine | x86_64                                                  |
| version_compile_os      | linux-glibc2.5                                          |
+-------------------------+---------------------------------------------------------+
7 rows 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> show global variables like '%daemon_memcached_option%';
+-------------------------+-------+
| Variable_name           | Value |
+-------------------------+-------+
| daemon_memcached_option | -m61  |
+-------------------------+-------+
1 row in set (0.00 sec)

mysql> select * from innodb_memcache.cache_policies;
+--------------+------------+------------+---------------+--------------+
| policy_name  | get_policy | set_policy | delete_policy | flush_policy |
+--------------+------------+------------+---------------+--------------+
| cache_policy | cache_only | cache_only | cache_only    |              |
+--------------+------------+------------+---------------+--------------+
1 row in set (0.00 sec)

## telnet session

[root@cluster-repo mysql-advanced-5.6.22]# 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.     934416 ops,   84886 ops/sec, 6.28MB/sec,  7.05msec latency
error: response parsing failed.
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.
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: 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: 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: 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: 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.
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.
error response: SERVER_ERROR out of memory storing object
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: 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: SERVER_ERROR out of memory storing object
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 parsing failed.
error: response parsing failed.
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: 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: SERVER_ERROR out of memory storing object
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: 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.
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: SERVER_ERROR out of memory storing object
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: 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.
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: SERVER_ERROR out of memory storing object
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: 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: SERVER_ERROR out of memory storing object
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 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 parsing failed.
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: 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: SERVER_ERROR out of memory storing object
error: response parsing failed.
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: 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 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 parsing failed.
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.
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: 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: 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 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: 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: SERVER_ERROR out of memory storing object
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: 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: 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: 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: 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 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: 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 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: 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: 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.
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 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 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 parsing failed.
error: response parsing failed.
error: response parsing failed.
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: 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: 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: 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: 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: 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 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 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: 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: SERVER_ERROR out of memory storing object
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: 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 parsing failed.
error: response parsing failed.
error response: SERVER_ERROR out of memory storing object
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: 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: 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: 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 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: 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: 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.
error: response parsing failed.
error: response parsing failed.
error: response parsing failed.
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.
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: 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 parsing failed.
error: response parsing failed.
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.
error: response parsing failed.
error: response parsing failed.
error response: SERVER_ERROR out of memory storing object
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: 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: 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: 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: 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 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: 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: 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: 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 parsing failed.
error: response parsing failed.
error: response parsing failed.
error response: SERVER_ERROR out of memory storing object
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: 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: 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: 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 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 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 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 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 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 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 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: 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.
^CUN #1, 621 secs]  4 threads:      998974 ops,    1607 ops/sec, 121.94KB/sec,  6.98msec latencyy


## 5.6.23

## Build used

[ushastry@cluster-repo mysql-advanced-5.6.23]$ more docs/INFO_SRC
revision-id: michael.izioumtchenko@oracle.com-20141106152508-nntohvuco3v1rjjx
date: 2014-11-06 16:25:08 +0100
build-date: 2014-11-06 18:00:43 +0100
revno: 6243
branch-nick: daily-5.6

MySQL source 5.6.23


## Follow steps from 5.6.22 for setting up innodb memcached plugin etc


mysql> show variables like '%version%';
+-------------------------+---------------------------------------------------------+
| Variable_name           | Value                                                   |
+-------------------------+---------------------------------------------------------+
| innodb_version          | 5.6.23                                                  |
| protocol_version        | 10                                                      |
| slave_type_conversions  |                                                         |
| version                 | 5.6.23-enterprise-commercial-advanced                   |
| version_comment         | MySQL Enterprise Server - Advanced Edition (Commercial) |
| version_compile_machine | x86_64                                                  |
| version_compile_os      | Linux                                                   |
+-------------------------+---------------------------------------------------------+
7 rows in set (0.00 sec)

mysql> select * from innodb_memcache.cache_policies;
+--------------+------------+------------+---------------+--------------+
| policy_name  | get_policy | set_policy | delete_policy | flush_policy |
+--------------+------------+------------+---------------+--------------+
| cache_policy | cache_only | cache_only | cache_only    |              |
+--------------+------------+------------+---------------+--------------+
1 row in set (0.00 sec)

mysql> show global variables like '%daemon_memcached_option%';
+-------------------------+-------+
| Variable_name           | Value |
+-------------------------+-------+
| daemon_memcached_option | -m61  |
+-------------------------+-------+
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)


[root@cluster-repo mysql-advanced-5.6.23]# 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.     934420 ops,   84912 ops/sec, 6.28MB/sec,  7.04msec 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 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 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: 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: 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: 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 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: 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: 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: 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: 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: 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: 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: SERVER_ERROR out of memory storing object
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: SERVER_ERROR out of memory storing object
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: 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.
error response: SERVER_ERROR out of memory storing object
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 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 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: 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: 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: 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 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 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 parsing failed.
error response: SERVER_ERROR out of memory storing object
error: response parsing failed.
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.
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: SERVER_ERROR out of memory storing object
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: 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: 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: 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.
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 parsing failed.
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.
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: 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.
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: 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: 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: 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: SERVER_ERROR out of memory storing object
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 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: 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.
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: SERVER_ERROR out of memory storing object
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 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: 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: 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: 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: 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 parsing failed.
error: response parsing failed.
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.
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: 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: SERVER_ERROR out of memory storing object
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: 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.
error: response parsing failed.
error: response parsing failed.
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.
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: 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: SERVER_ERROR out of memory storing object
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: 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: 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.
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 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.
error: response parsing failed.
error: response parsing failed.
error: response parsing failed.
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.
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: 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.
error: response parsing failed.
error: response parsing failed.
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: SERVER_ERROR out of memory storing object
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: 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: 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: 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: 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: 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 parsing failed.
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: 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: 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 parsing failed.
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: 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: 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 parsing failed.
error: response parsing failed.
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: 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: 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.
error: response parsing failed.
error: response parsing failed.
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: 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: 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: 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: 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.
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: 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 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 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 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 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 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 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 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 parsing failed.
error: response parsing failed.
error: response parsing failed.
error: response parsing failed.
error: response parsing failed.
error: response parsing failed.
^CUN #1,  25 secs]  4 threads:      992431 ops,   39681 ops/sec, 2.93MB/sec,  7.00msec latency