質問編集履歴
2
動作環境下部へ追記を記載しました
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -31,3 +31,8 @@
|
|
|
31
31
|
動作環境(Xserver)
|
|
32
32
|
MariaDB 10.5
|
|
33
33
|
PHP 7.4.25
|
|
34
|
+
追記：
|
|
35
|
+
`'SELECT @@GLOBAL.tx_isolation, @@tx_isolation'`
|
|
36
|
+
REPEATABLE-READ, REPEATABLE-READ
|
|
37
|
+
|
|
38
|
+
クエリ1，2，3は別セッションとなります（3セッション）
|
1
MAX(cmid) 誤字を MAX(id) へ変更しました
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -13,11 +13,11 @@
|
|
|
13
13
|
- クエリ1. (初期データ)
|
|
14
14
|
`INSERT INTO testtable (id, name) VALUES (1, 'yamada');`
|
|
15
15
|
- クエリ2. (処理時間稼ぐ為のデータ)
|
|
16
|
-
`INSERT INTO testtable (id, name) SELECT COALESCE(MAX(
|
|
16
|
+
`INSERT INTO testtable (id, name) SELECT COALESCE(MAX(id)+1,1), 'kato' FROM testtable;`
|
|
17
|
-
`INSERT INTO testtable (id, name) SELECT COALESCE(MAX(
|
|
17
|
+
`INSERT INTO testtable (id, name) SELECT COALESCE(MAX(id)+1,1), 'sato' FROM testtable;`
|
|
18
18
|
......（2,000件程度）
|
|
19
19
|
- クエリ3.
|
|
20
|
-
`INSERT INTO testtable (id, name) SELECT COALESCE(MAX(
|
|
20
|
+
`INSERT INTO testtable (id, name) SELECT COALESCE(MAX(id)+1,1), 'suzuki' FROM testtable;`
|
|
21
21
|
|
|
22
22
|
|
|
23
23
|
当方の認識としては、
|