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

-- 5.7.29
- terminal 1

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

mysql> use test
Database changed
mysql> CREATE TABLE test (id int unsigned NOT NULL AUTO_INCREMENT, a varchar(20), b int, c timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, d varchar(10), PRIMARY KEY (id), UNIQUE KEY uk1 (a,b,d)) ENGINE=InnoDB ;
Query OK, 0 rows affected (0.01 sec)


- terminal 2

 for i in {1..2000}; do bin/mysql -uroot -S /tmp/mysql_ushastry.sock test -e "REPLACE INTO test SET id=NULL, a='foobar', b = 2, d = 'boobar' "; done & for i in {1..1000}; do bin/mysql -uroot -S /tmp/mysql_ushastry.sock test -e "REPLACE INTO test SET id=NULL, a='foobar', b = 1, d = 'boobar' "; done &
[1] 17532
[2] 17533
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.29: ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction

[1]-  Done                    for i in {1..2000};
do
    bin/mysql -uroot -S /tmp/mysql_ushastry.sock test -e "REPLACE INTO test SET id=NULL, a='foobar', b = 2, d = 'boobar' ";
done
[2]+  Done                    for i in {1..1000};
do
    bin/mysql -uroot -S /tmp/mysql_ushastry.sock test -e "REPLACE INTO test SET id=NULL, a='foobar', b = 1, d = 'boobar' ";
done

-- 5.7.26

 for i in {1..2000}; do bin/mysql -uroot -S /tmp/mysql_ushastry.sock test -e "REPLACE INTO test SET id=NULL, a='foobar', b = 2, d = 'boobar' "; done & for i in {1..1000}; do bin/mysql -uroot -S /tmp/mysql_ushastry.sock test -e "REPLACE INTO test SET id=NULL, a='foobar', b = 1, d = 'boobar' "; done &
[1] 14024
[2] 14025
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.26: ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction

[1]-  Done                    for i in {1..2000};
do
    bin/mysql -uroot -S /tmp/mysql_ushastry.sock test -e "REPLACE INTO test SET id=NULL, a='foobar', b = 2, d = 'boobar' ";
done
[2]+  Done                    for i in {1..1000};
do
    bin/mysql -uroot -S /tmp/mysql_ushastry.sock test -e "REPLACE INTO test SET id=NULL, a='foobar', b = 1, d = 'boobar' ";
done

-- 5.7.25

 for i in {1..2000}; do bin/mysql -uroot -S /tmp/mysql_ushastry.sock test -e "REPLACE INTO test SET id=NULL, a='foobar', b = 2, d = 'boobar' "; done & for i in {1..1000}; do bin/mysql -uroot -S /tmp/mysql_ushastry.sock test -e "REPLACE INTO test SET id=NULL, a='foobar', b = 1, d = 'boobar' "; done &
[1] 20790
[2] 20791
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.25: ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction

[1]-  Done                    for i in {1..2000};
do
    bin/mysql -uroot -S /tmp/mysql_ushastry.sock test -e "REPLACE INTO test SET id=NULL, a='foobar', b = 2, d = 'boobar' ";
done
[2]+  Done                    for i in {1..1000};
do
    bin/mysql -uroot -S /tmp/mysql_ushastry.sock test -e "REPLACE INTO test SET id=NULL, a='foobar', b = 1, d = 'boobar' ";
done


- 8.0.19 seems be same as 5.7.26+

 for i in {1..2000}; do bin/mysql -uroot -S /tmp/mysql_ushastry.sock test -e "REPLACE INTO test SET id=NULL, a='foobar', b = 2, d = 'boobar' "; done & for i in {1..1000}; do bin/mysql -uroot -S /tmp/mysql_ushastry.sock test -e "REPLACE INTO test SET id=NULL, a='foobar', b = 1, d = 'boobar' "; done &
[1] 24313
[2] 24314
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-8.0.19: ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction
ERROR 1213 (40001) at line 1: Deadlock found when trying to get lock; try restarting transaction

[1]-  Done                    for i in {1..2000};
do
    bin/mysql -uroot -S /tmp/mysql_ushastry.sock test -e "REPLACE INTO test SET id=NULL, a='foobar', b = 2, d = 'boobar' ";
done
[2]+  Done                    for i in {1..1000};
do
    bin/mysql -uroot -S /tmp/mysql_ushastry.sock test -e "REPLACE INTO test SET id=NULL, a='foobar', b = 1, d = 'boobar' ";
done