| 1 |
CREATE TABLE t1(id INT PRIMARY KEY, v INT NOT NULL) ENGINE=InnoDB; |
| 2 |
# Adding debug point 'trx_sys_rw_trx_add_rc' to @@GLOBAL.debug |
| 3 |
CREATE PROCEDURE create_rw_transactions(k INT) |
| 4 |
BEGIN |
| 5 |
WHILE 1 DO |
| 6 |
START TRANSACTION; |
| 7 |
UPDATE t1 SET v=v+1 WHERE id=k; |
| 8 |
COMMIT; |
| 9 |
END WHILE; |
| 10 |
END| |
| 11 |
INSERT INTO t1 (id,v) VALUES (0,0); |
| 12 |
CALL create_rw_transactions(0); |
| 13 |
INSERT INTO t1 (id,v) VALUES (1,0); |
| 14 |
CALL create_rw_transactions(1); |
| 15 |
INSERT INTO t1 (id,v) VALUES (2,0); |
| 16 |
CALL create_rw_transactions(2); |
| 17 |
INSERT INTO t1 (id,v) VALUES (3,0); |
| 18 |
CALL create_rw_transactions(3); |
| 19 |
INSERT INTO t1 (id,v) VALUES (4,0); |
| 20 |
CALL create_rw_transactions(4); |
| 21 |
INSERT INTO t1 (id,v) VALUES (5,0); |
| 22 |
CALL create_rw_transactions(5); |
| 23 |
INSERT INTO t1 (id,v) VALUES (6,0); |
| 24 |
CALL create_rw_transactions(6); |
| 25 |
INSERT INTO t1 (id,v) VALUES (7,0); |
| 26 |
CALL create_rw_transactions(7); |
| 27 |
INSERT INTO t1 (id,v) VALUES (8,0); |
| 28 |
CALL create_rw_transactions(8); |
| 29 |
INSERT INTO t1 (id,v) VALUES (9,0); |
| 30 |
CALL create_rw_transactions(9); |
| 31 |
INSERT INTO t1 (id,v) VALUES (10,0); |
| 32 |
CALL create_rw_transactions(10); |
| 33 |
INSERT INTO t1 (id,v) VALUES (11,0); |
| 34 |
CALL create_rw_transactions(11); |
| 35 |
INSERT INTO t1 (id,v) VALUES (12,0); |
| 36 |
CALL create_rw_transactions(12); |
| 37 |
INSERT INTO t1 (id,v) VALUES (13,0); |
| 38 |
CALL create_rw_transactions(13); |
| 39 |
INSERT INTO t1 (id,v) VALUES (14,0); |
| 40 |
CALL create_rw_transactions(14); |
| 41 |
INSERT INTO t1 (id,v) VALUES (15,0); |
| 42 |
CALL create_rw_transactions(15); |
| 43 |
INSERT INTO t1 (id,v) VALUES (16,0); |
| 44 |
CALL create_rw_transactions(16); |
| 45 |
INSERT INTO t1 (id,v) VALUES (17,0); |
| 46 |
CALL create_rw_transactions(17); |
| 47 |
INSERT INTO t1 (id,v) VALUES (18,0); |
| 48 |
CALL create_rw_transactions(18); |
| 49 |
INSERT INTO t1 (id,v) VALUES (19,0); |
| 50 |
CALL create_rw_transactions(19); |
| 51 |
INSERT INTO t1 (id,v) VALUES (20,0); |
| 52 |
CALL create_rw_transactions(20); |
| 53 |
INSERT INTO t1 (id,v) VALUES (21,0); |
| 54 |
CALL create_rw_transactions(21); |
| 55 |
INSERT INTO t1 (id,v) VALUES (22,0); |
| 56 |
CALL create_rw_transactions(22); |
| 57 |
INSERT INTO t1 (id,v) VALUES (23,0); |
| 58 |
CALL create_rw_transactions(23); |
| 59 |
INSERT INTO t1 (id,v) VALUES (24,0); |
| 60 |
CALL create_rw_transactions(24); |
| 61 |
INSERT INTO t1 (id,v) VALUES (25,0); |
| 62 |
CALL create_rw_transactions(25); |
| 63 |
INSERT INTO t1 (id,v) VALUES (26,0); |
| 64 |
CALL create_rw_transactions(26); |
| 65 |
INSERT INTO t1 (id,v) VALUES (27,0); |
| 66 |
CALL create_rw_transactions(27); |
| 67 |
INSERT INTO t1 (id,v) VALUES (28,0); |
| 68 |
CALL create_rw_transactions(28); |
| 69 |
INSERT INTO t1 (id,v) VALUES (29,0); |
| 70 |
CALL create_rw_transactions(29); |
| 71 |
INSERT INTO t1 (id,v) VALUES (30,0); |
| 72 |
CALL create_rw_transactions(30); |
| 73 |
INSERT INTO t1 (id,v) VALUES (31,0); |
| 74 |
CALL create_rw_transactions(31); |
| 75 |
INSERT INTO t1 (id,v) VALUES (32,0); |
| 76 |
CALL create_rw_transactions(32); |
| 77 |
INSERT INTO t1 (id,v) VALUES (33,0); |
| 78 |
CALL create_rw_transactions(33); |
| 79 |
INSERT INTO t1 (id,v) VALUES (34,0); |
| 80 |
CALL create_rw_transactions(34); |
| 81 |
INSERT INTO t1 (id,v) VALUES (35,0); |
| 82 |
CALL create_rw_transactions(35); |
| 83 |
INSERT INTO t1 (id,v) VALUES (36,0); |
| 84 |
CALL create_rw_transactions(36); |
| 85 |
INSERT INTO t1 (id,v) VALUES (37,0); |
| 86 |
CALL create_rw_transactions(37); |
| 87 |
INSERT INTO t1 (id,v) VALUES (38,0); |
| 88 |
CALL create_rw_transactions(38); |
| 89 |
INSERT INTO t1 (id,v) VALUES (39,0); |
| 90 |
CALL create_rw_transactions(39); |
| 91 |
INSERT INTO t1 (id,v) VALUES (40,0); |
| 92 |
CALL create_rw_transactions(40); |
| 93 |
INSERT INTO t1 (id,v) VALUES (41,0); |
| 94 |
CALL create_rw_transactions(41); |
| 95 |
INSERT INTO t1 (id,v) VALUES (42,0); |
| 96 |
CALL create_rw_transactions(42); |
| 97 |
INSERT INTO t1 (id,v) VALUES (43,0); |
| 98 |
CALL create_rw_transactions(43); |
| 99 |
INSERT INTO t1 (id,v) VALUES (44,0); |
| 100 |
CALL create_rw_transactions(44); |
| 101 |
INSERT INTO t1 (id,v) VALUES (45,0); |
| 102 |
CALL create_rw_transactions(45); |
| 103 |
INSERT INTO t1 (id,v) VALUES (46,0); |
| 104 |
CALL create_rw_transactions(46); |
| 105 |
INSERT INTO t1 (id,v) VALUES (47,0); |
| 106 |
CALL create_rw_transactions(47); |
| 107 |
INSERT INTO t1 (id,v) VALUES (48,0); |
| 108 |
CALL create_rw_transactions(48); |
| 109 |
INSERT INTO t1 (id,v) VALUES (49,0); |
| 110 |
CALL create_rw_transactions(49); |
| 111 |
INSERT INTO t1 (id,v) VALUES (50,0); |
| 112 |
CALL create_rw_transactions(50); |
| 113 |
INSERT INTO t1 (id,v) VALUES (51,0); |
| 114 |
CALL create_rw_transactions(51); |
| 115 |
INSERT INTO t1 (id,v) VALUES (52,0); |
| 116 |
CALL create_rw_transactions(52); |
| 117 |
INSERT INTO t1 (id,v) VALUES (53,0); |
| 118 |
CALL create_rw_transactions(53); |
| 119 |
INSERT INTO t1 (id,v) VALUES (54,0); |
| 120 |
CALL create_rw_transactions(54); |
| 121 |
INSERT INTO t1 (id,v) VALUES (55,0); |
| 122 |
CALL create_rw_transactions(55); |
| 123 |
INSERT INTO t1 (id,v) VALUES (56,0); |
| 124 |
CALL create_rw_transactions(56); |
| 125 |
INSERT INTO t1 (id,v) VALUES (57,0); |
| 126 |
CALL create_rw_transactions(57); |
| 127 |
INSERT INTO t1 (id,v) VALUES (58,0); |
| 128 |
CALL create_rw_transactions(58); |
| 129 |
INSERT INTO t1 (id,v) VALUES (59,0); |
| 130 |
CALL create_rw_transactions(59); |
| 131 |
INSERT INTO t1 (id,v) VALUES (60,0); |
| 132 |
CALL create_rw_transactions(60); |
| 133 |
INSERT INTO t1 (id,v) VALUES (61,0); |
| 134 |
CALL create_rw_transactions(61); |
| 135 |
INSERT INTO t1 (id,v) VALUES (62,0); |
| 136 |
CALL create_rw_transactions(62); |
| 137 |
INSERT INTO t1 (id,v) VALUES (63,0); |
| 138 |
CALL create_rw_transactions(63); |
| 139 |
INSERT INTO t1 (id,v) VALUES (64,0); |
| 140 |
CALL create_rw_transactions(64); |
| 141 |
INSERT INTO t1 (id,v) VALUES (65,0); |
| 142 |
CALL create_rw_transactions(65); |
| 143 |
INSERT INTO t1 (id,v) VALUES (66,0); |
| 144 |
CALL create_rw_transactions(66); |
| 145 |
INSERT INTO t1 (id,v) VALUES (67,0); |
| 146 |
CALL create_rw_transactions(67); |
| 147 |
INSERT INTO t1 (id,v) VALUES (68,0); |
| 148 |
CALL create_rw_transactions(68); |
| 149 |
INSERT INTO t1 (id,v) VALUES (69,0); |
| 150 |
CALL create_rw_transactions(69); |
| 151 |
INSERT INTO t1 (id,v) VALUES (70,0); |
| 152 |
CALL create_rw_transactions(70); |
| 153 |
INSERT INTO t1 (id,v) VALUES (71,0); |
| 154 |
CALL create_rw_transactions(71); |
| 155 |
INSERT INTO t1 (id,v) VALUES (72,0); |
| 156 |
CALL create_rw_transactions(72); |
| 157 |
INSERT INTO t1 (id,v) VALUES (73,0); |
| 158 |
CALL create_rw_transactions(73); |
| 159 |
INSERT INTO t1 (id,v) VALUES (74,0); |
| 160 |
CALL create_rw_transactions(74); |
| 161 |
INSERT INTO t1 (id,v) VALUES (75,0); |
| 162 |
CALL create_rw_transactions(75); |
| 163 |
INSERT INTO t1 (id,v) VALUES (76,0); |
| 164 |
CALL create_rw_transactions(76); |
| 165 |
INSERT INTO t1 (id,v) VALUES (77,0); |
| 166 |
CALL create_rw_transactions(77); |
| 167 |
INSERT INTO t1 (id,v) VALUES (78,0); |
| 168 |
CALL create_rw_transactions(78); |
| 169 |
INSERT INTO t1 (id,v) VALUES (79,0); |
| 170 |
CALL create_rw_transactions(79); |
| 171 |
INSERT INTO t1 (id,v) VALUES (80,0); |
| 172 |
CALL create_rw_transactions(80); |
| 173 |
INSERT INTO t1 (id,v) VALUES (81,0); |
| 174 |
CALL create_rw_transactions(81); |
| 175 |
INSERT INTO t1 (id,v) VALUES (82,0); |
| 176 |
CALL create_rw_transactions(82); |
| 177 |
INSERT INTO t1 (id,v) VALUES (83,0); |
| 178 |
CALL create_rw_transactions(83); |
| 179 |
INSERT INTO t1 (id,v) VALUES (84,0); |
| 180 |
CALL create_rw_transactions(84); |
| 181 |
INSERT INTO t1 (id,v) VALUES (85,0); |
| 182 |
CALL create_rw_transactions(85); |
| 183 |
INSERT INTO t1 (id,v) VALUES (86,0); |
| 184 |
CALL create_rw_transactions(86); |
| 185 |
INSERT INTO t1 (id,v) VALUES (87,0); |
| 186 |
CALL create_rw_transactions(87); |
| 187 |
INSERT INTO t1 (id,v) VALUES (88,0); |
| 188 |
CALL create_rw_transactions(88); |
| 189 |
INSERT INTO t1 (id,v) VALUES (89,0); |
| 190 |
CALL create_rw_transactions(89); |
| 191 |
INSERT INTO t1 (id,v) VALUES (90,0); |
| 192 |
CALL create_rw_transactions(90); |
| 193 |
INSERT INTO t1 (id,v) VALUES (91,0); |
| 194 |
CALL create_rw_transactions(91); |
| 195 |
INSERT INTO t1 (id,v) VALUES (92,0); |
| 196 |
CALL create_rw_transactions(92); |
| 197 |
INSERT INTO t1 (id,v) VALUES (93,0); |
| 198 |
CALL create_rw_transactions(93); |
| 199 |
INSERT INTO t1 (id,v) VALUES (94,0); |
| 200 |
CALL create_rw_transactions(94); |
| 201 |
INSERT INTO t1 (id,v) VALUES (95,0); |
| 202 |
CALL create_rw_transactions(95); |
| 203 |
INSERT INTO t1 (id,v) VALUES (96,0); |
| 204 |
CALL create_rw_transactions(96); |
| 205 |
INSERT INTO t1 (id,v) VALUES (97,0); |
| 206 |
CALL create_rw_transactions(97); |
| 207 |
INSERT INTO t1 (id,v) VALUES (98,0); |
| 208 |
CALL create_rw_transactions(98); |
| 209 |
INSERT INTO t1 (id,v) VALUES (99,0); |
| 210 |
CALL create_rw_transactions(99); |
| 211 |
INSERT INTO t1 (id,v) VALUES (100,0); |
| 212 |
CALL create_rw_transactions(100); |
| 213 |
INSERT INTO t1 (id,v) VALUES (101,0); |
| 214 |
CALL create_rw_transactions(101); |
| 215 |
INSERT INTO t1 (id,v) VALUES (102,0); |
| 216 |
CALL create_rw_transactions(102); |
| 217 |
INSERT INTO t1 (id,v) VALUES (103,0); |
| 218 |
CALL create_rw_transactions(103); |
| 219 |
INSERT INTO t1 (id,v) VALUES (104,0); |
| 220 |
CALL create_rw_transactions(104); |
| 221 |
INSERT INTO t1 (id,v) VALUES (105,0); |
| 222 |
CALL create_rw_transactions(105); |
| 223 |
INSERT INTO t1 (id,v) VALUES (106,0); |
| 224 |
CALL create_rw_transactions(106); |
| 225 |
INSERT INTO t1 (id,v) VALUES (107,0); |
| 226 |
CALL create_rw_transactions(107); |
| 227 |
INSERT INTO t1 (id,v) VALUES (108,0); |
| 228 |
CALL create_rw_transactions(108); |
| 229 |
INSERT INTO t1 (id,v) VALUES (109,0); |
| 230 |
CALL create_rw_transactions(109); |
| 231 |
INSERT INTO t1 (id,v) VALUES (110,0); |
| 232 |
CALL create_rw_transactions(110); |
| 233 |
INSERT INTO t1 (id,v) VALUES (111,0); |
| 234 |
CALL create_rw_transactions(111); |
| 235 |
INSERT INTO t1 (id,v) VALUES (112,0); |
| 236 |
CALL create_rw_transactions(112); |
| 237 |
INSERT INTO t1 (id,v) VALUES (113,0); |
| 238 |
CALL create_rw_transactions(113); |
| 239 |
INSERT INTO t1 (id,v) VALUES (114,0); |
| 240 |
CALL create_rw_transactions(114); |
| 241 |
INSERT INTO t1 (id,v) VALUES (115,0); |
| 242 |
CALL create_rw_transactions(115); |
| 243 |
INSERT INTO t1 (id,v) VALUES (116,0); |
| 244 |
CALL create_rw_transactions(116); |
| 245 |
INSERT INTO t1 (id,v) VALUES (117,0); |
| 246 |
CALL create_rw_transactions(117); |
| 247 |
INSERT INTO t1 (id,v) VALUES (118,0); |
| 248 |
CALL create_rw_transactions(118); |
| 249 |
INSERT INTO t1 (id,v) VALUES (119,0); |
| 250 |
CALL create_rw_transactions(119); |
| 251 |
DROP PROCEDURE create_rw_transactions; |
| 252 |
DROP TABLE t1; |
| 253 |
# Removing debug point 'trx_sys_rw_trx_add_rc' from @@GLOBAL.debug |