##### Session 1

#####  Build used

cat docs/INFO_SRC
commit: 219340a29ccb6522a108e6bf143be9c7e18164ed
date: 2019-04-13 15:27:18 +0200
build-date: 2019-04-13 15:32:29 +0200
short: 219340a
branch: mysql-5.7.26-release

MySQL source 5.7.26


#####  Env 

cat /etc/*release
Oracle Linux Server release 7.1
NAME="Oracle Linux Server"
VERSION="7.1"
ID="ol"
VERSION_ID="7.1"
PRETTY_NAME="Oracle Linux Server 7.1"
ANSI_COLOR="0;31"
CPE_NAME="cpe:/o:oracle:linux:7:1"
HOME_URL="https://linux.oracle.com/"
BUG_REPORT_URL="https://bugzilla.oracle.com/"

ORACLE_BUGZILLA_PRODUCT="Oracle Linux 7"
ORACLE_BUGZILLA_PRODUCT_VERSION=7.1
ORACLE_SUPPORT_PRODUCT="Oracle Linux"
ORACLE_SUPPORT_PRODUCT_VERSION=7.1
Red Hat Enterprise Linux Server release 7.1 (Maipo)
Oracle Linux Server release 7.1

#####  Start up

rm -rf 96197/
bin/mysqld --initialize-insecure --basedir=$PWD --datadir=$PWD/96197 --log-error-verbosity=3
bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/96197 --core-file --socket=/tmp/mysql_ushastry.sock  --port=3333 --log-error=$PWD/96197/log.err --log-error-verbosity=3  --secure-file-priv=/tmp/ 2>&1 &

- Don't forget to create create user root@'%';  grant all on *.* to 'root'@'%';

#####  Used Shane's trick instead of Docker one

 cat test.sh test1.sh test2.sh
#!/bin/bash

i="0"
while [ $i -lt 15000 ]
do
#myVar=`perl -e 'printf "%vd\n",pack "N",rand 256**4'`
#echo $myVar
#myVar=`printf "%d.%d.%d.%d\n" "127" "0" "0" "$((RANDOM % 256))"`
myVar=`printf "%d.%d.%d.%d\n" "127" "0" "$((RANDOM % 256))" "$((RANDOM % 256))"`
#myVar=`printf "%d.%d.%d.%d\n" "127" "0" "0" "$((RANDOM % 256))"`
#myVar=`printf "%d.%d.%d.%d\n" "127" "0" "0" "$((RANDOM % 256))"`
bin/mysql -uroot --protocol=tcp --port=3333 --bind-address=$myVar -e "select count(*) from performance_schema.hosts"
i=$[$i+1]
done
#!/bin/bash

i="0"
while [ $i -lt 15000 ]
do
myVar=`printf "%d.%d.%d.%d\n" "127" "$((RANDOM % 256))" "$((RANDOM % 256))" "$((RANDOM % 256))"`
bin/mysql -uroot --protocol=tcp --port=3333 --bind-address=$myVar -e "select count(*) from performance_schema.hosts"
i=$[$i+1]
done
#!/bin/bash

i="0"
while [ $i -lt 15000 ]
do
myVar=`printf "%d.%d.%d.%d\n" "127" "$((RANDOM % 256))" "$((RANDOM % 256))" "0"`
bin/mysql -uroot --protocol=tcp --port=3333 --bind-address=$myVar -e "select count(*) from performance_schema.hosts"
i=$[$i+1]
done

#####  Session 2

./test.sh
.
.
+----------+
| count(*) |
+----------+
|    16363 |
+----------+
+----------+
| count(*) |
+----------+
|    16363 |
+----------+

^C^C -- query aborted

#####  Session 3

./test1.sh

+----------+
| count(*) |
+----------+
|    16363 |
+----------+
+----------+
| count(*) |
+----------+
|    16363 |
+----------+


#####  Session 4

./test2.sh
.
.
+----------+
| count(*) |
+----------+
|    16363 |
+----------+
+----------+
| count(*) |
+----------+
|    16363 |
+----------+


#####  Session 5

- before select count(*) from performance_schema.hosts" < 16K
bin/mysql -uroot -S /tmp/mysql_ushastry.sock
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1276
Server version: 5.7.26 MySQL Community Server (GPL)

Copyright (c) 2000, 2019, 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> show global status like 'Performance_schema_hosts_lost';
+-------------------------------+-------+
| Variable_name                 | Value |
+-------------------------------+-------+
| Performance_schema_hosts_lost | 0     |
+-------------------------------+-------+
1 row in set (0.01 sec)

mysql>

- After select count(*) from performance_schema.hosts" > 16K

mysql> show global status like 'Performance_schema_hosts_lost';
+-------------------------------+-------+
| Variable_name                 | Value |
+-------------------------------+-------+
| Performance_schema_hosts_lost | 232   | <-- keep on increasing
+-------------------------------+-------+
1 row in set (0.00 sec)

mysql>