Created
September 6, 2016 11:55
-
-
Save rubiread/b3c456f6292d43e81ea07a6de9775257 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| | InnoDB | | | |
| ===================================== | |
| 2016-09-06 17:17:44 7f8702c17700 INNODB MONITOR OUTPUT | |
| ===================================== | |
| Per second averages calculated from the last 59 seconds | |
| ----------------- | |
| BACKGROUND THREAD | |
| ----------------- | |
| srv_master_thread loops: 5358917 srv_active, 0 srv_shutdown, 1736765 srv_idle | |
| srv_master_thread log flush and writes: 7095682 | |
| ---------- | |
| SEMAPHORES | |
| ---------- | |
| OS WAIT ARRAY INFO: reservation count 654874452 | |
| --Thread 140217825441536 has waited at buf0lru.cc line 1251 for 0.00 seconds the semaphore: | |
| Mutex at 0x14d0ec8 created file buf0buf.cc line 1334, lock var 0 | |
| waiters flag 0 | |
| --Thread 140217845942016 has waited at buf0buf.cc line 1946 for 0.00 seconds the semaphore: | |
| Mutex at 0x14d0ec8 created file buf0buf.cc line 1334, lock var 0 | |
| waiters flag 0 | |
| --Thread 140217811597056 has waited at buf0lru.cc line 1251 for 0.00 seconds the semaphore: | |
| Mutex at 0x14d0ec8 created file buf0buf.cc line 1334, lock var 0 | |
| waiters flag 0 | |
| --Thread 140217591457536 has waited at buf0lru.cc line 1251 for 0.00 seconds the semaphore: | |
| Mutex at 0x14d0ec8 created file buf0buf.cc line 1334, lock var 0 | |
| waiters flag 0 | |
| --Thread 140217561106176 has waited at buf0lru.cc line 1251 for 0.00 seconds the semaphore: | |
| Mutex at 0x14d0ec8 created file buf0buf.cc line 1334, lock var 0 | |
| waiters flag 0 | |
| --Thread 140217540605696 has waited at buf0buf.cc line 1946 for 0.00 seconds the semaphore: | |
| Mutex at 0x14d0ec8 created file buf0buf.cc line 1334, lock var 0 | |
| waiters flag 0 | |
| --Thread 140218093995776 has waited at buf0flu.cc line 1755 for 0.00 seconds the semaphore: | |
| Mutex at 0x14d0ec8 created file buf0buf.cc line 1334, lock var 0 | |
| waiters flag 0 | |
| --Thread 140218066552576 has waited at buf0buf.cc line 1946 for 0.00 seconds the semaphore: | |
| Mutex at 0x14d0ec8 created file buf0buf.cc line 1334, lock var 0 | |
| waiters flag 0 | |
| --Thread 140213623781120 has waited at buf0buf.cc line 1946 for 0.00 seconds the semaphore: | |
| Mutex at 0x14d0ec8 created file buf0buf.cc line 1334, lock var 0 | |
| waiters flag 0 | |
| --Thread 140217820915456 has waited at buf0lru.cc line 1251 for 0.00 seconds the semaphore: | |
| Mutex at 0x14d0ec8 created file buf0buf.cc line 1334, lock var 0 | |
| waiters flag 0 | |
| --Thread 140217852864256 has waited at buf0buf.cc line 1946 for 0.00 seconds the semaphore: | |
| Mutex at 0x14d0ec8 created file buf0buf.cc line 1334, lock var 0 | |
| waiters flag 0 | |
| --Thread 140217830766336 has waited at buf0buf.cc line 1946 for 0.00 seconds the semaphore: | |
| Mutex at 0x14d0ec8 created file buf0buf.cc line 1334, lock var 0 | |
| waiters flag 0 | |
| --Thread 140218067883776 has waited at buf0buf.cc line 1946 for 0.00 seconds the semaphore: | |
| Mutex at 0x14d0ec8 created file buf0buf.cc line 1334, lock var 0 | |
| waiters flag 0 | |
| --Thread 140217813460736 has waited at buf0buf.cc line 1946 for 0.00 seconds the semaphore: | |
| Mutex at 0x14d0ec8 created file buf0buf.cc line 1334, lock var 0 | |
| waiters flag 0 | |
| --Thread 140217798817536 has waited at buf0buf.cc line 1946 for 0.00 seconds the semaphore: | |
| Mutex at 0x14d0ec8 created file buf0buf.cc line 1334, lock var 0 | |
| waiters flag 0 | |
| --Thread 140217851533056 has waited at buf0lru.cc line 1251 for 0.00 seconds the semaphore: | |
| Mutex at 0x14d0ec8 created file buf0buf.cc line 1334, lock var 0 | |
| waiters flag 0 | |
| --Thread 140217549924096 has waited at buf0lru.cc line 1251 for 0.00 seconds the semaphore: | |
| Mutex at 0x14d0ec8 created file buf0buf.cc line 1334, lock var 0 | |
| waiters flag 0 | |
| --Thread 140217594386176 has waited at buf0lru.cc line 1251 for 0.00 seconds the semaphore: | |
| Mutex at 0x14d0ec8 created file buf0buf.cc line 1334, lock var 0 | |
| waiters flag 0 | |
| --Thread 140217835558656 has waited at buf0lru.cc line 1251 for 0.00 seconds the semaphore: | |
| Mutex at 0x14d0ec8 created file buf0buf.cc line 1334, lock var 0 | |
| waiters flag 0 | |
| --Thread 140217558976256 has waited at buf0lru.cc line 1251 for 0.00 seconds the semaphore: | |
| Mutex at 0x14d0ec8 created file buf0buf.cc line 1334, lock var 0 | |
| waiters flag 0 | |
| --Thread 140217847006976 has waited at buf0buf.cc line 1946 for 0.00 seconds the semaphore: | |
| Mutex at 0x14d0ec8 created file buf0buf.cc line 1334, lock var 0 | |
| waiters flag 0 | |
| --Thread 140217805207296 has waited at buf0buf.cc line 1946 for 0.00 seconds the semaphore: | |
| Mutex at 0x14d0ec8 created file buf0buf.cc line 1334, lock var 0 | |
| waiters flag 0 | |
| --Thread 140217576548096 has waited at buf0buf.cc line 1946 for 0.00 seconds the semaphore: | |
| Mutex at 0x14d0ec8 created file buf0buf.cc line 1334, lock var 0 | |
| waiters flag 0 | |
| --Thread 140217821447936 has waited at buf0lru.cc line 1251 for 0.00 seconds the semaphore: | |
| Mutex at 0x14d0ec8 created file buf0buf.cc line 1334, lock var 0 | |
| waiters flag 0 | |
| --Thread 140217586931456 has waited at buf0rea.cc line 561 for 0.00 seconds the semaphore: | |
| Mutex at 0x14d0ec8 created file buf0buf.cc line 1334, lock var 0 | |
| waiters flag 0 | |
| --Thread 140217848870656 has waited at buf0rea.cc line 561 for 0.00 seconds the semaphore: | |
| Mutex at 0x14d0ec8 created file buf0buf.cc line 1334, lock var 0 | |
| waiters flag 0 | |
| OS WAIT ARRAY INFO: signal count 671549483 | |
| Mutex spin waits 33142574508, rounds 68810428825, OS waits 226380764 | |
| RW-shared spins 896362321, rounds 16588800516, OS waits 389792063 | |
| RW-excl spins 142707811, rounds 1329082367, OS waits 6212301 | |
| Spin rounds per wait: -56.53 mutex, 18.51 RW-shared, 9.31 RW-excl | |
| ------------------------ | |
| LATEST FOREIGN KEY ERROR | |
| ------------------------ | |
| 2016-07-12 12:13:25 7f8708232700 Transaction: | |
| TRANSACTION 106693436, ACTIVE 0 sec updating or deleting | |
| mysql tables in use 1, locked 1 | |
| 4 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 1 | |
| MySQL thread id 693376, OS thread handle 0x7f8708232700, query id 255724938 10.33.221.163 root updating | |
| update rs_dbApiMgt.AM_APP_KEY_DOMAIN_MAPPING set rs_dbApiMgt.AM_APP_KEY_DOMAIN_MAPPING.CONSUMER_KEY='x-0346d3dd-40b1-4d9c-a11d-821a6cd89b3b' where rs_dbApiMgt.AM_APP_KEY_DOMAIN_MAPPING.CONSUMER_KEY='tempConsumerkey' | |
| Foreign key constraint fails for table `rs_dbApiMgt`.`AM_APP_KEY_DOMAIN_MAPPING`: | |
| , | |
| CONSTRAINT `AM_APP_KEY_DOMAIN_MAPPING_ibfk_1` FOREIGN KEY (`CONSUMER_KEY`) REFERENCES `IDN_OAUTH_CONSUMER_APPS` (`CONSUMER_KEY`) | |
| Trying to add in child table, in index `PRIMARY` tuple: | |
| DATA TUPLE: 4 fields; | |
| 0: len 38; hex 782d30333436643364642d343062312d346439632d613131642d383231613663643839623362; asc x-0346d3dd-40b1-4d9c-a11d-821a6cd89b3b;; | |
| 1: len 3; hex 414c4c; asc ALL;; | |
| 2: len 6; hex 0000065c033c; asc \ <;; | |
| 3: len 7; hex b3000002af0110; asc ;; | |
| But in parent table `rs_dbApiMgt`.`IDN_OAUTH_CONSUMER_APPS`, in index `PRIMARY`, | |
| the closest match we can find is record: | |
| PHYSICAL RECORD: n_fields 10; compact format; info bits 0 | |
| 0: len 30; hex 782d31353732396566312d303132322d346361352d393137622d37643134; asc x-15729ef1-0122-4ca5-917b-7d14; (total 38 bytes); | |
| 1: len 6; hex 000005ec56a3; asc V ;; | |
| 2: len 7; hex e30000070a0110; asc ;; | |
| 3: len 30; hex 782d34663136326336382d633535382d343663352d613463652d37363437; asc x-4f162c68-c558-46c5-a4ce-7647; (total 38 bytes); | |
| 4: len 12; hex 6d616b656d79747269706d63; asc makemytripmc;; | |
| 5: len 4; hex 7ffffb2e; asc .;; | |
| 6: len 25; hex 4d616b654d79547269704d435f4d616b654d79547269704d43; asc MakeMyTripMC_MakeMyTripMC;; | |
| 7: len 9; hex 4f417574682d322e30; asc OAuth-2.0;; | |
| 8: len 30; hex 68747470733a2f2f636f6e6e6563742e6d616b656d79747269702e636f6d; asc https://connect.makemytrip.com; (total 88 bytes); | |
| 9: len 30; hex 617574686f72697a6174696f6e5f636f646520696d706c69636974207061; asc authorization_code implicit pa; (total 124 bytes); | |
| ------------------------ | |
| LATEST DETECTED DEADLOCK | |
| ------------------------ | |
| 2016-08-21 01:14:46 7f86f265a700 | |
| *** (1) TRANSACTION: | |
| TRANSACTION 246431086, ACTIVE 1 sec starting index read | |
| mysql tables in use 2, locked 2 | |
| LOCK WAIT 5 lock struct(s), heap size 1184, 2 row lock(s) | |
| MySQL thread id 2145388, OS thread handle 0x7f870357c700, query id 1312835732 10.33.221.173 UserstoreUser updating | |
| DELETE FROM UM_USER_ATTRIBUTE WHERE UM_USER_ID=(SELECT UM_ID FROM UM_USER WHERE UM_USER_NAME='919205620785' AND UM_TENANT_ID=-1234) AND UM_TENANT_ID=-1234 | |
| *** (1) WAITING FOR THIS LOCK TO BE GRANTED: | |
| RECORD LOCKS space id 1413 page no 18905 n bits 688 index `UM_USER_ID` of table `rs_dbUserstore`.`UM_USER_ATTRIBUTE` trx id 246431086 lock_mode X locks rec but not gap waiting | |
| Record lock, heap no 605 PHYSICAL RECORD: n_fields 3; compact format; info bits 32 | |
| 0: len 4; hex 80070885; asc ;; | |
| 1: len 4; hex 7ffffb2e; asc .;; | |
| 2: len 4; hex 803ecc15; asc > ;; | |
| *** (2) TRANSACTION: | |
| TRANSACTION 246431087, ACTIVE 1 sec starting index read | |
| mysql tables in use 1, locked 1 | |
| 8 lock struct(s), heap size 1184, 20 row lock(s), undo log entries 9 | |
| MySQL thread id 2145787, OS thread handle 0x7f86f265a700, query id 1312835739 10.33.221.173 UserstoreUser updating | |
| DELETE FROM UM_USER WHERE UM_USER_NAME = '919205620785' AND UM_TENANT_ID=-1234 | |
| *** (2) HOLDS THE LOCK(S): | |
| RECORD LOCKS space id 1413 page no 18905 n bits 688 index `UM_USER_ID` of table `rs_dbUserstore`.`UM_USER_ATTRIBUTE` trx id 246431087 lock_mode X locks rec but not gap | |
| Record lock, heap no 605 PHYSICAL RECORD: n_fields 3; compact format; info bits 32 | |
| 0: len 4; hex 80070885; asc ;; | |
| 1: len 4; hex 7ffffb2e; asc .;; | |
| 2: len 4; hex 803ecc15; asc > ;; | |
| Record lock, heap no 606 PHYSICAL RECORD: n_fields 3; compact format; info bits 32 | |
| 0: len 4; hex 80070885; asc ;; | |
| 1: len 4; hex 7ffffb2e; asc .;; | |
| 2: len 4; hex 803ecc16; asc > ;; | |
| Record lock, heap no 607 PHYSICAL RECORD: n_fields 3; compact format; info bits 32 | |
| 0: len 4; hex 80070885; asc ;; | |
| 1: len 4; hex 7ffffb2e; asc .;; | |
| 2: len 4; hex 803ecc17; asc > ;; | |
| Record lock, heap no 608 PHYSICAL RECORD: n_fields 3; compact format; info bits 32 | |
| 0: len 4; hex 80070885; asc ;; | |
| 1: len 4; hex 7ffffb2e; asc .;; | |
| 2: len 4; hex 803ecc18; asc > ;; | |
| Record lock, heap no 609 PHYSICAL RECORD: n_fields 3; compact format; info bits 32 | |
| 0: len 4; hex 80070885; asc ;; | |
| 1: len 4; hex 7ffffb2e; asc .;; | |
| 2: len 4; hex 803ecc19; asc > ;; | |
| Record lock, heap no 610 PHYSICAL RECORD: n_fields 3; compact format; info bits 32 | |
| 0: len 4; hex 80070885; asc ;; | |
| 1: len 4; hex 7ffffb2e; asc .;; | |
| 2: len 4; hex 803ecc1a; asc > ;; | |
| Record lock, heap no 611 PHYSICAL RECORD: n_fields 3; compact format; info bits 32 | |
| 0: len 4; hex 80070885; asc ;; | |
| 1: len 4; hex 7ffffb2e; asc .;; | |
| 2: len 4; hex 803ecc1b; asc > ;; | |
| Record lock, heap no 612 PHYSICAL RECORD: n_fields 3; compact format; info bits 32 | |
| 0: len 4; hex 80070885; asc ;; | |
| 1: len 4; hex 7ffffb2e; asc .;; | |
| 2: len 4; hex 803ecc1c; asc > ;; | |
| Record lock, heap no 613 PHYSICAL RECORD: n_fields 3; compact format; info bits 32 | |
| 0: len 4; hex 80070885; asc ;; | |
| 1: len 4; hex 7ffffb2e; asc .;; | |
| 2: len 4; hex 803ecc1d; asc > ;; | |
| *** (2) WAITING FOR THIS LOCK TO BE GRANTED: | |
| RECORD LOCKS space id 1412 page no 2164 n bits 656 index `UM_USER_NAME` of table `rs_dbUserstore`.`UM_USER` trx id 246431087 lock_mode X locks rec but not gap waiting | |
| Record lock, heap no 584 PHYSICAL RECORD: n_fields 3; compact format; info bits 0 | |
| 0: len 12; hex 393139323035363230373835; asc 919205620785;; | |
| 1: len 4; hex 7ffffb2e; asc .;; | |
| 2: len 4; hex 80070885; asc ;; | |
| *** WE ROLL BACK TRANSACTION (1) | |
| ------------ | |
| TRANSACTIONS | |
| ------------ | |
| Trx id counter 296432005 | |
| Purge done for trx's n:o < 296429594 undo n:o < 0 state: running but idle | |
| History list length 316 | |
| LIST OF TRANSACTIONS FOR EACH SESSION: | |
| ---TRANSACTION 0, not started | |
| MySQL thread id 2737290, OS thread handle 0x7f8702c17700, query id 1667206562 localhost root init | |
| show engine innodb status | |
| ---TRANSACTION 296431941, not started | |
| MySQL thread id 2737294, OS thread handle 0x7f86f1a6b700, query id 1667206161 10.33.221.176 analyticsUser cleaning up | |
| ---TRANSACTION 296431986, not started | |
| MySQL thread id 2737293, OS thread handle 0x7f86f334d700, query id 1667206451 10.33.221.175 analyticsUser cleaning up | |
| ---TRANSACTION 296431792, not started | |
| MySQL thread id 2737292, OS thread handle 0x7f86f1f3e700, query id 1667205444 10.33.221.173 connectdbuser cleaning up | |
| ---TRANSACTION 296431979, not started | |
| MySQL thread id 2737289, OS thread handle 0x7f87028ca700, query id 1667206390 10.33.221.162 AxiataMifeDBUser cleaning up | |
| ---TRANSACTION 296431944, not started | |
| MySQL thread id 2737288, OS thread handle 0x7f87020aa700, query id 1667206189 10.33.221.175 analyticsUser cleaning up | |
| ---TRANSACTION 296431914, not started | |
| MySQL thread id 2737286, OS thread handle 0x7f871030d700, query id 1667206044 10.33.221.172 root cleaning up | |
| ---TRANSACTION 296430944, not started | |
| MySQL thread id 2737280, OS thread handle 0x7f8700336700, query id 1667200608 10.33.221.171 USSDUser cleaning up | |
| ---TRANSACTION 296430931, not started | |
| MySQL thread id 2737254, OS thread handle 0x7f8700a52700, query id 1667200349 10.33.221.172 root cleaning up | |
| ---TRANSACTION 296431985, not started | |
| MySQL thread id 2737276, OS thread handle 0x7f87002b4700, query id 1667206445 10.33.221.174 connectdbuser cleaning up | |
| ---TRANSACTION 296430379, not started | |
| MySQL thread id 2737274, OS thread handle 0x7f87030ea700, query id 1667197328 10.33.221.165 connectdbuser cleaning up | |
| ---TRANSACTION 296430340, not started | |
| MySQL thread id 2737272, OS thread handle 0x7f86f3451700, query id 1667197011 10.33.221.165 connectdbuser cleaning up | |
| ---TRANSACTION 296431539, not started | |
| MySQL thread id 2737269, OS thread handle 0x7f8700b97700, query id 1667203775 10.33.221.174 UserstoreUser cleaning up | |
| ---TRANSACTION 296431842, not started | |
| MySQL thread id 2737268, OS thread handle 0x7f87120d9700, query id 1667205721 10.33.221.174 ApiMgtUser cleaning up | |
| ---TRANSACTION 296431945, not started | |
| MySQL thread id 2737267, OS thread handle 0x7f86f3492700, query id 1667206188 10.33.221.175 analyticsUser cleaning up | |
| ---TRANSACTION 296430268, not started | |
| MySQL thread id 2737264, OS thread handle 0x7f86f35d7700, query id 1667196653 10.33.221.165 connectdbuser cleaning up | |
| ---TRANSACTION 296428494, not started | |
| MySQL thread id 2737248, OS thread handle 0x7f87010ab700, query id 1667186914 10.33.221.171 USSDUser cleaning up | |
| ---TRANSACTION 296431946, not started | |
| MySQL thread id 2737255, OS thread handle 0x7f8701b96700, query id 1667206191 10.33.221.175 analyticsUser cleaning up | |
| ---TRANSACTION 296428262, not started | |
| MySQL thread id 2737241, OS thread handle 0x7f8701f65700, query id 1667185636 10.33.221.172 root cleaning up | |
| ---TRANSACTION 296430869, not started | |
| MySQL thread id 2737253, OS thread handle 0x7f8700642700, query id 1667200025 10.33.221.171 USSDUser cleaning up | |
| ---TRANSACTION 296431998, not started | |
| MySQL thread id 2737251, OS thread handle 0x7f8700ee4700, query id 1667206551 10.33.221.165 UserstoreUser cleaning up | |
| ---TRANSACTION 296428263, not started | |
| MySQL thread id 2737175, OS thread handle 0x7f86f3aaa700, query id 1667185641 10.33.221.172 root cleaning up | |
| ---TRANSACTION 296431943, not started | |
| MySQL thread id 2737232, OS thread handle 0x7f86f3208700, query id 1667206187 10.33.221.175 analyticsUser cleaning up | |
| ---TRANSACTION 296428525, not started | |
| MySQL thread id 2737220, OS thread handle 0x7f8607492700, query id 1667187078 10.33.221.172 root cleaning up | |
| ---TRANSACTION 296428074, not started | |
| MySQL thread id 2737218, OS thread handle 0x7f860730c700, query id 1667184624 10.33.221.172 root cleaning up | |
| ---TRANSACTION 296424211, not started | |
| MySQL thread id 2737216, OS thread handle 0x7f8702fa5700, query id 1667166500 10.33.221.171 USSDUser cleaning up | |
| ---TRANSACTION 296431948, not started | |
| MySQL thread id 2737213, OS thread handle 0x7f87003b8700, query id 1667206200 10.33.221.176 analyticsUser cleaning up | |
| ---TRANSACTION 296427623, not started | |
| MySQL thread id 2737174, OS thread handle 0x7f8700d5e700, query id 1667182133 10.33.221.172 root cleaning up | |
| ---TRANSACTION 296431947, not started | |
| MySQL thread id 2737207, OS thread handle 0x7f8712098700, query id 1667206192 10.33.221.176 analyticsUser cleaning up | |
| ---TRANSACTION 296424247, not started | |
| MySQL thread id 2737124, OS thread handle 0x7f86f228b700, query id 1667166712 10.33.221.172 root cleaning up | |
| ---TRANSACTION 296428203, not started | |
| MySQL thread id 2737149, OS thread handle 0x7f86f09a9700, query id 1667187006 10.33.221.171 USSDUser cleaning up | |
| ---TRANSACTION 296423880, not started | |
| MySQL thread id 2737191, OS thread handle 0x7f870157e700, query id 1667167223 10.33.221.172 root cleaning up | |
| ---TRANSACTION 296430868, not started | |
| MySQL thread id 2737187, OS thread handle 0x7f86f3aeb700, query id 1667200016 10.33.221.171 USSDUser cleaning up | |
| ---TRANSACTION 296431902, not started | |
| MySQL thread id 2737176, OS thread handle 0x7f86f3e38700, query id 1667205985 10.33.221.171 USSDUser cleaning up | |
| ---TRANSACTION 296431900, not started | |
| MySQL thread id 2737172, OS thread handle 0x7f86f0044700, query id 1667205971 10.33.221.162 AxiataMifeDBUser cleaning up | |
| ---TRANSACTION 296431965, not started | |
| MySQL thread id 2737166, OS thread handle 0x7f86f2cf4700, query id 1667206287 10.33.221.173 ApiMgtUser cleaning up | |
| ---TRANSACTION 296431187, not started | |
| MySQL thread id 2737147, OS thread handle 0x7f8702069700, query id 1667201932 10.33.221.171 USSDUser cleaning up | |
| ---TRANSACTION 296432003, not started | |
| MySQL thread id 2737158, OS thread handle 0x7f8703374700, query id 1667206566 10.33.221.173 UserstoreUser cleaning up | |
| ---TRANSACTION 296427366, not started | |
| MySQL thread id 2737119, OS thread handle 0x7f8700c19700, query id 1667180547 10.33.221.171 USSDUser cleaning up | |
| ---TRANSACTION 296431978, not started | |
| MySQL thread id 2737108, OS thread handle 0x7f86f3104700, query id 1667206389 10.33.221.162 ApiMgtUser cleaning up | |
| ---TRANSACTION 296431804, not started | |
| MySQL thread id 2737093, OS thread handle 0x7f8702f23700, query id 1667205544 10.33.221.173 ApiMgtUser cleaning up | |
| ---TRANSACTION 296431927, not started | |
| MySQL thread id 2737080, OS thread handle 0x7f86f2c72700, query id 1667206087 10.33.221.163 AxiataMifeDBUser cleaning up | |
| ---TRANSACTION 296431777, not started | |
| MySQL thread id 2737063, OS thread handle 0x7f86f0ebd700, query id 1667205381 10.33.221.165 ApiMgtUser cleaning up | |
| ---TRANSACTION 296431987, not started | |
| MySQL thread id 2737035, OS thread handle 0x7f8710105700, query id 1667206469 10.33.221.174 UserstoreUser cleaning up | |
| ---TRANSACTION 296431925, not started | |
| MySQL thread id 2737013, OS thread handle 0x7f86074d3700, query id 1667206085 10.33.221.165 ApiMgtUser cleaning up | |
| ---TRANSACTION 296431855, not started | |
| MySQL thread id 2737006, OS thread handle 0x7f87082b4700, query id 1667205799 10.33.221.165 UserstoreUser cleaning up | |
| ---TRANSACTION 296431335, not started | |
| MySQL thread id 2736973, OS thread handle 0x7f8710452700, query id 1667202722 10.33.221.163 AxiataMifeDBUser cleaning up | |
| ---TRANSACTION 296432002, not started | |
| MySQL thread id 2736966, OS thread handle 0x7f86f0968700, query id 1667206561 10.33.221.166 UserstoreUser cleaning up | |
| ---TRANSACTION 296422594, not started | |
| MySQL thread id 2736963, OS thread handle 0x7f8700fe8700, query id 1667161011 10.33.221.172 root cleaning up | |
| ---TRANSACTION 296422093, not started | |
| MySQL thread id 2736962, OS thread handle 0x7f86f3db6700, query id 1667158441 10.33.221.172 root cleaning up | |
| ---TRANSACTION 296431110, not started | |
| MySQL thread id 2736923, OS thread handle 0x7f8700cdc700, query id 1667202705 10.33.221.171 USSDUser cleaning up | |
| ---TRANSACTION 296422481, not started | |
| MySQL thread id 2736950, OS thread handle 0x7f870298d700, query id 1667157493 10.33.221.172 root cleaning up | |
| ---TRANSACTION 296422091, not started | |
| MySQL thread id 2736951, OS thread handle 0x7f870012e700, query id 1667158098 10.33.221.172 root cleaning up | |
| ---TRANSACTION 296421124, not started | |
| MySQL thread id 2736941, OS thread handle 0x7f8710411700, query id 1667153753 10.33.221.172 root cleaning up | |
| ---TRANSACTION 296431630, not started | |
| MySQL thread id 2736930, OS thread handle 0x7f87029ce700, query id 1667204522 10.33.221.162 AxiataMifeDBUser cleaning up | |
| ---TRANSACTION 296431886, not started | |
| MySQL thread id 2736919, OS thread handle 0x7f86f3a69700, query id 1667205914 10.33.221.165 connectdbuser cleaning up | |
| ---TRANSACTION 296422805, not started | |
| MySQL thread id 2736793, OS thread handle 0x7f87030a9700, query id 1667159226 10.33.221.171 USSDUser cleaning up | |
| ---TRANSACTION 296430290, not started | |
| MySQL thread id 2736870, OS thread handle 0x7f8701ee3700, query id 1667196798 10.33.221.165 connectdbuser cleaning up | |
| ---TRANSACTION 296421330, not started | |
| MySQL thread id 2736795, OS thread handle 0x7f86f02ce700, query id 1667151622 10.33.221.171 USSDUser cleaning up | |
| ---TRANSACTION 296425637, not started | |
| MySQL thread id 2736794, OS thread handle 0x7f870057f700, query id 1667172742 10.33.221.171 USSDUser cleaning up | |
| ---TRANSACTION 296399570, not started | |
| MySQL thread id 2736783, OS thread handle 0x7f86f38a2700, query id 1667037713 10.33.221.163 root cleaning up | |
| ---TRANSACTION 0, not started | |
| MySQL thread id 2736701, OS thread handle 0x7f87080ac700, query id 1667033937 10.212.134.202 root cleaning up | |
| ---TRANSACTION 296430990, not started | |
| MySQL thread id 2736694, OS thread handle 0x7f8701c18700, query id 1667202306 10.33.221.172 root cleaning up | |
| ---TRANSACTION 296427851, not started | |
| MySQL thread id 2736614, OS thread handle 0x7f8701bd7700, query id 1667205952 10.33.221.176 analyticsUser cleaning up | |
| ---TRANSACTION 296431846, not started | |
| MySQL thread id 2736612, OS thread handle 0x7f86f3596700, query id 1667205744 10.33.221.163 ApiMgtUser cleaning up | |
| ---TRANSACTION 296431915, not started | |
| MySQL thread id 2736370, OS thread handle 0x7f86f3082700, query id 1667206046 10.33.221.165 connectdbuser cleaning up | |
| ---TRANSACTION 296431672, not started | |
| MySQL thread id 2736319, OS thread handle 0x7f86f2d35700, query id 1667204724 10.33.221.173 connectdbuser cleaning up | |
| ---TRANSACTION 296379260, not started | |
| MySQL thread id 2736289, OS thread handle 0x7f86f2ebb700, query id 1666932561 10.33.221.166 GovCloudUser cleaning up | |
| ---TRANSACTION 296431982, not started | |
| MySQL thread id 2736285, OS thread handle 0x7f86f2fbf700, query id 1667206399 10.33.221.165 connectdbuser cleaning up | |
| ---TRANSACTION 296373954, not started | |
| MySQL thread id 2736274, OS thread handle 0x7f86f32cb700, query id 1666891598 10.33.221.166 GovCloudUser cleaning up | |
| ---TRANSACTION 296373975, not started | |
| MySQL thread id 2736283, OS thread handle 0x7f86f3041700, query id 1666891702 10.33.221.166 GovCloudUser cleaning up | |
| ---TRANSACTION 296373979, not started | |
| MySQL thread id 2736278, OS thread handle 0x7f86f31c7700, query id 1666891648 10.33.221.166 GovCloudUser cleaning up | |
| ---TRANSACTION 296378933, not started | |
| MySQL thread id 2736265, OS thread handle 0x7f8702a91700, query id 1666921627 10.33.221.166 GovCloudUser cleaning up | |
| ---TRANSACTION 296431972, not started | |
| MySQL thread id 2735544, OS thread handle 0x7f8702b95700, query id 1667206464 10.33.221.174 GovCloudUser cleaning up | |
| ---TRANSACTION 296431659, not started | |
| MySQL thread id 2736230, OS thread handle 0x7f870116e700, query id 1667204664 10.33.221.171 USSDUser cleaning up | |
| ---TRANSACTION 296431973, not started | |
| MySQL thread id 2735536, OS thread handle 0x7f86f3fbe700, query id 1667206368 10.33.221.173 ConfigDbUser cleaning up | |
| ---TRANSACTION 296416963, not started | |
| MySQL thread id 2736180, OS thread handle 0x7f8700a11700, query id 1667168789 10.33.221.166 ConfigDbUser cleaning up | |
| ---TRANSACTION 0, not started | |
| MySQL thread id 2735383, OS thread handle 0x7f870153d700, query id 1666869104 localhost root cleaning up | |
| ---TRANSACTION 296431726, not started | |
| MySQL thread id 2736195, OS thread handle 0x7f8700377700, query id 1667205061 10.33.221.174 connectdbuser cleaning up | |
| ---TRANSACTION 296431994, not started | |
| MySQL thread id 2736192, OS thread handle 0x7f8701f24700, query id 1667206513 10.33.221.173 connectdbuser cleaning up | |
| ---TRANSACTION 296378467, not started | |
| MySQL thread id 2736175, OS thread handle 0x7f871215b700, query id 1667130469 10.33.221.166 ConfigDbUser cleaning up | |
| ---TRANSACTION 296431952, not started | |
| MySQL thread id 2736172, OS thread handle 0x7f8700809700, query id 1667206229 10.33.221.162 UserstoreUser cleaning up | |
| ---TRANSACTION 296376517, not started | |
| MySQL thread id 2736166, OS thread handle 0x7f8702a0f700, query id 1666905795 10.33.221.162 ConfigDbUser cleaning up | |
| ---TRANSACTION 296431646, not started | |
| MySQL thread id 2736036, OS thread handle 0x7f87080ed700, query id 1667204615 10.33.221.173 connectdbuser cleaning up | |
| ---TRANSACTION 296430300, not started | |
| MySQL thread id 2736004, OS thread handle 0x7f85fb04d700, query id 1667196855 10.33.221.165 connectdbuser cleaning up | |
| ---TRANSACTION 296430624, not started | |
| MySQL thread id 2735985, OS thread handle 0x7f8708273700, query id 1667198701 10.33.221.165 connectdbuser cleaning up | |
| ---TRANSACTION 296431950, not started | |
| MySQL thread id 2735921, OS thread handle 0x7f870084a700, query id 1667206206 10.33.221.174 connectdbuser cleaning up | |
| ---TRANSACTION 296430301, not started | |
| MySQL thread id 2735824, OS thread handle 0x7f8700e62700, query id 1667196856 10.33.221.174 connectdbuser cleaning up | |
| ---TRANSACTION 296431931, not started | |
| MySQL thread id 2735522, OS thread handle 0x7f86f0495700, query id 1667206463 10.33.221.174 ConfigDbUser cleaning up | |
| ---TRANSACTION 296343177, not started | |
| MySQL thread id 2735537, OS thread handle 0x7f8607a69700, query id 1666871562 10.33.221.173 GovCloudUser cleaning up | |
| ---TRANSACTION 296343356, not started | |
| MySQL thread id 2735520, OS thread handle 0x7f8711e51700, query id 1666874191 10.33.221.174 GovCloudUser cleaning up | |
| ---TRANSACTION 296432004, not started | |
| MySQL thread id 2735363, OS thread handle 0x7f870147a700, query id 1667206567 10.33.221.165 connectdbuser cleaning up | |
| ---TRANSACTION 296430706, not started | |
| MySQL thread id 2735304, OS thread handle 0x7f8606a29700, query id 1667199142 10.33.221.172 root cleaning up | |
| ---TRANSACTION 296421427, not started | |
| MySQL thread id 2735173, OS thread handle 0x7f87083b8700, query id 1667152013 10.33.221.172 root cleaning up | |
| ---TRANSACTION 296431981, not started | |
| MySQL thread id 2735101, OS thread handle 0x7f870006b700, query id 1667206425 10.33.221.172 root cleaning up | |
| ---TRANSACTION 296431993, not started | |
| MySQL thread id 2730307, OS thread handle 0x7f8702fe6700, query id 1667206532 10.33.221.163 GovCloudUser cleaning up | |
| ---TRANSACTION 296430272, not started | |
| MySQL thread id 2733009, OS thread handle 0x7f870194d700, query id 1667196737 10.33.221.174 ConfigDbUser cleaning up | |
| ---TRANSACTION 296139352, not started | |
| MySQL thread id 2732777, OS thread handle 0x7f8607aaa700, query id 1666387662 10.212.134.200 root cleaning up | |
| ---TRANSACTION 0, not started | |
| MySQL thread id 2732774, OS thread handle 0x7f8702271700, query id 1666387641 10.212.134.200 root cleaning up | |
| ---TRANSACTION 296431888, not started | |
| MySQL thread id 2732627, OS thread handle 0x7f8710493700, query id 1667206071 10.33.221.175 analyticsUser cleaning up | |
| ---TRANSACTION 296390746, not started | |
| MySQL thread id 2732593, OS thread handle 0x7f86f3820700, query id 1667206004 10.33.221.175 analyticsUser cleaning up | |
| ---TRANSACTION 296431905, not started | |
| MySQL thread id 2732479, OS thread handle 0x7f8702375700, query id 1667206005 10.33.221.176 analyticsUser cleaning up | |
| ---TRANSACTION 296431920, not started | |
| MySQL thread id 2732163, OS thread handle 0x7f87018cb700, query id 1667206076 10.33.221.175 analyticsUser cleaning up | |
| ---TRANSACTION 296431966, not started | |
| MySQL thread id 2730564, OS thread handle 0x7f86f2001700, query id 1667206545 10.33.221.165 ConfigDbUser cleaning up | |
| ---TRANSACTION 296362089, not started | |
| MySQL thread id 2729954, OS thread handle 0x7f86f3d75700, query id 1666832892 10.33.221.163 GovCloudUser cleaning up | |
| ---TRANSACTION 296373411, not started | |
| MySQL thread id 2730011, OS thread handle 0x7f86f0760700, query id 1666874258 10.33.221.174 GovCloudUser cleaning up | |
| ---TRANSACTION 296431642, not started | |
| MySQL thread id 2729372, OS thread handle 0x7f8702438700, query id 1667204593 10.33.221.165 UserstoreUser cleaning up | |
| ---TRANSACTION 296431976, not started | |
| MySQL thread id 2729239, OS thread handle 0x7f86f34d3700, query id 1667206482 10.33.221.173 GovCloudUser cleaning up | |
| ---TRANSACTION 296413646, not started | |
| MySQL thread id 2720976, OS thread handle 0x7f8606e39700, query id 1667190377 10.33.221.162 GovCloudUser cleaning up | |
| ---TRANSACTION 296343171, not started | |
| MySQL thread id 2718624, OS thread handle 0x7f870198e700, query id 1666684235 10.33.221.173 GovCloudUser cleaning up | |
| ---TRANSACTION 296424918, not started | |
| MySQL thread id 2698661, OS thread handle 0x7f87024fb700, query id 1667170032 10.33.221.173 GovCloudUser cleaning up | |
| ---TRANSACTION 296431928, not started | |
| MySQL thread id 2697167, OS thread handle 0x7f86f0558700, query id 1667206224 10.33.221.162 ConfigDbUser cleaning up | |
| ---TRANSACTION 296373003, not started | |
| MySQL thread id 2658968, OS thread handle 0x7f8700bd8700, query id 1667204311 10.33.221.173 ConfigDbUser cleaning up | |
| ---TRANSACTION 296327403, not started | |
| MySQL thread id 2638907, OS thread handle 0x7f8607bef700, query id 1666581186 10.33.221.165 UserstoreUser cleaning up | |
| ---TRANSACTION 296431951, not started | |
| MySQL thread id 2605323, OS thread handle 0x7f8701b55700, query id 1667206481 10.33.221.173 ConfigDbUser cleaning up | |
| ---TRANSACTION 296345386, not started | |
| MySQL thread id 2605322, OS thread handle 0x7f86f2105700, query id 1666871564 10.33.221.173 GovCloudUser cleaning up | |
| ---TRANSACTION 293746682, not started | |
| MySQL thread id 2605321, OS thread handle 0x7f86f0350700, query id 1666865805 10.33.221.173 ConfigDbUser cleaning up | |
| ---TRANSACTION 295826814, not started | |
| MySQL thread id 2594541, OS thread handle 0x7f870816f700, query id 1666904749 10.33.221.162 GovCloudUser cleaning up | |
| ---TRANSACTION 296431929, not started | |
| MySQL thread id 2594539, OS thread handle 0x7f86f379e700, query id 1667206225 10.33.221.162 GovCloudUser cleaning up | |
| ---TRANSACTION 296431997, not started | |
| MySQL thread id 2586766, OS thread handle 0x7f87007c8700, query id 1667206537 10.33.221.163 UserstoreUser cleaning up | |
| ---TRANSACTION 296431305, not started | |
| MySQL thread id 2586163, OS thread handle 0x7f87010ec700, query id 1667202581 10.33.221.165 UserstoreUser cleaning up | |
| ---TRANSACTION 296430499, not started | |
| MySQL thread id 2582233, OS thread handle 0x7f8700a93700, query id 1667198030 10.33.221.174 GovCloudUser cleaning up | |
| ---TRANSACTION 296279971, not started | |
| MySQL thread id 2561200, OS thread handle 0x7f87024ba700, query id 1667205328 10.33.221.163 GovCloudUser cleaning up | |
| ---TRANSACTION 296373413, not started | |
| MySQL thread id 2565412, OS thread handle 0x7f86f2a6a700, query id 1666874259 10.33.221.174 ConfigDbUser cleaning up | |
| ---TRANSACTION 296431983, not started | |
| MySQL thread id 2561140, OS thread handle 0x7f860738e700, query id 1667206546 10.33.221.165 GovCloudUser cleaning up | |
| ---TRANSACTION 296426026, not started | |
| MySQL thread id 2561139, OS thread handle 0x7f8701849700, query id 1667174553 10.33.221.165 ConfigDbUser cleaning up | |
| ---TRANSACTION 296431992, not started | |
| MySQL thread id 2502392, OS thread handle 0x7f86f3b2c700, query id 1667206531 10.33.221.163 ConfigDbUser cleaning up | |
| ---TRANSACTION 296431974, not started | |
| MySQL thread id 1201229, OS thread handle 0x7f8606d35700, query id 1667206437 10.33.221.164 GovCloudUser cleaning up | |
| ---TRANSACTION 296431930, not started | |
| MySQL thread id 1201230, OS thread handle 0x7f86f2556700, query id 1667206436 10.33.221.164 ConfigDbUser cleaning up | |
| ---TRANSACTION 296431984, not started | |
| MySQL thread id 1201225, OS thread handle 0x7f86f3514700, query id 1667206442 10.33.221.164 UserstoreUser cleaning up | |
| ---TRANSACTION 296431999, ACTIVE 1 sec | |
| mysql tables in use 1, locked 0 | |
| MySQL thread id 2732548, OS thread handle 0x7f8701682700, query id 1667206553 10.33.221.176 analyticsUser Creating sort index | |
| SELECT REG_PATH, REG_USER_ID, REG_LOGGED_TIME, REG_ACTION, REG_ACTION_DATA FROM REG_LOG WHERE REG_LOGGED_TIME>'2016-09-06 16:57:04' AND REG_LOGGED_TIME<'2016-09-06 17:17:43.897' AND REG_TENANT_ID=-1234 ORDER BY REG_LOGGED_TIME DESC | |
| Trx read view will not see trx with id >= 296432000, sees < 296429502 | |
| ---TRANSACTION 296431989, ACTIVE 1 sec | |
| mysql tables in use 1, locked 0 | |
| MySQL thread id 2736125, OS thread handle 0x7f86073cf700, query id 1667206488 10.33.221.173 connectdbuser Sending data | |
| select Status from `clientstatus` where SessionID='d3347d4e-a12b-4b83-8f55-00cd95737be8' | |
| Trx read view will not see trx with id >= 296431990, sees < 296429502 | |
| ---TRANSACTION 296431924, ACTIVE 3 sec fetching rows | |
| mysql tables in use 1, locked 1 | |
| 581 lock struct(s), heap size 79400, 0 row lock(s) | |
| MySQL thread id 2737073, OS thread handle 0x7f870053e700, query id 1667206081 10.33.221.174 connectdbuser updating | |
| update clientstatus set Status='EXPIRED' WHERE SessionID='d1ac085f-3989-4562-9bf0-825b138166e7' | |
| ---TRANSACTION 296431923, ACTIVE 3 sec | |
| mysql tables in use 1, locked 0 | |
| MySQL thread id 2737273, OS thread handle 0x7f86f2e7a700, query id 1667206079 10.33.221.174 connectdbuser Sending data | |
| select Status from `clientstatus` where SessionID='f461834a-1672-4016-988a-4595efd7faac' | |
| Trx read view will not see trx with id >= 296431924, sees < 296429502 | |
| ---TRANSACTION 296431895, ACTIVE 4 sec | |
| mysql tables in use 6, locked 0 | |
| MySQL thread id 2737283, OS thread handle 0x7f86f375d700, query id 1667205939 10.33.221.171 USSDUser Sending data | |
| select this_.REQ_ID as REQ_ID1_1_4_, this_.APP_ID as APP_ID2_1_4_, this_.MESSAGE as MESSAGE3_1_4_, applicatio3_.APP_ID as APP_ID1_0_0_, applicatio3_.APP_STATUS as APP_STAT2_0_0_, applicatio3_.KEYWORD as KEYWORD3_0_0_, applicatio3_.SP_ID as SP_ID6_0_0_, applicatio3_.SHORTCODE as SHORTCOD4_0_0_, applicatio3_.IS_UNIQUE as IS_UNIQU5_0_0_, servicepro4_.SP_ID as SP_ID1_4_1_, servicepro4_.COMMENT as COMMENT2_4_1_, servicepro4_.SP_NAME as SP_NAME3_4_1_, o1_.REQ_ID as REQ_ID1_2_2_, o1_.ADDRESS as ADDRESS2_2_2_, o1_.CLIENT_CORRELATOR as CLIENT_C3_2_2_, o1_.DELIVERY_STATUS as DELIVERY4_2_2_, o1_.KEYWORD | |
| Trx read view will not see trx with id >= 296431896, sees < 296429502 | |
| ---TRANSACTION 296431879, ACTIVE 4 sec | |
| mysql tables in use 1, locked 0 | |
| MySQL thread id 2736107, OS thread handle 0x7f8702e60700, query id 1667205885 10.33.221.165 connectdbuser Sending data | |
| select Status from `clientstatus` where SessionID='eee18525-63b5-4e37-8429-3838b8c217c7' | |
| Trx read view will not see trx with id >= 296431880, sees < 296429502 | |
| ---TRANSACTION 296431819, ACTIVE 5 sec fetching rows | |
| mysql tables in use 1, locked 1 | |
| 1027 lock struct(s), heap size 128552, 0 row lock(s) | |
| MySQL thread id 2736039, OS thread handle 0x7f87034fa700, query id 1667205626 10.33.221.174 connectdbuser updating | |
| update clientstatus set Status='EXPIRED' WHERE SessionID='26f1d131-0530-4e47-8d8a-c66d6e189379' | |
| ---TRANSACTION 296431798, ACTIVE 5 sec fetching rows | |
| mysql tables in use 1, locked 0 | |
| MySQL thread id 2735125, OS thread handle 0x7f870106a700, query id 1667205471 10.33.221.175 analyticsUser Sending data | |
| SELECT record_id, timestamp, data FROM ANX___7LqLYnVI_ WHERE partition_key >= 16 and | |
| partition_key < 20 AND timestamp >= -9223372036854775808 AND timestamp < 9223372036854775807 LIMIT 0,2147483647 | |
| Trx read view will not see trx with id >= 296431799, sees < 296429502 | |
| ---TRANSACTION 296431771, ACTIVE 6 sec | |
| mysql tables in use 1, locked 0 | |
| MySQL thread id 2736225, OS thread handle 0x7f8700f66700, query id 1667205354 10.33.221.173 connectdbuser Sending data | |
| select Status from `clientstatus` where SessionID='2c38e064-4520-4e14-956f-12baaddfa71a' | |
| Trx read view will not see trx with id >= 296431772, sees < 296429394 | |
| ---TRANSACTION 296431761, ACTIVE 6 sec fetching rows | |
| mysql tables in use 6, locked 0 | |
| MySQL thread id 2735437, OS thread handle 0x7f8701fe7700, query id 1667205280 10.33.221.172 root Sending data | |
| select this_.REQ_ID as REQ_ID1_1_4_, this_.APP_ID as APP_ID2_1_4_, this_.MESSAGE as MESSAGE3_1_4_, applicatio3_.APP_ID as APP_ID1_0_0_, applicatio3_.APP_STATUS as APP_STAT2_0_0_, applicatio3_.KEYWORD as KEYWORD3_0_0_, applicatio3_.SP_ID as SP_ID6_0_0_, applicatio3_.SHORTCODE as SHORTCOD4_0_0_, applicatio3_.IS_UNIQUE as IS_UNIQU5_0_0_, servicepro4_.SP_ID as SP_ID1_4_1_, servicepro4_.COMMENT as COMMENT2_4_1_, servicepro4_.SP_NAME as SP_NAME3_4_1_, o1_.REQ_ID as REQ_ID1_2_2_, o1_.ADDRESS as ADDRESS2_2_2_, o1_.CLIENT_CORRELATOR as CLIENT_C3_2_2_, o1_.DELIVERY_STATUS as DELIVERY4_2_2_, o1_.KEYWORD | |
| Trx read view will not see trx with id >= 296431762, sees < 296429394 | |
| ---TRANSACTION 296431718, ACTIVE 7 sec | |
| mysql tables in use 6, locked 0 | |
| MySQL thread id 2737095, OS thread handle 0x7f870812e700, query id 1667205023 10.33.221.172 root Sending data | |
| select this_.REQ_ID as REQ_ID1_1_4_, this_.APP_ID as APP_ID2_1_4_, this_.MESSAGE as MESSAGE3_1_4_, applicatio3_.APP_ID as APP_ID1_0_0_, applicatio3_.APP_STATUS as APP_STAT2_0_0_, applicatio3_.KEYWORD as KEYWORD3_0_0_, applicatio3_.SP_ID as SP_ID6_0_0_, applicatio3_.SHORTCODE as SHORTCOD4_0_0_, applicatio3_.IS_UNIQUE as IS_UNIQU5_0_0_, servicepro4_.SP_ID as SP_ID1_4_1_, servicepro4_.COMMENT as COMMENT2_4_1_, servicepro4_.SP_NAME as SP_NAME3_4_1_, o1_.REQ_ID as REQ_ID1_2_2_, o1_.ADDRESS as ADDRESS2_2_2_, o1_.CLIENT_CORRELATOR as CLIENT_C3_2_2_, o1_.DELIVERY_STATUS as DELIVERY4_2_2_, o1_.KEYWORD | |
| Trx read view will not see trx with id >= 296431719, sees < 296429394 | |
| ---TRANSACTION 296431699, ACTIVE 7 sec fetching rows | |
| mysql tables in use 1, locked 0 | |
| MySQL thread id 2737278, OS thread handle 0x7f86f1ebc700, query id 1667204910 10.33.221.174 ApiMgtUser Creating sort index | |
| SELECT ACCESS_TOKEN, AUTHZ_USER, TOKEN_SCOPE, TOKEN_STATE, TIME_CREATED FROM IDN_OAUTH2_ACCESS_TOKEN WHERE CONSUMER_KEY = '_tb1HavmMQfgL3AUN4ta1vo56qQa' AND REFRESH_TOKEN = 'c3f58aa48b9637271fd7e98374aab' ORDER BY TIME_CREATED DESC LIMIT 1 | |
| Trx read view will not see trx with id >= 296431700, sees < 296429394 | |
| ---TRANSACTION 296431679, ACTIVE 8 sec | |
| mysql tables in use 6, locked 0 | |
| MySQL thread id 2737281, OS thread handle 0x7f87033b5700, query id 1667204777 10.33.221.171 USSDUser Sending data | |
| select this_.REQ_ID as REQ_ID1_1_4_, this_.APP_ID as APP_ID2_1_4_, this_.MESSAGE as MESSAGE3_1_4_, applicatio3_.APP_ID as APP_ID1_0_0_, applicatio3_.APP_STATUS as APP_STAT2_0_0_, applicatio3_.KEYWORD as KEYWORD3_0_0_, applicatio3_.SP_ID as SP_ID6_0_0_, applicatio3_.SHORTCODE as SHORTCOD4_0_0_, applicatio3_.IS_UNIQUE as IS_UNIQU5_0_0_, servicepro4_.SP_ID as SP_ID1_4_1_, servicepro4_.COMMENT as COMMENT2_4_1_, servicepro4_.SP_NAME as SP_NAME3_4_1_, o1_.REQ_ID as REQ_ID1_2_2_, o1_.ADDRESS as ADDRESS2_2_2_, o1_.CLIENT_CORRELATOR as CLIENT_C3_2_2_, o1_.DELIVERY_STATUS as DELIVERY4_2_2_, o1_.KEYWORD | |
| Trx read view will not see trx with id >= 296431680, sees < 296429394 | |
| ---TRANSACTION 296431614, ACTIVE 11 sec unlock_row | |
| mysql tables in use 1, locked 1 | |
| 2394 lock struct(s), heap size 276008, 1 row lock(s) | |
| MySQL thread id 2736318, OS thread handle 0x7f86f2d76700, query id 1667204356 10.33.221.173 connectdbuser updating | |
| update clientstatus set Status='EXPIRED' WHERE SessionID='f461834a-1672-4016-988a-4595efd7faac' | |
| ---TRANSACTION 296431550, ACTIVE 12 sec fetching rows | |
| mysql tables in use 1, locked 1 | |
| 2525 lock struct(s), heap size 292392, 0 row lock(s) | |
| MySQL thread id 2736307, OS thread handle 0x7f8702889700, query id 1667203852 10.33.221.173 connectdbuser updating | |
| update clientstatus set Status='EXPIRED' WHERE SessionID='d4553a7a-df8f-47ff-b517-b992c62f54d8' | |
| ---TRANSACTION 296431545, ACTIVE 12 sec fetching rows | |
| mysql tables in use 1, locked 1 | |
| 4752 lock struct(s), heap size 489000, 0 row lock(s) | |
| MySQL thread id 2736999, OS thread handle 0x7f8701ad3700, query id 1667203799 10.33.221.174 connectdbuser Searching rows for update | |
| update `authenticated_login` set status='1' where msisdn='917776075533' | |
| ---TRANSACTION 296431195, ACTIVE 20 sec fetching rows | |
| mysql tables in use 1, locked 0 | |
| MySQL thread id 2734666, OS thread handle 0x7f8700d9f700, query id 1667201962 10.33.221.175 analyticsUser Sending data | |
| SELECT record_id, timestamp, data FROM ANX___7LtZZXNI_ WHERE partition_key >= 92 and | |
| partition_key < 100 AND timestamp >= -9223372036854775808 AND timestamp < 9223372036854775807 LIMIT 0,2147483647 | |
| Trx read view will not see trx with id >= 296431196, sees < 296429394 | |
| ---TRANSACTION 296431194, ACTIVE 20 sec fetching rows | |
| mysql tables in use 1, locked 0 | |
| MySQL thread id 2737070, OS thread handle 0x7f8702334700, query id 1667201957 10.33.221.176 analyticsUser Sending data | |
| SELECT record_id, timestamp, data FROM ANX___7LtZZXNI_ WHERE partition_key >= 20 and | |
| partition_key < 24 AND timestamp >= -9223372036854775808 AND timestamp < 9223372036854775807 LIMIT 0,2147483647 | |
| Trx read view will not see trx with id >= 296431195, sees < 296429394 | |
| ---TRANSACTION 296431014, ACTIVE 26 sec unlock_row | |
| mysql tables in use 1, locked 1 | |
| 12454 lock struct(s), heap size 1144360, 1234 row lock(s) | |
| MySQL thread id 2737069, OS thread handle 0x7f86f3bae700, query id 1667200817 10.33.221.174 connectdbuser Searching rows for update | |
| update `authenticated_login` set status='1' where msisdn='919205620785' | |
| ---TRANSACTION 296430616, ACTIVE 36 sec unlock_row | |
| mysql tables in use 1, locked 1 | |
| 19500 lock struct(s), heap size 1783336, 2 row lock(s) | |
| MySQL thread id 2735721, OS thread handle 0x7f870188a700, query id 1667198657 10.33.221.173 connectdbuser Searching rows for update | |
| update `authenticated_login` set status='1' where msisdn='917206812840' | |
| ---TRANSACTION 296430065, ACTIVE 50 sec fetching rows | |
| mysql tables in use 1, locked 0 | |
| MySQL thread id 2735195, OS thread handle 0x7f8701704700, query id 1667195568 10.33.221.176 analyticsUser Sending data | |
| SELECT record_id, timestamp, data FROM ANX___7LqLYnVI_ WHERE partition_key >= 20 and | |
| partition_key < 24 AND timestamp >= -9223372036854775808 AND timestamp < 9223372036854775807 LIMIT 0,2147483647 | |
| Trx read view will not see trx with id >= 296430066, sees < 296428685 | |
| ---TRANSACTION 296429919, ACTIVE 54 sec fetching rows | |
| mysql tables in use 1, locked 0 | |
| MySQL thread id 2737266, OS thread handle 0x7f8607618700, query id 1667194796 10.33.221.174 ApiMgtUser Creating sort index | |
| SELECT ACCESS_TOKEN, AUTHZ_USER, TOKEN_SCOPE, TOKEN_STATE, TIME_CREATED FROM IDN_OAUTH2_ACCESS_TOKEN WHERE CONSUMER_KEY = 'x-42394e36-d6b3-4405-a24f-e74d2d6e7fc3' AND REFRESH_TOKEN = '728ec8268d8b2d9e6fb2334428f0afa4' ORDER BY TIME_CREATED DESC LIMIT 1 | |
| Trx read view will not see trx with id >= 296429920, sees < 296427905 | |
| ---TRANSACTION 296429502, ACTIVE 62 sec fetching rows | |
| mysql tables in use 1, locked 0 | |
| MySQL thread id 2737134, OS thread handle 0x7f86f0d78700, query id 1667192704 10.33.221.174 ApiMgtUser Creating sort index | |
| SELECT ACCESS_TOKEN, AUTHZ_USER, TOKEN_SCOPE, TOKEN_STATE, TIME_CREATED FROM IDN_OAUTH2_ACCESS_TOKEN WHERE CONSUMER_KEY = 'x-42394e36-d6b3-4405-a24f-e74d2d6e7fc3' AND REFRESH_TOKEN = 'eaf51d719fb3098e8055d511be498f' ORDER BY TIME_CREATED DESC LIMIT 1 | |
| Trx read view will not see trx with id >= 296429503, sees < 296427905 | |
| -------- | |
| 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: complete io for buf page (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 (write thread) | |
| I/O thread 7 state: waiting for completed aio requests (write thread) | |
| I/O thread 8 state: waiting for completed aio requests (write thread) | |
| I/O thread 9 state: waiting for completed aio requests (write thread) | |
| Pending normal aio reads: 27 [0, 27, 0, 0] , aio writes: 0 [0, 0, 0, 0] , | |
| ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 | |
| Pending flushes (fsync) log: 0; buffer pool: 0 | |
| 14207228864 OS file reads, 197839293 OS file writes, 73834624 OS fsyncs | |
| 2 pending preads, 0 pending pwrites | |
| 19583.67 reads/s, 16384 avg bytes/read, 39.52 writes/s, 20.37 fsyncs/s | |
| ------------------------------------- | |
| INSERT BUFFER AND ADAPTIVE HASH INDEX | |
| ------------------------------------- | |
| Ibuf: size 1, free list len 1884, seg size 1886, 18789350 merges | |
| merged operations: | |
| insert 35298723, delete mark 7178515, delete 2013052 | |
| discarded operations: | |
| insert 637, delete mark 685, delete 0 | |
| Hash table size 276671, node heap has 45 buffer(s) | |
| 282.55 hash searches/s, 17031.98 non-hash searches/s | |
| --- | |
| LOG | |
| --- | |
| Log sequence number 169193992217 | |
| Log flushed up to 169193992217 | |
| Pages flushed up to 169193925459 | |
| Last checkpoint at 169193925459 | |
| 0 pending log writes, 0 pending chkp writes | |
| 44594760 log i/o's done, 8.97 log i/o's/second | |
| ---------------------- | |
| BUFFER POOL AND MEMORY | |
| ---------------------- | |
| Total memory allocated 137363456; in additional pool allocated 0 | |
| Dictionary memory allocated 9104950 | |
| Buffer pool size 8191 | |
| Free buffers 0 | |
| Database pages 7897 | |
| Old database pages 2922 | |
| Modified db pages 23 | |
| Pending reads 106 | |
| Pending writes: LRU 0, flush list 0, single page 0 | |
| Pages made young 915069077, not young 441782740127 | |
| 52.34 youngs/s, 236634.65 non-youngs/s | |
| Pages read 14207612382, created 4420518, written 148201579 | |
| 19597.14 reads/s, 0.29 creates/s, 28.86 writes/s | |
| Buffer pool hit rate 993 / 1000, young-making rate 0 / 1000 not 89 / 1000 | |
| Pages read ahead 4351.18/s, evicted without access 72.22/s, Random read ahead 0.00/s | |
| LRU len: 7897, unzip_LRU len: 0 | |
| I/O sum[764786]:cur[18334], unzip sum[0]:cur[0] | |
| -------------- | |
| ROW OPERATIONS | |
| -------------- | |
| 0 queries inside InnoDB, 0 queries in queue | |
| 34 read views open inside InnoDB | |
| Main thread process no. 4058, id 140217977657088, state: sleeping | |
| Number of rows inserted 60439810, updated 88009764, deleted 10856931, read 3692507583844 | |
| 9.19 inserts/s, 0.47 updates/s, 0.32 deletes/s, 3150055.68 reads/s | |
| ---------------------------- | |
| END OF INNODB MONITOR OUTPUT | |
| ============================ | |
| | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment