Debian Codegraph @

mysql-test/suite/perfschema/r/innodb_data_locks.result

raw
1 drop table if exists t1_min;
2 Warnings:
3 Note 1051 Unknown table 'test.t1_min'
4 drop table if exists t1_max;
5 Warnings:
6 Note 1051 Unknown table 'test.t1_max'
7 drop table if exists t1_part;
8 Warnings:
9 Note 1051 Unknown table 'test.t1_part'
10 drop table if exists t1_subpart;
11 Warnings:
12 Note 1051 Unknown table 'test.t1_subpart'
13 create table t1_min(
14 c01 TINYINT,
15 c02 TINYINT UNSIGNED,
16 c03 SMALLINT,
17 c04 SMALLINT UNSIGNED,
18 c05 MEDIUMINT,
19 c06 MEDIUMINT UNSIGNED,
20 c07 INT,
21 c08 INT UNSIGNED,
22 c09 BIGINT,
23 c10 BIGINT UNSIGNED,
24 PRIMARY KEY(c01, c02, c03, c04, c05, c06, c07, c08, c09, c10)
25 ) ENGINE=INNODB;
26 create table t1_max(
27 c01 TINYINT,
28 c02 TINYINT UNSIGNED,
29 c03 SMALLINT,
30 c04 SMALLINT UNSIGNED,
31 c05 MEDIUMINT,
32 c06 MEDIUMINT UNSIGNED,
33 c07 INT,
34 c08 INT UNSIGNED,
35 c09 BIGINT,
36 c10 BIGINT UNSIGNED,
37 PRIMARY KEY(c01, c02, c03, c04, c05, c06, c07, c08, c09, c10)
38 ) ENGINE=INNODB;
39 create table t1_part(
40 a int,
41 b int,
42 c int,
43 PRIMARY KEY(a, b, c)
44 ) ENGINE=INNODB PARTITION BY HASH(a) PARTITIONS 4;
45 create table t1_subpart(
46 a int,
47 b int,
48 c int,
49 PRIMARY KEY (a, b, c)
50 ) ENGINE=INNODB
51 PARTITION BY RANGE( a )
52 SUBPARTITION BY HASH( b ) (
53 PARTITION p0 VALUES LESS THAN (1990) (
54 SUBPARTITION s0,
55 SUBPARTITION s1
56 ),
57 PARTITION p1 VALUES LESS THAN (2000) (
58 SUBPARTITION s2,
59 SUBPARTITION s3
60 ),
61 PARTITION p2 VALUES LESS THAN MAXVALUE (
62 SUBPARTITION s4,
63 SUBPARTITION s5
64 )
65 );
66 insert into t1_min values
67 (-128, 0,
68 -32768, 0,
69 -8388608, 0,
70 -2147483648, 0,
71 -9223372036854775808, 0);
72 insert into t1_max values
73 (127, 255,
74 32767, 65535,
75 8388607, 16777215,
76 2147483647, 4294967295,
77 9223372036854775807, 18446744073709551615);
78 insert into t1_part values (1, 1, 1), (2, 2, 2), (3, 3, 3), (4, 4, 4);
79 insert into t1_subpart values (1, 1, 1), (2, 2, 2), (3, 3, 3), (4, 4, 4);
80 SET autocommit=0;
81 select * from t1_min for update;
82 c01 c02 c03 c04 c05 c06 c07 c08 c09 c10
83 -128 0 -32768 0 -8388608 0 -2147483648 0 -9223372036854775808 0
84 select * from t1_max for update;
85 c01 c02 c03 c04 c05 c06 c07 c08 c09 c10
86 127 255 32767 65535 8388607 16777215 2147483647 4294967295 9223372036854775807 18446744073709551615
87 select * from t1_part for update;
88 a b c
89 4 4 4
90 1 1 1
91 2 2 2
92 3 3 3
93 select * from t1_subpart for update;
94 a b c
95 2 2 2
96 4 4 4
97 1 1 1
98 3 3 3
99 select * from t1_min for update;
100 select * from t1_max for update;
101 insert into t1_min values (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
102 insert into t1_max values (1, 2, 3, 4, 5, 6, 7, 8, 9, 10);
103 select * from t1_part for update;
104 select * from t1_subpart for update;
105 select
106 ENGINE,
107 OBJECT_SCHEMA, OBJECT_NAME,
108 PARTITION_NAME, SUBPARTITION_NAME, INDEX_NAME,
109 LOCK_TYPE, LOCK_MODE, LOCK_STATUS, LOCK_DATA
110 from performance_schema.data_locks
111 order by OBJECT_SCHEMA, OBJECT_NAME,
112 PARTITION_NAME, SUBPARTITION_NAME, INDEX_NAME,
113 LOCK_TYPE, LOCK_MODE, LOCK_STATUS, LOCK_DATA;
114 ENGINE OBJECT_SCHEMA OBJECT_NAME PARTITION_NAME SUBPARTITION_NAME INDEX_NAME LOCK_TYPE LOCK_MODE LOCK_STATUS LOCK_DATA
115 INNODB test t1_max NULL NULL NULL TABLE IX GRANTED NULL
116 INNODB test t1_max NULL NULL NULL TABLE IX GRANTED NULL
117 INNODB test t1_max NULL NULL NULL TABLE IX GRANTED NULL
118 INNODB test t1_max NULL NULL PRIMARY RECORD X GRANTED 127, 255, 32767, 65535, 8388607, 16777215, 2147483647, 4294967295, 9223372036854775807, 18446744073709551615
119 INNODB test t1_max NULL NULL PRIMARY RECORD X GRANTED supremum pseudo-record
120 INNODB test t1_max NULL NULL PRIMARY RECORD X WAITING 127, 255, 32767, 65535, 8388607, 16777215, 2147483647, 4294967295, 9223372036854775807, 18446744073709551615
121 INNODB test t1_max NULL NULL PRIMARY RECORD X,GAP,INSERT_INTENTION WAITING 127, 255, 32767, 65535, 8388607, 16777215, 2147483647, 4294967295, 9223372036854775807, 18446744073709551615
122 INNODB test t1_min NULL NULL NULL TABLE IX GRANTED NULL
123 INNODB test t1_min NULL NULL NULL TABLE IX GRANTED NULL
124 INNODB test t1_min NULL NULL NULL TABLE IX GRANTED NULL
125 INNODB test t1_min NULL NULL PRIMARY RECORD X GRANTED -128, 0, -32768, 0, -8388608, 0, -2147483648, 0, -9223372036854775808, 0
126 INNODB test t1_min NULL NULL PRIMARY RECORD X GRANTED supremum pseudo-record
127 INNODB test t1_min NULL NULL PRIMARY RECORD X WAITING -128, 0, -32768, 0, -8388608, 0, -2147483648, 0, -9223372036854775808, 0
128 INNODB test t1_min NULL NULL PRIMARY RECORD X,INSERT_INTENTION WAITING supremum pseudo-record
129 INNODB test t1_part p0 NULL NULL TABLE IX GRANTED NULL
130 INNODB test t1_part p0 NULL NULL TABLE IX GRANTED NULL
131 INNODB test t1_part p0 NULL PRIMARY RECORD X GRANTED 4, 4, 4
132 INNODB test t1_part p0 NULL PRIMARY RECORD X GRANTED supremum pseudo-record
133 INNODB test t1_part p0 NULL PRIMARY RECORD X WAITING 4, 4, 4
134 INNODB test t1_part p1 NULL NULL TABLE IX GRANTED NULL
135 INNODB test t1_part p1 NULL PRIMARY RECORD X GRANTED 1, 1, 1
136 INNODB test t1_part p1 NULL PRIMARY RECORD X GRANTED supremum pseudo-record
137 INNODB test t1_part p2 NULL NULL TABLE IX GRANTED NULL
138 INNODB test t1_part p2 NULL PRIMARY RECORD X GRANTED 2, 2, 2
139 INNODB test t1_part p2 NULL PRIMARY RECORD X GRANTED supremum pseudo-record
140 INNODB test t1_part p3 NULL NULL TABLE IX GRANTED NULL
141 INNODB test t1_part p3 NULL PRIMARY RECORD X GRANTED 3, 3, 3
142 INNODB test t1_part p3 NULL PRIMARY RECORD X GRANTED supremum pseudo-record
143 INNODB test t1_subpart p0 s0 NULL TABLE IX GRANTED NULL
144 INNODB test t1_subpart p0 s0 NULL TABLE IX GRANTED NULL
145 INNODB test t1_subpart p0 s0 PRIMARY RECORD X GRANTED 2, 2, 2
146 INNODB test t1_subpart p0 s0 PRIMARY RECORD X GRANTED 4, 4, 4
147 INNODB test t1_subpart p0 s0 PRIMARY RECORD X GRANTED supremum pseudo-record
148 INNODB test t1_subpart p0 s0 PRIMARY RECORD X WAITING 2, 2, 2
149 INNODB test t1_subpart p0 s1 NULL TABLE IX GRANTED NULL
150 INNODB test t1_subpart p0 s1 PRIMARY RECORD X GRANTED 1, 1, 1
151 INNODB test t1_subpart p0 s1 PRIMARY RECORD X GRANTED 3, 3, 3
152 INNODB test t1_subpart p0 s1 PRIMARY RECORD X GRANTED supremum pseudo-record
153 INNODB test t1_subpart p1 s2 NULL TABLE IX GRANTED NULL
154 INNODB test t1_subpart p1 s2 PRIMARY RECORD X GRANTED supremum pseudo-record
155 INNODB test t1_subpart p1 s3 NULL TABLE IX GRANTED NULL
156 INNODB test t1_subpart p1 s3 PRIMARY RECORD X GRANTED supremum pseudo-record
157 INNODB test t1_subpart p2 s4 NULL TABLE IX GRANTED NULL
158 INNODB test t1_subpart p2 s4 PRIMARY RECORD X GRANTED supremum pseudo-record
159 INNODB test t1_subpart p2 s5 NULL TABLE IX GRANTED NULL
160 INNODB test t1_subpart p2 s5 PRIMARY RECORD X GRANTED supremum pseudo-record
161 select ENGINE, ENGINE_LOCK_ID, ENGINE_TRANSACTION_ID
162 from performance_schema.data_locks
163 where (ENGINE = "INNODB")
164 and (ENGINE_TRANSACTION_ID not in
165 (select trx_id from information_schema.innodb_trx));
166 ENGINE ENGINE_LOCK_ID ENGINE_TRANSACTION_ID
167 select
168 dl.ENGINE,
169 dl.OBJECT_SCHEMA,
170 dl.OBJECT_NAME,
171 dl.PARTITION_NAME,
172 dl.SUBPARTITION_NAME,
173 dl.INDEX_NAME,
174 dl.LOCK_TYPE,
175 dl.LOCK_MODE,
176 dl.LOCK_STATUS,
177 dl.LOCK_DATA,
178 it.trx_state,
179 it.trx_weight,
180 it.trx_query,
181 it.trx_operation_state,
182 it.trx_tables_in_use,
183 it.trx_tables_locked,
184 it.trx_lock_structs,
185 it.trx_rows_locked,
186 it.trx_rows_modified,
187 it.trx_concurrency_tickets,
188 it.trx_isolation_level,
189 it.trx_unique_checks,
190 it.trx_foreign_key_checks,
191 it.trx_last_foreign_key_error,
192 it.trx_adaptive_hash_latched,
193 it.trx_adaptive_hash_timeout,
194 it.trx_is_read_only,
195 it.trx_autocommit_non_locking
196 from performance_schema.data_locks dl inner join information_schema.innodb_trx it
197 on dl.ENGINE_TRANSACTION_ID = it.TRX_ID
198 order by ENGINE,
199 OBJECT_SCHEMA, OBJECT_NAME,
200 PARTITION_NAME, SUBPARTITION_NAME, INDEX_NAME,
201 trx_query, lock_status, LOCK_DATA;
202 ENGINE INNODB
203 OBJECT_SCHEMA test
204 OBJECT_NAME t1_max
205 PARTITION_NAME NULL
206 SUBPARTITION_NAME NULL
207 INDEX_NAME NULL
208 LOCK_TYPE TABLE
209 LOCK_MODE IX
210 LOCK_STATUS GRANTED
211 LOCK_DATA NULL
212 trx_state RUNNING
213 trx_weight 24
214 trx_query NULL
215 trx_operation_state NULL
216 trx_tables_in_use 0
217 trx_tables_locked 12
218 trx_lock_structs 24
219 trx_rows_locked 22
220 trx_rows_modified 0
221 trx_concurrency_tickets 0
222 trx_isolation_level REPEATABLE READ
223 trx_unique_checks 1
224 trx_foreign_key_checks 1
225 trx_last_foreign_key_error NULL
226 trx_adaptive_hash_latched 0
227 trx_adaptive_hash_timeout 0
228 trx_is_read_only 0
229 trx_autocommit_non_locking 0
230 ENGINE INNODB
231 OBJECT_SCHEMA test
232 OBJECT_NAME t1_max
233 PARTITION_NAME NULL
234 SUBPARTITION_NAME NULL
235 INDEX_NAME NULL
236 LOCK_TYPE TABLE
237 LOCK_MODE IX
238 LOCK_STATUS GRANTED
239 LOCK_DATA NULL
240 trx_state LOCK WAIT
241 trx_weight 2
242 trx_query insert into t1_max values (1, 2, 3, 4, 5, 6, 7, 8, 9, 10)
243 trx_operation_state inserting
244 trx_tables_in_use 1
245 trx_tables_locked 1
246 trx_lock_structs 2
247 trx_rows_locked 1
248 trx_rows_modified 0
249 trx_concurrency_tickets 0
250 trx_isolation_level REPEATABLE READ
251 trx_unique_checks 1
252 trx_foreign_key_checks 1
253 trx_last_foreign_key_error NULL
254 trx_adaptive_hash_latched 0
255 trx_adaptive_hash_timeout 0
256 trx_is_read_only 0
257 trx_autocommit_non_locking 0
258 ENGINE INNODB
259 OBJECT_SCHEMA test
260 OBJECT_NAME t1_max
261 PARTITION_NAME NULL
262 SUBPARTITION_NAME NULL
263 INDEX_NAME NULL
264 LOCK_TYPE TABLE
265 LOCK_MODE IX
266 LOCK_STATUS GRANTED
267 LOCK_DATA NULL
268 trx_state LOCK WAIT
269 trx_weight 2
270 trx_query select * from t1_max for update
271 trx_operation_state starting index read
272 trx_tables_in_use 1
273 trx_tables_locked 1
274 trx_lock_structs 2
275 trx_rows_locked 1
276 trx_rows_modified 0
277 trx_concurrency_tickets 0
278 trx_isolation_level REPEATABLE READ
279 trx_unique_checks 1
280 trx_foreign_key_checks 1
281 trx_last_foreign_key_error NULL
282 trx_adaptive_hash_latched 0
283 trx_adaptive_hash_timeout 0
284 trx_is_read_only 0
285 trx_autocommit_non_locking 0
286 ENGINE INNODB
287 OBJECT_SCHEMA test
288 OBJECT_NAME t1_max
289 PARTITION_NAME NULL
290 SUBPARTITION_NAME NULL
291 INDEX_NAME PRIMARY
292 LOCK_TYPE RECORD
293 LOCK_MODE X
294 LOCK_STATUS GRANTED
295 LOCK_DATA 127, 255, 32767, 65535, 8388607, 16777215, 2147483647, 4294967295, 9223372036854775807, 18446744073709551615
296 trx_state RUNNING
297 trx_weight 24
298 trx_query NULL
299 trx_operation_state NULL
300 trx_tables_in_use 0
301 trx_tables_locked 12
302 trx_lock_structs 24
303 trx_rows_locked 22
304 trx_rows_modified 0
305 trx_concurrency_tickets 0
306 trx_isolation_level REPEATABLE READ
307 trx_unique_checks 1
308 trx_foreign_key_checks 1
309 trx_last_foreign_key_error NULL
310 trx_adaptive_hash_latched 0
311 trx_adaptive_hash_timeout 0
312 trx_is_read_only 0
313 trx_autocommit_non_locking 0
314 ENGINE INNODB
315 OBJECT_SCHEMA test
316 OBJECT_NAME t1_max
317 PARTITION_NAME NULL
318 SUBPARTITION_NAME NULL
319 INDEX_NAME PRIMARY
320 LOCK_TYPE RECORD
321 LOCK_MODE X
322 LOCK_STATUS GRANTED
323 LOCK_DATA supremum pseudo-record
324 trx_state RUNNING
325 trx_weight 24
326 trx_query NULL
327 trx_operation_state NULL
328 trx_tables_in_use 0
329 trx_tables_locked 12
330 trx_lock_structs 24
331 trx_rows_locked 22
332 trx_rows_modified 0
333 trx_concurrency_tickets 0
334 trx_isolation_level REPEATABLE READ
335 trx_unique_checks 1
336 trx_foreign_key_checks 1
337 trx_last_foreign_key_error NULL
338 trx_adaptive_hash_latched 0
339 trx_adaptive_hash_timeout 0
340 trx_is_read_only 0
341 trx_autocommit_non_locking 0
342 ENGINE INNODB
343 OBJECT_SCHEMA test
344 OBJECT_NAME t1_max
345 PARTITION_NAME NULL
346 SUBPARTITION_NAME NULL
347 INDEX_NAME PRIMARY
348 LOCK_TYPE RECORD
349 LOCK_MODE X,GAP,INSERT_INTENTION
350 LOCK_STATUS WAITING
351 LOCK_DATA 127, 255, 32767, 65535, 8388607, 16777215, 2147483647, 4294967295, 9223372036854775807, 18446744073709551615
352 trx_state LOCK WAIT
353 trx_weight 2
354 trx_query insert into t1_max values (1, 2, 3, 4, 5, 6, 7, 8, 9, 10)
355 trx_operation_state inserting
356 trx_tables_in_use 1
357 trx_tables_locked 1
358 trx_lock_structs 2
359 trx_rows_locked 1
360 trx_rows_modified 0
361 trx_concurrency_tickets 0
362 trx_isolation_level REPEATABLE READ
363 trx_unique_checks 1
364 trx_foreign_key_checks 1
365 trx_last_foreign_key_error NULL
366 trx_adaptive_hash_latched 0
367 trx_adaptive_hash_timeout 0
368 trx_is_read_only 0
369 trx_autocommit_non_locking 0
370 ENGINE INNODB
371 OBJECT_SCHEMA test
372 OBJECT_NAME t1_max
373 PARTITION_NAME NULL
374 SUBPARTITION_NAME NULL
375 INDEX_NAME PRIMARY
376 LOCK_TYPE RECORD
377 LOCK_MODE X
378 LOCK_STATUS WAITING
379 LOCK_DATA 127, 255, 32767, 65535, 8388607, 16777215, 2147483647, 4294967295, 9223372036854775807, 18446744073709551615
380 trx_state LOCK WAIT
381 trx_weight 2
382 trx_query select * from t1_max for update
383 trx_operation_state starting index read
384 trx_tables_in_use 1
385 trx_tables_locked 1
386 trx_lock_structs 2
387 trx_rows_locked 1
388 trx_rows_modified 0
389 trx_concurrency_tickets 0
390 trx_isolation_level REPEATABLE READ
391 trx_unique_checks 1
392 trx_foreign_key_checks 1
393 trx_last_foreign_key_error NULL
394 trx_adaptive_hash_latched 0
395 trx_adaptive_hash_timeout 0
396 trx_is_read_only 0
397 trx_autocommit_non_locking 0
398 ENGINE INNODB
399 OBJECT_SCHEMA test
400 OBJECT_NAME t1_min
401 PARTITION_NAME NULL
402 SUBPARTITION_NAME NULL
403 INDEX_NAME NULL
404 LOCK_TYPE TABLE
405 LOCK_MODE IX
406 LOCK_STATUS GRANTED
407 LOCK_DATA NULL
408 trx_state RUNNING
409 trx_weight 24
410 trx_query NULL
411 trx_operation_state NULL
412 trx_tables_in_use 0
413 trx_tables_locked 12
414 trx_lock_structs 24
415 trx_rows_locked 22
416 trx_rows_modified 0
417 trx_concurrency_tickets 0
418 trx_isolation_level REPEATABLE READ
419 trx_unique_checks 1
420 trx_foreign_key_checks 1
421 trx_last_foreign_key_error NULL
422 trx_adaptive_hash_latched 0
423 trx_adaptive_hash_timeout 0
424 trx_is_read_only 0
425 trx_autocommit_non_locking 0
426 ENGINE INNODB
427 OBJECT_SCHEMA test
428 OBJECT_NAME t1_min
429 PARTITION_NAME NULL
430 SUBPARTITION_NAME NULL
431 INDEX_NAME NULL
432 LOCK_TYPE TABLE
433 LOCK_MODE IX
434 LOCK_STATUS GRANTED
435 LOCK_DATA NULL
436 trx_state LOCK WAIT
437 trx_weight 2
438 trx_query insert into t1_min values (1, 2, 3, 4, 5, 6, 7, 8, 9, 10)
439 trx_operation_state inserting
440 trx_tables_in_use 1
441 trx_tables_locked 1
442 trx_lock_structs 2
443 trx_rows_locked 1
444 trx_rows_modified 0
445 trx_concurrency_tickets 0
446 trx_isolation_level REPEATABLE READ
447 trx_unique_checks 1
448 trx_foreign_key_checks 1
449 trx_last_foreign_key_error NULL
450 trx_adaptive_hash_latched 0
451 trx_adaptive_hash_timeout 0
452 trx_is_read_only 0
453 trx_autocommit_non_locking 0
454 ENGINE INNODB
455 OBJECT_SCHEMA test
456 OBJECT_NAME t1_min
457 PARTITION_NAME NULL
458 SUBPARTITION_NAME NULL
459 INDEX_NAME NULL
460 LOCK_TYPE TABLE
461 LOCK_MODE IX
462 LOCK_STATUS GRANTED
463 LOCK_DATA NULL
464 trx_state LOCK WAIT
465 trx_weight 2
466 trx_query select * from t1_min for update
467 trx_operation_state starting index read
468 trx_tables_in_use 1
469 trx_tables_locked 1
470 trx_lock_structs 2
471 trx_rows_locked 1
472 trx_rows_modified 0
473 trx_concurrency_tickets 0
474 trx_isolation_level REPEATABLE READ
475 trx_unique_checks 1
476 trx_foreign_key_checks 1
477 trx_last_foreign_key_error NULL
478 trx_adaptive_hash_latched 0
479 trx_adaptive_hash_timeout 0
480 trx_is_read_only 0
481 trx_autocommit_non_locking 0
482 ENGINE INNODB
483 OBJECT_SCHEMA test
484 OBJECT_NAME t1_min
485 PARTITION_NAME NULL
486 SUBPARTITION_NAME NULL
487 INDEX_NAME PRIMARY
488 LOCK_TYPE RECORD
489 LOCK_MODE X
490 LOCK_STATUS GRANTED
491 LOCK_DATA -128, 0, -32768, 0, -8388608, 0, -2147483648, 0, -9223372036854775808, 0
492 trx_state RUNNING
493 trx_weight 24
494 trx_query NULL
495 trx_operation_state NULL
496 trx_tables_in_use 0
497 trx_tables_locked 12
498 trx_lock_structs 24
499 trx_rows_locked 22
500 trx_rows_modified 0
501 trx_concurrency_tickets 0
502 trx_isolation_level REPEATABLE READ
503 trx_unique_checks 1
504 trx_foreign_key_checks 1
505 trx_last_foreign_key_error NULL
506 trx_adaptive_hash_latched 0
507 trx_adaptive_hash_timeout 0
508 trx_is_read_only 0
509 trx_autocommit_non_locking 0
510 ENGINE INNODB
511 OBJECT_SCHEMA test
512 OBJECT_NAME t1_min
513 PARTITION_NAME NULL
514 SUBPARTITION_NAME NULL
515 INDEX_NAME PRIMARY
516 LOCK_TYPE RECORD
517 LOCK_MODE X
518 LOCK_STATUS GRANTED
519 LOCK_DATA supremum pseudo-record
520 trx_state RUNNING
521 trx_weight 24
522 trx_query NULL
523 trx_operation_state NULL
524 trx_tables_in_use 0
525 trx_tables_locked 12
526 trx_lock_structs 24
527 trx_rows_locked 22
528 trx_rows_modified 0
529 trx_concurrency_tickets 0
530 trx_isolation_level REPEATABLE READ
531 trx_unique_checks 1
532 trx_foreign_key_checks 1
533 trx_last_foreign_key_error NULL
534 trx_adaptive_hash_latched 0
535 trx_adaptive_hash_timeout 0
536 trx_is_read_only 0
537 trx_autocommit_non_locking 0
538 ENGINE INNODB
539 OBJECT_SCHEMA test
540 OBJECT_NAME t1_min
541 PARTITION_NAME NULL
542 SUBPARTITION_NAME NULL
543 INDEX_NAME PRIMARY
544 LOCK_TYPE RECORD
545 LOCK_MODE X,INSERT_INTENTION
546 LOCK_STATUS WAITING
547 LOCK_DATA supremum pseudo-record
548 trx_state LOCK WAIT
549 trx_weight 2
550 trx_query insert into t1_min values (1, 2, 3, 4, 5, 6, 7, 8, 9, 10)
551 trx_operation_state inserting
552 trx_tables_in_use 1
553 trx_tables_locked 1
554 trx_lock_structs 2
555 trx_rows_locked 1
556 trx_rows_modified 0
557 trx_concurrency_tickets 0
558 trx_isolation_level REPEATABLE READ
559 trx_unique_checks 1
560 trx_foreign_key_checks 1
561 trx_last_foreign_key_error NULL
562 trx_adaptive_hash_latched 0
563 trx_adaptive_hash_timeout 0
564 trx_is_read_only 0
565 trx_autocommit_non_locking 0
566 ENGINE INNODB
567 OBJECT_SCHEMA test
568 OBJECT_NAME t1_min
569 PARTITION_NAME NULL
570 SUBPARTITION_NAME NULL
571 INDEX_NAME PRIMARY
572 LOCK_TYPE RECORD
573 LOCK_MODE X
574 LOCK_STATUS WAITING
575 LOCK_DATA -128, 0, -32768, 0, -8388608, 0, -2147483648, 0, -9223372036854775808, 0
576 trx_state LOCK WAIT
577 trx_weight 2
578 trx_query select * from t1_min for update
579 trx_operation_state starting index read
580 trx_tables_in_use 1
581 trx_tables_locked 1
582 trx_lock_structs 2
583 trx_rows_locked 1
584 trx_rows_modified 0
585 trx_concurrency_tickets 0
586 trx_isolation_level REPEATABLE READ
587 trx_unique_checks 1
588 trx_foreign_key_checks 1
589 trx_last_foreign_key_error NULL
590 trx_adaptive_hash_latched 0
591 trx_adaptive_hash_timeout 0
592 trx_is_read_only 0
593 trx_autocommit_non_locking 0
594 ENGINE INNODB
595 OBJECT_SCHEMA test
596 OBJECT_NAME t1_part
597 PARTITION_NAME p0
598 SUBPARTITION_NAME NULL
599 INDEX_NAME NULL
600 LOCK_TYPE TABLE
601 LOCK_MODE IX
602 LOCK_STATUS GRANTED
603 LOCK_DATA NULL
604 trx_state RUNNING
605 trx_weight 24
606 trx_query NULL
607 trx_operation_state NULL
608 trx_tables_in_use 0
609 trx_tables_locked 12
610 trx_lock_structs 24
611 trx_rows_locked 22
612 trx_rows_modified 0
613 trx_concurrency_tickets 0
614 trx_isolation_level REPEATABLE READ
615 trx_unique_checks 1
616 trx_foreign_key_checks 1
617 trx_last_foreign_key_error NULL
618 trx_adaptive_hash_latched 0
619 trx_adaptive_hash_timeout 0
620 trx_is_read_only 0
621 trx_autocommit_non_locking 0
622 ENGINE INNODB
623 OBJECT_SCHEMA test
624 OBJECT_NAME t1_part
625 PARTITION_NAME p0
626 SUBPARTITION_NAME NULL
627 INDEX_NAME NULL
628 LOCK_TYPE TABLE
629 LOCK_MODE IX
630 LOCK_STATUS GRANTED
631 LOCK_DATA NULL
632 trx_state LOCK WAIT
633 trx_weight 2
634 trx_query select * from t1_part for update
635 trx_operation_state starting index read
636 trx_tables_in_use 1
637 trx_tables_locked 1
638 trx_lock_structs 2
639 trx_rows_locked 1
640 trx_rows_modified 0
641 trx_concurrency_tickets 0
642 trx_isolation_level REPEATABLE READ
643 trx_unique_checks 1
644 trx_foreign_key_checks 1
645 trx_last_foreign_key_error NULL
646 trx_adaptive_hash_latched 0
647 trx_adaptive_hash_timeout 0
648 trx_is_read_only 0
649 trx_autocommit_non_locking 0
650 ENGINE INNODB
651 OBJECT_SCHEMA test
652 OBJECT_NAME t1_part
653 PARTITION_NAME p0
654 SUBPARTITION_NAME NULL
655 INDEX_NAME PRIMARY
656 LOCK_TYPE RECORD
657 LOCK_MODE X
658 LOCK_STATUS GRANTED
659 LOCK_DATA 4, 4, 4
660 trx_state RUNNING
661 trx_weight 24
662 trx_query NULL
663 trx_operation_state NULL
664 trx_tables_in_use 0
665 trx_tables_locked 12
666 trx_lock_structs 24
667 trx_rows_locked 22
668 trx_rows_modified 0
669 trx_concurrency_tickets 0
670 trx_isolation_level REPEATABLE READ
671 trx_unique_checks 1
672 trx_foreign_key_checks 1
673 trx_last_foreign_key_error NULL
674 trx_adaptive_hash_latched 0
675 trx_adaptive_hash_timeout 0
676 trx_is_read_only 0
677 trx_autocommit_non_locking 0
678 ENGINE INNODB
679 OBJECT_SCHEMA test
680 OBJECT_NAME t1_part
681 PARTITION_NAME p0
682 SUBPARTITION_NAME NULL
683 INDEX_NAME PRIMARY
684 LOCK_TYPE RECORD
685 LOCK_MODE X
686 LOCK_STATUS GRANTED
687 LOCK_DATA supremum pseudo-record
688 trx_state RUNNING
689 trx_weight 24
690 trx_query NULL
691 trx_operation_state NULL
692 trx_tables_in_use 0
693 trx_tables_locked 12
694 trx_lock_structs 24
695 trx_rows_locked 22
696 trx_rows_modified 0
697 trx_concurrency_tickets 0
698 trx_isolation_level REPEATABLE READ
699 trx_unique_checks 1
700 trx_foreign_key_checks 1
701 trx_last_foreign_key_error NULL
702 trx_adaptive_hash_latched 0
703 trx_adaptive_hash_timeout 0
704 trx_is_read_only 0
705 trx_autocommit_non_locking 0
706 ENGINE INNODB
707 OBJECT_SCHEMA test
708 OBJECT_NAME t1_part
709 PARTITION_NAME p0
710 SUBPARTITION_NAME NULL
711 INDEX_NAME PRIMARY
712 LOCK_TYPE RECORD
713 LOCK_MODE X
714 LOCK_STATUS WAITING
715 LOCK_DATA 4, 4, 4
716 trx_state LOCK WAIT
717 trx_weight 2
718 trx_query select * from t1_part for update
719 trx_operation_state starting index read
720 trx_tables_in_use 1
721 trx_tables_locked 1
722 trx_lock_structs 2
723 trx_rows_locked 1
724 trx_rows_modified 0
725 trx_concurrency_tickets 0
726 trx_isolation_level REPEATABLE READ
727 trx_unique_checks 1
728 trx_foreign_key_checks 1
729 trx_last_foreign_key_error NULL
730 trx_adaptive_hash_latched 0
731 trx_adaptive_hash_timeout 0
732 trx_is_read_only 0
733 trx_autocommit_non_locking 0
734 ENGINE INNODB
735 OBJECT_SCHEMA test
736 OBJECT_NAME t1_part
737 PARTITION_NAME p1
738 SUBPARTITION_NAME NULL
739 INDEX_NAME NULL
740 LOCK_TYPE TABLE
741 LOCK_MODE IX
742 LOCK_STATUS GRANTED
743 LOCK_DATA NULL
744 trx_state RUNNING
745 trx_weight 24
746 trx_query NULL
747 trx_operation_state NULL
748 trx_tables_in_use 0
749 trx_tables_locked 12
750 trx_lock_structs 24
751 trx_rows_locked 22
752 trx_rows_modified 0
753 trx_concurrency_tickets 0
754 trx_isolation_level REPEATABLE READ
755 trx_unique_checks 1
756 trx_foreign_key_checks 1
757 trx_last_foreign_key_error NULL
758 trx_adaptive_hash_latched 0
759 trx_adaptive_hash_timeout 0
760 trx_is_read_only 0
761 trx_autocommit_non_locking 0
762 ENGINE INNODB
763 OBJECT_SCHEMA test
764 OBJECT_NAME t1_part
765 PARTITION_NAME p1
766 SUBPARTITION_NAME NULL
767 INDEX_NAME PRIMARY
768 LOCK_TYPE RECORD
769 LOCK_MODE X
770 LOCK_STATUS GRANTED
771 LOCK_DATA 1, 1, 1
772 trx_state RUNNING
773 trx_weight 24
774 trx_query NULL
775 trx_operation_state NULL
776 trx_tables_in_use 0
777 trx_tables_locked 12
778 trx_lock_structs 24
779 trx_rows_locked 22
780 trx_rows_modified 0
781 trx_concurrency_tickets 0
782 trx_isolation_level REPEATABLE READ
783 trx_unique_checks 1
784 trx_foreign_key_checks 1
785 trx_last_foreign_key_error NULL
786 trx_adaptive_hash_latched 0
787 trx_adaptive_hash_timeout 0
788 trx_is_read_only 0
789 trx_autocommit_non_locking 0
790 ENGINE INNODB
791 OBJECT_SCHEMA test
792 OBJECT_NAME t1_part
793 PARTITION_NAME p1
794 SUBPARTITION_NAME NULL
795 INDEX_NAME PRIMARY
796 LOCK_TYPE RECORD
797 LOCK_MODE X
798 LOCK_STATUS GRANTED
799 LOCK_DATA supremum pseudo-record
800 trx_state RUNNING
801 trx_weight 24
802 trx_query NULL
803 trx_operation_state NULL
804 trx_tables_in_use 0
805 trx_tables_locked 12
806 trx_lock_structs 24
807 trx_rows_locked 22
808 trx_rows_modified 0
809 trx_concurrency_tickets 0
810 trx_isolation_level REPEATABLE READ
811 trx_unique_checks 1
812 trx_foreign_key_checks 1
813 trx_last_foreign_key_error NULL
814 trx_adaptive_hash_latched 0
815 trx_adaptive_hash_timeout 0
816 trx_is_read_only 0
817 trx_autocommit_non_locking 0
818 ENGINE INNODB
819 OBJECT_SCHEMA test
820 OBJECT_NAME t1_part
821 PARTITION_NAME p2
822 SUBPARTITION_NAME NULL
823 INDEX_NAME NULL
824 LOCK_TYPE TABLE
825 LOCK_MODE IX
826 LOCK_STATUS GRANTED
827 LOCK_DATA NULL
828 trx_state RUNNING
829 trx_weight 24
830 trx_query NULL
831 trx_operation_state NULL
832 trx_tables_in_use 0
833 trx_tables_locked 12
834 trx_lock_structs 24
835 trx_rows_locked 22
836 trx_rows_modified 0
837 trx_concurrency_tickets 0
838 trx_isolation_level REPEATABLE READ
839 trx_unique_checks 1
840 trx_foreign_key_checks 1
841 trx_last_foreign_key_error NULL
842 trx_adaptive_hash_latched 0
843 trx_adaptive_hash_timeout 0
844 trx_is_read_only 0
845 trx_autocommit_non_locking 0
846 ENGINE INNODB
847 OBJECT_SCHEMA test
848 OBJECT_NAME t1_part
849 PARTITION_NAME p2
850 SUBPARTITION_NAME NULL
851 INDEX_NAME PRIMARY
852 LOCK_TYPE RECORD
853 LOCK_MODE X
854 LOCK_STATUS GRANTED
855 LOCK_DATA 2, 2, 2
856 trx_state RUNNING
857 trx_weight 24
858 trx_query NULL
859 trx_operation_state NULL
860 trx_tables_in_use 0
861 trx_tables_locked 12
862 trx_lock_structs 24
863 trx_rows_locked 22
864 trx_rows_modified 0
865 trx_concurrency_tickets 0
866 trx_isolation_level REPEATABLE READ
867 trx_unique_checks 1
868 trx_foreign_key_checks 1
869 trx_last_foreign_key_error NULL
870 trx_adaptive_hash_latched 0
871 trx_adaptive_hash_timeout 0
872 trx_is_read_only 0
873 trx_autocommit_non_locking 0
874 ENGINE INNODB
875 OBJECT_SCHEMA test
876 OBJECT_NAME t1_part
877 PARTITION_NAME p2
878 SUBPARTITION_NAME NULL
879 INDEX_NAME PRIMARY
880 LOCK_TYPE RECORD
881 LOCK_MODE X
882 LOCK_STATUS GRANTED
883 LOCK_DATA supremum pseudo-record
884 trx_state RUNNING
885 trx_weight 24
886 trx_query NULL
887 trx_operation_state NULL
888 trx_tables_in_use 0
889 trx_tables_locked 12
890 trx_lock_structs 24
891 trx_rows_locked 22
892 trx_rows_modified 0
893 trx_concurrency_tickets 0
894 trx_isolation_level REPEATABLE READ
895 trx_unique_checks 1
896 trx_foreign_key_checks 1
897 trx_last_foreign_key_error NULL
898 trx_adaptive_hash_latched 0
899 trx_adaptive_hash_timeout 0
900 trx_is_read_only 0
901 trx_autocommit_non_locking 0
902 ENGINE INNODB
903 OBJECT_SCHEMA test
904 OBJECT_NAME t1_part
905 PARTITION_NAME p3
906 SUBPARTITION_NAME NULL
907 INDEX_NAME NULL
908 LOCK_TYPE TABLE
909 LOCK_MODE IX
910 LOCK_STATUS GRANTED
911 LOCK_DATA NULL
912 trx_state RUNNING
913 trx_weight 24
914 trx_query NULL
915 trx_operation_state NULL
916 trx_tables_in_use 0
917 trx_tables_locked 12
918 trx_lock_structs 24
919 trx_rows_locked 22
920 trx_rows_modified 0
921 trx_concurrency_tickets 0
922 trx_isolation_level REPEATABLE READ
923 trx_unique_checks 1
924 trx_foreign_key_checks 1
925 trx_last_foreign_key_error NULL
926 trx_adaptive_hash_latched 0
927 trx_adaptive_hash_timeout 0
928 trx_is_read_only 0
929 trx_autocommit_non_locking 0
930 ENGINE INNODB
931 OBJECT_SCHEMA test
932 OBJECT_NAME t1_part
933 PARTITION_NAME p3
934 SUBPARTITION_NAME NULL
935 INDEX_NAME PRIMARY
936 LOCK_TYPE RECORD
937 LOCK_MODE X
938 LOCK_STATUS GRANTED
939 LOCK_DATA 3, 3, 3
940 trx_state RUNNING
941 trx_weight 24
942 trx_query NULL
943 trx_operation_state NULL
944 trx_tables_in_use 0
945 trx_tables_locked 12
946 trx_lock_structs 24
947 trx_rows_locked 22
948 trx_rows_modified 0
949 trx_concurrency_tickets 0
950 trx_isolation_level REPEATABLE READ
951 trx_unique_checks 1
952 trx_foreign_key_checks 1
953 trx_last_foreign_key_error NULL
954 trx_adaptive_hash_latched 0
955 trx_adaptive_hash_timeout 0
956 trx_is_read_only 0
957 trx_autocommit_non_locking 0
958 ENGINE INNODB
959 OBJECT_SCHEMA test
960 OBJECT_NAME t1_part
961 PARTITION_NAME p3
962 SUBPARTITION_NAME NULL
963 INDEX_NAME PRIMARY
964 LOCK_TYPE RECORD
965 LOCK_MODE X
966 LOCK_STATUS GRANTED
967 LOCK_DATA supremum pseudo-record
968 trx_state RUNNING
969 trx_weight 24
970 trx_query NULL
971 trx_operation_state NULL
972 trx_tables_in_use 0
973 trx_tables_locked 12
974 trx_lock_structs 24
975 trx_rows_locked 22
976 trx_rows_modified 0
977 trx_concurrency_tickets 0
978 trx_isolation_level REPEATABLE READ
979 trx_unique_checks 1
980 trx_foreign_key_checks 1
981 trx_last_foreign_key_error NULL
982 trx_adaptive_hash_latched 0
983 trx_adaptive_hash_timeout 0
984 trx_is_read_only 0
985 trx_autocommit_non_locking 0
986 ENGINE INNODB
987 OBJECT_SCHEMA test
988 OBJECT_NAME t1_subpart
989 PARTITION_NAME p0
990 SUBPARTITION_NAME s0
991 INDEX_NAME NULL
992 LOCK_TYPE TABLE
993 LOCK_MODE IX
994 LOCK_STATUS GRANTED
995 LOCK_DATA NULL
996 trx_state RUNNING
997 trx_weight 24
998 trx_query NULL
999 trx_operation_state NULL
1000 trx_tables_in_use 0
1001 trx_tables_locked 12
1002 trx_lock_structs 24
1003 trx_rows_locked 22
1004 trx_rows_modified 0
1005 trx_concurrency_tickets 0
1006 trx_isolation_level REPEATABLE READ
1007 trx_unique_checks 1
1008 trx_foreign_key_checks 1
1009 trx_last_foreign_key_error NULL
1010 trx_adaptive_hash_latched 0
1011 trx_adaptive_hash_timeout 0
1012 trx_is_read_only 0
1013 trx_autocommit_non_locking 0
1014 ENGINE INNODB
1015 OBJECT_SCHEMA test
1016 OBJECT_NAME t1_subpart
1017 PARTITION_NAME p0
1018 SUBPARTITION_NAME s0
1019 INDEX_NAME NULL
1020 LOCK_TYPE TABLE
1021 LOCK_MODE IX
1022 LOCK_STATUS GRANTED
1023 LOCK_DATA NULL
1024 trx_state LOCK WAIT
1025 trx_weight 2
1026 trx_query select * from t1_subpart for update
1027 trx_operation_state starting index read
1028 trx_tables_in_use 1
1029 trx_tables_locked 1
1030 trx_lock_structs 2
1031 trx_rows_locked 1
1032 trx_rows_modified 0
1033 trx_concurrency_tickets 0
1034 trx_isolation_level REPEATABLE READ
1035 trx_unique_checks 1
1036 trx_foreign_key_checks 1
1037 trx_last_foreign_key_error NULL
1038 trx_adaptive_hash_latched 0
1039 trx_adaptive_hash_timeout 0
1040 trx_is_read_only 0
1041 trx_autocommit_non_locking 0
1042 ENGINE INNODB
1043 OBJECT_SCHEMA test
1044 OBJECT_NAME t1_subpart
1045 PARTITION_NAME p0
1046 SUBPARTITION_NAME s0
1047 INDEX_NAME PRIMARY
1048 LOCK_TYPE RECORD
1049 LOCK_MODE X
1050 LOCK_STATUS GRANTED
1051 LOCK_DATA 2, 2, 2
1052 trx_state RUNNING
1053 trx_weight 24
1054 trx_query NULL
1055 trx_operation_state NULL
1056 trx_tables_in_use 0
1057 trx_tables_locked 12
1058 trx_lock_structs 24
1059 trx_rows_locked 22
1060 trx_rows_modified 0
1061 trx_concurrency_tickets 0
1062 trx_isolation_level REPEATABLE READ
1063 trx_unique_checks 1
1064 trx_foreign_key_checks 1
1065 trx_last_foreign_key_error NULL
1066 trx_adaptive_hash_latched 0
1067 trx_adaptive_hash_timeout 0
1068 trx_is_read_only 0
1069 trx_autocommit_non_locking 0
1070 ENGINE INNODB
1071 OBJECT_SCHEMA test
1072 OBJECT_NAME t1_subpart
1073 PARTITION_NAME p0
1074 SUBPARTITION_NAME s0
1075 INDEX_NAME PRIMARY
1076 LOCK_TYPE RECORD
1077 LOCK_MODE X
1078 LOCK_STATUS GRANTED
1079 LOCK_DATA 4, 4, 4
1080 trx_state RUNNING
1081 trx_weight 24
1082 trx_query NULL
1083 trx_operation_state NULL
1084 trx_tables_in_use 0
1085 trx_tables_locked 12
1086 trx_lock_structs 24
1087 trx_rows_locked 22
1088 trx_rows_modified 0
1089 trx_concurrency_tickets 0
1090 trx_isolation_level REPEATABLE READ
1091 trx_unique_checks 1
1092 trx_foreign_key_checks 1
1093 trx_last_foreign_key_error NULL
1094 trx_adaptive_hash_latched 0
1095 trx_adaptive_hash_timeout 0
1096 trx_is_read_only 0
1097 trx_autocommit_non_locking 0
1098 ENGINE INNODB
1099 OBJECT_SCHEMA test
1100 OBJECT_NAME t1_subpart
1101 PARTITION_NAME p0
1102 SUBPARTITION_NAME s0
1103 INDEX_NAME PRIMARY
1104 LOCK_TYPE RECORD
1105 LOCK_MODE X
1106 LOCK_STATUS GRANTED
1107 LOCK_DATA supremum pseudo-record
1108 trx_state RUNNING
1109 trx_weight 24
1110 trx_query NULL
1111 trx_operation_state NULL
1112 trx_tables_in_use 0
1113 trx_tables_locked 12
1114 trx_lock_structs 24
1115 trx_rows_locked 22
1116 trx_rows_modified 0
1117 trx_concurrency_tickets 0
1118 trx_isolation_level REPEATABLE READ
1119 trx_unique_checks 1
1120 trx_foreign_key_checks 1
1121 trx_last_foreign_key_error NULL
1122 trx_adaptive_hash_latched 0
1123 trx_adaptive_hash_timeout 0
1124 trx_is_read_only 0
1125 trx_autocommit_non_locking 0
1126 ENGINE INNODB
1127 OBJECT_SCHEMA test
1128 OBJECT_NAME t1_subpart
1129 PARTITION_NAME p0
1130 SUBPARTITION_NAME s0
1131 INDEX_NAME PRIMARY
1132 LOCK_TYPE RECORD
1133 LOCK_MODE X
1134 LOCK_STATUS WAITING
1135 LOCK_DATA 2, 2, 2
1136 trx_state LOCK WAIT
1137 trx_weight 2
1138 trx_query select * from t1_subpart for update
1139 trx_operation_state starting index read
1140 trx_tables_in_use 1
1141 trx_tables_locked 1
1142 trx_lock_structs 2
1143 trx_rows_locked 1
1144 trx_rows_modified 0
1145 trx_concurrency_tickets 0
1146 trx_isolation_level REPEATABLE READ
1147 trx_unique_checks 1
1148 trx_foreign_key_checks 1
1149 trx_last_foreign_key_error NULL
1150 trx_adaptive_hash_latched 0
1151 trx_adaptive_hash_timeout 0
1152 trx_is_read_only 0
1153 trx_autocommit_non_locking 0
1154 ENGINE INNODB
1155 OBJECT_SCHEMA test
1156 OBJECT_NAME t1_subpart
1157 PARTITION_NAME p0
1158 SUBPARTITION_NAME s1
1159 INDEX_NAME NULL
1160 LOCK_TYPE TABLE
1161 LOCK_MODE IX
1162 LOCK_STATUS GRANTED
1163 LOCK_DATA NULL
1164 trx_state RUNNING
1165 trx_weight 24
1166 trx_query NULL
1167 trx_operation_state NULL
1168 trx_tables_in_use 0
1169 trx_tables_locked 12
1170 trx_lock_structs 24
1171 trx_rows_locked 22
1172 trx_rows_modified 0
1173 trx_concurrency_tickets 0
1174 trx_isolation_level REPEATABLE READ
1175 trx_unique_checks 1
1176 trx_foreign_key_checks 1
1177 trx_last_foreign_key_error NULL
1178 trx_adaptive_hash_latched 0
1179 trx_adaptive_hash_timeout 0
1180 trx_is_read_only 0
1181 trx_autocommit_non_locking 0
1182 ENGINE INNODB
1183 OBJECT_SCHEMA test
1184 OBJECT_NAME t1_subpart
1185 PARTITION_NAME p0
1186 SUBPARTITION_NAME s1
1187 INDEX_NAME PRIMARY
1188 LOCK_TYPE RECORD
1189 LOCK_MODE X
1190 LOCK_STATUS GRANTED
1191 LOCK_DATA 1, 1, 1
1192 trx_state RUNNING
1193 trx_weight 24
1194 trx_query NULL
1195 trx_operation_state NULL
1196 trx_tables_in_use 0
1197 trx_tables_locked 12
1198 trx_lock_structs 24
1199 trx_rows_locked 22
1200 trx_rows_modified 0
1201 trx_concurrency_tickets 0
1202 trx_isolation_level REPEATABLE READ
1203 trx_unique_checks 1
1204 trx_foreign_key_checks 1
1205 trx_last_foreign_key_error NULL
1206 trx_adaptive_hash_latched 0
1207 trx_adaptive_hash_timeout 0
1208 trx_is_read_only 0
1209 trx_autocommit_non_locking 0
1210 ENGINE INNODB
1211 OBJECT_SCHEMA test
1212 OBJECT_NAME t1_subpart
1213 PARTITION_NAME p0
1214 SUBPARTITION_NAME s1
1215 INDEX_NAME PRIMARY
1216 LOCK_TYPE RECORD
1217 LOCK_MODE X
1218 LOCK_STATUS GRANTED
1219 LOCK_DATA 3, 3, 3
1220 trx_state RUNNING
1221 trx_weight 24
1222 trx_query NULL
1223 trx_operation_state NULL
1224 trx_tables_in_use 0
1225 trx_tables_locked 12
1226 trx_lock_structs 24
1227 trx_rows_locked 22
1228 trx_rows_modified 0
1229 trx_concurrency_tickets 0
1230 trx_isolation_level REPEATABLE READ
1231 trx_unique_checks 1
1232 trx_foreign_key_checks 1
1233 trx_last_foreign_key_error NULL
1234 trx_adaptive_hash_latched 0
1235 trx_adaptive_hash_timeout 0
1236 trx_is_read_only 0
1237 trx_autocommit_non_locking 0
1238 ENGINE INNODB
1239 OBJECT_SCHEMA test
1240 OBJECT_NAME t1_subpart
1241 PARTITION_NAME p0
1242 SUBPARTITION_NAME s1
1243 INDEX_NAME PRIMARY
1244 LOCK_TYPE RECORD
1245 LOCK_MODE X
1246 LOCK_STATUS GRANTED
1247 LOCK_DATA supremum pseudo-record
1248 trx_state RUNNING
1249 trx_weight 24
1250 trx_query NULL
1251 trx_operation_state NULL
1252 trx_tables_in_use 0
1253 trx_tables_locked 12
1254 trx_lock_structs 24
1255 trx_rows_locked 22
1256 trx_rows_modified 0
1257 trx_concurrency_tickets 0
1258 trx_isolation_level REPEATABLE READ
1259 trx_unique_checks 1
1260 trx_foreign_key_checks 1
1261 trx_last_foreign_key_error NULL
1262 trx_adaptive_hash_latched 0
1263 trx_adaptive_hash_timeout 0
1264 trx_is_read_only 0
1265 trx_autocommit_non_locking 0
1266 ENGINE INNODB
1267 OBJECT_SCHEMA test
1268 OBJECT_NAME t1_subpart
1269 PARTITION_NAME p1
1270 SUBPARTITION_NAME s2
1271 INDEX_NAME NULL
1272 LOCK_TYPE TABLE
1273 LOCK_MODE IX
1274 LOCK_STATUS GRANTED
1275 LOCK_DATA NULL
1276 trx_state RUNNING
1277 trx_weight 24
1278 trx_query NULL
1279 trx_operation_state NULL
1280 trx_tables_in_use 0
1281 trx_tables_locked 12
1282 trx_lock_structs 24
1283 trx_rows_locked 22
1284 trx_rows_modified 0
1285 trx_concurrency_tickets 0
1286 trx_isolation_level REPEATABLE READ
1287 trx_unique_checks 1
1288 trx_foreign_key_checks 1
1289 trx_last_foreign_key_error NULL
1290 trx_adaptive_hash_latched 0
1291 trx_adaptive_hash_timeout 0
1292 trx_is_read_only 0
1293 trx_autocommit_non_locking 0
1294 ENGINE INNODB
1295 OBJECT_SCHEMA test
1296 OBJECT_NAME t1_subpart
1297 PARTITION_NAME p1
1298 SUBPARTITION_NAME s2
1299 INDEX_NAME PRIMARY
1300 LOCK_TYPE RECORD
1301 LOCK_MODE X
1302 LOCK_STATUS GRANTED
1303 LOCK_DATA supremum pseudo-record
1304 trx_state RUNNING
1305 trx_weight 24
1306 trx_query NULL
1307 trx_operation_state NULL
1308 trx_tables_in_use 0
1309 trx_tables_locked 12
1310 trx_lock_structs 24
1311 trx_rows_locked 22
1312 trx_rows_modified 0
1313 trx_concurrency_tickets 0
1314 trx_isolation_level REPEATABLE READ
1315 trx_unique_checks 1
1316 trx_foreign_key_checks 1
1317 trx_last_foreign_key_error NULL
1318 trx_adaptive_hash_latched 0
1319 trx_adaptive_hash_timeout 0
1320 trx_is_read_only 0
1321 trx_autocommit_non_locking 0
1322 ENGINE INNODB
1323 OBJECT_SCHEMA test
1324 OBJECT_NAME t1_subpart
1325 PARTITION_NAME p1
1326 SUBPARTITION_NAME s3
1327 INDEX_NAME NULL
1328 LOCK_TYPE TABLE
1329 LOCK_MODE IX
1330 LOCK_STATUS GRANTED
1331 LOCK_DATA NULL
1332 trx_state RUNNING
1333 trx_weight 24
1334 trx_query NULL
1335 trx_operation_state NULL
1336 trx_tables_in_use 0
1337 trx_tables_locked 12
1338 trx_lock_structs 24
1339 trx_rows_locked 22
1340 trx_rows_modified 0
1341 trx_concurrency_tickets 0
1342 trx_isolation_level REPEATABLE READ
1343 trx_unique_checks 1
1344 trx_foreign_key_checks 1
1345 trx_last_foreign_key_error NULL
1346 trx_adaptive_hash_latched 0
1347 trx_adaptive_hash_timeout 0
1348 trx_is_read_only 0
1349 trx_autocommit_non_locking 0
1350 ENGINE INNODB
1351 OBJECT_SCHEMA test
1352 OBJECT_NAME t1_subpart
1353 PARTITION_NAME p1
1354 SUBPARTITION_NAME s3
1355 INDEX_NAME PRIMARY
1356 LOCK_TYPE RECORD
1357 LOCK_MODE X
1358 LOCK_STATUS GRANTED
1359 LOCK_DATA supremum pseudo-record
1360 trx_state RUNNING
1361 trx_weight 24
1362 trx_query NULL
1363 trx_operation_state NULL
1364 trx_tables_in_use 0
1365 trx_tables_locked 12
1366 trx_lock_structs 24
1367 trx_rows_locked 22
1368 trx_rows_modified 0
1369 trx_concurrency_tickets 0
1370 trx_isolation_level REPEATABLE READ
1371 trx_unique_checks 1
1372 trx_foreign_key_checks 1
1373 trx_last_foreign_key_error NULL
1374 trx_adaptive_hash_latched 0
1375 trx_adaptive_hash_timeout 0
1376 trx_is_read_only 0
1377 trx_autocommit_non_locking 0
1378 ENGINE INNODB
1379 OBJECT_SCHEMA test
1380 OBJECT_NAME t1_subpart
1381 PARTITION_NAME p2
1382 SUBPARTITION_NAME s4
1383 INDEX_NAME NULL
1384 LOCK_TYPE TABLE
1385 LOCK_MODE IX
1386 LOCK_STATUS GRANTED
1387 LOCK_DATA NULL
1388 trx_state RUNNING
1389 trx_weight 24
1390 trx_query NULL
1391 trx_operation_state NULL
1392 trx_tables_in_use 0
1393 trx_tables_locked 12
1394 trx_lock_structs 24
1395 trx_rows_locked 22
1396 trx_rows_modified 0
1397 trx_concurrency_tickets 0
1398 trx_isolation_level REPEATABLE READ
1399 trx_unique_checks 1
1400 trx_foreign_key_checks 1
1401 trx_last_foreign_key_error NULL
1402 trx_adaptive_hash_latched 0
1403 trx_adaptive_hash_timeout 0
1404 trx_is_read_only 0
1405 trx_autocommit_non_locking 0
1406 ENGINE INNODB
1407 OBJECT_SCHEMA test
1408 OBJECT_NAME t1_subpart
1409 PARTITION_NAME p2
1410 SUBPARTITION_NAME s4
1411 INDEX_NAME PRIMARY
1412 LOCK_TYPE RECORD
1413 LOCK_MODE X
1414 LOCK_STATUS GRANTED
1415 LOCK_DATA supremum pseudo-record
1416 trx_state RUNNING
1417 trx_weight 24
1418 trx_query NULL
1419 trx_operation_state NULL
1420 trx_tables_in_use 0
1421 trx_tables_locked 12
1422 trx_lock_structs 24
1423 trx_rows_locked 22
1424 trx_rows_modified 0
1425 trx_concurrency_tickets 0
1426 trx_isolation_level REPEATABLE READ
1427 trx_unique_checks 1
1428 trx_foreign_key_checks 1
1429 trx_last_foreign_key_error NULL
1430 trx_adaptive_hash_latched 0
1431 trx_adaptive_hash_timeout 0
1432 trx_is_read_only 0
1433 trx_autocommit_non_locking 0
1434 ENGINE INNODB
1435 OBJECT_SCHEMA test
1436 OBJECT_NAME t1_subpart
1437 PARTITION_NAME p2
1438 SUBPARTITION_NAME s5
1439 INDEX_NAME NULL
1440 LOCK_TYPE TABLE
1441 LOCK_MODE IX
1442 LOCK_STATUS GRANTED
1443 LOCK_DATA NULL
1444 trx_state RUNNING
1445 trx_weight 24
1446 trx_query NULL
1447 trx_operation_state NULL
1448 trx_tables_in_use 0
1449 trx_tables_locked 12
1450 trx_lock_structs 24
1451 trx_rows_locked 22
1452 trx_rows_modified 0
1453 trx_concurrency_tickets 0
1454 trx_isolation_level REPEATABLE READ
1455 trx_unique_checks 1
1456 trx_foreign_key_checks 1
1457 trx_last_foreign_key_error NULL
1458 trx_adaptive_hash_latched 0
1459 trx_adaptive_hash_timeout 0
1460 trx_is_read_only 0
1461 trx_autocommit_non_locking 0
1462 ENGINE INNODB
1463 OBJECT_SCHEMA test
1464 OBJECT_NAME t1_subpart
1465 PARTITION_NAME p2
1466 SUBPARTITION_NAME s5
1467 INDEX_NAME PRIMARY
1468 LOCK_TYPE RECORD
1469 LOCK_MODE X
1470 LOCK_STATUS GRANTED
1471 LOCK_DATA supremum pseudo-record
1472 trx_state RUNNING
1473 trx_weight 24
1474 trx_query NULL
1475 trx_operation_state NULL
1476 trx_tables_in_use 0
1477 trx_tables_locked 12
1478 trx_lock_structs 24
1479 trx_rows_locked 22
1480 trx_rows_modified 0
1481 trx_concurrency_tickets 0
1482 trx_isolation_level REPEATABLE READ
1483 trx_unique_checks 1
1484 trx_foreign_key_checks 1
1485 trx_last_foreign_key_error NULL
1486 trx_adaptive_hash_latched 0
1487 trx_adaptive_hash_timeout 0
1488 trx_is_read_only 0
1489 trx_autocommit_non_locking 0
1490 drop table t1_min;
1491 drop table t1_max;
1492 drop table t1_part;
1493 drop table t1_subpart;
1494 CREATE TABLE t (
1495 id INT NOT NULL,
1496 u INT NOT NULL,
1497 s INT NOT NULL,
1498 u1 INT NOT NULL,
1499 u2 INT NOT NULL,
1500 s1 INT NOT NULL,
1501 s2 INT NOT NULL,
1502 PRIMARY KEY k_id(id),
1503 KEY k_s(s),
1504 KEY k_s1_s2(s1,s2),
1505 UNIQUE KEY k_u(u),
1506 UNIQUE KEY k_u1_u2(u1,u2)
1507 ) Engine = InnoDB;
1508 INSERT INTO t VALUES (1,2,3,4,5,6,7), (10,20,30,40,50,60,70);
1509 BEGIN;
1510 SELECT * FROM t WHERE id=1 FOR UPDATE;
1511 id u s u1 u2 s1 s2
1512 1 2 3 4 5 6 7
1513 SELECT * FROM t WHERE u=2 FOR UPDATE;
1514 id u s u1 u2 s1 s2
1515 1 2 3 4 5 6 7
1516 SELECT * FROM t WHERE u1=3 FOR UPDATE;
1517 id u s u1 u2 s1 s2
1518 SELECT * FROM t WHERE s=3 FOR UPDATE;
1519 id u s u1 u2 s1 s2
1520 1 2 3 4 5 6 7
1521 SELECT * FROM t WHERE u1=4 FOR UPDATE;
1522 id u s u1 u2 s1 s2
1523 1 2 3 4 5 6 7
1524 SELECT * FROM t WHERE u1=40 AND u2=50 FOR UPDATE;
1525 id u s u1 u2 s1 s2
1526 10 20 30 40 50 60 70
1527 SELECT * FROM t WHERE s1=6 FOR UPDATE;
1528 id u s u1 u2 s1 s2
1529 1 2 3 4 5 6 7
1530 SELECT * FROM t WHERE s1=60 AND s2=70 FOR UPDATE;
1531 id u s u1 u2 s1 s2
1532 10 20 30 40 50 60 70
1533 SELECT lock_type,index_name,lock_mode,lock_data
1534 FROM performance_schema.data_locks
1535 WHERE object_schema="test" AND object_name="t"
1536 ORDER BY 1,2,3,4;
1537 lock_type index_name lock_mode lock_data
1538 RECORD k_s X 3, 1
1539 RECORD k_s X,GAP 30, 10
1540 RECORD k_s1_s2 X 6, 7, 1
1541 RECORD k_s1_s2 X 60, 70, 10
1542 RECORD k_s1_s2 X supremum pseudo-record
1543 RECORD k_s1_s2 X,GAP 60, 70, 10
1544 RECORD k_u X,REC_NOT_GAP 2, 1
1545 RECORD k_u1_u2 X 4, 5, 1
1546 RECORD k_u1_u2 X,GAP 4, 5, 1
1547 RECORD k_u1_u2 X,GAP 40, 50, 10
1548 RECORD k_u1_u2 X,REC_NOT_GAP 40, 50, 10
1549 RECORD PRIMARY X,REC_NOT_GAP 1
1550 RECORD PRIMARY X,REC_NOT_GAP 10
1551 TABLE NULL IX NULL
1552 ROLLBACK;
1553 DROP TABLE t;