####################################### 5.6 #######################################


rm -rf 104245/
scripts/mysql_install_db --basedir=$PWD --datadir=$PWD/104245
bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/104245 --core-file --socket=/tmp/mysql_ushastry.sock  --port=3333 --log-error=$PWD/104245/log.err --performance-schema=ON 2>&1 &


####################################### 5.7 #######################################

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

####################################### 8.0 #######################################

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


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

Copyright (c) 2000, 2021, 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> CREATE TABLE `t1` (
    ->   `c1` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    ->   `c2` bigint(20) NOT NULL,
    ->   `c3` bigint(20) NOT NULL,
    ->   `c4` bigint(20) NOT NULL,
    ->   `c5` bigint(20) NOT NULL,
    ->   PRIMARY KEY (`c1`),
    ->   UNIQUE KEY `UNIQUE_KEY` (`c2`,`c3`,`c4`)
    -> ) ENGINE=InnoDB ;
Query OK, 0 rows affected, 5 warnings (0.02 sec)

mysql> show warnings;
+---------+------+------------------------------------------------------------------------------+
| Level   | Code | Message                                                                      |
+---------+------+------------------------------------------------------------------------------+
| Warning | 1681 | Integer display width is deprecated and will be removed in a future release. |
| Warning | 1681 | Integer display width is deprecated and will be removed in a future release. |
| Warning | 1681 | Integer display width is deprecated and will be removed in a future release. |
| Warning | 1681 | Integer display width is deprecated and will be removed in a future release. |
| Warning | 1681 | Integer display width is deprecated and will be removed in a future release. |
+---------+------+------------------------------------------------------------------------------+
5 rows in set (0.00 sec)

mysql> INSERT IGNORE INTO t1 (c2, c3, c4, c5) values (1,1,1,1);
Query OK, 1 row affected (0.01 sec)

mysql> BEGIN ;
Query OK, 0 rows affected (0.00 sec)

mysql> INSERT IGNORE INTO t1 (c2, c3, c4, c5) values (1,1,1,1),(1,1,1,1),(1,1,1,1),(1,1,1,1),(1,1,1,1);
Query OK, 0 rows affected, 5 warnings (0.00 sec)
Records: 5  Duplicates: 5  Warnings: 5

mysql> show engine innodb status\G
*************************** 1. row ***************************
.
TRANSACTIONS
------------

---TRANSACTION 1556, ACTIVE 9 sec
5 lock struct(s), heap size 1136, 2 row lock(s)
MySQL thread id 7, OS thread handle 140113242208000, query id 13 localhost root starting

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

Copyright (c) 2000, 2021, 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> CREATE TABLE `t1` (
    ->   `c1` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    ->   `c2` bigint(20) NOT NULL,
    ->   `c3` bigint(20) NOT NULL,
    ->   `c4` bigint(20) NOT NULL,
    ->   `c5` bigint(20) NOT NULL,
    ->   PRIMARY KEY (`c1`),
    ->   UNIQUE KEY `UNIQUE_KEY` (`c2`,`c3`,`c4`)
    -> ) ENGINE=InnoDB ;
Query OK, 0 rows affected (0.01 sec)

mysql> INSERT IGNORE INTO t1 (c2, c3, c4, c5) values (1,1,1,1);
Query OK, 1 row affected (0.00 sec)

mysql> BEGIN ;
Query OK, 0 rows affected (0.00 sec)

mysql> INSERT IGNORE INTO t1 (c2, c3, c4, c5) values (1,1,1,1),(1,1,1,1),(1,1,1,1),(1,1,1,1),(1,1,1,1);
Query OK, 0 rows affected, 5 warnings (0.00 sec)
Records: 5  Duplicates: 5  Warnings: 5

mysql> show engine innodb status\G
*************************** 1. row ***************************
  Type: InnoDB
  Name:
Status:
.
------------
TRANSACTIONS
------------
.
---TRANSACTION 1288, ACTIVE 7 sec
5 lock struct(s), heap size 1136, 10 row lock(s)
MySQL thread id 2, OS thread handle 140268398806784, query id 12 localhost root starting

-- 5.6.50


 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.50 MySQL Community Server (GPL)

Copyright (c) 2000, 2020, 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> CREATE TABLE `t1` (
    ->   `c1` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    ->   `c2` bigint(20) NOT NULL,
    ->   `c3` bigint(20) NOT NULL,
    ->   `c4` bigint(20) NOT NULL,
    ->   `c5` bigint(20) NOT NULL,
    ->   PRIMARY KEY (`c1`),
    ->   UNIQUE KEY `UNIQUE_KEY` (`c2`,`c3`,`c4`)
    -> ) ENGINE=InnoDB ;
Query OK, 0 rows affected (0.02 sec)

mysql> INSERT IGNORE INTO t1 (c2, c3, c4, c5) values (1,1,1,1);
Query OK, 1 row affected (0.00 sec)

mysql>  BEGIN ;
Query OK, 0 rows affected (0.00 sec)

mysql> INSERT IGNORE INTO t1 (c2, c3, c4, c5) values (1,1,1,1),(1,1,1,1),(1,1,1,1),(1,1,1,1),(1,1,1,1);
Query OK, 0 rows affected (0.00 sec)
Records: 5  Duplicates: 5  Warnings: 0

mysql> SHOW ENGINE INNODB STATUS\G
*************************** 1. row ***************************
  Type: InnoDB
  Name:
Status:
.
------------
TRANSACTIONS
------------
.
---TRANSACTION 1799, ACTIVE 8 sec
2 lock struct(s), heap size 360, 1 row lock(s)
MySQL thread id 1, OS thread handle 0x7feeaf381700, query id 11 localhost root init