Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Incomplete
-
10.5.4
-
Ubuntu-18.04
Description
start mariadb with:
transaction_isolation=READ-UNCOMMITTED
transaction_isolation=READ-COMMITTED
transaction_isolation=REPEATABLE-READ
transaction_isolation=SERIALIZABLE
respectively, and innodb_lock_wait_timeout=3600000 then run:
./mysql-test-run.pl \ |
--extern socket=/var/run/mysqld/mysqld.sock \ |
--report-times \ |
--max-connections=16 \
|
--max-test-fail=0 \ |
--retry-failure=0 \
|
--testcase-timeout=60 \
|
--force \
|
--repeat=10 \
|
main.deadlock_innodb
|
I got the results shown in Figure_1.png. I checked for 'top' and observe trival CPU/mem pressure (may be a deadlock). While I expect this won't happen even though 'SERIALIZABLE' provide the best isolation level among the four.
In MySQL-8.0.19, I got the results shown in Figure_2.png (repeat=100). Thouth the time spent is not stable, test finally got finished.