Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =====================================
- 2022-11-16 12:41:40 0x7faff6469700 INNODB MONITOR OUTPUT
- =====================================
- Per second averages calculated from the last 51 seconds
- -----------------
- BACKGROUND THREAD
- -----------------
- srv_master_thread loops: 3728645 srv_active, 0 srv_shutdown, 18633 srv_idle
- srv_master_thread log flush and writes: 3747278
- ----------
- SEMAPHORES
- ----------
- OS WAIT ARRAY INFO: reservation count 3487698078
- OS WAIT ARRAY INFO: signal count 2849616216
- RW-shared spins 0, rounds 1336530794, OS waits 313702145
- RW-excl spins 0, rounds 31988053366, OS waits 532768627
- RW-sx spins 558501507, rounds 14549647436, OS waits 371569835
- Spin rounds per wait: 1336530794.00 RW-shared, 31988053366.00 RW-excl, 26.05 RW-sx
- ------------------------
- LATEST DETECTED DEADLOCK
- ------------------------
- 2022-11-10 07:02:03 0x7fb55e10f700
- *** (1) TRANSACTION:
- TRANSACTION 232134723536, ACTIVE 1 sec starting index read
- mysql tables in use 1, locked 1
- LOCK WAIT 36 lock struct(s), heap size 3520, 20 row lock(s)
- MySQL thread id 8347053, OS thread handle 140397866137344, query id 102150496544 10.212.135.100 vivek Searching rows for update
- UPDATE `esms_mis`.dlr_outbox SET dlr_STATUS=1, thread_id=0 WHERE dlr_STATUS=6 LIMIT 1000000
- *** (1) WAITING FOR THIS LOCK TO BE GRANTED:
- RECORD LOCKS space id 7303064 page no 2344 n bits 184 index GEN_CLUST_INDEX of table `esms_mis`.`dlr_outbox` /* Partition `O15` */ trx id 232134723536 lock_mode X locks rec but not gap waiting
- Record lock, heap no 67 PHYSICAL RECORD: n_fields 21; compact format; info bits 0
- 0: len 6; hex 000bdb369f88; asc 6 ;;
- 1: len 6; hex 0036091c957a; asc 6 z;;
- 2: len 7; hex 220000c022122e; asc " " .;;
- 3: len 8; hex 80000000211ea023; asc ! #;;
- 4: len 3; hex 800000; asc ;;
- 5: len 2; hex 000f; asc ;;
- 6: len 2; hex 8001; asc ;;
- 7: len 1; hex 06; asc ;;
- 8: len 1; hex 00; asc ;;
- 9: len 1; hex 01; asc ;;
- 10: SQL NULL;
- 11: len 8; hex 99ae3620010c56c9; asc 6 V ;;
- 12: len 8; hex 99ae362004000000; asc 6 ;;
- 13: len 8; hex 99ae3620400cb137; asc 6 @ 7;;
- 14: len 8; hex 99ae5371210d60c4; asc Sq! ` ;;
- 15: SQL NULL;
- 16: len 30; hex 65306137336664642d333562622d343165642d396263382d376336393764; asc e0a73fdd-35bb-41ed-9bc8-7c697d; (total 36 bytes);
- 17: len 24; hex 79345069777947537a68773479616333462f783476513d3d; asc y4PiwyGSzhw4yac3F/x4vQ==;;
- 18: SQL NULL;
- 19: SQL NULL;
- 20: SQL NULL;
- *** (2) TRANSACTION:
- TRANSACTION 232134722350, ACTIVE 1 sec updating or deleting
- mysql tables in use 3, locked 3
- 1704 lock struct(s), heap size 188624, 263951 row lock(s), undo log entries 1
- MySQL thread id 8337568, OS thread handle 140416943978240, query id 102150485862 192.168.61.152 pdduser updating
- UPDATE dlr_outbox SET dlr_status=2, thread_id= NAME_CONST('_thread_id',2) WHERE dlr_status =1 and gateway_id= NAME_CONST('_gateway_id',15) LIMIT 1000
- *** (2) HOLDS THE LOCK(S):
- RECORD LOCKS space id 7303064 page no 2344 n bits 184 index GEN_CLUST_INDEX of table `esms_mis`.`dlr_outbox` /* Partition `O15` */ trx id 232134722350 lock_mode X locks rec but not gap
- Record lock, heap no 67 PHYSICAL RECORD: n_fields 21; compact format; info bits 0
- 0: len 6; hex 000bdb369f88; asc 6 ;;
- 1: len 6; hex 0036091c957a; asc 6 z;;
- 2: len 7; hex 220000c022122e; asc " " .;;
- 3: len 8; hex 80000000211ea023; asc ! #;;
- 4: len 3; hex 800000; asc ;;
- 5: len 2; hex 000f; asc ;;
- 6: len 2; hex 8001; asc ;;
- 7: len 1; hex 06; asc ;;
- 8: len 1; hex 00; asc ;;
- 9: len 1; hex 01; asc ;;
- 10: SQL NULL;
- 11: len 8; hex 99ae3620010c56c9; asc 6 V ;;
- 12: len 8; hex 99ae362004000000; asc 6 ;;
- 13: len 8; hex 99ae3620400cb137; asc 6 @ 7;;
- 14: len 8; hex 99ae5371210d60c4; asc Sq! ` ;;
- 15: SQL NULL;
- 16: len 30; hex 65306137336664642d333562622d343165642d396263382d376336393764; asc e0a73fdd-35bb-41ed-9bc8-7c697d; (total 36 bytes);
- 17: len 24; hex 79345069777947537a68773479616333462f783476513d3d; asc y4PiwyGSzhw4yac3F/x4vQ==;;
- 18: SQL NULL;
- 19: SQL NULL;
- 20: SQL NULL;
- Record lock, heap no 68 PHYSICAL RECORD: n_fields 21; compact format; info bits 0
- 0: len 6; hex 000bdb5240ac; asc R@ ;;
- 1: len 6; hex 0036091c957a; asc 6 z;;
- 2: len 7; hex 220000c02212a8; asc " " ;;
- 3: len 8; hex 80000000216e307d; asc !n0};;
- 4: len 3; hex 800000; asc ;;
- 5: len 2; hex 000f; asc ;;
- 6: len 2; hex 8001; asc ;;
- 7: len 1; hex 06; asc ;;
- 8: len 1; hex 00; asc ;;
- 9: len 1; hex 01; asc ;;
- 10: SQL NULL;
- 11: len 8; hex 99ae36aa010c24fb; asc 6 $ ;;
- 12: len 8; hex 99ae36aa05000000; asc 6 ;;
- 13: len 8; hex 99ae36aa39088c1d; asc 6 9 ;;
- 14: len 8; hex 99ae5371210d6b4b; asc Sq! kK;;
- 15: SQL NULL;
- 16: len 30; hex 31363936633236662d386166622d346630642d393534652d383330323738; asc 1696c26f-8afb-4f0d-954e-830278; (total 36 bytes);
- 17: len 24; hex 796d38444e55432f4d435558505171434a77316269513d3d; asc ym8DNUC/MCUXPQqCJw1biQ==;;
- 18: SQL NULL;
- 19: SQL NULL;
- 20: SQL NULL;
- Record lock, heap no 69 PHYSICAL RECORD: n_fields 21; compact format; info bits 0
- 0: len 6; hex 000bdb641cd3; asc d ;;
- 1: len 6; hex 0036091c957a; asc 6 z;;
- 2: len 7; hex 220000c0221322; asc " " ";;
- 3: len 8; hex 8000000021a43a9d; asc ! : ;;
- 4: len 3; hex 800000; asc ;;
- 5: len 2; hex 000f; asc ;;
- 6: len 2; hex 8001; asc ;;
- 7: len 1; hex 06; asc ;;
- 8: len 1; hex 00; asc ;;
- 9: len 1; hex 01; asc ;;
- 10: SQL NULL;
- 11: len 8; hex 99ae36ca010e8beb; asc 6 ;;
- 12: len 8; hex 99ae36ca03000000; asc 6 ;;
- 13: len 8; hex 99ae36ca2908e662; asc 6 ) b;;
- 14: len 8; hex 99ae5371210d751c; asc Sq! u ;;
- 15: SQL NULL;
- 16: len 30; hex 35316234666438392d396235632d343131632d396536622d323262313438; asc 51b4fd89-9b5c-411c-9e6b-22b148; (total 36 bytes);
- 17: len 24; hex 796d38444e55432f4d435558505171434a77316269513d3d; asc ym8DNUC/MCUXPQqCJw1biQ==;;
- 18: SQL NULL;
- 19: SQL NULL;
- 20: SQL NULL;
- Record lock, heap no 70 PHYSICAL RECORD: n_fields 21; compact format; info bits 0
- 0: len 6; hex 000bdb658356; asc e V;;
- 1: len 6; hex 0036091c957a; asc 6 z;;
- 2: len 7; hex 220000c022139c; asc " " ;;
- 3: len 8; hex 8000000021a894af; asc ! ;;
- 4: len 3; hex 800000; asc ;;
- 5: len 2; hex 000f; asc ;;
- 6: len 2; hex 8001; asc ;;
- 7: len 1; hex 06; asc ;;
- 8: len 1; hex 00; asc ;;
- 9: len 1; hex 01; asc ;;
- 10: SQL NULL;
- 11: len 8; hex 99ae36cc8200f64e; asc 6 N;;
- 12: len 8; hex 99ae36cc84000000; asc 6 ;;
- 13: len 8; hex 99ae36ccb100da1e; asc 6 ;;
- 14: len 8; hex 99ae5371210d7ee4; asc Sq! ~ ;;
- 15: SQL NULL;
- 16: len 30; hex 34366462313137352d393436372d343436652d613861622d656539616536; asc 46db1175-9467-446e-a8ab-ee9ae6; (total 36 bytes);
- 17: len 24; hex 627232447668475666763650797332426a5a353439773d3d; asc br2DvhGVfv6Pys2BjZ549w==;;
- 18: SQL NULL;
- 19: SQL NULL;
- 20: SQL NULL;
- Record lock, heap no 71 PHYSICAL RECORD: n_fields 21; compact format; info bits 0
- 0: len 6; hex 000bdb70f7a0; asc p ;;
- 1: len 6; hex 0036091c957a; asc 6 z;;
- 2: len 7; hex 220000c0221416; asc " " ;;
- 3: len 8; hex 8000000021cbd2b1; asc ! ;;
- 4: len 3; hex 800000; asc ;;
- 5: len 2; hex 000f; asc ;;
- 6: len 2; hex 8001; asc ;;
- 7: len 1; hex 06; asc ;;
- 8: len 1; hex 00; asc ;;
- 9: len 1; hex 01; asc ;;
- 10: SQL NULL;
- 11: len 8; hex 99ae36e3c1023c82; asc 6 < ;;
- 12: len 8; hex 99ae36e3c4000000; asc 6 ;;
- 13: len 8; hex 99ae36e3f70062b3; asc 6 b ;;
- 14: len 8; hex 99ae5371210d86f2; asc Sq! ;;
- 15: SQL NULL;
- 16: len 30; hex 62306535643834632d306633662d343264632d386639322d643139343265; asc b0e5d84c-0f3f-42dc-8f92-d1942e; (total 36 bytes);
- 17: len 24; hex 74526b634d304946675744684278465a4f6933784e513d3d; asc tRkcM0IFgWDhBxFZOi3xNQ==;;
- 18: SQL NULL;
- 19: SQL NULL;
- 20: SQL NULL;
- Record lock, heap no 72 PHYSICAL RECORD: n_fields 21; compact format; info bits 0
- 0: len 6; hex 000bdb74ab41; asc t A;;
- 1: len 6; hex 0036091c957a; asc 6 z;;
- 2: len 7; hex 220000c0221490; asc " " ;;
- 3: len 8; hex 8000000021d6ed7f; asc ! ;;
- 4: len 3; hex 800000; asc ;;
- 5: len 2; hex 000f; asc ;;
- 6: len 2; hex 8001; asc ;;
- 7: len 1; hex 06; asc ;;
- 8: len 1; hex 00; asc ;;
- 9: len 1; hex 01; asc ;;
- 10: SQL NULL;
- 11: len 8; hex 99ae36ec82013f8a; asc 6 ? ;;
- 12: len 8; hex 99ae36ec84000000; asc 6 ;;
- 13: len 8; hex 99ae36ecb505a349; asc 6 I;;
- 14: len 8; hex 99ae5371210d90ad; asc Sq! ;;
- 15: SQL NULL;
- 16: len 30; hex 36643134396364612d643037382d346632312d393132332d633731626237; asc 6d149cda-d078-4f21-9123-c71bb7; (total 36 bytes);
- 17: len 24; hex 654a32516d664d794e6c4735385257685144654a2b413d3d; asc eJ2QmfMyNlG58RWhQDeJ+A==;;
- 18: SQL NULL;
- 19: SQL NULL;
- 20: SQL NULL;
- Record lock, heap no 73 PHYSICAL RECORD: n_fields 21; compact format; info bits 0
- 0: len 6; hex 000bdb8f34ff; asc 4 ;;
- 1: len 6; hex 0036091c957a; asc 6 z;;
- 2: len 7; hex 220000c022150a; asc " " ;;
- 3: len 8; hex 800000002221e643; asc "! C;;
- 4: len 3; hex 800000; asc ;;
- 5: len 2; hex 000f; asc ;;
- 6: len 2; hex 8001; asc ;;
- 7: len 1; hex 06; asc ;;
- 8: len 1; hex 00; asc ;;
- 9: len 1; hex 01; asc ;;
- 10: SQL NULL;
- 11: len 8; hex 99ae3723c1094b8a; asc 7# K ;;
- 12: len 8; hex 99ae3723c4000000; asc 7# ;;
- 13: len 8; hex 99ae3723f10e6c09; asc 7# l ;;
- 14: len 8; hex 99ae5371210d9b0a; asc Sq! ;;
- 15: SQL NULL;
- 16: len 30; hex 62346233396438302d666165662d343537642d393537332d303335363034; asc b4b39d80-faef-457d-9573-035604; (total 36 bytes);
- 17: len 24; hex 41617948435341343864744d565346457531756342513d3d; asc AayHCSA48dtMVSFEu1ucBQ==;;
- 18: SQL NULL;
- 19: SQL NULL;
- 20: SQL NULL;
- Record lock, heap no 74 PHYSICAL RECORD: n_fields 21; compact format; info bits 0
- 0: len 6; hex 000bdb937990; asc y ;;
- 1: len 6; hex 0036091c957a; asc 6 z;;
- 2: len 7; hex 220000c0221584; asc " " ;;
- 3: len 8; hex 80000000222e9035; asc ". 5;;
- 4: len 3; hex 800000; asc ;;
- 5: len 2; hex 000f; asc ;;
- 6: len 2; hex 8001; asc ;;
- 7: len 1; hex 06; asc ;;
- 8: len 1; hex 00; asc ;;
- 9: len 1; hex 01; asc ;;
- 10: SQL NULL;
- 11: len 8; hex 99ae372c810d4c47; asc 7, LG;;
- 12: len 8; hex 99ae372c83000000; asc 7, ;;
- 13: len 8; hex 99ae372cab05c725; asc 7, %;;
- 14: len 8; hex 99ae5371210da55c; asc Sq! \;;
- 15: SQL NULL;
- 16: len 30; hex 36313433633762642d356363632d343330632d386436322d313939326361; asc 6143c7bd-5ccc-430c-8d62-1992ca; (total 36 bytes);
- 17: len 24; hex 627232447668475666763650797332426a5a353439773d3d; asc br2DvhGVfv6Pys2BjZ549w==;;
- 18: SQL NULL;
- 19: SQL NULL;
- 20: SQL NULL;
- Record lock, heap no 75 PHYSICAL RECORD: n_fields 21; compact format; info bits 0
- 0: len 6; hex 000bdb9ab781; asc ;;
- 1: len 6; hex 0036091c957a; asc 6 z;;
- 2: len 7; hex 220000c02215fe; asc " " ;;
- 3: len 8; hex 800000002243aee7; asc "C ;;
- 4: len 3; hex 800000; asc ;;
- 5: len 2; hex 000f; asc ;;
- 6: len 2; hex 8001; asc ;;
- 7: len 1; hex 06; asc ;;
- 8: len 1; hex 00; asc ;;
- 9: len 1; hex 01; asc ;;
- 10: SQL NULL;
- 11: len 8; hex 99ae37428200155a; asc 7B Z;;
- 12: len 8; hex 99ae374283000000; asc 7B ;;
- 13: len 8; hex 99ae3742c20aaced; asc 7B ;;
- 14: len 8; hex 99ae5371210dadaa; asc Sq! ;;
- 15: SQL NULL;
- 16: len 30; hex 63653965653933312d326462632d346662622d386537632d363332353665; asc ce9ee931-2dbc-4fbb-8e7c-63256e; (total 36 bytes);
- 17: len 24; hex 46744c3359456b765468303554513362324d713935773d3d; asc FtL3YEkvTh05TQ3b2Mq95w==;;
- 18: SQL NULL;
- 19: SQL NULL;
- 20: SQL NULL;
- Record lock, heap no 76 PHYSICAL RECORD: n_fields 21; compact format; info bits 0
- 0: len 6; hex 000bdba065e2; asc e ;;
- 1: len 6; hex 0036091c957a; asc 6 z;;
- 2: len 7; hex 220000c0221678; asc " " x;;
- 3: len 8; hex 8000000022526a6b; asc "Rjk;;
- 4: len 3; hex 800000; asc ;;
- 5: len 2; hex 000f; asc ;;
- 6: len 2; hex 8001; asc ;;
- 7: len 1; hex 06; asc ;;
- 8: len 1; hex 00; asc ;;
- 9: len 1; hex 01; asc ;;
- 10: SQL NULL;
- 11: len 8; hex 99ae3763c2008cc5; asc 7c ;;
- 12: len 8; hex 99ae3763c5000000; asc 7c ;;
- 13: len 8; hex 99ae376402085c7e; asc 7d \~;;
- 14: len 8; hex 99ae5371210db96c; asc Sq! l;;
- 15: SQL NULL;
- 16: len 30; hex 35613039323264652d313765392d346166652d613037622d336631373761; asc 5a0922de-17e9-4afe-a07b-3f177a; (total 36 bytes);
- 17: len 24; hex 486139754362434446765a36486b5352736e5a4e58513d3d; asc Ha9uCbCDFvZ6HkSRsnZNXQ==;;
- 18: SQL NULL;
- 19: SQL NULL;
- 20: SQL NULL;
- Record lock, heap no 77 PHYSICAL RECORD: n_fields 21; compact format; info bits 0
- 0: len 6; hex 000bdba197ce; asc ;;
- 1: len 6; hex 0036091c957a; asc 6 z;;
- 2: len 7; hex 220000c02216f2; asc " " ;;
- 3: len 8; hex 8000000022553189; asc "U1 ;;
- 4: len 3; hex 800000; asc ;;
- 5: len 2; hex 000f; asc ;;
- 6: len 2; hex 8001; asc ;;
- 7: len 1; hex 06; asc ;;
- 8: len 1; hex 00; asc ;;
- 9: len 1; hex 01; asc ;;
- 10: SQL NULL;
- 11: len 8; hex 99ae376c8106df78; asc 7l x;;
- 12: len 8; hex 99ae376c84000000; asc 7l ;;
- 13: len 8; hex 99ae376cc109d2dd; asc 7l ;;
- 14: len 8; hex 99ae5371210dc3b7; asc Sq! ;;
- 15: SQL NULL;
- 16: len 30; hex 31663463623136332d343061642d343863302d383663392d336464366131; asc 1f4cb163-40ad-48c0-86c9-3dd6a1; (total 36 bytes);
- 17: len 24; hex 627232447668475666763650797332426a5a353439773d3d; asc br2DvhGVfv6Pys2BjZ549w==;;
- 18: SQL NULL;
- 19: SQL NULL;
- 20: SQL NULL;
- Record lock, heap no 78 PHYSICAL RECORD: n_fields 21; compact format; info bits 0
- 0: len 6; hex 000bdba36de5; asc m ;;
- 1: len 6; hex 0036091c957a; asc 6 z;;
- 2: len 7; hex 220000c022176c; asc " " l;;
- 3: len 8; hex 8000000022591f5f; asc "Y _;;
- 4: len 3; hex 800000; asc ;;
- 5: len 2; hex 000f; asc ;;
- 6: len 2; hex 8001; asc ;;
- 7: len 1; hex 06; asc ;;
- 8: len 1; hex 00; asc ;;
- 9: len 1; hex 01; asc ;;
- 10: SQL NULL;
- 11: len 8; hex 99ae3803c1096313; asc 8 c ;;
- 12: len 8; hex 99ae3803c3000000; asc 8 ;;
- 13: len 8; hex 99ae3804000b29b7; asc 8 ) ;;
- 14: len 8; hex 99ae5371210dcd67; asc Sq! g;;
- 15: SQL NULL;
- 16: len 30; hex 61393239396366312d326532362d343839662d613433342d303036336166; asc a9299cf1-2e26-489f-a434-0063af; (total 36 bytes);
- 17: len 24; hex 41617948435341343864744d565346457531756342513d3d; asc AayHCSA48dtMVSFEu1ucBQ==;;
- 18: SQL NULL;
- 19: SQL NULL;
- 20: SQL NULL;
- Record lock, heap no 79 PHYSICAL RECORD: n_fields 21; compact format; info bits 0
- 0: len 6; hex 000bdba36def; asc m ;;
- 1: len 6; hex 0036091c957a; asc 6 z;;
- 2: len 7; hex 220000c02217e6; asc " " ;;
- 3: len 8; hex 8000000022591f5d; asc "Y ];;
- 4: len 3; hex 800000; asc ;;
- 5: len 2; hex 000f; asc ;;
- 6: len 2; hex 8001; asc ;;
- 7: len 1; hex 06; asc ;;
- 8: len 1; hex 00; asc ;;
- 9: len 1; hex 01; asc ;;
- 10: SQL NULL;
- 11: len 8; hex 99ae3803c10895da; asc 8 ;;
- 12: len 8; hex 99ae3803c4000000; asc 8 ;;
- 13: len 8; hex 99ae3804000cbb83; asc 8 ;;
- 14: len 8; hex 99ae5371210de08e; asc Sq! ;;
- 15: SQL NULL;
- 16: len 30; hex 32396231373930312d336561652d346234362d613339382d373634666136; asc 29b17901-3eae-4b46-a398-764fa6; (total 36 bytes);
- 17: len 24; hex 776f646e45443659475a41516351656863746a5834413d3d; asc wodnED6YGZAQcQehctjX4A==;;
- 18: SQL NULL;
- 19: SQL NULL;
- 20: SQL NULL;
- Record lock, heap no 80 PHYSICAL RECORD: n_fields 21; compact format; info bits 0
- 0: len 6; hex 000bdba45c6a; asc \j;;
- 1: len 6; hex 0036091c957a; asc 6 z;;
- 2: len 7; hex 220000c0221860; asc " " `;;
- 3: len 8; hex 80000000225a8e8d; asc "Z ;;
- 4: len 3; hex 800000; asc ;;
- 5: len 2; hex 000f; asc ;;
- 6: len 2; hex 8001; asc ;;
- 7: len 1; hex 06; asc ;;
- 8: len 1; hex 00; asc ;;
- 9: len 1; hex 01; asc ;;
- 10: SQL NULL;
- 11: len 8; hex 99ae3823c10f17a9; asc 8# ;;
- 12: len 8; hex 99ae3823c9000000; asc 8# ;;
- 13: len 8; hex 99ae382401003fe8; asc 8$ ? ;;
- 14: len 8; hex 99ae5371210deb47; asc Sq! G;;
- 15: SQL NULL;
- 16: len 30; hex 33363335653839312d323565322d346632322d623263312d653236303231; asc 3635e891-25e2-4f22-b2c1-e26021; (total 36 bytes);
- 17: len 24; hex 41617948435341343864744d565346457531756342513d3d; asc AayHCSA48dtMVSFEu1ucBQ==;;
- 18: SQL NULL;
- 19: SQL NULL;
- 20: SQL NULL;
- Record lock, heap no 81 PHYSICAL RECORD: n_fields 21; compact format; info bits 0
- 0: len 6; hex 000bdbb9a9f0; asc ;;
- 1: len 6; hex 0036091c957a; asc 6 z;;
- 2: len 7; hex 220000c02218da; asc " " ;;
- 3: len 8; hex 80000000229c576d; asc " Wm;;
- 4: len 3; hex 800000; asc ;;
- 5: len 2; hex 000f; asc ;;
- 6: len 2; hex 8001; asc ;;
- 7: len 1; hex 06; asc ;;
- 8: len 1; hex 00; asc ;;
- 9: len 1; hex 01; asc ;;
- 10: SQL NULL;
- 11: len 8; hex 99ae38a3c202bcad; asc 8 ;;
- 12: len 8; hex 99ae38a3c5000000; asc 8 ;;
- 13: len 8; hex 99ae38a3f10efb21; asc 8 !;;
- 14: len 8; hex 99ae5371210df410; asc Sq! ;;
- 15: SQL NULL;
- 16: len 30; hex 35343166643234362d316364622d343965662d626537642d646262636435; asc 541fd246-1cdb-49ef-be7d-dbbcd5; (total 36 bytes);
- 17: len 24; hex 41617948435341343864744d565346457531756342513d3d; asc AayHCSA48dtMVSFEu1ucBQ==;;
- 18: SQL NULL;
- 19: SQL NULL;
- 20: SQL NULL;
- Record lock, heap no 82 PHYSICAL RECORD: n_fields 21; compact format; info bits 0
- 0: len 6; hex 000bdbb9aa0c; asc ;;
- 1: len 6; hex 0036091c957a; asc 6 z;;
- 2: len 7; hex 220000c0221954; asc " " T;;
- 3: len 8; hex 80000000229c5717; asc " W ;;
- 4: len 3; hex 800000; asc ;;
- 5: len 2; hex 000f; asc ;;
- 6: len 2; hex 8001; asc ;;
- 7: len 1; hex 06; asc ;;
- 8: len 1; hex 00; asc ;;
- 9: len 1; hex 01; asc ;;
- 10: SQL NULL;
- 11: len 8; hex 99ae38a3c200f341; asc 8 A;;
- 12: len 8; hex 99ae38a3c6000000; asc 8 ;;
- 13: len 8; hex 99ae38a3f202fadf; asc 8 ;;
- 14: len 8; hex 99ae5371210e0af2; asc Sq! ;;
- 15: SQL NULL;
- 16: len 30; hex 35373938653762392d653238642d346234392d396436332d653238346330; asc 5798e7b9-e28d-4b49-9d63-e284c0; (total 36 bytes);
- 17: len 24; hex 486139754362434446765a36486b5352736e5a4e58513d3d; asc Ha9uCbCDFvZ6HkSRsnZNXQ==;;
- 18: SQL NULL;
- 19: SQL NULL;
- 20: SQL NULL;
- Record lock, heap no 83 PHYSICAL RECORD: n_fields 21; compact format; info bits 0
- 0: len 6; hex 000bdbcf394b; asc 9K;;
- 1: len 6; hex 0036091c957a; asc 6 z;;
- 2: len 7; hex 220000c02219ce; asc " " ;;
- 3: len 8; hex 8000000022dc33e7; asc " 3 ;;
- 4: len 3; hex 800000; asc ;;
- 5: len 2; hex 000f; asc ;;
- 6: len 2; hex 8001; asc ;;
- 7: len 1; hex 06; asc ;;
- 8: len 1; hex 00; asc ;;
- 9: len 1; hex 01; asc ;;
- 10: SQL NULL;
- 11: len 8; hex 99ae38c5010e342f; asc 8 4/;;
- 12: len 8; hex 99ae38c503000000; asc 8 ;;
- 13: len 8; hex 99ae38c528062fe1; asc 8 ( / ;;
- 14: len 8; hex 99ae5371210e13d4; asc Sq! ;;
- 15: SQL NULL;
- 16: len 30; hex 31336361653836632d616164372d346238362d623639332d313535376531; asc 13cae86c-aad7-4b86-b693-1557e1; (total 36 bytes);
- 17: len 24; hex 5633456a5a735579655931556c46324f495337655a673d3d; asc V3EjZsUyeY1UlF2OIS7eZg==;;
- 18: SQL NULL;
- 19: SQL NULL;
- 20: SQL NULL;
- Record lock, heap no 84 PHYSICAL RECORD: n_fields 21; compact format; info bits 0
- 0: len 6; hex 000bdbd4bbde; asc ;;
- 1: len 6; hex 0036091c957a; asc 6 z;;
- 2: len 7; hex 220000c0221a48; asc " " H;;
- 3: len 8; hex 8000000022ecdd15; asc " ;;
- 4: len 3; hex 800000; asc ;;
- 5: len 2; hex 000f; asc ;;
- 6: len 2; hex 8001; asc ;;
- 7: len 1; hex 06; asc ;;
- 8: len 1; hex 00; asc ;;
- 9: len 1; hex 01; asc ;;
- 10: SQL NULL;
- 11: len 8; hex 99ae38cc810d874b; asc 8 K;;
- 12: len 8; hex 99ae38cc86000000; asc 8 ;;
- 13: len 8; hex 99ae38ccad0daa40; asc 8 @;;
- 14: len 8; hex 99ae5371210e1ea6; asc Sq! ;;
- 15: SQL NULL;
- 16: len 30; hex 66656166656531392d643037642d343337662d613936392d373864313963; asc feafee19-d07d-437f-a969-78d19c; (total 36 bytes);
- 17: len 24; hex 654a32516d664d794e6c4735385257685144654a2b413d3d; asc eJ2QmfMyNlG58RWhQDeJ+A==;;
- 18: SQL NULL;
- 19: SQL NULL;
- 20: SQL NULL;
- Record lock, heap no 85 PHYSICAL RECORD: n_fields 21; compact format; info bits 0
- 0: len 6; hex 000bdbe3b265; asc e;;
- 1: len 6; hex 0036091c957a; asc 6 z;;
- 2: len 7; hex 220000c0221ac2; asc " " ;;
- 3: len 8; hex 80000000231b45fd; asc # E ;;
- 4: len 3; hex 800000; asc ;;
- 5: len 2; hex 000f; asc ;;
- 6: len 2; hex 8001; asc ;;
- 7: len 1; hex 06; asc ;;
- 8: len 1; hex 00; asc ;;
- 9: len 1; hex 01; asc ;;
- 10: SQL NULL;
- 11: len 8; hex 99ae38e78108c0b9; asc 8 ;;
- 12: len 8; hex 99ae38e785000000; asc 8 ;;
- 13: len 8; hex 99ae38e7b2016994; asc 8 i ;;
- 14: len 8; hex 99ae5371210e28bd; asc Sq! ( ;;
- 15: SQL NULL;
- 16: len 30; hex 66396531303539362d363731662d346635362d383364612d343031636461; asc f9e10596-671f-4f56-83da-401cda; (total 36 bytes);
- 17: len 24; hex 306d6b4a474662377a4c327871686f645673475271413d3d; asc 0mkJGFb7zL2xqhodVsGRqA==;;
- 18: SQL NULL;
- 19: SQL NULL;
- 20: SQL NULL;
- Record lock, heap no 86 PHYSICAL RECORD: n_fields 21; compact format; info bits 0
- 0: len 6; hex 000bdbf41c2e; asc .;;
- 1: len 6; hex 0036091c957a; asc 6 z;;
- 2: len 7; hex 220000c0221b3c; asc " " <;;
- 3: len 8; hex 800000002349046d; asc #I m;;
- 4: len 3; hex 800000; asc ;;
- 5: len 2; hex 000f; asc ;;
- 6: len 2; hex 8001; asc ;;
- 7: len 1; hex 06; asc ;;
- 8: len 1; hex 00; asc ;;
- 9: len 1; hex 01; asc ;;
- 10: SQL NULL;
- 11: len 8; hex 99ae3903c1049f0a; asc 9 ;;
- 12: len 8; hex 99ae3903c3000000; asc 9 ;;
- 13: len 8; hex 99ae3903ea099467; asc 9 g;;
- 14: len 8; hex 99ae5371210e3181; asc Sq! 1 ;;
- 15: SQL NULL;
- 16: len 30; hex 37633638383632382d336362332d346334312d613738352d333364333030; asc 7c688628-3cb3-4c41-a785-33d300; (total 36 bytes);
- 17: len 24; hex 41617948435341343864744d565346457531756342513d3d; asc AayHCSA48dtMVSFEu1ucBQ==;;
- 18: SQL NULL;
- 19: SQL NULL;
- 20: SQL NULL;
- Record lock, heap no 87 PHYSICAL RECORD: n_fields 21; compact format; info bits 0
- 0: len 6; hex 000bdbf41cc7; asc ;;
- 1: len 6; hex 0036091c957a; asc 6 z;;
- 2: len 7; hex 220000c0221bb6; asc " " ;;
- 3: len 8; hex 800000002349045b; asc #I [;;
- 4: len 3; hex 800000; asc ;;
- 5: len 2; hex 000f; asc ;;
- 6: len 2; hex 8001; asc ;;
- 7: len 1; hex 06; asc ;;
- 8: len 1; hex 00; asc ;;
- 9: len 1; hex 01; asc ;;
- 10: SQL NULL;
- 11: len 8; hex 99ae3903c103fd15; asc 9 ;;
- 12: len 8; hex 99ae3903c4000000; asc 9 ;;
- 13: len 8; hex 99ae3903ec040597; asc 9 ;;
- 14: len 8; hex 99ae5371210e3a9c; asc Sq! : ;;
- 15: SQL NULL;
- 16: len 30; hex 36323938353639622d386233642d346238312d383964302d353833643261; asc 6298569b-8b3d-4b81-89d0-583d2a; (total 36 bytes);
- 17: len 24; hex 776f646e45443659475a41516351656863746a5834413d3d; asc wodnED6YGZAQcQehctjX4A==;;
- 18: SQL NULL;
- 19: SQL NULL;
- 20: SQL NULL;
- Record lock, heap no 88 PHYSICAL RECORD: n_fields 21; compact format; info bits 0
- 0: len 6; hex 000bdbf95c5e; asc \^;;
- 1: len 6; hex 0036091c957a; asc 6 z;;
- 2: len 7; hex 220000c0221c30; asc " " 0;;
- 3: len 8; hex 8000000023583081; asc #X0 ;;
- 4: len 3; hex 800000; asc ;;
- 5: len 2; hex 000f; asc ;;
- 6: len 2; hex 8001; asc ;;
- 7: len 1; hex 06; asc ;;
- 8: len 1; hex 00; asc ;;
- 9: len 1; hex 01; asc ;;
- 10: SQL NULL;
- 11: len 8; hex 99ae390c81047cd5; asc 9 | ;;
- 12: len 8; hex 99ae390c84000000; asc 9 ;;
- 13: len 8; hex 99ae390ca6074a0d; asc 9 J ;;
- 14: len 8; hex 99ae5371210e4580; asc Sq! E ;;
- 15: SQL NULL;
- 16: len 30; hex 62363636373633312d323162392d343330372d613934302d373861373534; asc b6667631-21b9-4307-a940-78a754; (total 36 bytes);
- 17: len 24; hex 627232447668475666763650797332426a5a353439773d3d; asc br2DvhGVfv6Pys2BjZ549w==;;
- 18: SQL NULL;
- 19: SQL NULL;
- 20: SQL NULL;
- Record lock, heap no 89 PHYSICAL RECORD: n_fields 21; compact format; info bits 0
- 0: len 6; hex 000bdc09c887; asc ;;
- 1: len 6; hex 0036091c957a; asc 6 z;;
- 2: len 7; hex 220000c0221caa; asc " " ;;
- 3: len 8; hex 8000000023878b6f; asc # o;;
- 4: len 3; hex 800000; asc ;;
- 5: len 2; hex 000f; asc ;;
- 6: len 2; hex 8001; asc ;;
- 7: len 1; hex 06; asc ;;
- 8: len 1; hex 00; asc ;;
- 9: len 1; hex 01; asc ;;
- 10: SQL NULL;
- 11: len 8; hex 99ae392c810d9d8e; asc 9, ;;
- 12: len 8; hex 99ae392c84000000; asc 9, ;;
- 13: len 8; hex 99ae392ca702fdbf; asc 9, ;;
- 14: len 8; hex 99ae5371210e501d; asc Sq! P ;;
- 15: SQL NULL;
- 16: len 30; hex 31626530633065332d386130332d343837342d396631322d613731363335; asc 1be0c0e3-8a03-4874-9f12-a71635; (total 36 bytes);
- 17: len 24; hex 654a32516d664d794e6c4735385257685144654a2b413d3d; asc eJ2QmfMyNlG58RWhQDeJ+A==;;
- 18: SQL NULL;
- 19: SQL NULL;
- 20: SQL NULL;
- Record lock, heap no 90 PHYSICAL RECORD: n_fields 21; compact format; info bits 0
- 0: len 6; hex 000bdc882797; asc ' ;;
- 1: len 6; hex 0036091c957a; asc 6 z;;
- 2: len 7; hex 220000c0221d24; asc " " $;;
- 3: len 8; hex 8000000024e80125; asc $ %;;
- 4: len 3; hex 800000; asc ;;
- 5: len 2; hex 000f; asc ;;
- 6: len 2; hex 8001; asc ;;
- 7: len 1; hex 06; asc ;;
- 8: len 1; hex 00; asc ;;
- 9: len 1; hex 01; asc ;;
- 10: SQL NULL;
- 11: len 8; hex 99ae3c23c20018b3; asc <# ;;
- 12: len 8; hex 99ae3c23c4000000; asc <# ;;
- 13: len 8; hex 99ae3c84a50039d0; asc < 9 ;;
- 14: len 8; hex 99ae5371210e5a98; asc Sq! Z ;;
- 15: SQL NULL;
- 16: len 30; hex 66343566313366652d613764322d343534632d626666332d376635663138; asc f45f13fe-a7d2-454c-bff3-7f5f18; (total 36 bytes);
- 17: len 24; hex 41617948435341343864744d565346457531756342513d3d; asc AayHCSA48dtMVSFEu1ucBQ==;;
- 18: SQL NULL;
- 19: SQL NULL;
- 20: SQL NULL;
- Record lock, heap no 91 PHYSICAL RECORD: n_fields 21; compact format; info bits 0
- 0: len 6; hex 000bdc8829b9; asc ) ;;
- 1: len 6; hex 0036091c957a; asc 6 z;;
- 2: len 7; hex 220000c0221d9e; asc " " ;;
- 3: len 8; hex 8000000024e926d1; asc $ & ;;
- 4: len 3; hex 800000; asc ;;
- 5: len 2; hex 000f; asc ;;
- 6: len 2; hex 8001; asc ;;
- 7: len 1; hex 06; asc ;;
- 8: len 1; hex 00; asc ;;
- 9: len 1; hex 01; asc ;;
- 10: SQL NULL;
- 11: len 8; hex 99ae3c43c2047f9a; asc <C ;;
- 12: len 8; hex 99ae3c43c4000000; asc <C ;;
- 13: len 8; hex 99ae3c84ad03712b; asc < q+;;
- 14: len 8; hex 99ae5371210e68f1; asc Sq! h ;;
- 15: SQL NULL;
- 16: len 30; hex 30346531336337622d316539662d346135392d383334302d356338326332; asc 04e13c7b-1e9f-4a59-8340-5c82c2; (total 36 bytes);
- 17: len 24; hex 41617948435341343864744d565346457531756342513d3d; asc AayHCSA48dtMVSFEu1ucBQ==;;
- 18: SQL NULL;
- 19: SQL NULL;
- 20: SQL NULL;
- Record lock, heap no 92 PHYSICAL RECORD: n_fields 21; compact format; info bits 0
- 0: len 6; hex 000bdc88448b; asc D ;;
- 1: len 6; hex 0036091c957a; asc 6 z;;
- 2: len 7; hex 220000c0221e18; asc " " ;;
- 3: len 8; hex 800000002503cb69; asc % i;;
- 4: len 3; hex 800000; asc ;;
- 5: len 2; hex 000f; asc ;;
- 6: len 2; hex 8001; asc ;;
- 7: len 1; hex 06; asc ;;
- 8: len 1; hex 00; asc ;;
- 9: len 1; hex 01; asc ;;
- 10: SQL NULL;
- 11: len 8; hex 99ae3c850108d6be; asc < ;;
- 12: len 8; hex 99ae3c8504000000; asc < ;;
- 13: len 8; hex 99ae3c854406cf36; asc < D 6;;
- 14: len 8; hex 99ae5371210e83ad; asc Sq! ;;
- 15: SQL NULL;
- 16: len 30; hex 32393336346361322d353064392d346165302d623662372d313562383733; asc 29364ca2-50d9-4ae0-b6b7-15b873; (total 36 bytes);
- 17: len 24; hex 5633456a5a735579655931556c46324f495337655a673d3d; asc V3EjZsUyeY1UlF2OIS7eZg==;;
- 18: SQL NULL;
- 19: SQL NULL;
- 20: SQL NULL;
- Record lock, heap no 93 PHYSICAL RECORD: n_fields 21; compact format; info bits 0
- 0: len 6; hex 000bdc9b0aea; asc ;;
- 1: len 6; hex 0036091c957a; asc 6 z;;
- 2: len 7; hex 220000c0221e92; asc " " ;;
- 3: len 8; hex 8000000025442699; asc %D& ;;
- 4: len 3; hex 800000; asc ;;
- 5: len 2; hex 000f; asc ;;
- 6: len 2; hex 8001; asc ;;
- 7: len 1; hex 06; asc ;;
- 8: len 1; hex 00; asc ;;
- 9: len 1; hex 01; asc ;;
- 10: SQL NULL;
- 11: len 8; hex 99ae3cc3c1044901; asc < I ;;
- 12: len 8; hex 99ae3cc3c3000000; asc < ;;
- 13: len 8; hex 99ae3cc3f2079c1c; asc < ;;
- 14: len 8; hex 99ae5371210e8f4d; asc Sq! M;;
- 15: SQL NULL;
- 16: len 30; hex 34373439656137362d663863622d346138612d623135332d633237396630; asc 4749ea76-f8cb-4a8a-b153-c279f0; (total 36 bytes);
- 17: len 24; hex 486139754362434446765a36486b5352736e5a4e58513d3d; asc Ha9uCbCDFvZ6HkSRsnZNXQ==;;
- 18: SQL NULL;
- 19: SQL NULL;
- 20: SQL NULL;
- Record lock, heap no 94 PHYSICAL RECORD: n_fields 21; compact format; info bits 0
- 0: len 6; hex 000bdc9dd175; asc u;;
- 1: len 6; hex 0036091c957a; asc 6 z;;
- 2: len 7; hex 220000c0221f0c; asc " " ;;
- 3: len 8; hex 80000000254dde37; asc %M 7;;
- 4: len 3; hex 800000; asc ;;
- 5: len 2; hex 000f; asc ;;
- 6: len 2; hex 8001; asc ;;
- 7: len 1; hex 06; asc ;;
- 8: len 1; hex 00; asc ;;
- 9: len 1; hex 01; asc ;;
- 10: SQL NULL;
- 11: len 8; hex 99ae3cca0102a7c7; asc < ;;
- 12: len 8; hex 99ae3cca02000000; asc < ;;
- 13: len 8; hex 99ae3cca3000f6ee; asc < 0 ;;
- 14: len 8; hex 99ae5371210e97fa; asc Sq! ;;
- 15: SQL NULL;
- 16: len 30; hex 62636265383236652d306631382d343335622d623936312d396130346462; asc bcbe826e-0f18-435b-b961-9a04db; (total 36 bytes);
- 17: len 24; hex 796d38444e55432f4d435558505171434a77316269513d3d; asc ym8DNUC/MCUXPQqCJw1biQ==;;
- 18: SQL NULL;
- 19: SQL NULL;
- 20: SQL NULL;
- Record lock, heap no 95 PHYSICAL RECORD: n_fields 21; compact format; info bits 0
- 0: len 6; hex 000bdc9fdfcd; asc ;;
- 1: len 6; hex 0036091c957a; asc 6 z;;
- 2: len 7; hex 220000c0221f86; asc " " ;;
- 3: len 8; hex 800000002554793f; asc %Ty?;;
- 4: len 3; hex 800000; asc ;;
- 5: len 2; hex 000f; asc ;;
- 6: len 2; hex 8001; asc ;;
- 7: len 1; hex 06; asc ;;
- 8: len 1; hex 00; asc ;;
- 9: len 1; hex 01; asc ;;
- 10: SQL NULL;
- 11: len 8; hex 99ae3cd002019ca1; asc < ;;
- 12: len 8; hex 99ae3cd063000000; asc < c ;;
- 13: len 8; hex 99ae3cd08409752d; asc < u-;;
- 14: len 8; hex 99ae5371210ea019; asc Sq! ;;
- 15: SQL NULL;
- 16: len 30; hex 62623762356136322d346434362d343663352d396432632d666361366539; asc bb7b5a62-4d46-46c5-9d2c-fca6e9; (total 36 bytes);
- 17: len 24; hex 675053724b7776587a6e44544648446e5431633774673d3d; asc gPSrKwvXznDTFHDnT1c7tg==;;
- 18: SQL NULL;
- 19: SQL NULL;
- 20: SQL NULL;
- Record lock, heap no 96 PHYSICAL RECORD: n_fields 21; compact format; info bits 0
- 0: len 6; hex 000bdca0d69b; asc ;;
- 1: len 6; hex 0036091c957a; asc 6 z;;
- 2: len 7; hex 220000c0222000; asc " " ;;
- 3: len 8; hex 800000002558415f; asc %XA_;;
- 4: len 3; hex 800000; asc ;;
- 5: len 2; hex 000f; asc ;;
- 6: len 2; hex 8001; asc ;;
- 7: len 1; hex 06; asc ;;
- 8: len 1; hex 00; asc ;;
- 9: len 1; hex 01; asc ;;
- 10: SQL NULL;
- 11: len 8; hex 99ae3cd2810bbbbe; asc < ;;
- 12: len 8; hex 99ae3cd283000000; asc < ;;
- 13: len 8; hex 99ae3cd2b4050c3a; asc < :;;
- 14: len 8; hex 99ae5371210ead66; asc Sq! f;;
- 15: SQL NULL;
- 16: len 30; hex 34663434363664612d313264382d343939662d626135662d613035613030; asc 4f4466da-12d8-499f-ba5f-a05a00; (total 36 bytes);
- 17: len 24; hex 46744c3359456b765468303554513362324d713935773d3d; asc FtL3YEkvTh05TQ3b2Mq95w==;;
- 18: SQL NULL;
- 19: SQL NULL;
- 20: SQL NULL;
- Record lock, heap no 97 PHYSICAL RECORD: n_fields 21; compact format; info bits 0
- 0: len 6; hex 000bdca2aff1; asc ;;
- 1: len 6; hex 0036091c957a; asc 6 z;;
- 2: len 7; hex 220000c022207a; asc " " z;;
- 3: len 8; hex 80000000255e7cff; asc %^| ;;
- 4: len 3; hex 800000; asc ;;
- 5: len 2; hex 000f; asc ;;
- 6: len 2; hex 8001; asc ;;
- 7: len 1; hex 06; asc ;;
- 8: len 1; hex 00; asc ;;
- 9: len 1; hex 01; asc ;;
- 10: SQL NULL;
- 11: len 8; hex 99ae3cd7810d37f9; asc < 7 ;;
- 12: len 8; hex 99ae3cd783000000; asc < ;;
- 13: len 8; hex 99ae3cd7b80b8aaf; asc < ;;
- 14: len 8; hex 99ae5371210ec262; asc Sq! b;;
- 15: SQL NULL;
- 16: len 30; hex 37373534623338332d363336622d343338662d396438332d353462323330; asc 7754b383-636b-438f-9d83-54b230; (total 36 bytes);
- 17: len 24; hex 306d6b4a474662377a4c327871686f645673475271413d3d; asc 0mkJGFb7zL2xqhodVsGRqA==;;
- 18: SQL NULL;
- 19: SQL NULL;
- 20: SQL NULL;
- *** (2) WAITING FOR THIS LOCK TO BE GRANTED:
- RECORD LOCKS space id 7303064 page no 4750 n bits 488 index dlr_status of table `esms_mis`.`dlr_outbox` /* Partition `O15` */ trx id 232134722350 lock_mode X locks gap before rec insert intention waiting
- Record lock, heap no 2 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
- 0: len 1; hex 06; asc ;;
- 1: len 6; hex 000bdb369f88; asc 6 ;;
- *** WE ROLL BACK TRANSACTION (1)
- ------------
- TRANSACTIONS
- ------------
- Trx id counter 234841932665
- Purge done for trx's n:o < 234841930521 undo n:o < 1 state: running but idle
- History list length 821
- LIST OF TRANSACTIONS FOR EACH SESSION:
- ---TRANSACTION 421983835176672, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835256016, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835170288, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835130160, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835480368, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835483104, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835482192, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835478544, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835473984, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835473072, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835222272, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835117392, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835452096, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835368192, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835277904, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835203120, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835471248, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835122864, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835305264, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835211328, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835476720, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835472160, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835467600, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835281552, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835275168, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835224096, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835220448, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835470336, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835188528, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835218624, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835466688, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835464864, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835456656, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835455744, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835453920, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835453008, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835449360, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835448448, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835446624, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835445712, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835444800, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835443888, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835441152, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835440240, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835438416, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835432944, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835431120, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835430208, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835429296, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835428384, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835423824, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835421088, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835419264, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835418352, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835416528, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835413792, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835411056, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835410144, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835409232, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835407408, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835405584, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835400112, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835398288, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835396464, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835395552, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835394640, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835391904, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835390992, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835389168, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835387344, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835386432, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835382784, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835380960, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835379136, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835377312, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835373664, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835369104, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835367280, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835363632, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835360896, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835359072, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835357248, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835355424, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835354512, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835353600, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835352688, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835344480, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835342656, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835337184, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835341744, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835335360, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835329888, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835325328, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835322592, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835318944, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835311648, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835300704, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835299792, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835292496, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835288848, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835287936, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835197648, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835194912, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835270608, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835269696, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835266960, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835245072, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835228656, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835186704, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835153872, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835185792, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835265136, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835264224, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835213152, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835119216, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835263312, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835262400, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835260576, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835255104, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835254192, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835253280, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835251456, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835235040, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835221360, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835190352, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835181232, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835173024, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835133808, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835249632, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835248720, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835246896, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835239600, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835207680, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835204032, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835195824, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835171200, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835126512, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835120128, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835127424, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835173936, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835166640, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835371840, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835350864, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835328064, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835318032, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835280640, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835267872, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835250544, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835245984, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835244160, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835243248, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835237776, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835236864, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835230480, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835212240, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835199472, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835193088, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835189440, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835167552, not started inserting
- mysql tables in use 1, locked 1
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835164816, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835140192, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835156608, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835152048, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835142016, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835439328, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835422000, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835417440, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835411968, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835408320, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835397376, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835383696, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835378224, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835370016, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835366368, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835359984, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835347216, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835340832, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835339920, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835205856, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835202208, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835323504, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835308912, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835307088, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835286112, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835283376, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835210416, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835142928, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835136544, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835131984, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835137456, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835348128, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835346304, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835343568, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835319856, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835291584, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835152960, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835132896, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835297056, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835339008, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835144752, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835118304, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835332624, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835301616, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835162080, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835154784, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835241424, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835208592, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835180320, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835177584, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835214976, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835191264, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835141104, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835124688, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835123776, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835155696, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835147488, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835139280, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835121952, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835523232, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835525968, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835488576, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835402848, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835372752, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835234128, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835174848, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835159344, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835135632, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835125600, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835365456, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835531440, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835530528, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835529616, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835524144, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835401936, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835374576, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835183056, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835289760, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835134720, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835527792, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835525056, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835401024, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835399200, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835157520, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835276992, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835162992, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835143840, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835274256, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835515024, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835511376, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835507728, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835505904, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835504992, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835503168, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835500432, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835496784, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835495872, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835493136, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835491312, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835490400, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835489488, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835486752, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835485840, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835474896, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835469424, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835468512, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835465776, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835463952, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835463040, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835462128, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835460304, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835459392, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835458480, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835457568, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835450272, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835447536, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835435680, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835434768, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835433856, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835427472, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835426560, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835424736, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835420176, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835406496, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835404672, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835393728, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835392816, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835388256, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835380048, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835370928, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835349952, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835149312, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835362720, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835351776, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835345392, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835336272, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835278816, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835333536, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835331712, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835330800, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835327152, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835326240, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835183968, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835317120, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835223184, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835178496, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835313472, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835312560, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835285200, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835169376, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835158432, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835294320, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835216800, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835194000, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835204944, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835184880, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835308000, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835302528, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835296144, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835293408, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835290672, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835238688, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835233216, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835146576, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835272432, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835163904, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835271520, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835232304, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835231392, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835229568, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835227744, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835219536, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835165728, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835266048, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835148400, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835235952, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835226832, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835217712, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835161168, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835215888, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835172112, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835200384, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835196736, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835138368, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835338096, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835298880, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835320768, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835315296, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835145664, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835168464, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835282464, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835121040, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835534176, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835506816, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835477632, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835240512, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835425648, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835151136, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835364544, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835316208, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835324416, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835284288, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835242336, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835309824, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835414704, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835481280, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835475808, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835451184, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835442064, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835412880, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835390080, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835334448, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835304352, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835279728, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835273344, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835257840, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835225920, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835129248, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835150224, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835187616, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835622640, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835198560, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835566096, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835517760, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835504080, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835501344, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835461216, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835437504, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835422912, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835361808, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835356336, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835306176, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835256928, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835247808, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835225008, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835201296, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835252368, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835297968, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835385520, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835206768, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835209504, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835160256, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835128336, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 421983835310736, not started
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- ---TRANSACTION 234841932664, ACTIVE 0 sec inserting
- mysql tables in use 1, locked 1
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- MySQL thread id 8538631, OS thread handle 140393730529024, query id 125672897385 192.168.61.152 websms update
- INSERT INTO `outbox` (`user_id`,`priority`,`destination_number`,`originator_name`,`originator_number`,`sms_text`,`ip_address`,`received_date_time`,`sms_type`,`datetime_to_send`,`msg_subject`,`isd_flag`,`gateway_id`,`source_id`,`client_msg_id`,`template_id`,`pe_id`,`message_id`,`msg_part_number`,`msg_total_parts`,key_id)
- VALUES ( NAME_CONST('userid',5), NAME_CONST('priority',2), NAME_CONST('destinationnumber',_utf8mb4'/lqbSyBY0T5GZRL+O3RfQg==' COLLATE 'utf8mb4_general_ci'), NAME_CONST('originatorname',_utf8mb4'SBIINB' COLLATE 'utf8mb4_general_ci'), NAME_CONST('originatornumber',_utf8mb4'0000'
- ---TRANSACTION 234841932663, ACTIVE 0 sec inserting
- mysql tables in use 1, locked 1
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- MySQL thread id 8534790, OS thread handle 140417985230592, query id 125672897269 192.168.61.242 websms update
- INSERT INTO `outbox` (`user_id`,`priority`,`destination_number`,`originator_name`,`originator_number`,`sms_text`,`ip_address`,`received_date_time`,`sms_type`,`datetime_to_send`,`msg_subject`,`isd_flag`,`gateway_id`,`source_id`,`client_msg_id`,`template_id`,`pe_id`,`message_id`,`msg_part_number`,`msg_total_parts`,key_id)
- VALUES ( NAME_CONST('userid',5), NAME_CONST('priority',2), NAME_CONST('destinationnumber',_utf8mb4'91OLcOPwPwVRaJlJjXd4Mw==' COLLATE 'utf8mb4_general_ci'), NAME_CONST('originatorname',_utf8mb4'SBIINB' COLLATE 'utf8mb4_general_ci'), NAME_CONST('originatornumber',_utf8mb4'0000'
- ---TRANSACTION 234841932662, ACTIVE 0 sec inserting
- mysql tables in use 1, locked 1
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- MySQL thread id 8538698, OS thread handle 140416975877888, query id 125672896556 192.168.61.152 websms update
- INSERT INTO `outbox` (`user_id`,`priority`,`destination_number`,`originator_name`,`originator_number`,`sms_text`,`ip_address`,`received_date_time`,`sms_type`,`datetime_to_send`,`msg_subject`,`isd_flag`,`gateway_id`,`source_id`,`client_msg_id`,`template_id`,`pe_id`,`message_id`,`msg_part_number`,`msg_total_parts`,key_id)
- VALUES ( NAME_CONST('userid',5), NAME_CONST('priority',2), NAME_CONST('destinationnumber',_utf8mb4'4fbX29R3pnqCb0giSFlI6A==' COLLATE 'utf8mb4_general_ci'), NAME_CONST('originatorname',_utf8mb4'SBIINB' COLLATE 'utf8mb4_general_ci'), NAME_CONST('originatornumber',_utf8mb4'0000'
- ---TRANSACTION 234841932661, ACTIVE 0 sec inserting
- mysql tables in use 1, locked 1
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- MySQL thread id 8534795, OS thread handle 140397878032128, query id 125672896547 192.168.61.242 websms update
- INSERT INTO `outbox` (`user_id`,`priority`,`destination_number`,`originator_name`,`originator_number`,`sms_text`,`ip_address`,`received_date_time`,`sms_type`,`datetime_to_send`,`msg_subject`,`isd_flag`,`gateway_id`,`source_id`,`client_msg_id`,`template_id`,`pe_id`,`message_id`,`msg_part_number`,`msg_total_parts`,key_id)
- VALUES ( NAME_CONST('userid',5), NAME_CONST('priority',2), NAME_CONST('destinationnumber',_utf8mb4'im8ogz7PNritNd74TWPNIg==' COLLATE 'utf8mb4_general_ci'), NAME_CONST('originatorname',_utf8mb4'SBIKBP' COLLATE 'utf8mb4_general_ci'), NAME_CONST('originatornumber',_utf8mb4'0000'
- ---TRANSACTION 234841932660, ACTIVE 0 sec inserting
- mysql tables in use 1, locked 1
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- MySQL thread id 8538680, OS thread handle 140397885060864, query id 125672896457 192.168.61.242 websms update
- INSERT INTO `outbox` (`user_id`,`priority`,`destination_number`,`originator_name`,`originator_number`,`sms_text`,`ip_address`,`received_date_time`,`sms_type`,`datetime_to_send`,`msg_subject`,`isd_flag`,`gateway_id`,`source_id`,`client_msg_id`,`template_id`,`pe_id`,`message_id`,`msg_part_number`,`msg_total_parts`,key_id)
- VALUES ( NAME_CONST('userid',5), NAME_CONST('priority',2), NAME_CONST('destinationnumber',_utf8mb4'PqueOuvOQvUbSbcDYcmVfA==' COLLATE 'utf8mb4_general_ci'), NAME_CONST('originatorname',_utf8mb4'SBIKBP' COLLATE 'utf8mb4_general_ci'), NAME_CONST('originatornumber',_utf8mb4'0000'
- ---TRANSACTION 234841932659, ACTIVE 0 sec inserting
- mysql tables in use 1, locked 1
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- MySQL thread id 8537136, OS thread handle 140397908850432, query id 125672896453 192.168.61.242 websms update
- INSERT INTO `outbox` (`user_id`,`priority`,`destination_number`,`originator_name`,`originator_number`,`sms_text`,`ip_address`,`received_date_time`,`sms_type`,`datetime_to_send`,`msg_subject`,`isd_flag`,`gateway_id`,`source_id`,`client_msg_id`,`template_id`,`pe_id`,`message_id`,`msg_part_number`,`msg_total_parts`,key_id)
- VALUES ( NAME_CONST('userid',5), NAME_CONST('priority',2), NAME_CONST('destinationnumber',_utf8mb4'Gd/tLgg3C7wtgHd5vpNemw==' COLLATE 'utf8mb4_general_ci'), NAME_CONST('originatorname',_utf8mb4'SBIINB' COLLATE 'utf8mb4_general_ci'), NAME_CONST('originatornumber',_utf8mb4'0000'
- ---TRANSACTION 234841932658, ACTIVE 0 sec inserting
- mysql tables in use 1, locked 1
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- MySQL thread id 8538694, OS thread handle 140503897073408, query id 125672896353 192.168.61.152 websms update
- INSERT INTO `outbox` (`user_id`,`priority`,`destination_number`,`originator_name`,`originator_number`,`sms_text`,`ip_address`,`received_date_time`,`sms_type`,`datetime_to_send`,`msg_subject`,`isd_flag`,`gateway_id`,`source_id`,`client_msg_id`,`template_id`,`pe_id`,`message_id`,`msg_part_number`,`msg_total_parts`,key_id)
- VALUES ( NAME_CONST('userid',5), NAME_CONST('priority',2), NAME_CONST('destinationnumber',_utf8mb4'LH59hmjm62lG/PF58dPFow==' COLLATE 'utf8mb4_general_ci'), NAME_CONST('originatorname',_utf8mb4'SBIINB' COLLATE 'utf8mb4_general_ci'), NAME_CONST('originatornumber',_utf8mb4'0000'
- ---TRANSACTION 234841932657, ACTIVE 0 sec inserting
- mysql tables in use 1, locked 1
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- MySQL thread id 8538674, OS thread handle 140416945059584, query id 125672896348 192.168.61.152 websms update
- INSERT INTO `outbox` (`user_id`,`priority`,`destination_number`,`originator_name`,`originator_number`,`sms_text`,`ip_address`,`received_date_time`,`sms_type`,`datetime_to_send`,`msg_subject`,`isd_flag`,`gateway_id`,`source_id`,`client_msg_id`,`template_id`,`pe_id`,`message_id`,`msg_part_number`,`msg_total_parts`,key_id)
- VALUES ( NAME_CONST('userid',5), NAME_CONST('priority',2), NAME_CONST('destinationnumber',_utf8mb4'EpTY7zxQ5y+YpsZrA+b8Jw==' COLLATE 'utf8mb4_general_ci'), NAME_CONST('originatorname',_utf8mb4'SBIKBP' COLLATE 'utf8mb4_general_ci'), NAME_CONST('originatornumber',_utf8mb4'0000'
- ---TRANSACTION 234841932656, ACTIVE 0 sec starting index read
- mysql tables in use 1, locked 1
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- MySQL thread id 8461774, OS thread handle 140397868029696, query id 125672896299 192.168.62.27 dsuser updating
- UPDATE `outbox` SET `outbox_status`=2 , `thread_id` = NAME_CONST('_thread_id',1839) WHERE `gateway_id`= NAME_CONST('_gateway_id',15) and `outbox_status`=1 LIMIT 750
- ---TRANSACTION 234841932655, ACTIVE 0 sec starting index read
- mysql tables in use 1, locked 1
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- MySQL thread id 8539977, OS thread handle 140416933435136, query id 125672896229 192.168.62.27 qdupdater updating
- UPDATE `2022-11-16` SET `msg_status` = GREATEST(0, `msg_status`), `dlr_received_parts` = `dlr_received_parts` + 1 WHERE `message_id` = "5c62f106-5867-42e0-bf5b-22db3f227a1e"
- Trx read view will not see trx with id >= 234841932652, sees < 234841932647
- ---TRANSACTION 234841932654, ACTIVE 0 sec inserting
- mysql tables in use 1, locked 1
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- MySQL thread id 8517263, OS thread handle 140397898307328, query id 125672896241 192.168.62.27 dsuser update
- insert into esms_mis.`2022-11-16` (
- sms_id,
- user_id,
- priority,
- sms_status,
- destination_number,
- originator_name,
- originator_number,ip_address,received_date_time,submit_date_time,
- sms_type,datetime_to_send,msg_subject,isd_flag,
- gateway_id,source_id,template_id,pe_id,
- message_id,msg_part_number,msg_total_parts,sms_submit_id, key_id,sequence_number,submit_retry_count,submitted_time)
- VALUES('1341549097','5','2','3333','BlESqokkiKTUCt1iwDzIpQ==','SBIINB','0000','103.209.96.154,2','2022-11-16 12:41:40.539226','2022-11-16 12:41:40.598374','2','2022-11-16 12:41:41.000000','54
- ---TRANSACTION 234841932653, ACTIVE 0 sec starting index read
- mysql tables in use 1, locked 1
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- MySQL thread id 8539724, OS thread handle 140397245060864, query id 125672896191 192.168.62.27 qdupdater updating
- UPDATE `2022-11-16` SET `msg_status` = GREATEST(0, `msg_status`), `dlr_received_parts` = `dlr_received_parts` + 1 WHERE `message_id` = "0a267685-2e4e-476b-8d66-635cf2ec8fac"
- Trx read view will not see trx with id >= 234841932649, sees < 234841932647
- ---TRANSACTION 234841932652, ACTIVE 0 sec inserting
- mysql tables in use 1, locked 1
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- MySQL thread id 8538638, OS thread handle 140417586054912, query id 125672896208 192.168.61.152 websms update
- INSERT INTO `outbox` (`user_id`,`priority`,`destination_number`,`originator_name`,`originator_number`,`sms_text`,`ip_address`,`received_date_time`,`sms_type`,`datetime_to_send`,`msg_subject`,`isd_flag`,`gateway_id`,`source_id`,`client_msg_id`,`template_id`,`pe_id`,`message_id`,`msg_part_number`,`msg_total_parts`,key_id)
- VALUES ( NAME_CONST('userid',5), NAME_CONST('priority',2), NAME_CONST('destinationnumber',_utf8mb4'nky3EUOdYgWBXwX6fb28eQ==' COLLATE 'utf8mb4_general_ci'), NAME_CONST('originatorname',_utf8mb4'SBIKBP' COLLATE 'utf8mb4_general_ci'), NAME_CONST('originatornumber',_utf8mb4'0000'
- ---TRANSACTION 234841932651, ACTIVE 0 sec starting index read
- mysql tables in use 1, locked 1
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- MySQL thread id 8526056, OS thread handle 140397852890880, query id 125672896193 192.168.61.152 pdduser Searching rows for update
- UPDATE dlr_outbox SET dlr_status=2, thread_id= NAME_CONST('_thread_id',9) WHERE dlr_status =1 and gateway_id= NAME_CONST('_gateway_id',13) LIMIT 1000
- ---TRANSACTION 234841932650, ACTIVE 0 sec inserting
- mysql tables in use 1, locked 1
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- MySQL thread id 8538636, OS thread handle 140397911824128, query id 125672896183 192.168.61.152 websms update
- INSERT INTO `outbox` (`user_id`,`priority`,`destination_number`,`originator_name`,`originator_number`,`sms_text`,`ip_address`,`received_date_time`,`sms_type`,`datetime_to_send`,`msg_subject`,`isd_flag`,`gateway_id`,`source_id`,`client_msg_id`,`template_id`,`pe_id`,`message_id`,`msg_part_number`,`msg_total_parts`,key_id)
- VALUES ( NAME_CONST('userid',5), NAME_CONST('priority',2), NAME_CONST('destinationnumber',_utf8mb4'+sn0CewoG1yEt8yfX2Y2QQ==' COLLATE 'utf8mb4_general_ci'), NAME_CONST('originatorname',_utf8mb4'SBIINB' COLLATE 'utf8mb4_general_ci'), NAME_CONST('originatornumber',_utf8mb4'0000'
- ---TRANSACTION 234841932649, ACTIVE 0 sec starting index read
- mysql tables in use 1, locked 1
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- MySQL thread id 8522850, OS thread handle 140393722418944, query id 125672896133 192.168.61.152 pdduser Searching rows for update
- UPDATE dlr_outbox SET dlr_status=2, thread_id= NAME_CONST('_thread_id',5) WHERE dlr_status =1 and gateway_id= NAME_CONST('_gateway_id',10) LIMIT 1000
- ---TRANSACTION 234841932648, ACTIVE 0 sec starting index read
- mysql tables in use 1, locked 1
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- MySQL thread id 8526134, OS thread handle 140393752426240, query id 125672896043 192.168.61.152 pdduser updating
- UPDATE dlr_outbox SET dlr_status=2, thread_id= NAME_CONST('_thread_id',1) WHERE dlr_status =1 and gateway_id= NAME_CONST('_gateway_id',37) LIMIT 1000
- ---TRANSACTION 234841932647, ACTIVE 0 sec starting index read
- mysql tables in use 1, locked 1
- 0 lock struct(s), heap size 1136, 0 row lock(s)
- MySQL thread id 8474027, OS thread handle 140416939923200, query id 125672896026 192.168.61.152 pdduser updating
- UPDATE dlr_outbox SET dlr_status=2, thread_id= NAME_CONST('_thread_id',2) WHERE dlr_status =1 and gateway_id= NAME_CONST('_gateway_id',49) LIMIT 1000
- --------
- FILE I/O
- --------
- I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
- I/O thread 1 state: waiting for completed aio requests (log thread)
- I/O thread 2 state: waiting for completed aio requests (read thread)
- I/O thread 3 state: waiting for completed aio requests (read thread)
- I/O thread 4 state: waiting for completed aio requests (read thread)
- I/O thread 5 state: waiting for completed aio requests (read thread)
- I/O thread 6 state: waiting for completed aio requests (read thread)
- I/O thread 7 state: waiting for completed aio requests (read thread)
- I/O thread 8 state: waiting for completed aio requests (read thread)
- I/O thread 9 state: waiting for completed aio requests (read thread)
- I/O thread 10 state: waiting for completed aio requests (read thread)
- I/O thread 11 state: waiting for completed aio requests (read thread)
- I/O thread 12 state: waiting for completed aio requests (read thread)
- I/O thread 13 state: waiting for completed aio requests (read thread)
- I/O thread 14 state: waiting for completed aio requests (read thread)
- I/O thread 15 state: waiting for completed aio requests (read thread)
- I/O thread 16 state: waiting for completed aio requests (read thread)
- I/O thread 17 state: waiting for completed aio requests (read thread)
- I/O thread 18 state: waiting for completed aio requests (read thread)
- I/O thread 19 state: waiting for completed aio requests (read thread)
- I/O thread 20 state: waiting for completed aio requests (read thread)
- I/O thread 21 state: waiting for completed aio requests (read thread)
- I/O thread 22 state: waiting for completed aio requests (read thread)
- I/O thread 23 state: waiting for completed aio requests (read thread)
- I/O thread 24 state: waiting for completed aio requests (read thread)
- I/O thread 25 state: waiting for completed aio requests (read thread)
- I/O thread 26 state: waiting for completed aio requests (read thread)
- I/O thread 27 state: waiting for completed aio requests (read thread)
- I/O thread 28 state: waiting for completed aio requests (read thread)
- I/O thread 29 state: waiting for completed aio requests (read thread)
- I/O thread 30 state: waiting for completed aio requests (read thread)
- I/O thread 31 state: waiting for completed aio requests (read thread)
- I/O thread 32 state: waiting for completed aio requests (read thread)
- I/O thread 33 state: waiting for completed aio requests (read thread)
- I/O thread 34 state: waiting for completed aio requests (read thread)
- I/O thread 35 state: waiting for completed aio requests (read thread)
- I/O thread 36 state: waiting for completed aio requests (read thread)
- I/O thread 37 state: waiting for completed aio requests (read thread)
- I/O thread 38 state: waiting for completed aio requests (read thread)
- I/O thread 39 state: waiting for completed aio requests (read thread)
- I/O thread 40 state: waiting for completed aio requests (read thread)
- I/O thread 41 state: waiting for completed aio requests (read thread)
- I/O thread 42 state: waiting for completed aio requests (read thread)
- I/O thread 43 state: waiting for completed aio requests (read thread)
- I/O thread 44 state: waiting for completed aio requests (read thread)
- I/O thread 45 state: waiting for completed aio requests (read thread)
- I/O thread 46 state: waiting for completed aio requests (read thread)
- I/O thread 47 state: waiting for completed aio requests (read thread)
- I/O thread 48 state: waiting for completed aio requests (read thread)
- I/O thread 49 state: waiting for completed aio requests (read thread)
- I/O thread 50 state: waiting for completed aio requests (read thread)
- I/O thread 51 state: waiting for completed aio requests (read thread)
- I/O thread 52 state: waiting for completed aio requests (read thread)
- I/O thread 53 state: waiting for completed aio requests (read thread)
- I/O thread 54 state: waiting for completed aio requests (read thread)
- I/O thread 55 state: waiting for completed aio requests (read thread)
- I/O thread 56 state: waiting for completed aio requests (read thread)
- I/O thread 57 state: waiting for completed aio requests (read thread)
- I/O thread 58 state: waiting for completed aio requests (read thread)
- I/O thread 59 state: waiting for completed aio requests (read thread)
- I/O thread 60 state: waiting for completed aio requests (read thread)
- I/O thread 61 state: waiting for completed aio requests (read thread)
- I/O thread 62 state: waiting for completed aio requests (read thread)
- I/O thread 63 state: waiting for completed aio requests (read thread)
- I/O thread 64 state: waiting for completed aio requests (read thread)
- I/O thread 65 state: waiting for completed aio requests (read thread)
- I/O thread 66 state: waiting for completed aio requests (write thread)
- I/O thread 67 state: waiting for completed aio requests (write thread)
- I/O thread 68 state: waiting for completed aio requests (write thread)
- I/O thread 69 state: waiting for completed aio requests (write thread)
- I/O thread 70 state: waiting for completed aio requests (write thread)
- I/O thread 71 state: waiting for completed aio requests (write thread)
- I/O thread 72 state: waiting for completed aio requests (write thread)
- I/O thread 73 state: waiting for completed aio requests (write thread)
- I/O thread 74 state: waiting for completed aio requests (write thread)
- I/O thread 75 state: waiting for completed aio requests (write thread)
- I/O thread 76 state: waiting for completed aio requests (write thread)
- I/O thread 77 state: waiting for completed aio requests (write thread)
- I/O thread 78 state: waiting for completed aio requests (write thread)
- I/O thread 79 state: waiting for completed aio requests (write thread)
- I/O thread 80 state: waiting for completed aio requests (write thread)
- I/O thread 81 state: waiting for completed aio requests (write thread)
- I/O thread 82 state: waiting for completed aio requests (write thread)
- I/O thread 83 state: waiting for completed aio requests (write thread)
- I/O thread 84 state: waiting for completed aio requests (write thread)
- I/O thread 85 state: waiting for completed aio requests (write thread)
- I/O thread 86 state: waiting for completed aio requests (write thread)
- I/O thread 87 state: waiting for completed aio requests (write thread)
- I/O thread 88 state: waiting for completed aio requests (write thread)
- I/O thread 89 state: waiting for completed aio requests (write thread)
- I/O thread 90 state: waiting for completed aio requests (write thread)
- I/O thread 91 state: waiting for completed aio requests (write thread)
- I/O thread 92 state: waiting for completed aio requests (write thread)
- I/O thread 93 state: waiting for completed aio requests (write thread)
- I/O thread 94 state: waiting for completed aio requests (write thread)
- I/O thread 95 state: waiting for completed aio requests (write thread)
- I/O thread 96 state: waiting for completed aio requests (write thread)
- I/O thread 97 state: waiting for completed aio requests (write thread)
- I/O thread 98 state: waiting for completed aio requests (write thread)
- I/O thread 99 state: waiting for completed aio requests (write thread)
- I/O thread 100 state: waiting for completed aio requests (write thread)
- I/O thread 101 state: waiting for completed aio requests (write thread)
- I/O thread 102 state: waiting for completed aio requests (write thread)
- I/O thread 103 state: waiting for completed aio requests (write thread)
- I/O thread 104 state: waiting for completed aio requests (write thread)
- I/O thread 105 state: waiting for completed aio requests (write thread)
- I/O thread 106 state: waiting for completed aio requests (write thread)
- I/O thread 107 state: waiting for completed aio requests (write thread)
- I/O thread 108 state: waiting for completed aio requests (write thread)
- I/O thread 109 state: waiting for completed aio requests (write thread)
- I/O thread 110 state: waiting for completed aio requests (write thread)
- I/O thread 111 state: waiting for completed aio requests (write thread)
- I/O thread 112 state: waiting for completed aio requests (write thread)
- I/O thread 113 state: waiting for completed aio requests (write thread)
- I/O thread 114 state: waiting for completed aio requests (write thread)
- I/O thread 115 state: waiting for completed aio requests (write thread)
- I/O thread 116 state: waiting for completed aio requests (write thread)
- I/O thread 117 state: waiting for completed aio requests (write thread)
- I/O thread 118 state: waiting for completed aio requests (write thread)
- I/O thread 119 state: waiting for completed aio requests (write thread)
- I/O thread 120 state: waiting for completed aio requests (write thread)
- I/O thread 121 state: waiting for completed aio requests (write thread)
- I/O thread 122 state: waiting for completed aio requests (write thread)
- I/O thread 123 state: waiting for completed aio requests (write thread)
- I/O thread 124 state: waiting for completed aio requests (write thread)
- I/O thread 125 state: waiting for completed aio requests (write thread)
- I/O thread 126 state: waiting for completed aio requests (write thread)
- I/O thread 127 state: waiting for completed aio requests (write thread)
- I/O thread 128 state: waiting for completed aio requests (write thread)
- I/O thread 129 state: waiting for completed aio requests (write thread)
- Pending normal aio reads: [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0] , aio writes: [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0] ,
- ibuf aio reads:, log i/o's:, sync i/o's:
- Pending flushes (fsync) log: 0; buffer pool: 0
- 37887338 OS file reads, 3400116261 OS file writes, 332024055 OS fsyncs
- 0.02 reads/s, 16384 avg bytes/read, 1019.00 writes/s, 101.88 fsyncs/s
- -------------------------------------
- INSERT BUFFER AND ADAPTIVE HASH INDEX
- -------------------------------------
- Ibuf: size 1, free list len 135717, seg size 135719, 844814 merges
- merged operations:
- insert 3737336, delete mark 84408322, delete 3098458
- discarded operations:
- insert 0, delete mark 0, delete 0
- Hash table size 21247271, node heap has 18853 buffer(s)
- Hash table size 21247271, node heap has 16673 buffer(s)
- Hash table size 21247271, node heap has 16638 buffer(s)
- Hash table size 21247271, node heap has 30950 buffer(s)
- Hash table size 21247271, node heap has 24457 buffer(s)
- Hash table size 21247271, node heap has 8506 buffer(s)
- Hash table size 21247271, node heap has 22119 buffer(s)
- Hash table size 21247271, node heap has 25273 buffer(s)
- 1610.50 hash searches/s, 130402.23 non-hash searches/s
- ---
- LOG
- ---
- Log sequence number 201790908243342
- Log flushed up to 201790907659498
- Pages flushed up to 201790374015892
- Last checkpoint at 201790367846766
- 0 pending log flushes, 0 pending chkp writes
- 2582006803 log i/o's done, 788.51 log i/o's/second
- ----------------------
- BUFFER POOL AND MEMORY
- ----------------------
- Total large memory allocated 79159099392
- Dictionary memory allocated 200563065
- Buffer pool size 4718016
- Free buffers 16378
- Database pages 4538169
- Old database pages 1674892
- Modified db pages 45187
- Pending reads 0
- Pending writes: LRU 0, flush list 0, single page 0
- Pages made young 31747976, not young 546527085
- 0.00 youngs/s, 0.00 non-youngs/s
- Pages read 37885481, created 46692674, written 742208498
- 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
- Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
- Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
- LRU len: 4538169, unzip_LRU len: 0
- I/O sum[157744]:cur[5328], unzip sum[0]:cur[0]
- ----------------------
- INDIVIDUAL BUFFER POOL INFO
- ----------------------
- ---BUFFER POOL 0
- Buffer pool size 294876
- Free buffers 1024
- Database pages 283676
- Old database pages 104696
- Modified db pages 3908
- Pending reads 0
- Pending writes: LRU 0, flush list 0, single page 0
- Pages made young 2021271, not young 33657635
- 0.00 youngs/s, 0.00 non-youngs/s
- Pages read 2369835, created 2922958, written 58689466
- 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
- Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
- Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
- LRU len: 283676, unzip_LRU len: 0
- I/O sum[9859]:cur[333], unzip sum[0]:cur[0]
- ---BUFFER POOL 1
- Buffer pool size 294876
- Free buffers 1024
- Database pages 283545
- Old database pages 104647
- Modified db pages 2715
- Pending reads 0
- Pending writes: LRU 0, flush list 0, single page 0
- Pages made young 1984712, not young 33644917
- 0.00 youngs/s, 0.00 non-youngs/s
- Pages read 2367326, created 2921691, written 44160310
- 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
- Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
- Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
- LRU len: 283545, unzip_LRU len: 0
- I/O sum[9859]:cur[333], unzip sum[0]:cur[0]
- ---BUFFER POOL 2
- Buffer pool size 294876
- Free buffers 1024
- Database pages 283744
- Old database pages 104721
- Modified db pages 2586
- Pending reads 0
- Pending writes: LRU 0, flush list 0, single page 0
- Pages made young 1920812, not young 33581567
- 0.00 youngs/s, 0.00 non-youngs/s
- Pages read 2328656, created 2916728, written 44490498
- 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
- Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
- Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
- LRU len: 283744, unzip_LRU len: 0
- I/O sum[9859]:cur[333], unzip sum[0]:cur[0]
- ---BUFFER POOL 3
- Buffer pool size 294876
- Free buffers 1022
- Database pages 283684
- Old database pages 104699
- Modified db pages 2398
- Pending reads 0
- Pending writes: LRU 0, flush list 0, single page 0
- Pages made young 1954793, not young 34249262
- 0.00 youngs/s, 0.00 non-youngs/s
- Pages read 2364712, created 2911804, written 46364318
- 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
- Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
- Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
- LRU len: 283684, unzip_LRU len: 0
- I/O sum[9859]:cur[333], unzip sum[0]:cur[0]
- ---BUFFER POOL 4
- Buffer pool size 294876
- Free buffers 1024
- Database pages 283620
- Old database pages 104675
- Modified db pages 3167
- Pending reads 0
- Pending writes: LRU 0, flush list 0, single page 0
- Pages made young 1999119, not young 34533916
- 0.00 youngs/s, 0.00 non-youngs/s
- Pages read 2377748, created 2922431, written 45730804
- 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
- Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
- Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
- LRU len: 283620, unzip_LRU len: 0
- I/O sum[9859]:cur[333], unzip sum[0]:cur[0]
- ---BUFFER POOL 5
- Buffer pool size 294876
- Free buffers 1023
- Database pages 283481
- Old database pages 104624
- Modified db pages 2836
- Pending reads 0
- Pending writes: LRU 0, flush list 0, single page 0
- Pages made young 1978080, not young 34039717
- 0.00 youngs/s, 0.00 non-youngs/s
- Pages read 2389971, created 2928840, written 43371960
- 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
- Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
- Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
- LRU len: 283481, unzip_LRU len: 0
- I/O sum[9859]:cur[333], unzip sum[0]:cur[0]
- ---BUFFER POOL 6
- Buffer pool size 294876
- Free buffers 1024
- Database pages 283512
- Old database pages 104635
- Modified db pages 2602
- Pending reads 0
- Pending writes: LRU 0, flush list 0, single page 0
- Pages made young 1974190, not young 33128412
- 0.00 youngs/s, 0.00 non-youngs/s
- Pages read 2345895, created 2913735, written 45055458
- 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
- Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
- Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
- LRU len: 283512, unzip_LRU len: 0
- I/O sum[9859]:cur[333], unzip sum[0]:cur[0]
- ---BUFFER POOL 7
- Buffer pool size 294876
- Free buffers 1025
- Database pages 283626
- Old database pages 104677
- Modified db pages 2142
- Pending reads 0
- Pending writes: LRU 0, flush list 0, single page 0
- Pages made young 1964595, not young 34066793
- 0.00 youngs/s, 0.00 non-youngs/s
- Pages read 2356264, created 2920780, written 45338425
- 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
- Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
- Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
- LRU len: 283626, unzip_LRU len: 0
- I/O sum[9859]:cur[333], unzip sum[0]:cur[0]
- ---BUFFER POOL 8
- Buffer pool size 294876
- Free buffers 1024
- Database pages 283552
- Old database pages 104650
- Modified db pages 2996
- Pending reads 0
- Pending writes: LRU 0, flush list 0, single page 0
- Pages made young 1998100, not young 34856851
- 0.00 youngs/s, 0.00 non-youngs/s
- Pages read 2388482, created 2929865, written 46203601
- 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
- Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
- Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
- LRU len: 283552, unzip_LRU len: 0
- I/O sum[9859]:cur[333], unzip sum[0]:cur[0]
- ---BUFFER POOL 9
- Buffer pool size 294876
- Free buffers 1024
- Database pages 283855
- Old database pages 104762
- Modified db pages 2869
- Pending reads 0
- Pending writes: LRU 0, flush list 0, single page 0
- Pages made young 1968827, not young 33106701
- 0.00 youngs/s, 0.00 non-youngs/s
- Pages read 2356464, created 2917618, written 46555772
- 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
- Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
- Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
- LRU len: 283855, unzip_LRU len: 0
- I/O sum[9859]:cur[333], unzip sum[0]:cur[0]
- ---BUFFER POOL 10
- Buffer pool size 294876
- Free buffers 1022
- Database pages 283607
- Old database pages 104670
- Modified db pages 2882
- Pending reads 0
- Pending writes: LRU 0, flush list 0, single page 0
- Pages made young 2003702, not young 35108461
- 0.00 youngs/s, 0.00 non-youngs/s
- Pages read 2383507, created 2910609, written 46090732
- 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
- Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
- Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
- LRU len: 283607, unzip_LRU len: 0
- I/O sum[9859]:cur[333], unzip sum[0]:cur[0]
- ---BUFFER POOL 11
- Buffer pool size 294876
- Free buffers 1024
- Database pages 283680
- Old database pages 104697
- Modified db pages 2586
- Pending reads 0
- Pending writes: LRU 0, flush list 0, single page 0
- Pages made young 2032816, not young 34989923
- 0.00 youngs/s, 0.00 non-youngs/s
- Pages read 2388105, created 2920610, written 45213613
- 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
- Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
- Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
- LRU len: 283680, unzip_LRU len: 0
- I/O sum[9859]:cur[333], unzip sum[0]:cur[0]
- ---BUFFER POOL 12
- Buffer pool size 294876
- Free buffers 1022
- Database pages 283536
- Old database pages 104644
- Modified db pages 3072
- Pending reads 0
- Pending writes: LRU 0, flush list 0, single page 0
- Pages made young 1987392, not young 35149338
- 0.00 youngs/s, 0.00 non-youngs/s
- Pages read 2356529, created 2920345, written 45390288
- 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
- Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
- Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
- LRU len: 283536, unzip_LRU len: 0
- I/O sum[9859]:cur[333], unzip sum[0]:cur[0]
- ---BUFFER POOL 13
- Buffer pool size 294876
- Free buffers 1023
- Database pages 283734
- Old database pages 104717
- Modified db pages 2813
- Pending reads 0
- Pending writes: LRU 0, flush list 0, single page 0
- Pages made young 1959680, not young 32712841
- 0.00 youngs/s, 0.00 non-youngs/s
- Pages read 2354147, created 2907912, written 47260652
- 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
- Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
- Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
- LRU len: 283734, unzip_LRU len: 0
- I/O sum[9859]:cur[333], unzip sum[0]:cur[0]
- ---BUFFER POOL 14
- Buffer pool size 294876
- Free buffers 1025
- Database pages 283588
- Old database pages 104663
- Modified db pages 2880
- Pending reads 0
- Pending writes: LRU 0, flush list 0, single page 0
- Pages made young 2007281, not young 35521110
- 0.00 youngs/s, 0.00 non-youngs/s
- Pages read 2399996, created 2915838, written 46827580
- 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
- Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
- Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
- LRU len: 283588, unzip_LRU len: 0
- I/O sum[9859]:cur[333], unzip sum[0]:cur[0]
- ---BUFFER POOL 15
- Buffer pool size 294876
- Free buffers 1024
- Database pages 283729
- Old database pages 104715
- Modified db pages 2735
- Pending reads 0
- Pending writes: LRU 0, flush list 0, single page 0
- Pages made young 1992606, not young 34179641
- 0.00 youngs/s, 0.00 non-youngs/s
- Pages read 2357844, created 2910910, written 45465021
- 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
- Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
- Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
- LRU len: 283729, unzip_LRU len: 0
- I/O sum[9859]:cur[333], unzip sum[0]:cur[0]
- --------------
- ROW OPERATIONS
- --------------
- 0 queries inside InnoDB, 0 queries in queue
- 2 read views open inside InnoDB
- Process ID=27089, Main thread ID=140418260342528, state: sleeping
- Number of rows inserted 1874451760, updated 3327545456, deleted 1137060964, read 572055339230
- 626.22 inserts/s, 1010.86 updates/s, 281.19 deletes/s, 2738.34 reads/s
- ----------------------------
- END OF INNODB MONITOR OUTPUT
- ============================
Advertisement
Add Comment
Please, Sign In to add comment