-- build details [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.19: cat docs/INFO_SRC commit: 432d360adedd7d8976fd6254eb3f5bee0b1ac3d6 date: 2017-06-22 16:12:22 +0200 build-date: 2017-06-22 16:13:32 +0200 short: 432d360 branch: mysql-5.7.19-release MySQL source 5.7.19 free -g -t total used free shared buff/cache available Mem: 251 3 55 0 193 248 Swap: 7 0 7 Total: 259 3 62 -- Start up command rm -rf 87355 bin/mysqld --initialize-insecure --basedir=$PWD --datadir=$PWD/87355 -v bin/mysqld --basedir=$PWD --datadir=$PWD/87355 --core-file --socket=/tmp/mysql.sock --port=3306 --log-error=$PWD/87355/log.err 2>&1 & [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.19: cat ./share/innodb_memcached_config.sql |sed -e 's/c2 VARCHAR(1024)/c2 VARCHAR(65000)/' > innodb_memcached_config_changed.sql [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.19: [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.19: bin/mysql -uroot < innodb_memcached_config_changed.sql [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.19: bin/mysql -uroot Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 Server version: 5.7.19 MySQL Community Server (GPL) Copyright (c) 2000, 2017, 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. root@localhost [(none)]> INSTALL PLUGIN daemon_memcached soname "libmemcached.so"; Query OK, 0 rows affected (0.01 sec) root@localhost [(none)]> root@localhost [(none)]> #### ruby session ruby test_memcache.rb ## Mem usage monitoring [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.19: cat runmon.sh while [ 1 ] do date +"%Y%m%d %H:%M:%S" >> top.txt top -n1 -b -p $( pgrep -xn mysqld ) >> top.txt sleep 2 done ### <30min, 50Gb+ memory utilized. Had to kill the ruby test to bring back to normalcy ### As reporter claimed, memory is reclaimed after test case killed/over ### Easier to invoke OOM on smaller/medium sized box 20170809 13:51:53 top - 13:51:54 up 18 days, 21:26, 3 users, load average: 0.20, 0.14, 0.20 Tasks: 1 total, 0 running, 1 sleeping, 0 stopped, 0 zombie %Cpu(s): 6.3 us, 0.4 sy, 0.0 ni, 93.3 id, 0.0 wa, 0.0 hi, 0.0 si, 0.0 st KiB Mem : 26409883+total, 10666395+free, 3410348 used, 15402454+buff/cache KiB Swap: 8191996 total, 8191996 free, 0 used. 26005030+avail Mem PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 32467 umshastr 20 0 1833556 380200 11752 S 0.0 0.1 12:28.17 mysqld 20170809 13:51:56 top - 13:51:56 up 18 days, 21:26, 3 users, load average: 0.20, 0.14, 0.20 Tasks: 1 total, 0 running, 1 sleeping, 0 stopped, 0 zombie %Cpu(s): 6.3 us, 0.4 sy, 0.0 ni, 93.3 id, 0.0 wa, 0.0 hi, 0.0 si, 0.0 st KiB Mem : 26409883+total, 10666375+free, 3410420 used, 15402467+buff/cache KiB Swap: 8191996 total, 8191996 free, 0 used. 26005009+avail Mem . . . PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 32467 umshastr 20 0 55.999g 0.053t 11876 S 13.3 21.7 24:36.56 mysqld 20170809 14:29:41 top - 14:29:41 up 18 days, 22:04, 4 users, load average: 1.25, 1.27, 1.19 Tasks: 1 total, 0 running, 1 sleeping, 0 stopped, 0 zombie %Cpu(s): 6.3 us, 0.4 sy, 0.0 ni, 93.3 id, 0.0 wa, 0.0 hi, 0.0 si, 0.0 st KiB Mem : 26409883+total, 628916 free, 60446344 used, 20302358+buff/cache KiB Swap: 8191996 total, 8190044 free, 1952 used. 20301048+avail Mem PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 32467 umshastr 20 0 56.061g 0.053t 11876 S 6.7 21.7 24:37.32 mysqld 20170809 14:29:43 top - 14:29:43 up 18 days, 22:04, 4 users, load average: 1.25, 1.27, 1.19 Tasks: 1 total, 0 running, 1 sleeping, 0 stopped, 0 zombie %Cpu(s): 6.3 us, 0.4 sy, 0.0 ni, 93.3 id, 0.0 wa, 0.0 hi, 0.0 si, 0.0 st KiB Mem : 26409883+total, 13864068 free, 47230032 used, 20300473+buff/cache KiB Swap: 8191996 total, 8190036 free, 1960 used. 21622699+avail Mem