- 8.0.17

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

commit: a5b2e523c881ab8c68fd0adb478a6232dd69e522
date: 2019-06-25 11:50:40 +0200
build-date: 2019-06-25 12:24:04 +0200
short: a5b2e52
branch: mysql-8.0.17-release

MySQL source 8.0.17



#/bin/bash
function do_db {
        db_exist=$(bin/mysql -uroot -S /tmp/mysql_ushastry.sock -A -s -Nbe "select 1 from information_schema.schemata where schema_name = '$db'")
        if [ "$db_exist" == "1" ]; then echo "Already exists $db"; return 0; fi;
        bin/mysql -uroot -S /tmp/mysql_ushastry.sock -vvv -e "create database $db";
        bin/mysql -uroot -S /tmp/mysql_ushastry.sock -vvv $db -e "CREATE TABLESPACE $db ADD DATAFILE '$db.ibd' engine=InnoDB;"
        for i in {1..5}
        do
                table="CREATE TABLE tbl$i ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace $db;"
                bin/mysql -uroot -S /tmp/mysql_ushastry.sock $db -e "$table"
        done
}
c=0
for m in {1..1000}
do
        for i in {1..5}
        do
                let c=$c+1
                echo $c
                db="customer_$c"
                do_db &
        done
        wait
done

- sysbench

conn=" --db-driver=mysql --mysql-host=127.0.0.1 --mysql-db=test --mysql-user=ushastry --mysql-password=mysql123 --mysql-port=3333 "
bin/sysbench $conn --report-interval=1 --num-threads=16 --max-requests=0 --max-time=300 --test=share/sysbench/select_custom.lua run | tee -a sysbench_80.txt

SQL statistics:
    queries performed:
        read:                            6216476
        write:                           0
        other:                           0
        total:                           6216476
    transactions:                        6216476 (20721.30 per sec.)
    queries:                             6216476 (20721.30 per sec.)
    ignored errors:                      0      (0.00 per sec.)
    reconnects:                          0      (0.00 per sec.)

General statistics:
    total time:                          300.0023s
    total number of events:              6216476

Latency (ms):
         min:                                  0.10
         avg:                                  0.77
         max:                                102.51
         95th percentile:                      3.36
         sum:                            4789158.11

Threads fairness:
    events (avg/stddev):           388529.7500/2402.79
    execution time (avg/stddev):   299.3224/0.01



- 5.7.27

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

- build used

cat docs/INFO_SRC
commit: 8ccfc51ab8d361be94168fe04b6818d0b234c9c0
date: 2019-06-10 20:06:14 +0530
build-date: 2019-06-10 16:43:41 +0200
short: 8ccfc51
branch: mysql-5.7.27-release

MySQL source 5.7.27


#/bin/bash
function do_db {
        db_exist=$(bin/mysql -uroot -S /tmp/mysql_ushastry.sock -A -s -Nbe "select 1 from information_schema.schemata where schema_name = '$db'")
        if [ "$db_exist" == "1" ]; then echo "Already exists $db"; return 0; fi;
        bin/mysql -uroot -S /tmp/mysql_ushastry.sock -vvv -e "create database $db";
        for i in {1..5}
        do
                table="CREATE TABLE tbl$i ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;"
                bin/mysql -uroot -S /tmp/mysql_ushastry.sock  $db -e "$table"
        done
}
c=0
for m in {1..1000}
do
        for i in {1..5}
        do
                let c=$c+1
                echo $c
                db="customer_$c"
                do_db &
        done
        wait
done

conn=" --db-driver=mysql --mysql-host=127.0.0.1 --mysql-db=test --mysql-user=ushastry --mysql-password=mysql123 --mysql-port=3333 "
bin/sysbench $conn --report-interval=1 --num-threads=16 --max-requests=0 --max-time=300 --test=share/sysbench/select_custom.lua run | tee -a sysbench_57.txt

-
SQL statistics:
    queries performed:
        read:                            21521202
        write:                           0
        other:                           0
        total:                           21521202
    transactions:                        21521202 (71736.39 per sec.)
    queries:                             21521202 (71736.39 per sec.)
    ignored errors:                      0      (0.00 per sec.)
    reconnects:                          0      (0.00 per sec.)

General statistics:
    total time:                          300.0020s
    total number of events:              21521202

Latency (ms):
         min:                                  0.09
         avg:                                  0.22
         max:                                107.62
         95th percentile:                      0.64
         sum:                            4765849.29

Threads fairness:
    events (avg/stddev):           1345075.1250/4749.60
    execution time (avg/stddev):   297.8656/0.01