MariaDB [(none)]> show processlist ; +---------+----------------+------------------------------------------------------+------+---------+---------+-----------------------------------------+-------------------------------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +---------+----------------+------------------------------------------------------+------+---------+---------+-----------------------------------------+-------------------------------------------+----------+ | 1 | system user | | NULL | Sleep | 6677 | wsrep applier committed | NULL | 0.000 | | 2 | system user | | NULL | Sleep | 2459891 | wsrep aborter idle | NULL | 0.000 | | 7 | system user | | NULL | Sleep | 6869 | wsrep applier committed | NULL | 0.000 | | 8 | system user | | NULL | Sleep | 6781 | wsrep applier committed | NULL | 0.000 | | 9 | system user | | NULL | Sleep | 6759 | wsrep applier committed | NULL | 0.000 | | 11 | system user | | NULL | Sleep | 6837 | wsrep applier committed | NULL | 0.000 | | 12 | system user | | NULL | Sleep | 6839 | wsrep applier committed | NULL | 0.000 | | 13 | system user | | NULL | Sleep | 6685 | wsrep applier committed | NULL | 0.000 | | 14 | system user | | NULL | Sleep | 6783 | wsrep applier committed | NULL | 0.000 | | 15 | system user | | NULL | Sleep | 6811 | wsrep applier committed | NULL | 0.000 | | 16 | system user | | NULL | Sleep | 6909 | wsrep applier committed | NULL | 0.000 | | 17 | system user | | NULL | Sleep | 6612 | committing | NULL | 0.000 | | 18 | system user | | NULL | Sleep | 6612 | committing | NULL | 0.000 | | 19 | system user | | NULL | Sleep | 6735 | wsrep applier committed | NULL | 0.000 | | 20 | system user | | NULL | Sleep | 6845 | wsrep applier committed | NULL | 0.000 | | 21 | system user | | NULL | Sleep | 6679 | wsrep applier committed | NULL | 0.000 | | 22 | system user | | NULL | Sleep | 6492 | committing | NULL | 0.000 | | 23 | system user | | NULL | Sleep | 7078 | wsrep applier committed | NULL | 0.000 | | 24 | system user | | NULL | Sleep | 6672 | committing | NULL | 0.000 | | 25 | system user | | NULL | Sleep | 6805 | wsrep applier committed | NULL | 0.000 | | 26 | system user | | NULL | Sleep | 6753 | wsrep applier committed | NULL | 0.000 | | 27 | system user | | NULL | Sleep | 6729 | wsrep applier committed | NULL | 0.000 | | 28 | system user | | NULL | Sleep | 6821 | wsrep applier committed | NULL | 0.000 | | 29 | system user | | NULL | Sleep | 6907 | wsrep applier committed | NULL | 0.000 | | 30 | system user | | NULL | Sleep | 6789 | wsrep applier committed | NULL | 0.000 | | 31 | system user | | NULL | Sleep | 6797 | wsrep applier committed | NULL | 0.000 | | 32 | system user | | NULL | Sleep | 6859 | wsrep applier committed | NULL | 0.000 | | 33 | system user | | NULL | Sleep | 6807 | wsrep applier committed | NULL | 0.000 | | 34 | system user | | NULL | Sleep | 6749 | wsrep applier committed | NULL | 0.000 | | 35 | system user | | NULL | Sleep | 6829 | wsrep applier committed | NULL | 0.000 | | 36 | system user | | NULL | Sleep | 6879 | wsrep applier committed | NULL | 0.000 | | 37 | system user | | NULL | Sleep | 6771 | wsrep applier committed | NULL | 0.000 | | 38 | system user | | NULL | Sleep | 6552 | committing | NULL | 0.000 | | 39 | system user | | NULL | Sleep | 6767 | wsrep applier committed | NULL | 0.000 | | 40 | system user | | NULL | Sleep | 6865 | wsrep applier committed | NULL | 0.000 | | 41 | system user | | NULL | Sleep | 6893 | wsrep applier committed | NULL | 0.000 | | 42 | system user | | NULL | Sleep | 6877 | wsrep applier committed | NULL | 0.000 | | 43 | system user | | NULL | Sleep | 6747 | wsrep applier committed | NULL | 0.000 | | 44 | system user | | NULL | Sleep | 6852 | wsrep applier committed | NULL | 0.000 | | 45 | system user | | NULL | Sleep | 6853 | wsrep applier committed | NULL | 0.000 | | 46 | system user | | NULL | Sleep | 6801 | wsrep applier committed | NULL | 0.000 | | 47 | system user | | NULL | Sleep | 6757 | wsrep applier committed | NULL | 0.000 | | 48 | system user | | NULL | Sleep | 6675 | wsrep applier committed | NULL | 0.000 | | 49 | system user | | NULL | Sleep | 6903 | wsrep applier committed | NULL | 0.000 | | 50 | system user | | NULL | Sleep | 6897 | wsrep applier committed | NULL | 0.000 | | 51 | system user | | NULL | Sleep | 6895 | wsrep applier committed | NULL | 0.000 | | 52 | system user | | NULL | Sleep | 6891 | wsrep applier committed | NULL | 0.000 | | 53 | system user | | NULL | Sleep | 6769 | wsrep applier committed | NULL | 0.000 | | 54 | system user | | NULL | Sleep | 6719 | wsrep applier committed | NULL | 0.000 | | 55 | system user | | NULL | Sleep | 6855 | wsrep applier committed | NULL | 0.000 | | 56 | system user | | NULL | Sleep | 6863 | wsrep applier committed | NULL | 0.000 | | 57 | system user | | NULL | Sleep | 6815 | wsrep applier committed | NULL | 0.000 | | 58 | system user | | NULL | Sleep | 6741 | wsrep applier committed | NULL | 0.000 | | 59 | system user | | NULL | Sleep | 6793 | wsrep applier committed | NULL | 0.000 | | 60 | system user | | NULL | Sleep | 6809 | wsrep applier committed | NULL | 0.000 | | 61 | system user | | NULL | Sleep | 6889 | wsrep applier committed | NULL | 0.000 | | 62 | system user | | NULL | Sleep | 6791 | wsrep applier committed | NULL | 0.000 | | 63 | system user | | NULL | Sleep | 6813 | wsrep applier committed | NULL | 0.000 | | 10 | system user | | NULL | Sleep | 6905 | wsrep applier committed | NULL | 0.000 | | 64 | system user | | NULL | Sleep | 6871 | wsrep applier committed | NULL | 0.000 | | 65 | system user | | NULL | Sleep | 6777 | wsrep applier committed | NULL | 0.000 | | 66 | system user | | NULL | Sleep | 6755 | wsrep applier committed | NULL | 0.000 | | 67 | system user | | NULL | Sleep | 6899 | wsrep applier committed | NULL | 0.000 | | 68 | system user | | NULL | Sleep | 6883 | wsrep applier committed | NULL | 0.000 | | 69 | system user | | NULL | Sleep | 6841 | wsrep applier committed | NULL | 0.000 | | 70 | system user | | NULL | Sleep | 6779 | wsrep applier committed | NULL | 0.000 | | 71 | system user | | NULL | Sleep | 6739 | wsrep applier committed | NULL | 0.000 | | 72 | system user | | NULL | Sleep | 6819 | wsrep applier committed | NULL | 0.000 | | 73 | system user | | NULL | Sleep | 6867 | wsrep applier committed | NULL | 0.000 | | 74 | system user | | NULL | Sleep | 6887 | wsrep applier committed | NULL | 0.000 | | 75 | system user | | NULL | Sleep | 6552 | committing | NULL | 0.000 | | 76 | system user | | NULL | Sleep | 6843 | wsrep applier committed | NULL | 0.000 | | 77 | system user | | NULL | Sleep | 6831 | wsrep applier committed | NULL | 0.000 | | 78 | system user | | NULL | Sleep | 6857 | wsrep applier committed | NULL | 0.000 | | 79 | system user | | NULL | Sleep | 6785 | wsrep applier committed | NULL | 0.000 | | 80 | system user | | NULL | Sleep | 6721 | wsrep applier committed | NULL | 0.000 | | 81 | system user | | NULL | Sleep | 6835 | wsrep applier committed | NULL | 0.000 | | 82 | system user | | NULL | Sleep | 6881 | wsrep applier committed | NULL | 0.000 | | 83 | system user | | NULL | Sleep | 6787 | wsrep applier committed | NULL | 0.000 | | 84 | system user | | NULL | Sleep | 6901 | wsrep applier committed | NULL | 0.000 | | 85 | system user | | NULL | Sleep | 6849 | wsrep applier committed | NULL | 0.000 | | 86 | system user | | NULL | Sleep | 6833 | wsrep applier committed | NULL | 0.000 | | 87 | system user | | NULL | Sleep | 6847 | wsrep applier committed | NULL | 0.000 | | 88 | system user | | NULL | Sleep | 6861 | wsrep applier committed | NULL | 0.000 | | 89 | system user | | NULL | Sleep | 6727 | wsrep applier committed | NULL | 0.000 | | 90 | system user | | NULL | Sleep | 6765 | wsrep applier committed | NULL | 0.000 | | 91 | system user | | NULL | Sleep | 6875 | wsrep applier committed | NULL | 0.000 | | 92 | system user | | NULL | Sleep | 6773 | wsrep applier committed | NULL | 0.000 | | 93 | system user | | NULL | Sleep | 6745 | wsrep applier committed | NULL | 0.000 | | 94 | system user | | NULL | Sleep | 6885 | wsrep applier committed | NULL | 0.000 | | 95 | system user | | NULL | Sleep | 6795 | wsrep applier committed | NULL | 0.000 | | 96 | system user | | | Busy | 6673 | innobase_commit_low() | NULL | 0.000 | | 97 | system user | | NULL | Sleep | 6672 | Waiting for prior transaction to commit | NULL | 0.000 | | 98 | system user | | NULL | Sleep | 6717 | wsrep applier committed | NULL | 0.000 | | 99 | system user | | NULL | Sleep | 6823 | wsrep applier committed | NULL | 0.000 | | 100 | system user | | NULL | Sleep | 6873 | wsrep applier committed | NULL | 0.000 | | 101 | system user | | NULL | Sleep | 6799 | wsrep applier committed | NULL | 0.000 | | 102 | system user | | NULL | Sleep | 6743 | wsrep applier committed | NULL | 0.000 | | 105 | system user | | NULL | Sleep | 6817 | wsrep applier committed | NULL | 0.000 | | 104 | system user | | NULL | Sleep | 6491 | committing | NULL | 0.000 | | 103 | system user | | NULL | Sleep | 6827 | wsrep applier committed | NULL | 0.000 | | 112 | system user | | NULL | Sleep | 6775 | wsrep applier committed | NULL | 0.000 | | 107 | system user | | NULL | Sleep | 6731 | wsrep applier committed | NULL | 0.000 | | 106 | system user | | NULL | Sleep | 6737 | wsrep applier committed | NULL | 0.000 | | 114 | system user | | NULL | Sleep | 6803 | wsrep applier committed | NULL | 0.000 | | 111 | system user | | NULL | Sleep | 6825 | wsrep applier committed | NULL | 0.000 | | 109 | system user | | NULL | Sleep | 6732 | wsrep applier committed | NULL | 0.000 | | 110 | system user | | NULL | Sleep | 6763 | wsrep applier committed | NULL | 0.000 | | 113 | system user | | NULL | Sleep | 6751 | wsrep applier committed | NULL | 0.000 | | 118 | system user | | NULL | Sleep | 6725 | wsrep applier committed | NULL | 0.000 | | 115 | system user | | NULL | Sleep | 6761 | wsrep applier committed | NULL | 0.000 | | 108 | system user | | NULL | Sleep | 6713 | wsrep applier committed | NULL | 0.000 | | 117 | system user | | NULL | Sleep | 6723 | wsrep applier committed | NULL | 0.000 | | 116 | system user | | NULL | Sleep | 6705 | wsrep applier committed | NULL | 0.000 | | 121 | system user | | NULL | Sleep | 6711 | wsrep applier committed | NULL | 0.000 | | 122 | system user | | NULL | Sleep | 6709 | wsrep applier committed | NULL | 0.000 | | 123 | system user | | NULL | Sleep | 6715 | wsrep applier committed | NULL | 0.000 | | 124 | system user | | NULL | Sleep | 6695 | wsrep applier committed | NULL | 0.000 | | 125 | system user | | NULL | Sleep | 6697 | wsrep applier committed | NULL | 0.000 | | 126 | system user | | NULL | Sleep | 6693 | wsrep applier committed | NULL | 0.000 | | 127 | system user | | NULL | Sleep | 6699 | wsrep applier committed | NULL | 0.000 | | 128 | system user | | NULL | Sleep | 6707 | wsrep applier committed | NULL | 0.000 | | 129 | system user | | NULL | Sleep | 6701 | wsrep applier committed | NULL | 0.000 | | 130 | system user | | NULL | Sleep | 6703 | wsrep applier committed | NULL | 0.000 | | 131 | system user | | NULL | Sleep | 6687 | wsrep applier committed | NULL | 0.000 | | 132 | system user | | NULL | Sleep | 6691 | wsrep applier committed | NULL | 0.000 | | 133 | system user | | NULL | Sleep | 6689 | wsrep applier committed | NULL | 0.000 | | 134 | system user | | NULL | Sleep | 6683 | wsrep applier committed | NULL | 0.000 | | 135 | system user | | NULL | Sleep | 6681 | wsrep applier committed | NULL | 0.000 | | 3542404 | gcis_pmm | t2vdbs-gcissc-pmm02.dbaas.gcisdctr.hksarg:49928 | NULL | Query | 6648 | Filling schema table | SHOW GLOBAL STATUS | 0.000 | | 3542407 | gcis_pmm | t2vdbs-gcissc-pmm02.dbaas.gcisdctr.hksarg:49974 | NULL | Query | 6663 | Filling schema table | SHOW GLOBAL STATUS | 0.000 | | 3542419 | gcis_pmm | t2vdbs-gcissc-pmm02.dbaas.gcisdctr.hksarg:50428 | NULL | Query | 6668 | Filling schema table | SHOW GLOBAL STATUS | 0.000 | | 3542424 | gcis_dbmon | t2vdbs-gcissc-haproxy02a.dbaas.gcisdctr.hksarg:37768 | NULL | Query | 6672 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542425 | gcis_dbmon | t2vdbs-gcissc-haproxy02c.dbaas.gcisdctr.hksarg:38762 | NULL | Query | 6672 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542426 | gcis_dbmon | t2vdbs-gcissc-haproxy02b.dbaas.gcisdctr.hksarg:43508 | NULL | Query | 6672 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542427 | gcis_dbmon | t1vdbs-gcissc-haproxy02b.dbaas.gcisdctr.hksarg:44790 | NULL | Query | 6670 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542428 | gcis_dbmon | t1vdbs-gcissc-haproxy02c.dbaas.gcisdctr.hksarg:45330 | NULL | Query | 6670 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542429 | gcis_dbmon | t1vdbs-gcissc-haproxy02a.dbaas.gcisdctr.hksarg:50292 | NULL | Query | 6668 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542430 | gcis_dbmon | t2vdbs-gcissc-haproxy02a.dbaas.gcisdctr.hksarg:38724 | NULL | Query | 6663 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542431 | gcis_dbmon | t2vdbs-gcissc-haproxy02c.dbaas.gcisdctr.hksarg:39508 | NULL | Query | 6663 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542432 | gcis_dbmon | t2vdbs-gcissc-haproxy02b.dbaas.gcisdctr.hksarg:44232 | NULL | Query | 6662 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542433 | gcis_dbmon | t1vdbs-gcissc-haproxy02b.dbaas.gcisdctr.hksarg:45534 | NULL | Query | 6661 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542434 | gcis_dbmon | t1vdbs-gcissc-haproxy02c.dbaas.gcisdctr.hksarg:46074 | NULL | Query | 6660 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542435 | gcis_dbmon | t1vdbs-gcissc-haproxy02a.dbaas.gcisdctr.hksarg:51060 | NULL | Query | 6659 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542436 | gcis_pmm | t2vdbs-gcissc-pmm02.dbaas.gcisdctr.hksarg:51250 | NULL | Query | 6658 | Filling schema table | SHOW GLOBAL STATUS | 0.000 | | 3542437 | gcis_pmm | t2vdbs-gcissc-pmm02.dbaas.gcisdctr.hksarg:51294 | NULL | Query | 6653 | Filling schema table | SHOW GLOBAL STATUS | 0.000 | | 3542438 | gcis_dbmon | t2vdbs-gcissc-haproxy02a.dbaas.gcisdctr.hksarg:39518 | NULL | Query | 6654 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542439 | gcis_dbmon | t2vdbs-gcissc-haproxy02c.dbaas.gcisdctr.hksarg:40282 | NULL | Query | 6654 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542440 | gcis_dbmon | t2vdbs-gcissc-haproxy02b.dbaas.gcisdctr.hksarg:45042 | NULL | Query | 6653 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542441 | gcis_dbmon | t1vdbs-gcissc-haproxy02b.dbaas.gcisdctr.hksarg:46302 | NULL | Query | 6652 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542442 | gcis_dbmon | t1vdbs-gcissc-haproxy02c.dbaas.gcisdctr.hksarg:46838 | NULL | Query | 6651 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542443 | gcis_dbmon | t1vdbs-gcissc-haproxy02a.dbaas.gcisdctr.hksarg:51866 | NULL | Query | 6650 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542453 | gcis_pmm | t2vdbs-gcissc-pmm02.dbaas.gcisdctr.hksarg:51598 | NULL | Query | 6638 | Filling schema table | SHOW GLOBAL STATUS | 0.000 | | 3542454 | gcis_pmm | t2vdbs-gcissc-pmm02.dbaas.gcisdctr.hksarg:51640 | NULL | Query | 6643 | Filling schema table | SHOW GLOBAL STATUS | 0.000 | | 3542455 | gcis_dbmon | t2vdbs-gcissc-haproxy02a.dbaas.gcisdctr.hksarg:40272 | NULL | Query | 6645 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542456 | gcis_dbmon | t2vdbs-gcissc-haproxy02c.dbaas.gcisdctr.hksarg:41056 | NULL | Query | 6644 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542457 | gcis_dbmon | t2vdbs-gcissc-haproxy02b.dbaas.gcisdctr.hksarg:45788 | NULL | Query | 6644 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542458 | gcis_dbmon | t1vdbs-gcissc-haproxy02b.dbaas.gcisdctr.hksarg:47060 | NULL | Query | 6643 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542459 | gcis_dbmon | t1vdbs-gcissc-haproxy02c.dbaas.gcisdctr.hksarg:47602 | NULL | Query | 6642 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542460 | gcis_dbmon | t1vdbs-gcissc-haproxy02a.dbaas.gcisdctr.hksarg:52698 | NULL | Query | 6641 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542461 | gcis_pmm | t2vdbs-gcissc-pmm02.dbaas.gcisdctr.hksarg:51938 | NULL | Query | 6633 | Filling schema table | SHOW GLOBAL STATUS | 0.000 | | 3542462 | gcis_pmm | t2vdbs-gcissc-pmm02.dbaas.gcisdctr.hksarg:51984 | NULL | Query | 6628 | Filling schema table | SHOW GLOBAL STATUS | 0.000 | | 3542463 | gcis_dbmon | t2vdbs-gcissc-haproxy02a.dbaas.gcisdctr.hksarg:41128 | NULL | Query | 6635 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542464 | gcis_dbmon | t2vdbs-gcissc-haproxy02c.dbaas.gcisdctr.hksarg:41816 | NULL | Query | 6635 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542465 | gcis_dbmon | t2vdbs-gcissc-haproxy02b.dbaas.gcisdctr.hksarg:46538 | NULL | Query | 6635 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542466 | gcis_dbmon | t1vdbs-gcissc-haproxy02b.dbaas.gcisdctr.hksarg:47864 | NULL | Query | 6634 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542467 | gcis_dbmon | t1vdbs-gcissc-haproxy02c.dbaas.gcisdctr.hksarg:48404 | NULL | Query | 6633 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542468 | gcis_dbmon | t1vdbs-gcissc-haproxy02a.dbaas.gcisdctr.hksarg:53582 | NULL | Query | 6631 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542469 | gcis_pmm | t2vdbs-gcissc-pmm02.dbaas.gcisdctr.hksarg:52238 | NULL | Query | 6618 | Filling schema table | SHOW GLOBAL STATUS | 0.000 | | 3542472 | gcis_dbmon | t2vdbs-gcissc-haproxy02a.dbaas.gcisdctr.hksarg:41864 | NULL | Query | 6626 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542473 | gcis_dbmon | t2vdbs-gcissc-haproxy02c.dbaas.gcisdctr.hksarg:42562 | NULL | Query | 6626 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542474 | gcis_dbmon | t2vdbs-gcissc-haproxy02b.dbaas.gcisdctr.hksarg:47278 | NULL | Query | 6625 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542475 | gcis_dbmon | t1vdbs-gcissc-haproxy02b.dbaas.gcisdctr.hksarg:48582 | NULL | Query | 6624 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542476 | gcis_dbmon | t1vdbs-gcissc-haproxy02c.dbaas.gcisdctr.hksarg:49134 | NULL | Query | 6624 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542478 | gcis_dbmon | t1vdbs-gcissc-haproxy02a.dbaas.gcisdctr.hksarg:54542 | NULL | Query | 6622 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542480 | gcis_dbmon | t2vdbs-gcissc-haproxy02a.dbaas.gcisdctr.hksarg:42662 | NULL | Query | 6617 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542483 | gcis_dbmon | t2vdbs-gcissc-haproxy02c.dbaas.gcisdctr.hksarg:43334 | NULL | Query | 6617 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542484 | gcis_dbmon | t2vdbs-gcissc-haproxy02b.dbaas.gcisdctr.hksarg:48000 | NULL | Query | 6616 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542485 | gcis_dbmon | t1vdbs-gcissc-haproxy02b.dbaas.gcisdctr.hksarg:49372 | NULL | Query | 6615 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542486 | gcis_dbmon | t1vdbs-gcissc-haproxy02c.dbaas.gcisdctr.hksarg:49904 | NULL | Query | 6614 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542489 | gcis_dbmon | t1vdbs-gcissc-haproxy02a.dbaas.gcisdctr.hksarg:55506 | NULL | Query | 6613 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542494 | gcis_dbmon | t2vdbs-gcissc-haproxy02a.dbaas.gcisdctr.hksarg:43572 | NULL | Query | 6608 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542495 | gcis_dbmon | t2vdbs-gcissc-haproxy02c.dbaas.gcisdctr.hksarg:44108 | NULL | Query | 6608 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542498 | gcis_dbmon | t2vdbs-gcissc-haproxy02b.dbaas.gcisdctr.hksarg:48738 | NULL | Query | 6607 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542499 | gcis_dbmon | t1vdbs-gcissc-haproxy02b.dbaas.gcisdctr.hksarg:50108 | NULL | Query | 6606 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542500 | gcis_dbmon | t1vdbs-gcissc-haproxy02c.dbaas.gcisdctr.hksarg:50670 | NULL | Query | 6605 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542501 | gcis_dbmon | t1vdbs-gcissc-haproxy02a.dbaas.gcisdctr.hksarg:56590 | NULL | Query | 6604 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542504 | gcis_dbmon | t2vdbs-gcissc-haproxy02a.dbaas.gcisdctr.hksarg:44322 | NULL | Query | 6599 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542505 | gcis_dbmon | t2vdbs-gcissc-haproxy02c.dbaas.gcisdctr.hksarg:44878 | NULL | Query | 6599 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542508 | gcis_dbmon | t2vdbs-gcissc-haproxy02b.dbaas.gcisdctr.hksarg:49494 | NULL | Query | 6597 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542511 | gcis_dbmon | t1vdbs-gcissc-haproxy02b.dbaas.gcisdctr.hksarg:50922 | NULL | Query | 6597 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542512 | gcis_dbmon | t1vdbs-gcissc-haproxy02c.dbaas.gcisdctr.hksarg:51440 | NULL | Query | 6596 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542513 | gcis_dbmon | t1vdbs-gcissc-haproxy02a.dbaas.gcisdctr.hksarg:57410 | NULL | Query | 6595 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542516 | gcis_dbmon | t2vdbs-gcissc-haproxy02c.dbaas.gcisdctr.hksarg:45620 | NULL | Query | 6589 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542517 | gcis_dbmon | t2vdbs-gcissc-haproxy02a.dbaas.gcisdctr.hksarg:45200 | NULL | Query | 6589 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542520 | root | localhost | NULL | Query | 6589 | Filling schema table | SHOW status like 'wsrep_cluster_size' | 0.000 | | 3542522 | root | localhost | NULL | Query | 6588 | Filling schema table | show status like 'wsrep_local_state_uuid' | 0.000 | | 3542525 | gcis_dbmon | t2vdbs-gcissc-haproxy02b.dbaas.gcisdctr.hksarg:50248 | NULL | Query | 6588 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542532 | gcis_dbmon | t1vdbs-gcissc-haproxy02b.dbaas.gcisdctr.hksarg:51648 | NULL | Query | 6588 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542536 | gcis_dbmon | t1vdbs-gcissc-haproxy02c.dbaas.gcisdctr.hksarg:52222 | NULL | Query | 6587 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542537 | gcis_dbmon | t1vdbs-gcissc-haproxy02a.dbaas.gcisdctr.hksarg:58190 | NULL | Query | 6585 | Filling schema table | show status like 'wsrep_ready' | 0.000 | | 3542750 | root | localhost | NULL | Query | 6469 | Filling schema table | show status like 'wsrep_local_state_uuid' | 0.000 | | 3542751 | root | localhost | NULL | Query | 6469 | Filling schema table | SHOW status like 'wsrep_cluster_size' | 0.000 | | 3542985 | root | localhost | NULL | Query | 6348 | Filling schema table | show status like 'wsrep_local_state_uuid' | 0.000 | | 3542989 | root | localhost | NULL | Query | 6348 | Filling schema table | SHOW status like 'wsrep_cluster_size' | 0.000 | | 3543221 | root | localhost | NULL | Query | 6228 | Filling schema table | show status like 'wsrep_local_state_uuid' | 0.000 | | 3543222 | root | localhost | NULL | Query | 6228 | Filling schema table | SHOW status like 'wsrep_cluster_size' | 0.000 | | 3543456 | root | localhost | NULL | Query | 6109 | Filling schema table | show status like 'wsrep_local_state_uuid' | 0.000 | | 3543458 | root | localhost | NULL | Query | 6109 | Filling schema table | SHOW status like 'wsrep_cluster_size' | 0.000 | | 3543691 | root | localhost | NULL | Query | 5989 | Filling schema table | show status like 'wsrep_local_state_uuid' | 0.000 | | 3543694 | root | localhost | NULL | Query | 5989 | Filling schema table | SHOW status like 'wsrep_cluster_size' | 0.000 | | 3543960 | root | localhost | NULL | Query | 5869 | Filling schema table | show status like 'wsrep_local_state_uuid' | 0.000 | | 3543963 | root | localhost | NULL | Query | 5869 | Filling schema table | SHOW status like 'wsrep_cluster_size' | 0.000 | | 3544195 | root | localhost | NULL | Query | 5749 | Filling schema table | SHOW status like 'wsrep_cluster_size' | 0.000 | | 3544196 | root | localhost | NULL | Query | 5749 | Filling schema table | show status like 'wsrep_local_state_uuid' | 0.000 | | 3544431 | root | localhost | NULL | Query | 5629 | Filling schema table | show status like 'wsrep_local_state_uuid' | 0.000 | | 3544432 | root | localhost | NULL | Query | 5628 | Filling schema table | SHOW status like 'wsrep_cluster_size' | 0.000 | | 3544666 | root | localhost | NULL | Query | 5509 | Filling schema table | SHOW status like 'wsrep_cluster_size' | 0.000 | | 3544668 | root | localhost | NULL | Query | 5509 | Filling schema table | show status like 'wsrep_local_state_uuid' | 0.000 | | 3544900 | root | localhost | NULL | Query | 5389 | Filling schema table | show status like 'wsrep_local_state_uuid' | 0.000 | | 3544904 | root | localhost | NULL | Query | 5389 | Filling schema table | SHOW status like 'wsrep_cluster_size' | 0.000 | | 3545137 | root | localhost | NULL | Query | 5268 | Filling schema table | show status like 'wsrep_local_state_uuid' | 0.000 | | 3545139 | root | localhost | NULL | Query | 5268 | Filling schema table | SHOW status like 'wsrep_cluster_size' | 0.000 | | 3545370 | root | localhost | NULL | Query | 5149 | Filling schema table | show status like 'wsrep_local_state_uuid' | 0.000 | | 3545372 | root | localhost | NULL | Query | 5149 | Filling schema table | SHOW status like 'wsrep_cluster_size' | 0.000 | | 3545607 | root | localhost | NULL | Query | 5029 | Filling schema table | SHOW status like 'wsrep_cluster_size' | 0.000 | | 3545608 | root | localhost | NULL | Query | 5029 | Filling schema table | show status like 'wsrep_local_state_uuid' | 0.000 | | 3545876 | root | localhost | NULL | Query | 4908 | Filling schema table | show status like 'wsrep_local_state_uuid' | 0.000 | | 3545877 | root | localhost | NULL | Query | 4908 | Filling schema table | SHOW status like 'wsrep_cluster_size' | 0.000 | | 3546113 | root | localhost | NULL | Query | 4788 | Filling schema table | show status like 'wsrep_local_state_uuid' | 0.000 | | 3546114 | root | localhost | NULL | Query | 4788 | Filling schema table | SHOW status like 'wsrep_cluster_size' | 0.000 | | 3546348 | root | localhost | NULL | Query | 4668 | Filling schema table | show status like 'wsrep_local_state_uuid' | 0.000 | | 3546349 | root | localhost | NULL | Query | 4668 | Filling schema table | SHOW status like 'wsrep_cluster_size' | 0.000 | | 3546582 | root | localhost | NULL | Query | 4548 | Filling schema table | show status like 'wsrep_local_state_uuid' | 0.000 | | 3546583 | root | localhost | NULL | Query | 4548 | Filling schema table | SHOW status like 'wsrep_cluster_size' | 0.000 | | 3546818 | root | localhost | NULL | Query | 4428 | Filling schema table | show status like 'wsrep_local_state_uuid' | 0.000 | | 3546821 | root | localhost | NULL | Query | 4428 | Filling schema table | SHOW status like 'wsrep_cluster_size' | 0.000 | | 3547054 | root | localhost | NULL | Query | 4309 | Filling schema table | show status like 'wsrep_local_state_uuid' | 0.000 | | 3547055 | root | localhost | NULL | Query | 4309 | Filling schema table | SHOW status like 'wsrep_cluster_size' | 0.000 | | 3547290 | root | localhost | NULL | Query | 4189 | Filling schema table | show status like 'wsrep_local_state_uuid' | 0.000 | | 3547292 | root | localhost | NULL | Query | 4188 | Filling schema table | SHOW status like 'wsrep_cluster_size' | 0.000 | | 3547558 | root | localhost | NULL | Query | 4069 | Filling schema table | show status like 'wsrep_local_state_uuid' | 0.000 | | 3547559 | root | localhost | NULL | Query | 4069 | Filling schema table | SHOW status like 'wsrep_cluster_size' | 0.000 | | 3547793 | root | localhost | NULL | Query | 3949 | Filling schema table | SHOW status like 'wsrep_cluster_size' | 0.000 | | 3547794 | root | localhost | NULL | Query | 3948 | Filling schema table | show status like 'wsrep_local_state_uuid' | 0.000 | | 3548028 | root | localhost | NULL | Query | 3829 | Filling schema table | show status like 'wsrep_local_state_uuid' | 0.000 | | 3548029 | root | localhost | NULL | Query | 3829 | Filling schema table | SHOW status like 'wsrep_cluster_size' | 0.000 | | 3548265 | root | localhost | NULL | Query | 3709 | Filling schema table | show status like 'wsrep_local_state_uuid' | 0.000 | | 3548266 | root | localhost | NULL | Query | 3709 | Filling schema table | SHOW status like 'wsrep_cluster_size' | 0.000 | | 3548500 | root | localhost | NULL | Query | 3589 | Filling schema table | show status like 'wsrep_local_state_uuid' | 0.000 | | 3548503 | root | localhost | NULL | Query | 3589 | Filling schema table | SHOW status like 'wsrep_cluster_size' | 0.000 | | 3548735 | root | localhost | NULL | Query | 3469 | Filling schema table | SHOW status like 'wsrep_cluster_size' | 0.000 | | 3548736 | root | localhost | NULL | Query | 3469 | Filling schema table | show status like 'wsrep_local_state_uuid' | 0.000 | | 3548970 | root | localhost | NULL | Query | 3348 | Filling schema table | show status like 'wsrep_local_state_uuid' | 0.000 | | 3548973 | root | localhost | NULL | Query | 3348 | Filling schema table | SHOW status like 'wsrep_cluster_size' | 0.000 | | 3549205 | root | localhost | NULL | Query | 3229 | Filling schema table | show status like 'wsrep_local_state_uuid' | 0.000 | | 3549207 | root | localhost | NULL | Query | 3229 | Filling schema table | SHOW status like 'wsrep_cluster_size' | 0.000 | | 3549473 | root | localhost | NULL | Query | 3109 | Filling schema table | show status like 'wsrep_local_state_uuid' | 0.000 | | 3549476 | root | localhost | NULL | Query | 3109 | Filling schema table | SHOW status like 'wsrep_cluster_size' | 0.000 | | 3549708 | root | localhost | NULL | Query | 2989 | Filling schema table | show status like 'wsrep_local_state_uuid' | 0.000 | | 3549710 | root | localhost | NULL | Query | 2988 | Filling schema table | SHOW status like 'wsrep_cluster_size' | 0.000 | | 3549943 | root | localhost | NULL | Query | 2868 | Filling schema table | show status like 'wsrep_local_state_uuid' | 0.000 | | 3549944 | root | localhost | NULL | Query | 2868 | Filling schema table | SHOW status like 'wsrep_cluster_size' | 0.000 | | 3550178 | root | localhost | NULL | Query | 2749 | Filling schema table | SHOW status like 'wsrep_cluster_size' | 0.000 | | 3550179 | root | localhost | NULL | Query | 2749 | Filling schema table | show status like 'wsrep_local_state_uuid' | 0.000 | | 3550414 | root | localhost | NULL | Query | 2629 | Filling schema table | show status like 'wsrep_local_state_uuid' | 0.000 | | 3550415 | root | localhost | NULL | Query | 2629 | Filling schema table | SHOW status like 'wsrep_cluster_size' | 0.000 | | 3550650 | root | localhost | NULL | Query | 2508 | Filling schema table | show status like 'wsrep_local_state_uuid' | 0.000 | | 3550651 | root | localhost | NULL | Query | 2508 | Filling schema table | SHOW status like 'wsrep_cluster_size' | 0.000 | | 3550884 | root | localhost | NULL | Query | 2389 | Filling schema table | SHOW status like 'wsrep_cluster_size' | 0.000 | | 3550887 | root | localhost | NULL | Query | 2389 | Filling schema table | show status like 'wsrep_local_state_uuid' | 0.000 | | 3551151 | root | localhost | NULL | Query | 2269 | Filling schema table | show status like 'wsrep_local_state_uuid' | 0.000 | | 3551153 | root | localhost | NULL | Query | 2269 | Filling schema table | SHOW status like 'wsrep_cluster_size' | 0.000 | | 3551387 | root | localhost | NULL | Query | 2149 | Filling schema table | SHOW status like 'wsrep_cluster_size' | 0.000 | | 3551388 | root | localhost | NULL | Query | 2149 | Filling schema table | show status like 'wsrep_local_state_uuid' | 0.000 | | 3551629 | root | localhost | NULL | Query | 2026 | Filling schema table | show status like 'wsrep_local_state_uuid' | 0.000 | | 3551631 | root | localhost | NULL | Query | 2026 | Filling schema table | SHOW status like 'wsrep_cluster_size' | 0.000 | | 3551858 | root | localhost | NULL | Query | 1909 | Filling schema table | show status like 'wsrep_local_state_uuid' | 0.000 | | 3551860 | root | localhost | NULL | Query | 1909 | Filling schema table | SHOW status like 'wsrep_cluster_size' | 0.000 | | 3552093 | root | localhost | NULL | Query | 1789 | Filling schema table | show status like 'wsrep_local_state_uuid' | 0.000 | | 3552094 | root | localhost | NULL | Query | 1789 | Filling schema table | SHOW status like 'wsrep_cluster_size' | 0.000 | | 3552329 | root | localhost | NULL | Query | 1668 | Filling schema table | SHOW status like 'wsrep_cluster_size' | 0.000 | | 3552330 | root | localhost | NULL | Query | 1668 | Filling schema table | show status like 'wsrep_local_state_uuid' | 0.000 | | 3552563 | root | localhost | NULL | Query | 1549 | Filling schema table | show status like 'wsrep_local_state_uuid' | 0.000 | | 3552565 | root | localhost | NULL | Query | 1549 | Filling schema table | SHOW status like 'wsrep_cluster_size' | 0.000 | | 3552800 | root | localhost | NULL | Query | 1428 | Filling schema table | SHOW status like 'wsrep_cluster_size' | 0.000 | | 3552804 | root | localhost | NULL | Query | 1428 | Filling schema table | show status like 'wsrep_local_state_uuid' | 0.000 | | 3553067 | root | localhost | NULL | Query | 1308 | Filling schema table | show status like 'wsrep_local_state_uuid' | 0.000 | | 3553068 | root | localhost | NULL | Query | 1308 | Filling schema table | SHOW status like 'wsrep_cluster_size' | 0.000 | | 3553080 | gcis_bkup_oper | localhost | NULL | Query | 1306 | starting | flush binary logs | 0.000 | | 3553302 | root | localhost | NULL | Query | 1189 | Filling schema table | show status like 'wsrep_local_state_uuid' | 0.000 | | 3553304 | root | localhost | NULL | Query | 1189 | Filling schema table | SHOW status like 'wsrep_cluster_size' | 0.000 | | 3553538 | root | localhost | NULL | Query | 1069 | Filling schema table | SHOW status like 'wsrep_cluster_size' | 0.000 | | 3553539 | root | localhost | NULL | Query | 1068 | Filling schema table | show status like 'wsrep_local_state_uuid' | 0.000 | | 3553771 | root | localhost | NULL | Query | 949 | Filling schema table | show status like 'wsrep_local_state_uuid' | 0.000 | | 3553772 | root | localhost | NULL | Query | 949 | Filling schema table | SHOW status like 'wsrep_cluster_size' | 0.000 | | 3553826 | root | localhost | NULL | Killed | 892 | Filling schema table | show status like 'wsrep_last_committed' | 0.000 | | 3554009 | root | localhost | NULL | Query | 828 | Filling schema table | show status like 'wsrep_local_state_uuid' | 0.000 | | 3554011 | root | localhost | NULL | Query | 828 | Filling schema table | SHOW status like 'wsrep_cluster_size' | 0.000 | | 3554246 | root | localhost | NULL | Query | 708 | Filling schema table | show status like 'wsrep_local_state_uuid' | 0.000 | | 3554247 | root | localhost | NULL | Query | 708 | Filling schema table | SHOW status like 'wsrep_cluster_size' | 0.000 | | 3554252 | root | localhost | NULL | Query | 708 | acquiring total order isolation | flush error logs | 0.000 | | 3554481 | root | localhost | NULL | Query | 589 | Filling schema table | SHOW status like 'wsrep_cluster_size' | 0.000 | | 3554482 | root | localhost | NULL | Query | 589 | Filling schema table | show status like 'wsrep_local_state_uuid' | 0.000 | | 3554750 | root | localhost | NULL | Query | 468 | Filling schema table | SHOW status like 'wsrep_cluster_size' | 0.000 | | 3554751 | root | localhost | NULL | Query | 468 | Filling schema table | show status like 'wsrep_local_state_uuid' | 0.000 | | 3554985 | root | localhost | NULL | Query | 348 | Filling schema table | show status like 'wsrep_local_state_uuid' | 0.000 | | 3554986 | root | localhost | NULL | Query | 348 | Filling schema table | SHOW status like 'wsrep_cluster_size' | 0.000 | | 3555219 | root | localhost | NULL | Query | 229 | Filling schema table | show status like 'wsrep_local_state_uuid' | 0.000 | | 3555222 | root | localhost | NULL | Query | 228 | Filling schema table | SHOW status like 'wsrep_cluster_size' | 0.000 | | 3555455 | root | localhost | NULL | Query | 109 | Filling schema table | show status like 'wsrep_local_state_uuid' | 0.000 | | 3555458 | root | localhost | NULL | Query | 109 | Filling schema table | SHOW status like 'wsrep_cluster_size' | 0.000 | | 3555664 | gcis_dbmon | localhost | NULL | Query | 0 | starting | show processlist | 0.000 | +---------+----------------+------------------------------------------------------+------+---------+---------+-----------------------------------------+-------------------------------------------+----------+ 313 rows in set (0.001 sec) MariaDB [(none)]> SELECT * FROM information_schema.innodb_trx order by trx_started \G *************************** 1. row *************************** trx_id: 22120903 trx_state: RUNNING trx_started: 2024-03-22 22:32:38 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 3 trx_mysql_thread_id: 96 trx_query: NULL trx_operation_state: committing trx_tables_in_use: 0 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 1 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 2. row *************************** trx_id: 22120905 trx_state: RUNNING trx_started: 2024-03-22 22:32:39 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 97 trx_query: NULL trx_operation_state: trx_tables_in_use: 0 trx_tables_locked: 1 trx_lock_structs: 1 trx_lock_memory_bytes: 1128 trx_rows_locked: 0 trx_rows_modified: 1 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 3. row *************************** trx_id: 22120906 trx_state: RUNNING trx_started: 2024-03-22 22:32:39 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 24 trx_query: NULL trx_operation_state: trx_tables_in_use: 0 trx_tables_locked: 1 trx_lock_structs: 1 trx_lock_memory_bytes: 1128 trx_rows_locked: 0 trx_rows_modified: 1 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 4. row *************************** trx_id: 22120907 trx_state: RUNNING trx_started: 2024-03-22 22:33:38 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 18 trx_query: NULL trx_operation_state: trx_tables_in_use: 0 trx_tables_locked: 1 trx_lock_structs: 1 trx_lock_memory_bytes: 1128 trx_rows_locked: 0 trx_rows_modified: 1 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 5. row *************************** trx_id: 22120908 trx_state: RUNNING trx_started: 2024-03-22 22:33:39 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 17 trx_query: NULL trx_operation_state: trx_tables_in_use: 0 trx_tables_locked: 1 trx_lock_structs: 1 trx_lock_memory_bytes: 1128 trx_rows_locked: 0 trx_rows_modified: 1 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 6. row *************************** trx_id: 22120909 trx_state: RUNNING trx_started: 2024-03-22 22:34:39 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 75 trx_query: NULL trx_operation_state: trx_tables_in_use: 0 trx_tables_locked: 1 trx_lock_structs: 1 trx_lock_memory_bytes: 1128 trx_rows_locked: 0 trx_rows_modified: 1 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 7. row *************************** trx_id: 22120910 trx_state: RUNNING trx_started: 2024-03-22 22:34:39 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 38 trx_query: NULL trx_operation_state: trx_tables_in_use: 0 trx_tables_locked: 1 trx_lock_structs: 1 trx_lock_memory_bytes: 1128 trx_rows_locked: 0 trx_rows_modified: 1 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 8. row *************************** trx_id: 22120912 trx_state: RUNNING trx_started: 2024-03-22 22:35:39 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 104 trx_query: NULL trx_operation_state: trx_tables_in_use: 0 trx_tables_locked: 1 trx_lock_structs: 1 trx_lock_memory_bytes: 1128 trx_rows_locked: 0 trx_rows_modified: 1 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 9. row *************************** trx_id: 22120911 trx_state: RUNNING trx_started: 2024-03-22 22:35:39 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 22 trx_query: NULL trx_operation_state: trx_tables_in_use: 0 trx_tables_locked: 1 trx_lock_structs: 1 trx_lock_memory_bytes: 1128 trx_rows_locked: 0 trx_rows_modified: 1 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 9 rows in set (0.001 sec) MariaDB [(none)]> MariaDB [(none)]> MariaDB [(none)]> MariaDB [(none)]> SELECT * FROM information_schema.innodb_trx order by trx_started \G *************************** 1. row *************************** trx_id: 22120903 trx_state: RUNNING trx_started: 2024-03-22 22:32:38 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 3 trx_mysql_thread_id: 96 trx_query: NULL trx_operation_state: committing trx_tables_in_use: 0 trx_tables_locked: 1 trx_lock_structs: 2 trx_lock_memory_bytes: 1128 trx_rows_locked: 1 trx_rows_modified: 1 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 2. row *************************** trx_id: 22120905 trx_state: RUNNING trx_started: 2024-03-22 22:32:39 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 97 trx_query: NULL trx_operation_state: trx_tables_in_use: 0 trx_tables_locked: 1 trx_lock_structs: 1 trx_lock_memory_bytes: 1128 trx_rows_locked: 0 trx_rows_modified: 1 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 3. row *************************** trx_id: 22120906 trx_state: RUNNING trx_started: 2024-03-22 22:32:39 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 24 trx_query: NULL trx_operation_state: trx_tables_in_use: 0 trx_tables_locked: 1 trx_lock_structs: 1 trx_lock_memory_bytes: 1128 trx_rows_locked: 0 trx_rows_modified: 1 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 4. row *************************** trx_id: 22120907 trx_state: RUNNING trx_started: 2024-03-22 22:33:38 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 18 trx_query: NULL trx_operation_state: trx_tables_in_use: 0 trx_tables_locked: 1 trx_lock_structs: 1 trx_lock_memory_bytes: 1128 trx_rows_locked: 0 trx_rows_modified: 1 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 5. row *************************** trx_id: 22120908 trx_state: RUNNING trx_started: 2024-03-22 22:33:39 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 17 trx_query: NULL trx_operation_state: trx_tables_in_use: 0 trx_tables_locked: 1 trx_lock_structs: 1 trx_lock_memory_bytes: 1128 trx_rows_locked: 0 trx_rows_modified: 1 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 6. row *************************** trx_id: 22120909 trx_state: RUNNING trx_started: 2024-03-22 22:34:39 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 75 trx_query: NULL trx_operation_state: trx_tables_in_use: 0 trx_tables_locked: 1 trx_lock_structs: 1 trx_lock_memory_bytes: 1128 trx_rows_locked: 0 trx_rows_modified: 1 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 7. row *************************** trx_id: 22120910 trx_state: RUNNING trx_started: 2024-03-22 22:34:39 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 38 trx_query: NULL trx_operation_state: trx_tables_in_use: 0 trx_tables_locked: 1 trx_lock_structs: 1 trx_lock_memory_bytes: 1128 trx_rows_locked: 0 trx_rows_modified: 1 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 8. row *************************** trx_id: 22120912 trx_state: RUNNING trx_started: 2024-03-22 22:35:39 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 104 trx_query: NULL trx_operation_state: trx_tables_in_use: 0 trx_tables_locked: 1 trx_lock_structs: 1 trx_lock_memory_bytes: 1128 trx_rows_locked: 0 trx_rows_modified: 1 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 *************************** 9. row *************************** trx_id: 22120911 trx_state: RUNNING trx_started: 2024-03-22 22:35:39 trx_requested_lock_id: NULL trx_wait_started: NULL trx_weight: 2 trx_mysql_thread_id: 22 trx_query: NULL trx_operation_state: trx_tables_in_use: 0 trx_tables_locked: 1 trx_lock_structs: 1 trx_lock_memory_bytes: 1128 trx_rows_locked: 0 trx_rows_modified: 1 trx_concurrency_tickets: 0 trx_isolation_level: READ COMMITTED trx_unique_checks: 1 trx_foreign_key_checks: 1 trx_last_foreign_key_error: NULL trx_is_read_only: 0 trx_autocommit_non_locking: 0 9 rows in set (0.001 sec)