Skip to content

Instantly share code, notes, and snippets.

@mdcallag
Created June 21, 2023 23:43
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mdcallag/ae5e04d11f8f8fc8709cd88c65184d55 to your computer and use it in GitHub Desktop.
Save mdcallag/ae5e04d11f8f8fc8709cd88c65184d55 to your computer and use it in GitHub Desktop.
Id User Host db Command Time State Info Tid
5 event_scheduler localhost NULL Daemon 81429 Waiting on empty queue NULL 999699
1428 root localhost:54448 ib Query 68171 waiting for handler commit insert into pi1 (dateandtime,cashregisterid,customerid,productid,price,data) values ('2023-06-21 04: 999776
1429 root localhost:54458 ib Query 68171 waiting for handler commit delete from pi1 where(transactionid>=275751 and transactionid<275801) 999811
1432 root localhost:54484 ib Query 68171 waiting for handler commit insert into pi2 (dateandtime,cashregisterid,customerid,productid,price,data) values ('2023-06-21 04: 1011967
1433 root localhost:54500 ib Query 68171 waiting for handler commit delete from pi2 where(transactionid>=227401 and transactionid<227451) 999800
1436 root localhost:54526 ib Query 68171 waiting for handler commit delete from pi3 where(transactionid>=185551 and transactionid<185601) 999769
1437 root localhost:54530 ib Query 68171 waiting for handler commit insert into pi3 (dateandtime,cashregisterid,customerid,productid,price,data) values ('2023-06-21 04: 1011967
1440 root localhost:54540 ib Query 68171 waiting for handler commit delete from pi4 where(transactionid>=152401 and transactionid<152451) 1011967
1441 root localhost:54544 ib Query 68171 waiting for handler commit insert into pi4 (dateandtime,cashregisterid,customerid,productid,price,data) values ('2023-06-21 04: 999787
1444 root localhost:54572 ib Query 68171 waiting for handler commit delete from pi5 where(transactionid>=127001 and transactionid<127051) 1011967
1445 root localhost:54574 ib Query 68171 waiting for handler commit insert into pi5 (dateandtime,cashregisterid,customerid,productid,price,data) values ('2023-06-21 04: 1011967
1448 root localhost:54602 ib Query 68171 waiting for handler commit delete from pi6 where(transactionid>=108951 and transactionid<109001) 1011967
1449 root localhost:54604 ib Query 68171 waiting for handler commit insert into pi6 (dateandtime,cashregisterid,customerid,productid,price,data) values ('2023-06-21 04: 1011967
1452 root localhost:54632 ib Query 68171 waiting for handler commit delete from pi7 where(transactionid>=92101 and transactionid<92151) 1011956
1453 root localhost:54634 ib Query 68171 waiting for handler commit insert into pi7 (dateandtime,cashregisterid,customerid,productid,price,data) values ('2023-06-21 04: 1011957
1456 root localhost:54670 ib Query 68171 waiting for handler commit insert into pi8 (dateandtime,cashregisterid,customerid,productid,price,data) values ('2023-06-21 04: 1011967
1457 root localhost:54668 ib Query 68171 waiting for handler commit delete from pi8 where(transactionid>=79651 and transactionid<79701) 1011967
8273 root localhost NULL Query 0 init show processlist 1011973
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment