######## Environment used for verification

# System Summary Report ######################################
        Date | 2024-10-15 10:54:58 UTC (local TZ: CEST +0200)
    Hostname | support-cluster03
      Uptime | 998 days, 17:23,  5 users,  load average: 0.04, 0.49, 0.44
    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 | 6.0G
        Used | physical = 4.5G, swap allocated = 8.0G, swap used = 5.0G, virtual = 9.5G
      Shared | 8.0G
     Buffers | 106.9G
      Caches | 103.8G
       Dirty | 136 kB
     UsedRSS | 3.7G
  Swappiness | 60
 DirtyPolicy | 20, 10
 DirtyStatus | 0, 0
  Locator   Size     Speed             Form Factor   Type          Type Detail
  ========= ======== ================= ============= ============= ===========

######## 8.0.33

##. Set proxy if you are behind Oracle network	

[umshastr@support-cluster03:~/work/binaries/utils]$
[umshastr@support-cluster03:~/work/binaries/utils]$ export http_proxy=http://www-proxy.us.oracle.com:80
[umshastr@support-cluster03:~/work/binaries/utils]$ export https_proxy=http://www-proxy.us.oracle.com:80
[umshastr@support-cluster03:~/work/binaries/utils]$ export ftp_proxy=http://www-proxy.us.oracle.com:80
[umshastr@support-cluster03:~/work/binaries/utils]$

## Download required binary tarball package

[umshastr@support-cluster03:~/work/binaries/utils]$ ./dbdeployer downloads get mysql-8.0.33-linux-glibc2.17-x86_64-minimal.tar.xz
Downloading mysql-8.0.33-linux-glibc2.17-x86_64-minimal.tar.xz
File /home/umshastr/work/binaries/utils/mysql-8.0.33-linux-glibc2.17-x86_64-minimal.tar.xz downloaded
Checksum matches
[umshastr@support-cluster03:~/work/binaries/utils]$

## Unpack the tarball

[umshastr@support-cluster03:~/work/binaries/utils]$ ./dbdeployer unpack mysql-8.0.33-linux-glibc2.17-x86_64-minimal.tar.xz
Unpacking tarball mysql-8.0.33-linux-glibc2.17-x86_64-minimal.tar.xz to $HOME/opt/mysql/8.0.33
.........100.........200......268
Renaming directory /home/umshastr/opt/mysql/mysql-8.0.33-linux-glibc2.17-x86_64-minimal to /home/umshastr/opt/mysql/8.0.33


[umshastr@support-cluster03:~]$ cd /home/umshastr/work/binaries/utils
[umshastr@support-cluster03:~/work/binaries/utils]$ dbdc="-c skip-log-bin"
[umshastr@support-cluster03:~/work/binaries/utils]$ dbdc="$dbdc -c innodb_buffer_pool_size=$((128*1024*1024))"
[umshastr@support-cluster03:~/work/binaries/utils]$ dbdc="$dbdc -c default-authentication-plugin=mysql_native_password"
[umshastr@support-cluster03:~/work/binaries/utils]$ ./dbdeployer deploy single 8.0.33 $dbdc
Database installed in $HOME/sandboxes/msb_8_0_33
run 'dbdeployer usage single' for basic instructions'
... sandbox server started
[umshastr@support-cluster03:~/work/binaries/utils]$


[umshastr@support-cluster03:~/sandboxes]$ cd msb_8_0_33/
[umshastr@support-cluster03:~/sandboxes/msb_8_0_33]$ ./use <<< "CREATE DATABASE sbtest"
[umshastr@support-cluster03:~/sandboxes/msb_8_0_33]$
[umshastr@support-cluster03:~/sandboxes/msb_8_0_33]$ nb_rows=$((2*1024*1024))
[umshastr@support-cluster03:~/sandboxes/msb_8_0_33]$ socket=$(awk '$1=="socket"{print $3; exit}' my.sandbox.cnf)
[umshastr@support-cluster03:~/sandboxes/msb_8_0_33]$ sba="/home/umshastr/work/binaries/utils/sysbench/share/sysbench/oltp_point_select.lua --rand-type=uniform --mysql-socket=$socket"
[umshastr@support-cluster03:~/sandboxes/msb_8_0_33]$ sba="$sba --mysql-user=msandbox --mysql-password=msandbox --mysql-db=sbtest"
[umshastr@support-cluster03:~/sandboxes/msb_8_0_33]$ sba="$sba --tables=1 --table_size=$nb_rows"
[umshastr@support-cluster03:~/sandboxes/msb_8_0_33]$ time /home/umshastr/work/binaries/utils/sysbench/bin/sysbench $sba prepare --create_secondary=off
sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2)

Creating table 'sbtest1'...
Inserting 2097152 records into 'sbtest1'

real	0m36.464s
user	0m2.130s
sys	0m0.072s
[umshastr@support-cluster03:~/sandboxes/msb_8_0_33]$ time { echo "ALTER TABLE sbtest1 ADD COLUMN c0 CHAR(60) DEFAULT ''"
>        seq -f " ADD COLUMN c%.0f CHAR(240) DEFAULT ''" 1 3
> } | paste -s -d "," | ./use sbtest

real	0m0.050s
user	0m0.002s
sys	0m0.006s
[umshastr@support-cluster03:~/sandboxes/msb_8_0_33]$ time ./use sbtest <<< "ALTER TABLE sbtest1 FORCE"

real	3m43.515s
user	0m0.004s
sys	0m0.003s
[umshastr@support-cluster03:~/sandboxes/msb_8_0_33]$ time ./use sbtest <<< "FLUSH TABLE sbtest1 FOR EXPORT"

real	0m0.034s
user	0m0.003s
sys	0m0.004s
[umshastr@support-cluster03:~/sandboxes/msb_8_0_33]$ for i in {1..5}; do /home/umshastr/work/binaries/utils/pv/bin/pv data/sbtest/sbtest1.ibd > /dev/null;  time ./use sbtest <<< "ALTER TABLE sbtest1 force"; done
2.47GiB 0:00:12 [ 210MiB/s] [==============================================================================================================================================================================================>] 100%

real	4m29.766s
user	0m0.004s
sys	0m0.003s
2.47GiB 0:00:12 [ 199MiB/s] [==============================================================================================================================================================================================>] 100%

real	3m47.420s
user	0m0.003s
sys	0m0.004s
2.47GiB 0:00:12 [ 207MiB/s] [==============================================================================================================================================================================================>] 100%

real	3m46.671s
user	0m0.003s
sys	0m0.004s
2.47GiB 0:00:12 [ 202MiB/s] [==============================================================================================================================================================================================>] 100%

real	3m49.263s
user	0m0.003s
sys	0m0.004s
2.47GiB 0:00:12 [ 197MiB/s] [==============================================================================================================================================================================================>] 100%

real	3m50.902s
user	0m0.002s
sys	0m0.005s

[umshastr@support-cluster03:~/sandboxes/msb_8_0_33]$ ./stop
stop /home/umshastr/sandboxes/msb_8_0_33
[umshastr@support-cluster03:~/sandboxes/msb_8_0_33]$


######## 5.7.42

 -- Not sure why but dbdeployer failing to download 5.7.42 build hence using wget to pull the binary tarball build

[umshastr@support-cluster03:~/work/binaries/utils]$ wget https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.42-linux-glibc2.12-x86_64.tar.gz
Continuing in background, pid 5715.

[umshastr@support-cluster03:~/work/binaries/utils]$ ./dbdeployer unpack mysql-5.7.42-linux-glibc2.12-x86_64.tar.gz
Unpacking tarball mysql-5.7.42-linux-glibc2.12-x86_64.tar.gz to $HOME/opt/mysql/5.7.42
.........100.........200.........300.......379
Renaming directory /home/umshastr/opt/mysql/mysql-5.7.42-linux-glibc2.12-x86_64 to /home/umshastr/opt/mysql/5.7.42
[umshastr@support-cluster03:~/work/binaries/utils]$ dbdc="-c skip-log-bin"
[umshastr@support-cluster03:~/work/binaries/utils]$ dbdc="$dbdc -c innodb_buffer_pool_size=$((128*1024*1024))"
[umshastr@support-cluster03:~/work/binaries/utils]$ dbdc="$dbdc -c default-authentication-plugin=mysql_native_password"
[umshastr@support-cluster03:~/work/binaries/utils]$ ./dbdeployer deploy single 5.7.42 $dbdc
Database installed in $HOME/sandboxes/msb_5_7_42
run 'dbdeployer usage single' for basic instructions'
. sandbox server started
[umshastr@support-cluster03:~/work/binaries/utils]$ cd ~/sandboxes/msb_5_7_42/
[umshastr@support-cluster03:~/sandboxes/msb_5_7_42]$ ./use <<< "CREATE DATABASE sbtest"
[umshastr@support-cluster03:~/sandboxes/msb_5_7_42]$
[umshastr@support-cluster03:~/sandboxes/msb_5_7_42]$ nb_rows=$((2*1024*1024))
[umshastr@support-cluster03:~/sandboxes/msb_5_7_42]$ socket=$(awk '$1=="socket"{print $3; exit}' my.sandbox.cnf)
[umshastr@support-cluster03:~/sandboxes/msb_5_7_42]$ sba="/home/umshastr/work/binaries/utils/sysbench/share/sysbench/oltp_point_select.lua --rand-type=uniform --mysql-socket=$socket"
[umshastr@support-cluster03:~/sandboxes/msb_5_7_42]$ sba="$sba --mysql-user=msandbox --mysql-password=msandbox --mysql-db=sbtest"
[umshastr@support-cluster03:~/sandboxes/msb_5_7_42]$ sba="$sba --tables=1 --table_size=$nb_rows"
[umshastr@support-cluster03:~/sandboxes/msb_5_7_42]$ time /home/umshastr/work/binaries/utils/sysbench/bin/sysbench $sba prepare --create_secondary=off
sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2)

Creating table 'sbtest1'...
Inserting 2097152 records into 'sbtest1'

real	0m26.223s
user	0m2.126s
sys	0m0.059s
[umshastr@support-cluster03:~/sandboxes/msb_5_7_42]$
[umshastr@support-cluster03:~/sandboxes/msb_5_7_42]$ time { echo "ALTER TABLE sbtest1 ADD COLUMN c0 CHAR(60) DEFAULT ''"
>        seq -f " ADD COLUMN c%.0f CHAR(240) DEFAULT ''" 1 3
> } | paste -s -d "," | ./use sbtest


real	0m56.933s
user	0m0.005s
sys	0m0.003s
[umshastr@support-cluster03:~/sandboxes/msb_5_7_42]$
[umshastr@support-cluster03:~/sandboxes/msb_5_7_42]$ time ./use sbtest <<< "ALTER TABLE sbtest1 FORCE"

real	1m10.879s
user	0m0.005s
sys	0m0.001s
[umshastr@support-cluster03:~/sandboxes/msb_5_7_42]$ time ./use sbtest <<< "FLUSH TABLE sbtest1 FOR EXPORT"

real	0m0.012s
user	0m0.004s
sys	0m0.001s
[umshastr@support-cluster03:~/sandboxes/msb_5_7_42]$ for i in {1..5}; do /home/umshastr/work/binaries/utils/pv/bin/pv data/sbtest/sbtest1.ibd > /dev/null;  time ./use sbtest <<< "ALTER TABLE sbtest1 force"; done
2.48GiB 0:00:12 [ 208MiB/s] [==============================================================================================================================================================================================>] 100%

real	0m56.810s
user	0m0.005s
sys	0m0.001s
2.48GiB 0:00:12 [ 201MiB/s] [==============================================================================================================================================================================================>] 100%

real	0m56.945s
user	0m0.003s
sys	0m0.003s
2.48GiB 0:00:12 [ 204MiB/s] [==============================================================================================================================================================================================>] 100%

real	0m56.768s
user	0m0.003s
sys	0m0.003s
2.48GiB 0:00:11 [ 216MiB/s] [==============================================================================================================================================================================================>] 100%

real	0m56.878s
user	0m0.003s
sys	0m0.003s
2.48GiB 0:00:12 [ 206MiB/s] [==============================================================================================================================================================================================>] 100%

real	0m56.674s
user	0m0.005s
sys	0m0.000s