#################### Environment

uname -an
Linux support-cluster03 5.4.17-2102.206.1.el7uek.x86_64 #2 SMP Wed Oct 6 16:40:40 PDT 2021 x86_64 x86_64 x86_64 GNU/Linux

System Summary Report ######################
        Date | 2023-10-23 05:22:05 UTC (local TZ: CEST +0200)
      Uptime | 640 days, 11:50,  3 users,  load average: 0.11, 0.31, 0.27
    Platform | Linux
     Release | Red Hat Enterprise Linux Server release 7.9 (Maipo)
      Kernel | 5.4.17-2102.206.1.el7uek.x86_64
Architecture | CPU = 64-bit, OS = 64-bit
   Threading | NPTL 2.17
    Compiler | GNU CC version 4.8.5 20150623 (Red Hat 4.8.5-44.0.3).
     SELinux | Disabled
 Virtualized | VMWare
# Processor ##################################################
  Processors | physical = 1, cores = 8, virtual = 16, hyperthreading = yes
      Speeds | 16x2445.406
      Models | 16xAMD EPYC 7J13 64-Core Processor
      Caches | 16x512 KB
# Memory #####################################################
       Total | 117.4G
        Free | 4.0G
        Used | physical = 2.1G, swap allocated = 8.0G, swap used = 1.7G, virtual = 3.7G
      Shared | 6.5G
     Buffers | 111.3G
      Caches | 107.7G
       Dirty | 144 kB
     UsedRSS | 1.9G
  Swappiness | 60
 DirtyPolicy | 20, 10
 DirtyStatus | 0, 0



#################### 5.7.43

-- build used

cat docs/INFO_SRC
commit: 4346a1d04fc6ef8683bd16e5bc35ff6a7993b493
date: 2023-06-21 14:58:21 +0200
build-date: 2023-06-21 13:02:22 +0000
short: 4346a1d04fc
branch: mysql-5.7.43-release

MySQL source 5.7.43

-- start up (default settings)

rm -rf 112787/
bin/mysqld --no-defaults --initialize-insecure --basedir=$PWD --datadir=$PWD/112787 --log-error-verbosity=3
bin/mysqld_safe --no-defaults --basedir=$PWD --datadir=$PWD/112787 --core-file --socket=/tmp/mysql.sock  --port=3306 --log-error=$PWD/112787/log.err --log-error-verbosity=3  --secure-file-priv="" --local-infile=1 2>&1 &

 bin/mysql -uroot -S /tmp/mysql.sock
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 8.1.0 MySQL Community Server - GPL

Copyright (c) 2000, 2023, Oracle and/or its affiliates.

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> create database test;
Query OK, 1 row affected (0.00 sec)

mysql> use test
Database changed
mysql> DELIMITER $$
mysql> CREATE DEFINER=`user`@`%` PROCEDURE return_alpha_from_10k_uuids()
    label2: WHILE p2 < 36 DO
    -> SQL SECURITY INVOKER
    -> BEGIN
    ->   DECLARE STRLEN int;
    ->   DECLARE p1 int default 10000;
    ->   DECLARE p2 int default 0;
    ->   DECLARE retval varchar(50) default '';
    ->   DECLARE myuuid char(50) default '';
    ->
    ->   label1: WHILE p1 > 0 DO
    ->     SET p1 = p1 - 1;
    ->     select uuid() into myuuid;
    ->     set retval='';
    ->     set p2 = 0;
    ->     label2: WHILE p2 < 36 DO
    ->       set p2 = p2 + 1;
    ->       set retval = concat(retval,if(substring(myuuid, p2, 1) REGEXP '[[:alpha:]]', substring(myuuid, p2, 1), ''));
    ->     END WHILE label2;
    ->     select retval;
    ->   END WHILE label1;
    -> END$$
Query OK, 0 rows affected, 1 warning (0.01 sec)

mysql> DELIMITER ;
mysql> call return_alpha_from_10k_uuids();
.




bin/mysql -uroot -S /tmp/mysql.sock
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.43 MySQL Community Server (GPL)

Copyright (c) 2000, 2023, Oracle and/or its affiliates.

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> use test
Database changed
mysql> call return_alpha_from_10k_uuids();
.
.
Query OK, 0 rows affected (5.06 sec)
Query OK, 0 rows affected (3.27 sec)
Query OK, 0 rows affected (3.41 sec)
Query OK, 0 rows affected (3.19 sec)
Query OK, 0 rows affected (3.16 sec)

#################### 8.0.34

-- build

cat docs/INFO_SRC
commit: 5a8b5ea7251bc6fec043a69b434d34366c6899ec
date: 2023-06-22 09:38:31 +0200
build-date: 2023-06-22 11:09:16 +0000
short: 5a8b5ea7251
branch: mysql-8.0.34-release

MySQL source 8.0.34


-- startup
rm -rf 112787/
bin/mysqld --no-defaults --initialize-insecure --basedir=$PWD --datadir=$PWD/112787 --log-error-verbosity=3
bin/mysqld_safe --no-defaults --mysqld-version='' --basedir=$PWD --datadir=$PWD/112787 --core-file --socket=/tmp/mysql.sock  --port=3306 --log-error=$PWD/112787/log.err --mysqlx-port=33330 --mysqlx-socket=/tmp/mysql_x_ushastry.sock --log-error-verbosity=3  --secure-file-priv="" --local-infile=1  2>&1 &


bin/mysql -uroot -S /tmp/mysql.sock
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 8.0.34 MySQL Community Server - GPL

Copyright (c) 2000, 2023, Oracle and/or its affiliates.

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> create database test;
Query OK, 1 row affected (0.01 sec)

mysql> use test
Database changed
mysql> DELIMITER $$
mysql> CREATE DEFINER=`user`@`%` PROCEDURE return_alpha_from_10k_uuids()
    -> SQL SECURITY INVOKER
    -> BEGIN
    ->   DECLARE STRLEN int;
    ->   DECLARE p1 int default 10000;
    ->   DECLARE p2 int default 0;
    ->   DECLARE retval varchar(50) default '';
    ->   DECLARE myuuid char(50) default '';
    ->
    ->   label1: WHILE p1 > 0 DO
    ->     SET p1 = p1 - 1;
    ->     select uuid() into myuuid;
    ->     set retval='';
    ->     set p2 = 0;
    ->     label2: WHILE p2 < 36 DO
    ->       set p2 = p2 + 1;
    ->       set retval = concat(retval,if(substring(myuuid, p2, 1) REGEXP '[[:alpha:]]', substring(myuuid, p2, 1), ''));
    ->     END WHILE label2;
    ->     select retval;
    ->   END WHILE label1;
    -> END$$
Query OK, 0 rows affected, 1 warning (0.01 sec)

mysql> DELIMITER ;
mysql> call return_alpha_from_10k_uuids();
.

Query OK, 0 rows affected (1 min 57.89 sec)
Query OK, 0 rows affected (1 min 57.64 sec)
Query OK, 0 rows affected (1 min 57.75 sec)
Query OK, 0 rows affected (1 min 58.49 sec)
Query OK, 0 rows affected (1 min 58.42 sec)
Query OK, 0 rows affected (1 min 58.48 sec)

#################### 8.1.0

-- build
cat docs/INFO_SRC
commit: 7d3b61ea23a44d7dbd34dfdcb0c25ffb20699be8
date: 2023-06-21 09:39:09 +0200
build-date: 2023-06-21 07:53:44 +0000
short: 7d3b61ea23a
branch: mysql-8.1.0-release

MySQL source 8.1.0

-- start up

rm -rf 112787/
bin/mysqld --no-defaults --initialize-insecure --basedir=$PWD --datadir=$PWD/112787 --log-error-verbosity=3
bin/mysqld_safe --no-defaults --mysqld-version='' --basedir=$PWD --datadir=$PWD/112787 --core-file --socket=/tmp/mysql.sock  --port=3306 --log-error=$PWD/112787/log.err --mysqlx-port=33330 --mysqlx-socket=/tmp/mysql_x_ushastry.sock --log-error-verbosity=3  --secure-file-priv="" --local-infile=1  2>&1 &

 bin/mysql -uroot -S /tmp/mysql.sock
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 8.1.0 MySQL Community Server - GPL

Copyright (c) 2000, 2023, Oracle and/or its affiliates.

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> use test
Database changed
mysql> call return_alpha_from_10k_uuids();
.
Query OK, 0 rows affected (1 min 55.42 sec)
Query OK, 0 rows affected (1 min 55.49 sec)
Query OK, 0 rows affected (1 min 55.75 sec)
Query OK, 0 rows affected (1 min 55.82 sec)
Query OK, 0 rows affected (1 min 56.09 sec)

#################### 5.0.61

 bin/mysql -uroot -S /tmp/mysql_ushastry.sock
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.51 MySQL Community Server (GPL)

Copyright (c) 2000, 2021, 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> use test
Database changed
mysql> DELIMITER $$
mysql> CREATE DEFINER=`user`@`%` PROCEDURE return_alpha_from_10k_uuids()
    -> SQL SECURITY INVOKER
    -> BEGIN
    ->   DECLARE STRLEN int;
    ->   DECLARE p1 int default 10000;
    ->   DECLARE p2 int default 0;
    ->   DECLARE retval varchar(50) default '';
    ->   DECLARE myuuid char(50) default '';
    ->
    ->   label1: WHILE p1 > 0 DO
    ->     SET p1 = p1 - 1;
    ->     select uuid() into myuuid;
    ->     set retval='';
    ->     set p2 = 0;
    ->     label2: WHILE p2 < 36 DO
    ->       set p2 = p2 + 1;
    ->       set retval = concat(retval,if(substring(myuuid, p2, 1) REGEXP '[[:alpha:]]', substring(myuuid, p2, 1), ''));
    ->     END WHILE label2;
    ->     select retval;
    ->   END WHILE label1;
    -> END$$
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> DELIMITER ;
mysql> call return_alpha_from_10k_uuids();
.
Query OK, 0 rows affected (5.98 sec)
Query OK, 0 rows affected (2.39 sec)
Query OK, 0 rows affected (3.35 sec)
Query OK, 0 rows affected (3.30 sec)
Query OK, 0 rows affected (3.29 sec)