Example of locks when innodb_thread_concurrency = 8
0
Mutex block
Count nsec Lock Caller
-------------------------------------------------------------------------------
225554 299695 mysqld`srv_conc_mutex mysqld`srv_conc_enter_innodb+0x34
203038 300416 mysqld`srv_conc_mutex mysqld`srv_conc_force_exit_innodb+0x38
32597 326522 mysqld`srv_conc_mutex mysqld`srv_conc_enter_innodb+0x34
21289 319810 mysqld`srv_conc_mutex mysqld`srv_conc_force_exit_innodb+0x38
8243 773016 mysqld`srv_conc_mutex mysqld`srv_conc_enter_innodb+0x100
10829 357416 mysqld`srv_conc_mutex mysqld`srv_conc_enter_innodb+0x34
11598 330907 mysqld`srv_conc_mutex mysqld`srv_conc_enter_innodb+0x34
10641 323978 mysqld`srv_conc_mutex mysqld`srv_conc_force_exit_innodb+0x38
9832 306689 mysqld`srv_conc_mutex mysqld`srv_conc_force_exit_innodb+0x38
18309 161278 0x1006da540 mysqld`os_mutex_enter+0x4
10406 280263 mysqld`srv_conc_mutex mysqld`srv_conc_force_exit_innodb+0x38
3016 794455 mysqld`srv_conc_mutex mysqld`srv_conc_enter_innodb+0x100
11557 182521 0x1006da540 mysqld`os_mutex_enter+0x4
11044 124884 0x1006da540 mysqld`os_mutex_enter+0x4
7480 171042 0x1006da540 mysqld`os_mutex_enter+0x4
1503 742086 mysqld`srv_conc_mutex mysqld`srv_conc_enter_innodb+0x100
17382 58724 mysqld`LOCK_open mysqld`__1cKopen_table6FpnDTHD_pnKTABLE_LIST_pnLst_mem_root_pbI_pnIst_table__+0x228
6806 140996 0x1006da540 mysqld`os_mutex_enter+0x4
5257 153668 0x1006da540 mysqld`os_mutex_enter+0x4
2342 328426 mysqld`srv_conc_mutex mysqld`srv_conc_enter_innodb+0x2d4
4348 168480 0x1006da540 mysqld`os_mutex_enter+0x4
837 764987 mysqld`srv_conc_mutex mysqld`srv_conc_enter_innodb+0x100
2845 201163 0x1006da540 mysqld`os_mutex_enter+0x4
2916 154285 0x1006da540 mysqld`os_mutex_enter+0x4
3064 144482 0x1006da540 mysqld`os_mutex_enter+0x4
3790 116457 0x1006da540 mysqld`os_mutex_enter+0x4
2140 199341 0x1006da540 mysqld`os_mutex_enter+0x4
2123 193049 0x1006da540 mysqld`os_mutex_enter+0x4
2835 142194 0x1006da540 mysqld`os_mutex_enter+0x4
913 439144 mysqld`LOCK_alarm mysqld`thr_alarm+0x38
1934 198333 0x1006da540 mysqld`os_mutex_enter+0x4
1971 191468 0x1006da540 mysqld`os_mutex_enter+0x4
2317 153738 0x1006da540 mysqld`os_mutex_enter+0x4
1676 185160 0x1006da540 mysqld`os_mutex_enter+0x4
844 321903 mysqld`srv_conc_mutex mysqld`srv_conc_enter_innodb+0x2d4
2589 100377 0x1006da540 mysqld`os_mutex_enter+0x4
1736 135222 0x1006da540 mysqld`os_mutex_enter+0x4
1182 186100 0x1006da540 mysqld`os_mutex_enter+0x4
3833 55618 mysqld`LOCK_open mysqld`__1cTclose_thread_tables6FpnDTHD_bb_v_+0x10c
1015 171217 0x1006da540 mysqld`os_mutex_enter+0x4
1123 147698 0x1006da540 mysqld`os_mutex_enter+0x4
797 190149 0x1006da540 mysqld`os_mutex_enter+0x4
648 229337 0x1006da540 mysqld`os_mutex_enter+0x4
433 331966 mysqld`srv_conc_mutex mysqld`srv_conc_enter_innodb+0x2d4
545 210079 0x1006da540 mysqld`os_mutex_enter+0x4
856 133186 0x1006da540 mysqld`os_mutex_enter+0x4
659 129381 0x1006da540 mysqld`os_mutex_enter+0x4
829 102585 0x1006da540 mysqld`os_mutex_enter+0x4
248 327095 mysqld`srv_conc_mutex mysqld`srv_conc_enter_innodb+0x2d4
534 144214 0x1006da540 mysqld`os_mutex_enter+0x4
504 145633 0x1006da540 mysqld`os_mutex_enter+0x4
481 146835 0x1006da540 mysqld`os_mutex_enter+0x4
119 588750 mysqld`LOCK_thread_count mysqld`__1cQdispatch_command6FnTenum_server_command_pnDTHD_pcI_b_+0xb8
413 168410 0x1006da540 mysqld`os_mutex_enter+0x4
117 577636 mysqld`LOCK_thread_count mysqld`__1cQdispatch_command6FnTenum_server_command_pnDTHD_pcI_b_+0x17ac
466 135152 0x1006da540 mysqld`os_mutex_enter+0x4
307 201692 0x1006da540 mysqld`os_mutex_enter+0x4
370 152455 0x1006da540 mysqld`os_mutex_enter+0x4
256 212891 0x1006da540 mysqld`os_mutex_enter+0x4
500 108284 0x1006da540 mysqld`os_mutex_enter+0x4
309 150813 0x1006da540 mysqld`os_mutex_enter+0x4
361 127239 0x1006da540 mysqld`os_mutex_enter+0x4
344 132204 0x1006da540 mysqld`os_mutex_enter+0x4
232 182365 0x1006da540 mysqld`os_mutex_enter+0x4
318 132341 0x1006da540 mysqld`os_mutex_enter+0x4
342 121343 0x1006da540 mysqld`os_mutex_enter+0x4
358 107505 0x1006da540 mysqld`os_mutex_enter+0x4
279 136366 0x1006da540 mysqld`os_mutex_enter+0x4
207 181679 0x1006da540 mysqld`os_mutex_enter+0x4
189 198205 mysqld`LOCK_alarm mysqld`thr_end_alarm+0x24
266 127897 0x1006da540 mysqld`os_mutex_enter+0x4
178 181104 0x1006da540 mysqld`os_mutex_enter+0x4
245 128821 0x1006da540 mysqld`os_mutex_enter+0x4
171 176862 0x1006da540 mysqld`os_mutex_enter+0x4
199 149676 0x1006da540 mysqld`os_mutex_enter+0x4
234 125839 0x1006da540 mysqld`os_mutex_enter+0x4
277 105921 0x1006da540 mysqld`os_mutex_enter+0x4
248 113066 0x1006da540 mysqld`os_mutex_enter+0x4
143 188762 0x1006da540 mysqld`os_mutex_enter+0x4
125 208668 0x1006da540 mysqld`os_mutex_enter+0x4
115 224526 0x1006da540 mysqld`os_mutex_enter+0x4
141 181203 0x1006da540 mysqld`os_mutex_enter+0x4
204 118794 0x1006da540 mysqld`os_mutex_enter+0x4
190 116918 0x1006da540 mysqld`os_mutex_enter+0x4
132 168005 0x1006da540 mysqld`os_mutex_enter+0x4
200 109635 0x1006da540 mysqld`os_mutex_enter+0x4
123 151022 0x1006da540 mysqld`os_mutex_enter+0x4
155 115972 0x1006da540 mysqld`os_mutex_enter+0x4
123 141556 0x1006da540 mysqld`os_mutex_enter+0x4
104 164925 0x1006da540 mysqld`os_mutex_enter+0x4
21 797423 mysqld`LOCK_thread_count mysqld`__1cKcheck_user6FpnDTHD_nTenum_server_command_pkcI4b_i_+0x274
133 120981 0x1006da540 mysqld`os_mutex_enter+0x4
72 206795 0x1006da540 mysqld`os_mutex_enter+0x4
102 139493 0x1006da540 mysqld`os_mutex_enter+0x4
96 141570 0x1006da540 mysqld`os_mutex_enter+0x4
106 111750 0x1006da540 mysqld`os_mutex_enter+0x4
75 144460 0x1006da540 mysqld`os_mutex_enter+0x4
58 180222 0x1006da540 mysqld`os_mutex_enter+0x4
48 214035 0x1006da540 mysqld`os_mutex_enter+0x4
89 111455 0x1006da540 mysqld`os_mutex_enter+0x4
46 204252 0x1006da540 mysqld`os_mutex_enter+0x4
58 155568 0x1006da540 mysqld`os_mutex_enter+0x4
61 128108 0x1006da540 mysqld`os_mutex_enter+0x4
46 169182 0x1006da540 mysqld`os_mutex_enter+0x4
40 190792 0x1006da540 mysqld`os_mutex_enter+0x4
240 31103 0x52f787b58 mysqld`os_event_reset+0x88
30 219036 0x1006da540 mysqld`os_mutex_enter+0x4
181 35862 0x52f787b58 mysqld`os_event_reset+0x88
33 174463 0x1006da540 mysqld`os_mutex_enter+0x4
59 92318 0x1006da540 mysqld`os_mutex_enter+0x4
229 19159 0x52f787b58 mysqld`os_event_wait_low+0x4
144 29374 0x52f787b58 mysqld`os_event_wait_low+0x4
36 115144 0x1006da540 mysqld`os_mutex_enter+0x4
47 80444 0x1006da540 mysqld`os_mutex_enter+0x4
22 161600 0x1006da540 mysqld`os_mutex_enter+0x4
19 174447 0x1006da540 mysqld`os_mutex_enter+0x4
33 91766 0x1006da540 mysqld`os_mutex_enter+0x4
25 115228 0x1006da540 mysqld`os_mutex_enter+0x4
84 34276 0x52f787b58 mysqld`os_event_reset+0x88
52 54457 0x52f787b58 mysqld`os_event_wait_low+0x38
8 325312 0x1006da540 mysqld`os_mutex_enter+0x4
11 201927 0x1006da540 mysqld`os_mutex_enter+0x4
24 80491 0x1006da540 mysqld`os_mutex_enter+0x4
6 307000 0x1006da540 mysqld`os_mutex_enter+0x4
7 248400 0x1006da540 mysqld`os_mutex_enter+0x4
7 243285 0x1006da540 mysqld`os_mutex_enter+0x4
6 279466 0x1006c89d0 mysqld`os_event_reset+0x88
2 786350 mysqld`LOCK_alarm mysqld`thr_alarm+0x38
22 63736 0x1006da540 mysqld`os_mutex_enter+0x4
22 62345 0x1006da540 mysqld`os_mutex_enter+0x4
14 88542 0x1006da540 mysqld`os_mutex_enter+0x4
2 610250 0x1006da540 mysqld`os_mutex_enter+0x4
19 61478 0x52f787b58 mysqld`os_event_set+0x88
14 82971 0x1034e3658 mysqld`os_event_reset+0x88
142 7853 0x52f787be0 mysqld`os_event_wait_low+0x4
6 175333 0x1006da540 mysqld`os_mutex_enter+0x4
2 419650 0x1006da540 mysqld`os_mutex_enter+0x4
8 103225 0x1006da540 mysqld`os_mutex_enter+0x4
4 204725 0x1006da540 mysqld`os_mutex_enter+0x4
27 29618 0x52f787b58 mysqld`os_event_set+0x88
1 770900 0x1006da540 mysqld`os_mutex_enter+0x4
6 127900 0x1006c89d0 mysqld`os_event_reset+0x88
31 22416 0x1034e3658 mysqld`os_event_reset+0x88
55 12205 0x52f787b58 mysqld`os_event_wait_low+0x4
4 164975 0x1006da540 mysqld`os_mutex_enter+0x4
4 162200 0x1006da540 mysqld`os_mutex_enter+0x4
23 27347 0x1034e3658 mysqld`os_event_wait_low+0x4
9 67622 mysqld`LOCK_alarm mysqld`process_alarm+0xcc
7 79500 0x1006c89d0 mysqld`os_event_reset+0x88
21 25738 0x1034e3658 mysqld`os_event_wait_low+0x4
4 127725 0x1006da540 mysqld`os_mutex_enter+0x4
13 38561 0x1006da540 mysqld`os_mutex_enter+0x4
5 86400 0x52f787b58 mysqld`os_event_reset+0x88
4 106650 0x1006da540 mysqld`os_mutex_enter+0x4
45 9424 0x52f787be0 mysqld`os_event_reset+0x88
2 187300 0x1006da540 mysqld`os_mutex_enter+0x4
2 183800 0x1006da540 mysqld`os_mutex_enter+0x4
6 59450 0x1006da540 mysqld`os_mutex_enter+0x4
18 19300 0x52f787b58 mysqld`os_event_set+0x88
2 164050 0x5e03fb8e0 mysqld`thr_unlock+0x14
2 163850 0x5e0695af0 mysqld`thr_unlock+0x14
2 156950 0x1006da540 mysqld`os_mutex_enter+0x4
4 77400 0x1006c89d0 mysqld`os_event_wait_low+0x4
3 102066 0x5e03fb8e0 mysqld`thr_lock+0x30
1 305200 0x1006da540 mysqld`os_mutex_enter+0x4
3 95033 0x1006da540 mysqld`os_mutex_enter+0x4
4 65375 0x1006c89d0 mysqld`os_event_set+0x88
1 236200 0x1006da540 mysqld`os_mutex_enter+0x4
3 71266 0x5e0695af0 mysqld`thr_lock+0x30
5 40660 0x1034e3658 mysqld`os_event_wait_low+0x38
4 50550 0x52f787b58 mysqld`os_event_set+0x88
1 174800 0x1006da540 mysqld`os_mutex_enter+0x4
4 38900 0x1006da540 mysqld`os_mutex_enter+0x4
20 7005 0x52f787be0 mysqld`os_event_wait_low+0x4
9 14155 0x52f787b58 mysqld`os_event_set+0x88
1 112600 0x1006da540 mysqld`os_mutex_enter+0x4
9 11877 0x52f787be0 mysqld`os_event_reset+0x88
6 17666 0x1006c89d0 mysqld`os_event_wait_low+0x38
2 50800 0x52f787be0 mysqld`os_event_set+0x88
6 13900 0x1034e3658 mysqld`os_event_set+0x88
1 80700 0x1006da540 mysqld`os_mutex_enter+0x4
2 39450 0x1006da540 mysqld`os_mutex_enter+0x4
1 75500 0x52f787b58 mysqld`os_event_set+0x88
2 34000 0x1006da540 mysqld`os_mutex_enter+0x4
1 62900 0x1006da540 mysqld`os_mutex_enter+0x4
5 12540 0x52f787b58 mysqld`os_event_set+0x88
1 62500 0x102e2dec0 mysqld`os_event_set+0x88
2 26550 0x5e0695bf8 mysqld`thr_unlock+0x14
1 53000 0x52f787b58 mysqld`os_event_wait_low+0x4
1 52800 0x5e03fbbf8 mysqld`thr_lock+0x30
2 26000 mysqld`LOCK_thread_count mysqld`__1cRcreate_new_thread6FpnDTHD__v_+0xa0
6 8450 0x52f787be0 mysqld`os_event_wait_low+0x38
1 50600 0x1006da540 mysqld`os_mutex_enter+0x4
1 49200 0x1006da540 mysqld`os_mutex_enter+0x4
1 47000 0x1006da540 mysqld`os_mutex_enter+0x4
6 7750 0x1006c89d0 mysqld`os_event_wait_low+0x4
3 14966 0x1006c89d0 mysqld`os_event_wait_low+0x4
2 21900 0x5e03fb9e8 mysqld`thr_unlock+0x14
4 10150 0x52f787b58 mysqld`os_event_reset+0x88
1 38000 0x1006da540 mysqld`os_mutex_enter+0x4
2 18300 0x1006c89d0 mysqld`os_event_set+0x88
1 34700 0x1006da540 mysqld`os_mutex_enter+0x4
1 32500 0x5e03fb9e8 mysqld`thr_lock+0x30
3 10666 0x52f787be0 mysqld`os_event_wait_low+0x4
2 14050 0x52f787b58 mysqld`os_event_reset+0x88
1 27000 0x1006da540 mysqld`os_mutex_enter+0x4
1 25100 0x52f787b58 mysqld`os_event_set+0x88
3 5733 0x52f787b58 mysqld`os_event_set+0x88
4 3975 0x52f787be0 mysqld`os_event_wait_low+0x4
2 6650 0x1006c89d0 mysqld`os_event_set+0x88
2 5500 0x52f787be0 mysqld`os_event_reset+0x88
2 5000 0x52f787b58 mysqld`os_event_wait_low+0x4
1 7200 0x1006da540 mysqld`os_mutex_enter+0x4
1 6900 0x1006da540 mysqld`os_mutex_enter+0x4
1 5900 0x1006da540 mysqld`os_mutex_enter+0x4
1 5600 0x52f787b58 mysqld`os_event_wait_low+0x4
1 5600 0x52f787b58 mysqld`os_event_set+0x88
1 5200 0x52f787b58 mysqld`os_event_set+0x88
1 5100 0x52f787b58 mysqld`os_event_wait_low+0x4
1 4800 0x52f787b58 mysqld`os_event_set+0x88
1 4800 0x1006da540 mysqld`os_mutex_enter+0x4
1 4200 0x52f787b58 mysqld`os_event_set+0x88