x01sibdb6a - 10.93.98.94 20230112_033302 : show full processlist +--------+-------------+---------------------+---------+--------------+--------+--------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +--------+-------------+---------------------+---------+--------------+--------+--------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+ | 3990 | system user | | NULL | Slave_IO | 471886 | Waiting for master to send event | NULL | 0.000 | | 3992 | system user | | NULL | Slave_worker | 129 | Waiting for prior transaction to commit | NULL | 0.000 | | 3993 | system user | | NULL | Slave_worker | 129 | Waiting for backup lock | NULL | 0.000 | | 3994 | system user | | bankfrm | Slave_worker | 129 | Waiting for prior transaction to commit | XA COMMIT X'00000000000000000000ffff0a5d63a10605f71c63bef4d3002d89d931',X'00000000000000000000ffff0a5d63a10605f71c63bef4d3002d89e40000000900000000',131077 | 0.000 | | 3996 | system user | | NULL | Slave_worker | 129 | Waiting for prior transaction to commit | NULL | 0.000 | | 3995 | system user | | NULL | Slave_worker | 129 | Waiting for prior transaction to commit | NULL | 0.000 | | 3997 | system user | | NULL | Slave_worker | 129 | Waiting for prior transaction to commit | NULL | 0.000 | | 3991 | system user | | NULL | Slave_SQL | 176 | Slave has read all relay log; waiting for more updates | NULL | 0.000 | | 4098 | repuser | 10.93.97.53:43018 | NULL | Sleep | 0 | | NULL | 0.000 | | 4099 | repuser | 10.93.97.61:39228 | NULL | Sleep | 3 | | NULL | 0.000 | | 4152 | repuser | 10.93.97.40:36096 | NULL | Sleep | 1 | | NULL | 0.000 | | 4219 | repuser | 10.93.97.4:12030 | NULL | Sleep | 3 | | NULL | 0.000 | | 4220 | repuser | 10.93.97.59:43524 | NULL | Sleep | 4 | | NULL | 0.000 | | 4221 | repuser | 10.93.97.57:52766 | NULL | Sleep | 4 | | NULL | 0.000 | | 4222 | repuser | 10.93.97.58:57944 | NULL | Sleep | 1 | | NULL | 0.000 | | 4264 | repuser | 10.93.97.6:31482 | NULL | Sleep | 4 | | NULL | 0.000 | | 4265 | repuser | 10.93.98.38:42776 | NULL | Sleep | 2 | | NULL | 0.000 | | 4266 | repuser | 10.93.97.54:53610 | NULL | Sleep | 4 | | NULL | 0.000 | | 4267 | repuser | 10.93.97.51:48874 | NULL | Sleep | 4 | | NULL | 0.000 | | 4268 | repuser | 10.93.97.52:53930 | NULL | Sleep | 3 | | NULL | 0.000 | | 4269 | repuser | 10.93.98.28:33794 | NULL | Sleep | 1 | | NULL | 0.000 | | 4270 | repuser | 10.91.135.92:59826 | NULL | Sleep | 0 | | NULL | 0.000 | | 4271 | repuser | 10.91.135.91:54198 | NULL | Sleep | 0 | | NULL | 0.000 | | 4272 | repuser | 10.93.97.55:53070 | NULL | Sleep | 2 | | NULL | 0.000 | | 4305 | bankfrm | 10.93.97.48:45170 | bankfrm | Sleep | 97 | | NULL | 0.000 | | 4392 | repuser | 10.93.97.56:39294 | NULL | Sleep | 3 | | NULL | 0.000 | | 4440 | repuser | 10.93.98.4:35714 | NULL | Sleep | 2 | | NULL | 0.000 | | 4451 | repuser | 10.93.97.41:57874 | NULL | Sleep | 2 | | NULL | 0.000 | | 4507 | repuser | 10.93.97.28:34304 | NULL | Sleep | 0 | | NULL | 0.000 | | 4509 | repuser | 10.93.97.48:47230 | NULL | Sleep | 2 | | NULL | 0.000 | | 4511 | repuser | 10.93.97.47:48344 | NULL | Sleep | 1 | | NULL | 0.000 | | 4694 | repuser | 10.93.97.46:52796 | NULL | Sleep | 4 | | NULL | 0.000 | | 4695 | repuser | 10.93.98.37:53620 | NULL | Sleep | 5 | | NULL | 0.000 | | 4697 | repuser | 10.93.97.49:41804 | NULL | Sleep | 2 | | NULL | 0.000 | | 4698 | repuser | 10.93.97.5:56378 | NULL | Sleep | 4 | | NULL | 0.000 | | 4699 | repuser | 10.93.97.50:39682 | NULL | Sleep | 3 | | NULL | 0.000 | | 4828 | bankfrm | 10.93.97.52:34862 | bankfrm | Sleep | 65 | | NULL | 0.000 | | 4976 | repuser | 10.93.97.43:39274 | NULL | Sleep | 2 | | NULL | 0.000 | | 4977 | repuser | 10.93.98.40:58702 | NULL | Sleep | 0 | | NULL | 0.000 | | 4978 | repuser | 10.93.98.41:35830 | NULL | Sleep | 0 | | NULL | 0.000 | | 4979 | repuser | 10.93.99.157:47342 | NULL | Sleep | 4 | | NULL | 0.000 | | 4981 | repuser | 10.93.97.37:34196 | NULL | Sleep | 3 | | NULL | 0.000 | | 4982 | repuser | 10.93.97.44:43960 | NULL | Sleep | 2 | | NULL | 0.000 | | 5024 | repuser | 10.93.97.38:55708 | NULL | Sleep | 4 | | NULL | 0.000 | | 5025 | repuser | 10.93.97.29:43022 | NULL | Sleep | 2 | | NULL | 0.000 | | 5026 | repuser | 10.93.99.159:51048 | NULL | Sleep | 3 | | NULL | 0.000 | | 5114 | repuser | 10.93.99.158:52012 | NULL | Sleep | 0 | | NULL | 0.000 | | 5115 | repuser | 10.93.99.161:37702 | NULL | Sleep | 3 | | NULL | 0.000 | | 5125 | repuser | 10.93.99.16:43410 | NULL | Sleep | 1 | | NULL | 0.000 | | 5126 | repuser | 10.93.99.160:45802 | NULL | Sleep | 2 | | NULL | 0.000 | | 5567 | repuser | 10.93.97.39:40652 | NULL | Sleep | 3 | | NULL | 0.000 | | 175073 | bankfrm | 10.93.97.51:43230 | bankfrm | Sleep | 125 | | NULL | 0.000 | | 653113 | bankfrm | 10.93.97.5:52758 | bankfrm | Sleep | 42 | | NULL | 0.000 | | 704030 | bankfrm | 10.93.97.47:37646 | bankfrm | Sleep | 48 | | NULL | 0.000 | | 707512 | bankfrm | 10.93.97.28:42576 | bankfrm | Sleep | 4 | | NULL | 0.000 | | 707514 | bankfrm | 10.93.97.28:42578 | bankfrm | Sleep | 4 | | NULL | 0.000 | | 707515 | bankfrm | 10.93.97.53:32848 | bankfrm | Sleep | 4 | | NULL | 0.000 | | 707517 | bankfrm | 10.93.97.5:45830 | bankfrm | Sleep | 4 | | NULL | 0.000 | | 707519 | bankfrm | 10.93.97.5:45838 | bankfrm | Sleep | 4 | | NULL | 0.000 | | 707520 | bankfrm | 10.93.97.52:48332 | bankfrm | Sleep | 4 | | NULL | 0.000 | | 707521 | bankfrm | 10.93.97.5:45848 | bankfrm | Sleep | 4 | | NULL | 0.000 | | 707522 | bankfrm | 10.91.107.232:38880 | bankfrm | Sleep | 4 | | NULL | 0.000 | | 707525 | bankfrm | 10.93.97.50:49564 | bankfrm | Sleep | 4 | | NULL | 0.000 | | 707526 | bankfrm | 10.93.97.48:59044 | bankfrm | Sleep | 4 | | NULL | 0.000 | | 707527 | bankfrm | 10.93.97.53:32850 | bankfrm | Sleep | 4 | | NULL | 0.000 | | 707531 | bankfrm | 10.93.97.47:49990 | bankfrm | Sleep | 4 | | NULL | 0.000 | | 707538 | bankfrm | 10.93.97.50:49572 | bankfrm | Sleep | 4 | | NULL | 0.000 | | 707539 | bankfrm | 10.93.97.53:32856 | bankfrm | Sleep | 4 | | NULL | 0.000 | | 707543 | bankfrm | 10.93.97.49:38850 | bankfrm | Sleep | 4 | | NULL | 0.000 | | 707544 | bankfrm | 10.93.97.28:42590 | bankfrm | Sleep | 4 | | NULL | 0.000 | | 709715 | bankfrm | 10.93.97.51:36858 | bankfrm | Sleep | 17 | | NULL | 0.000 | | 709717 | bankfrm | 10.93.97.52:51764 | bankfrm | Sleep | 17 | | NULL | 0.000 | | 709718 | bankfrm | 10.93.97.53:36002 | bankfrm | Sleep | 17 | | NULL | 0.000 | | 709904 | bankfrm | 10.93.97.51:37034 | bankfrm | Sleep | 24 | | NULL | 0.000 | | 709905 | bankfrm | 10.93.97.48:43368 | bankfrm | Sleep | 24 | | NULL | 0.000 | | 709906 | bankfrm | 10.93.97.52:51964 | bankfrm | Sleep | 24 | | NULL | 0.000 | | 709908 | bankfrm | 10.93.97.47:58728 | bankfrm | Sleep | 24 | | NULL | 0.000 | | 709909 | bankfrm | 10.93.97.50:34282 | bankfrm | Sleep | 24 | | NULL | 0.000 | | 709910 | bankfrm | 10.93.97.5:60294 | bankfrm | Sleep | 24 | | NULL | 0.000 | | 709911 | bankfrm | 10.93.97.50:34284 | bankfrm | Sleep | 24 | | NULL | 0.000 | | 709912 | bankfrm | 10.91.107.232:44343 | bankfrm | Sleep | 24 | | NULL | 0.000 | | 709913 | bankfrm | 10.93.97.49:54776 | bankfrm | Sleep | 24 | | NULL | 0.000 | | 709914 | bankfrm | 10.93.97.49:54778 | bankfrm | Sleep | 24 | | NULL | 0.000 | | 709915 | bankfrm | 10.91.107.232:63633 | bankfrm | Sleep | 24 | | NULL | 0.000 | | 709916 | bankfrm | 10.93.97.48:43402 | bankfrm | Sleep | 24 | | NULL | 0.000 | | 709918 | bankfrm | 10.93.97.49:54780 | bankfrm | Sleep | 24 | | NULL | 0.000 | | 709919 | bankfrm | 10.93.97.49:54782 | bankfrm | Sleep | 24 | | NULL | 0.000 | | 709920 | bankfrm | 10.93.97.47:58730 | bankfrm | Sleep | 24 | | NULL | 0.000 | | 709921 | bankfrm | 10.93.97.28:58864 | bankfrm | Sleep | 24 | | NULL | 0.000 | | 709923 | bankfrm | 10.93.97.51:37038 | bankfrm | Sleep | 24 | | NULL | 0.000 | | 709924 | bankfrm | 10.93.97.48:43430 | bankfrm | Sleep | 24 | | NULL | 0.000 | | 709925 | bankfrm | 10.93.97.50:34286 | bankfrm | Sleep | 24 | | NULL | 0.000 | | 709927 | bankfrm | 10.93.97.49:54784 | bankfrm | Sleep | 24 | | NULL | 0.000 | | 709928 | bankfrm | 10.93.97.52:51968 | bankfrm | Sleep | 24 | | NULL | 0.000 | | 709929 | bankfrm | 10.93.97.51:37044 | bankfrm | Sleep | 24 | | NULL | 0.000 | | 709930 | bankfrm | 10.93.97.47:58734 | bankfrm | Sleep | 24 | | NULL | 0.000 | | 709932 | bankfrm | 10.93.97.5:60298 | bankfrm | Sleep | 24 | | NULL | 0.000 | | 709933 | bankfrm | 10.93.97.5:60302 | bankfrm | Sleep | 24 | | NULL | 0.000 | | 709934 | bankfrm | 10.93.97.53:36068 | bankfrm | Sleep | 24 | | NULL | 0.000 | | 709936 | bankfrm | 10.91.107.232:17886 | bankfrm | Sleep | 24 | | NULL | 0.000 | | 709937 | bankfrm | 10.93.97.48:43474 | bankfrm | Sleep | 24 | | NULL | 0.000 | | 709938 | bankfrm | 10.93.97.47:58738 | bankfrm | Sleep | 24 | | NULL | 0.000 | | 709997 | bankfrm | 10.93.97.50:35744 | bankfrm | Sleep | 18 | | NULL | 0.000 | | 709999 | bankfrm | 10.93.97.50:35766 | bankfrm | Sleep | 18 | | NULL | 0.000 | | 710001 | bankfrm | 10.93.97.51:37096 | bankfrm | Sleep | 18 | | NULL | 0.000 | | 710002 | bankfrm | 10.93.97.51:37098 | bankfrm | Sleep | 18 | | NULL | 0.000 | | 710003 | bankfrm | 10.93.97.51:37102 | bankfrm | Sleep | 18 | | NULL | 0.000 | | 710004 | bankfrm | 10.93.97.52:52190 | bankfrm | Sleep | 18 | | NULL | 0.000 | | 710005 | bankfrm | 10.93.97.52:52194 | bankfrm | Sleep | 18 | | NULL | 0.000 | | 710006 | bankfrm | 10.93.97.49:56554 | bankfrm | Sleep | 18 | | NULL | 0.000 | | 710008 | bankfrm | 10.93.97.52:52202 | bankfrm | Sleep | 18 | | NULL | 0.000 | | 710009 | bankfrm | 10.93.97.5:33186 | bankfrm | Sleep | 18 | | NULL | 0.000 | | 710010 | bankfrm | 10.91.107.232:46490 | bankfrm | Sleep | 18 | | NULL | 0.000 | | 710011 | bankfrm | 10.93.97.28:59164 | bankfrm | Sleep | 18 | | NULL | 0.000 | | 710012 | bankfrm | 10.93.97.28:59166 | bankfrm | Sleep | 18 | | NULL | 0.000 | | 710013 | bankfrm | 10.91.107.232:46496 | bankfrm | Sleep | 18 | | NULL | 0.000 | | 710014 | bankfrm | 10.93.97.52:52220 | bankfrm | Sleep | 18 | | NULL | 0.000 | | 710015 | bankfrm | 10.91.107.232:46506 | bankfrm | Sleep | 18 | | NULL | 0.000 | | 710016 | bankfrm | 10.91.107.232:46508 | bankfrm | Sleep | 18 | | NULL | 0.000 | | 710017 | bankfrm | 10.93.97.5:33190 | bankfrm | Sleep | 18 | | NULL | 0.000 | | 710018 | bankfrm | 10.93.97.5:33192 | bankfrm | Sleep | 18 | | NULL | 0.000 | | 710019 | bankfrm | 10.93.97.49:56558 | bankfrm | Sleep | 18 | | NULL | 0.000 | | 710020 | bankfrm | 10.93.97.50:35916 | bankfrm | Sleep | 18 | | NULL | 0.000 | | 710022 | bankfrm | 10.93.97.53:36102 | bankfrm | Sleep | 18 | | NULL | 0.000 | | 710023 | bankfrm | 10.93.97.48:43642 | bankfrm | Sleep | 18 | | NULL | 0.000 | | 710024 | bankfrm | 10.93.97.28:59172 | bankfrm | Sleep | 18 | | NULL | 0.000 | | 710025 | bankfrm | 10.93.97.49:56562 | bankfrm | Sleep | 18 | | NULL | 0.000 | | 710026 | bankfrm | 10.93.97.48:43646 | bankfrm | Sleep | 18 | | NULL | 0.000 | | 710212 | bankfrm | 10.93.97.47:59400 | bankfrm | Sleep | 33 | | NULL | 0.000 | | 710214 | bankfrm | 10.93.97.51:37268 | bankfrm | Sleep | 33 | | NULL | 0.000 | | 710215 | bankfrm | 10.93.97.51:37270 | bankfrm | Sleep | 33 | | NULL | 0.000 | | 710216 | bankfrm | 10.93.97.5:33582 | bankfrm | Sleep | 33 | | NULL | 0.000 | | 710217 | bankfrm | 10.91.107.232:18800 | bankfrm | Sleep | 33 | | NULL | 0.000 | | 710219 | bankfrm | 10.93.97.28:59224 | bankfrm | Sleep | 33 | | NULL | 0.000 | | 710220 | bankfrm | 10.93.97.47:59402 | bankfrm | Sleep | 33 | | NULL | 0.000 | | 710221 | bankfrm | 10.93.97.47:59404 | bankfrm | Sleep | 33 | | NULL | 0.000 | | 710222 | bankfrm | 10.93.97.47:59406 | bankfrm | Sleep | 33 | | NULL | 0.000 | | 710223 | bankfrm | 10.91.107.232:44433 | bankfrm | Sleep | 33 | | NULL | 0.000 | | 710224 | bankfrm | 10.91.107.232:41010 | bankfrm | Sleep | 33 | | NULL | 0.000 | | 710226 | bankfrm | 10.93.97.53:36360 | bankfrm | Sleep | 33 | | NULL | 0.000 | | 710227 | bankfrm | 10.93.97.48:43704 | bankfrm | Sleep | 33 | | NULL | 0.000 | | 710228 | bankfrm | 10.93.97.28:59228 | bankfrm | Sleep | 33 | | NULL | 0.000 | | 710229 | bankfrm | 10.93.97.51:37272 | bankfrm | Sleep | 33 | | NULL | 0.000 | | 710230 | bankfrm | 10.93.97.49:56628 | bankfrm | Sleep | 33 | | NULL | 0.000 | | 710231 | bankfrm | 10.93.97.5:33586 | bankfrm | Sleep | 33 | | NULL | 0.000 | | 710232 | bankfrm | 10.93.97.47:59410 | bankfrm | Sleep | 33 | | NULL | 0.000 | | 710233 | bankfrm | 10.93.97.5:33590 | bankfrm | Sleep | 33 | | NULL | 0.000 | | 710235 | bankfrm | 10.93.97.50:37128 | bankfrm | Sleep | 33 | | NULL | 0.000 | | 710236 | bankfrm | 10.93.97.28:59232 | bankfrm | Sleep | 33 | | NULL | 0.000 | | 710237 | bankfrm | 10.91.107.232:7223 | bankfrm | Sleep | 33 | | NULL | 0.000 | | 710238 | bankfrm | 10.93.97.50:37132 | bankfrm | Sleep | 33 | | NULL | 0.000 | | 710240 | bankfrm | 10.93.97.48:43708 | bankfrm | Sleep | 33 | | NULL | 0.000 | | 710241 | bankfrm | 10.93.97.47:59414 | bankfrm | Sleep | 33 | | NULL | 0.000 | | 710242 | bankfrm | 10.93.97.5:33594 | bankfrm | Sleep | 33 | | NULL | 0.000 | | 710243 | bankfrm | 10.93.97.53:36420 | bankfrm | Sleep | 33 | | NULL | 0.000 | | 710245 | bankfrm | 10.93.97.53:36428 | bankfrm | Sleep | 33 | | NULL | 0.000 | | 711716 | bankfrm | 10.93.97.5:40402 | bankfrm | Sleep | 55 | | NULL | 0.000 | | 711717 | bankfrm | 10.93.97.51:39912 | bankfrm | Sleep | 55 | | NULL | 0.000 | | 711718 | bankfrm | 10.93.97.51:39914 | bankfrm | Sleep | 55 | | NULL | 0.000 | | 711719 | bankfrm | 10.93.97.51:39918 | bankfrm | Sleep | 54 | | NULL | 0.000 | | 711720 | bankfrm | 10.93.97.52:55124 | bankfrm | Sleep | 54 | | NULL | 0.000 | | 711721 | bankfrm | 10.93.97.52:55128 | bankfrm | Sleep | 54 | | NULL | 0.000 | | 711722 | bankfrm | 10.93.97.49:38580 | bankfrm | Sleep | 54 | | NULL | 0.000 | | 711723 | bankfrm | 10.93.97.50:43626 | bankfrm | Sleep | 54 | | NULL | 0.000 | | 711724 | bankfrm | 10.93.97.50:43628 | bankfrm | Sleep | 54 | | NULL | 0.000 | | 711725 | bankfrm | 10.93.97.53:37842 | bankfrm | Sleep | 54 | | NULL | 0.000 | | 711727 | bankfrm | 10.93.97.51:39924 | bankfrm | Sleep | 54 | | NULL | 0.000 | | 711728 | bankfrm | 10.93.97.5:40404 | bankfrm | Sleep | 54 | | NULL | 0.000 | | 711729 | bankfrm | 10.93.97.52:55132 | bankfrm | Sleep | 54 | | NULL | 0.000 | | 711730 | bankfrm | 10.91.107.232:60256 | bankfrm | Sleep | 54 | | NULL | 0.000 | | 711731 | bankfrm | 10.93.97.48:52766 | bankfrm | Sleep | 54 | | NULL | 0.000 | | 711733 | bankfrm | 10.93.97.48:52768 | bankfrm | Sleep | 54 | | NULL | 0.000 | | 711734 | bankfrm | 10.93.97.48:52772 | bankfrm | Sleep | 54 | | NULL | 0.000 | | 711735 | bankfrm | 10.91.107.232:38482 | bankfrm | Sleep | 54 | | NULL | 0.000 | | 711736 | bankfrm | 10.91.107.232:18545 | bankfrm | Sleep | 54 | | NULL | 0.000 | | 711737 | bankfrm | 10.93.97.48:52776 | bankfrm | Sleep | 54 | | NULL | 0.000 | | 711738 | bankfrm | 10.93.97.53:37846 | bankfrm | Sleep | 54 | | NULL | 0.000 | | 711739 | bankfrm | 10.93.97.49:38644 | bankfrm | Sleep | 54 | | NULL | 0.000 | | 711740 | bankfrm | 10.93.97.49:38648 | bankfrm | Sleep | 54 | | NULL | 0.000 | | 711741 | bankfrm | 10.93.97.49:38656 | bankfrm | Sleep | 54 | | NULL | 0.000 | | 711742 | bankfrm | 10.93.97.28:40612 | bankfrm | Sleep | 54 | | NULL | 0.000 | | 711744 | bankfrm | 10.93.97.28:40616 | bankfrm | Sleep | 54 | | NULL | 0.000 | | 711745 | bankfrm | 10.93.97.47:37656 | bankfrm | Sleep | 54 | | NULL | 0.000 | | 711953 | bankfrm | 10.93.97.5:44048 | bankfrm | Sleep | 34 | | NULL | 0.000 | | 711954 | bankfrm | 10.93.97.49:41926 | bankfrm | Sleep | 34 | | NULL | 0.000 | | 711955 | bankfrm | 10.93.97.49:41928 | bankfrm | Sleep | 34 | | NULL | 0.000 | | 711956 | bankfrm | 10.93.97.49:41930 | bankfrm | Sleep | 34 | | NULL | 0.000 | | 711957 | bankfrm | 10.93.97.28:43120 | bankfrm | Sleep | 34 | | NULL | 0.000 | | 711958 | bankfrm | 10.93.97.52:55180 | bankfrm | Sleep | 34 | | NULL | 0.000 | | 711959 | bankfrm | 10.93.97.28:43122 | bankfrm | Sleep | 34 | | NULL | 0.000 | | 712182 | bankfrm | 10.93.97.50:47464 | bankfrm | Sleep | 48 | | NULL | 0.000 | | 712283 | bankfrm | 10.93.97.49:42862 | bankfrm | Sleep | 559 | | NULL | 0.000 | | 712284 | bankfrm | 10.93.97.49:42866 | bankfrm | Sleep | 559 | | NULL | 0.000 | | 712285 | bankfrm | 10.93.97.49:42870 | bankfrm | Sleep | 559 | | NULL | 0.000 | | 712286 | bankfrm | 10.93.97.49:42874 | bankfrm | Sleep | 559 | | NULL | 0.000 | | 712288 | bankfrm | 10.93.97.49:42878 | bankfrm | Sleep | 559 | | NULL | 0.000 | | 712289 | bankfrm | 10.93.97.49:42882 | bankfrm | Sleep | 559 | | NULL | 0.000 | | 712290 | bankfrm | 10.93.97.49:42886 | bankfrm | Sleep | 559 | | NULL | 0.000 | | 712291 | bankfrm | 10.93.97.49:42890 | bankfrm | Sleep | 559 | | NULL | 0.000 | | 712292 | bankfrm | 10.93.97.49:42894 | bankfrm | Sleep | 559 | | NULL | 0.000 | | 712293 | bankfrm | 10.93.97.49:42898 | bankfrm | Sleep | 559 | | NULL | 0.000 | | 712294 | bankfrm | 10.93.97.49:42902 | bankfrm | Sleep | 559 | | NULL | 0.000 | | 712295 | bankfrm | 10.93.97.49:42906 | bankfrm | Sleep | 559 | | NULL | 0.000 | | 712297 | bankfrm | 10.93.97.49:42910 | bankfrm | Sleep | 559 | | NULL | 0.000 | | 712298 | bankfrm | 10.93.97.49:42914 | bankfrm | Sleep | 559 | | NULL | 0.000 | | 712299 | bankfrm | 10.93.97.49:42918 | bankfrm | Sleep | 559 | | NULL | 0.000 | | 712300 | bankfrm | 10.93.97.49:42922 | bankfrm | Sleep | 559 | | NULL | 0.000 | | 712301 | bankfrm | 10.93.97.49:42926 | bankfrm | Sleep | 559 | | NULL | 0.000 | | 712302 | bankfrm | 10.93.97.49:42930 | bankfrm | Sleep | 559 | | NULL | 0.000 | | 712303 | bankfrm | 10.93.97.49:42934 | bankfrm | Sleep | 559 | | NULL | 0.000 | | 712304 | bankfrm | 10.93.97.49:42938 | bankfrm | Sleep | 559 | | NULL | 0.000 | | 712305 | bankfrm | 10.93.97.49:42942 | bankfrm | Sleep | 559 | | NULL | 0.000 | | 712307 | bankfrm | 10.93.97.49:42946 | bankfrm | Sleep | 559 | | NULL | 0.000 | | 712308 | bankfrm | 10.93.97.49:42950 | bankfrm | Sleep | 559 | | NULL | 0.000 | | 712341 | bankfrm | 10.93.97.5:44414 | bankfrm | Sleep | 554 | | NULL | 0.000 | | 712570 | bankfrm | 10.93.97.5:45972 | bankfrm | Sleep | 520 | | NULL | 0.000 | | 712571 | bankfrm | 10.93.97.5:45980 | bankfrm | Sleep | 520 | | NULL | 0.000 | | 712619 | bankfrm | 10.93.97.47:39674 | bankfrm | Sleep | 512 | | NULL | 0.000 | | 712620 | bankfrm | 10.93.97.47:39678 | bankfrm | Sleep | 512 | | NULL | 0.000 | | 712621 | bankfrm | 10.93.97.47:39682 | bankfrm | Sleep | 512 | | NULL | 0.000 | | 712622 | bankfrm | 10.93.97.47:39686 | bankfrm | Sleep | 512 | | NULL | 0.000 | | 712624 | bankfrm | 10.93.97.47:39690 | bankfrm | Sleep | 512 | | NULL | 0.000 | | 712625 | bankfrm | 10.93.97.47:39694 | bankfrm | Sleep | 512 | | NULL | 0.000 | | 712626 | bankfrm | 10.93.97.47:39698 | bankfrm | Sleep | 512 | | NULL | 0.000 | | 712627 | bankfrm | 10.93.97.47:39702 | bankfrm | Sleep | 512 | | NULL | 0.000 | | 712677 | bankfrm | 10.93.97.47:40042 | bankfrm | Sleep | 18 | | NULL | 0.000 | | 712679 | bankfrm | 10.93.97.50:50830 | bankfrm | Sleep | 18 | | NULL | 0.000 | | 712680 | bankfrm | 10.93.97.53:38598 | bankfrm | Sleep | 18 | | NULL | 0.000 | | 712681 | bankfrm | 10.93.97.50:50832 | bankfrm | Sleep | 18 | | NULL | 0.000 | | 712682 | bankfrm | 10.93.97.50:50834 | bankfrm | Sleep | 18 | | NULL | 0.000 | | 712684 | bankfrm | 10.93.97.53:38602 | bankfrm | Sleep | 18 | | NULL | 0.000 | | 712685 | bankfrm | 10.93.97.48:33230 | bankfrm | Sleep | 18 | | NULL | 0.000 | | 712686 | bankfrm | 10.93.97.50:50836 | bankfrm | Sleep | 18 | | NULL | 0.000 | | 712687 | bankfrm | 10.93.97.50:50840 | bankfrm | Sleep | 18 | | NULL | 0.000 | | 712688 | bankfrm | 10.93.97.51:41078 | bankfrm | Sleep | 18 | | NULL | 0.000 | | 712689 | bankfrm | 10.93.97.52:57550 | bankfrm | Sleep | 18 | | NULL | 0.000 | | 712690 | bankfrm | 10.93.97.52:57554 | bankfrm | Sleep | 18 | | NULL | 0.000 | | 712691 | bankfrm | 10.93.97.52:57558 | bankfrm | Sleep | 18 | | NULL | 0.000 | | 712693 | bankfrm | 10.91.107.232:51846 | bankfrm | Sleep | 18 | | NULL | 0.000 | | 712694 | bankfrm | 10.93.97.48:33232 | bankfrm | Sleep | 18 | | NULL | 0.000 | | 712695 | bankfrm | 10.93.97.53:38606 | bankfrm | Sleep | 18 | | NULL | 0.000 | | 712697 | bankfrm | 10.93.97.53:38610 | bankfrm | Sleep | 18 | | NULL | 0.000 | | 712698 | bankfrm | 10.93.97.51:41086 | bankfrm | Sleep | 18 | | NULL | 0.000 | | 712699 | bankfrm | 10.93.97.47:40048 | bankfrm | Sleep | 18 | | NULL | 0.000 | | 712700 | bankfrm | 10.93.97.51:41090 | bankfrm | Sleep | 18 | | NULL | 0.000 | | 712701 | bankfrm | 10.91.107.232:51874 | bankfrm | Sleep | 18 | | NULL | 0.000 | | 712703 | bankfrm | 10.93.97.48:33236 | bankfrm | Sleep | 18 | | NULL | 0.000 | | 712704 | bankfrm | 10.93.97.52:57606 | bankfrm | Sleep | 18 | | NULL | 0.000 | | 713009 | bankfrm | 10.93.97.5:48026 | bankfrm | Sleep | 457 | | NULL | 0.000 | | 713010 | bankfrm | 10.93.97.5:48030 | bankfrm | Sleep | 457 | | NULL | 0.000 | | 713011 | bankfrm | 10.93.97.5:48034 | bankfrm | Sleep | 457 | | NULL | 0.000 | | 713012 | bankfrm | 10.93.97.5:48042 | bankfrm | Sleep | 457 | | NULL | 0.000 | | 713013 | bankfrm | 10.93.97.5:48050 | bankfrm | Sleep | 457 | | NULL | 0.000 | | 713014 | bankfrm | 10.93.97.5:48058 | bankfrm | Sleep | 457 | | NULL | 0.000 | | 713015 | bankfrm | 10.93.97.5:48066 | bankfrm | Sleep | 457 | | NULL | 0.000 | | 713016 | bankfrm | 10.93.97.5:48074 | bankfrm | Sleep | 457 | | NULL | 0.000 | | 713018 | bankfrm | 10.93.97.5:48082 | bankfrm | Sleep | 457 | | NULL | 0.000 | | 713019 | bankfrm | 10.93.97.5:48090 | bankfrm | Sleep | 457 | | NULL | 0.000 | | 713020 | bankfrm | 10.93.97.5:48098 | bankfrm | Sleep | 457 | | NULL | 0.000 | | 713021 | bankfrm | 10.93.97.5:48106 | bankfrm | Sleep | 457 | | NULL | 0.000 | | 713022 | bankfrm | 10.93.97.5:48114 | bankfrm | Sleep | 457 | | NULL | 0.000 | | 713023 | bankfrm | 10.93.97.5:48122 | bankfrm | Sleep | 457 | | NULL | 0.000 | | 713024 | bankfrm | 10.93.97.5:48130 | bankfrm | Sleep | 457 | | NULL | 0.000 | | 713026 | bankfrm | 10.93.97.5:48138 | bankfrm | Sleep | 457 | | NULL | 0.000 | | 713027 | bankfrm | 10.93.97.5:48146 | bankfrm | Sleep | 457 | | NULL | 0.000 | | 713028 | bankfrm | 10.93.97.5:48154 | bankfrm | Sleep | 457 | | NULL | 0.000 | | 713029 | bankfrm | 10.93.97.5:48162 | bankfrm | Sleep | 457 | | NULL | 0.000 | | 713030 | bankfrm | 10.93.97.5:48170 | bankfrm | Sleep | 457 | | NULL | 0.000 | | 713031 | bankfrm | 10.93.97.5:48178 | bankfrm | Sleep | 457 | | NULL | 0.000 | | 713032 | bankfrm | 10.93.97.5:48186 | bankfrm | Sleep | 457 | | NULL | 0.000 | | 713033 | bankfrm | 10.93.97.5:48194 | bankfrm | Sleep | 457 | | NULL | 0.000 | | 713034 | bankfrm | 10.93.97.5:48202 | bankfrm | Sleep | 457 | | NULL | 0.000 | | 713036 | bankfrm | 10.93.97.5:48210 | bankfrm | Sleep | 457 | | NULL | 0.000 | | 713037 | bankfrm | 10.93.97.5:48218 | bankfrm | Sleep | 457 | | NULL | 0.000 | | 713373 | bankfrm | 10.93.97.49:50568 | bankfrm | Sleep | 406 | | NULL | 0.000 | | 713375 | bankfrm | 10.93.97.49:50572 | bankfrm | Sleep | 406 | | NULL | 0.000 | | 713376 | bankfrm | 10.93.97.49:50576 | bankfrm | Sleep | 406 | | NULL | 0.000 | | 713587 | bankfrm | 10.91.107.232:44082 | bankfrm | Sleep | 20 | | NULL | 0.000 | | 713588 | bankfrm | 10.93.97.28:53478 | bankfrm | Sleep | 20 | | NULL | 0.000 | | 713589 | bankfrm | 10.93.97.28:53484 | bankfrm | Sleep | 20 | | NULL | 0.000 | | 713590 | bankfrm | 10.93.97.47:44080 | bankfrm | Sleep | 20 | | NULL | 0.000 | | 713592 | bankfrm | 10.93.97.47:44092 | bankfrm | Sleep | 20 | | NULL | 0.000 | | 713593 | bankfrm | 10.91.107.232:28471 | bankfrm | Sleep | 20 | | NULL | 0.000 | | 713594 | bankfrm | 10.93.97.49:51936 | bankfrm | Sleep | 20 | | NULL | 0.000 | | 713596 | bankfrm | 10.93.97.28:53526 | bankfrm | Sleep | 20 | | NULL | 0.000 | | 713597 | bankfrm | 10.93.97.28:53550 | bankfrm | Sleep | 20 | | NULL | 0.000 | | 713599 | bankfrm | 10.93.97.48:35858 | bankfrm | Sleep | 20 | | NULL | 0.000 | | 713602 | bankfrm | 10.93.97.49:52014 | bankfrm | Sleep | 20 | | NULL | 0.000 | | 713603 | bankfrm | 10.93.97.47:44172 | bankfrm | Sleep | 20 | | NULL | 0.000 | | 713605 | bankfrm | 10.93.97.50:53916 | bankfrm | Sleep | 20 | | NULL | 0.000 | | 713606 | bankfrm | 10.93.97.5:51928 | bankfrm | Sleep | 20 | | NULL | 0.000 | | 713607 | bankfrm | 10.93.97.53:40638 | bankfrm | Sleep | 20 | | NULL | 0.000 | | 713608 | bankfrm | 10.93.97.51:42718 | bankfrm | Sleep | 20 | | NULL | 0.000 | | 713609 | bankfrm | 10.93.97.52:58936 | bankfrm | Sleep | 20 | | NULL | 0.000 | | 713611 | bankfrm | 10.93.97.28:53584 | bankfrm | Sleep | 20 | | NULL | 0.000 | | 713612 | bankfrm | 10.91.107.232:37715 | bankfrm | Sleep | 20 | | NULL | 0.000 | | 713613 | bankfrm | 10.93.97.50:53920 | bankfrm | Sleep | 20 | | NULL | 0.000 | | 713614 | bankfrm | 10.93.97.48:35862 | bankfrm | Sleep | 20 | | NULL | 0.000 | | 713616 | bankfrm | 10.93.97.47:44176 | bankfrm | Sleep | 20 | | NULL | 0.000 | | 713907 | bankfrm | 10.93.97.50:56562 | bankfrm | Sleep | 329 | | NULL | 0.000 | | 713909 | bankfrm | 10.93.97.50:56578 | bankfrm | Sleep | 329 | | NULL | 0.000 | | 713911 | bankfrm | 10.93.97.50:56594 | bankfrm | Sleep | 328 | | NULL | 0.000 | | 713913 | bankfrm | 10.93.97.50:56610 | bankfrm | Sleep | 328 | | NULL | 0.000 | | 713915 | bankfrm | 10.93.97.50:56626 | bankfrm | Sleep | 328 | | NULL | 0.000 | | 713942 | bankfrm | 10.93.97.47:45242 | bankfrm | Sleep | 325 | | NULL | 0.000 | | 713943 | bankfrm | 10.93.97.47:45250 | bankfrm | Sleep | 325 | | NULL | 0.000 | | 713944 | bankfrm | 10.93.97.47:45258 | bankfrm | Sleep | 325 | | NULL | 0.000 | | 713945 | bankfrm | 10.93.97.47:45266 | bankfrm | Sleep | 325 | | NULL | 0.000 | | 713946 | bankfrm | 10.93.97.47:45274 | bankfrm | Sleep | 325 | | NULL | 0.000 | | 713948 | bankfrm | 10.93.97.47:45282 | bankfrm | Sleep | 324 | | NULL | 0.000 | | 713949 | bankfrm | 10.93.97.47:45290 | bankfrm | Sleep | 324 | | NULL | 0.000 | | 713950 | bankfrm | 10.93.97.47:45298 | bankfrm | Sleep | 324 | | NULL | 0.000 | | 713951 | bankfrm | 10.93.97.47:45306 | bankfrm | Sleep | 324 | | NULL | 0.000 | | 713952 | bankfrm | 10.93.97.47:45314 | bankfrm | Sleep | 324 | | NULL | 0.000 | | 713953 | bankfrm | 10.93.97.47:45322 | bankfrm | Sleep | 324 | | NULL | 0.000 | | 713954 | bankfrm | 10.93.97.47:45330 | bankfrm | Sleep | 324 | | NULL | 0.000 | | 713955 | bankfrm | 10.93.97.47:45338 | bankfrm | Sleep | 324 | | NULL | 0.000 | | 714007 | bankfrm | 10.93.97.49:55270 | bankfrm | Sleep | 317 | | NULL | 0.000 | | 714008 | bankfrm | 10.93.97.49:55274 | bankfrm | Sleep | 317 | | NULL | 0.000 | | 714009 | bankfrm | 10.93.97.49:55278 | bankfrm | Sleep | 317 | | NULL | 0.000 | | 714010 | bankfrm | 10.93.97.49:55282 | bankfrm | Sleep | 317 | | NULL | 0.000 | | 714012 | bankfrm | 10.93.97.49:55286 | bankfrm | Sleep | 317 | | NULL | 0.000 | | 714013 | bankfrm | 10.93.97.49:55290 | bankfrm | Sleep | 317 | | NULL | 0.000 | | 714014 | bankfrm | 10.93.97.49:55294 | bankfrm | Sleep | 317 | | NULL | 0.000 | | 714015 | bankfrm | 10.93.97.49:55298 | bankfrm | Sleep | 317 | | NULL | 0.000 | | 714016 | bankfrm | 10.93.97.49:55302 | bankfrm | Sleep | 317 | | NULL | 0.000 | | 714017 | bankfrm | 10.93.97.49:55306 | bankfrm | Sleep | 317 | | NULL | 0.000 | | 714018 | bankfrm | 10.93.97.49:55310 | bankfrm | Sleep | 317 | | NULL | 0.000 | | 714020 | bankfrm | 10.93.97.49:55314 | bankfrm | Sleep | 317 | | NULL | 0.000 | | 714021 | bankfrm | 10.93.97.49:55318 | bankfrm | Sleep | 317 | | NULL | 0.000 | | 714022 | bankfrm | 10.93.97.49:55322 | bankfrm | Sleep | 317 | | NULL | 0.000 | | 714023 | bankfrm | 10.93.97.49:55326 | bankfrm | Sleep | 317 | | NULL | 0.000 | | 714024 | bankfrm | 10.93.97.49:55330 | bankfrm | Sleep | 317 | | NULL | 0.000 | | 714026 | bankfrm | 10.93.97.49:55334 | bankfrm | Sleep | 317 | | NULL | 0.000 | | 714027 | bankfrm | 10.93.97.49:55338 | bankfrm | Sleep | 316 | | NULL | 0.000 | | 714028 | bankfrm | 10.93.97.49:55342 | bankfrm | Sleep | 316 | | NULL | 0.000 | | 714095 | bankfrm | 10.93.97.53:40946 | bankfrm | Sleep | 47 | | NULL | 0.000 | | 714099 | bankfrm | 10.93.97.5:55600 | bankfrm | Sleep | 47 | | NULL | 0.000 | | 714117 | bankfrm | 10.93.97.52:59406 | bankfrm | Sleep | 21 | | NULL | 0.000 | | 714125 | bankfrm | 10.93.97.53:40988 | bankfrm | Sleep | 21 | | NULL | 0.000 | | 714134 | bankfrm | 10.93.97.5:55610 | bankfrm | Sleep | 21 | | NULL | 0.000 | | 714167 | bankfrm | 10.93.97.51:43218 | bankfrm | Sleep | 21 | | NULL | 0.000 | | 714171 | bankfrm | 10.93.97.49:55360 | bankfrm | Sleep | 21 | | NULL | 0.000 | | 714195 | bankfrm | 10.93.97.49:55396 | bankfrm | Sleep | 21 | | NULL | 0.000 | | 714199 | bankfrm | 10.93.97.52:59446 | bankfrm | Sleep | 21 | | NULL | 0.000 | | 714204 | bankfrm | 10.93.97.28:56316 | bankfrm | Sleep | 21 | | NULL | 0.000 | | 714209 | bankfrm | 10.93.97.28:56318 | bankfrm | Sleep | 21 | | NULL | 0.000 | | 714213 | bankfrm | 10.93.97.48:37472 | bankfrm | Sleep | 21 | | NULL | 0.000 | | 714217 | bankfrm | 10.93.97.53:41014 | bankfrm | Sleep | 21 | | NULL | 0.000 | | 714243 | bankfrm | 10.93.97.28:56406 | bankfrm | Sleep | 21 | | NULL | 0.000 | | 714249 | bankfrm | 10.93.97.5:55678 | bankfrm | Sleep | 21 | | NULL | 0.000 | | 714259 | bankfrm | 10.93.97.51:43336 | bankfrm | Sleep | 21 | | NULL | 0.000 | | 714265 | bankfrm | 10.93.97.52:59468 | bankfrm | Sleep | 21 | | NULL | 0.000 | | 714273 | bankfrm | 10.93.97.49:55510 | bankfrm | Sleep | 21 | | NULL | 0.000 | | 714277 | bankfrm | 10.93.97.5:55684 | bankfrm | Sleep | 21 | | NULL | 0.000 | | 714282 | bankfrm | 10.91.107.232:16753 | bankfrm | Sleep | 21 | | NULL | 0.000 | | 714289 | bankfrm | 10.93.97.50:57866 | bankfrm | Sleep | 21 | | NULL | 0.000 | | 714293 | bankfrm | 10.93.97.47:45546 | bankfrm | Sleep | 21 | | NULL | 0.000 | | 714298 | bankfrm | 10.93.97.48:37746 | bankfrm | Sleep | 21 | | NULL | 0.000 | | 714311 | bankfrm | 10.93.97.53:41034 | bankfrm | Sleep | 21 | | NULL | 0.000 | | 714315 | bankfrm | 10.93.97.5:55698 | bankfrm | Sleep | 21 | | NULL | 0.000 | | 714554 | bankfrm | 10.93.97.5:57162 | bankfrm | Sleep | 242 | | NULL | 0.000 | | 714559 | bankfrm | 10.93.97.5:57212 | bankfrm | Sleep | 241 | | NULL | 0.000 | | 714562 | bankfrm | 10.93.97.5:57256 | bankfrm | Sleep | 241 | | NULL | 0.000 | | 714565 | bankfrm | 10.93.97.5:57300 | bankfrm | Sleep | 241 | | NULL | 0.000 | | 714568 | bankfrm | 10.93.97.5:57346 | bankfrm | Sleep | 240 | | NULL | 0.000 | | 714569 | bankfrm | 10.93.97.5:57386 | bankfrm | Sleep | 240 | | NULL | 0.000 | | 714571 | bankfrm | 10.93.97.5:57432 | bankfrm | Sleep | 240 | | NULL | 0.000 | | 714574 | bankfrm | 10.93.97.5:57470 | bankfrm | Sleep | 240 | | NULL | 0.000 | | 714576 | bankfrm | 10.93.97.5:57502 | bankfrm | Sleep | 240 | | NULL | 0.000 | | 714580 | bankfrm | 10.93.97.5:57540 | bankfrm | Sleep | 239 | | NULL | 0.000 | | 714583 | bankfrm | 10.93.97.5:57582 | bankfrm | Sleep | 239 | | NULL | 0.000 | | 714586 | bankfrm | 10.93.97.5:57622 | bankfrm | Sleep | 239 | | NULL | 0.000 | | 714589 | bankfrm | 10.93.97.5:57663 | bankfrm | Sleep | 238 | | NULL | 0.000 | | 714592 | bankfrm | 10.93.97.5:57718 | bankfrm | Sleep | 238 | | NULL | 0.000 | | 714595 | bankfrm | 10.93.97.5:57776 | bankfrm | Sleep | 238 | | NULL | 0.000 | | 714598 | bankfrm | 10.93.97.5:57814 | bankfrm | Sleep | 237 | | NULL | 0.000 | | 714602 | bankfrm | 10.93.97.5:57854 | bankfrm | Sleep | 237 | | NULL | 0.000 | | 714605 | bankfrm | 10.93.97.5:57886 | bankfrm | Sleep | 237 | | NULL | 0.000 | | 714608 | bankfrm | 10.93.97.5:57918 | bankfrm | Sleep | 236 | | NULL | 0.000 | | 714611 | bankfrm | 10.93.97.5:57950 | bankfrm | Sleep | 236 | | NULL | 0.000 | | 714615 | bankfrm | 10.93.97.5:57980 | bankfrm | Sleep | 235 | | NULL | 0.000 | | 714618 | bankfrm | 10.93.97.5:58010 | bankfrm | Sleep | 235 | | NULL | 0.000 | | 714620 | bankfrm | 10.93.97.47:47008 | bankfrm | Sleep | 235 | | NULL | 0.000 | | 714621 | bankfrm | 10.93.97.47:47012 | bankfrm | Sleep | 235 | | NULL | 0.000 | | 714622 | bankfrm | 10.93.97.47:47016 | bankfrm | Sleep | 235 | | NULL | 0.000 | | 714623 | bankfrm | 10.93.97.47:47020 | bankfrm | Sleep | 235 | | NULL | 0.000 | | 714625 | bankfrm | 10.93.97.47:47034 | bankfrm | Sleep | 235 | | NULL | 0.000 | | 714628 | bankfrm | 10.93.97.47:47050 | bankfrm | Sleep | 234 | | NULL | 0.000 | | 714630 | bankfrm | 10.93.97.47:47066 | bankfrm | Sleep | 234 | | NULL | 0.000 | | 714632 | bankfrm | 10.93.97.47:47082 | bankfrm | Sleep | 234 | | NULL | 0.000 | | 714634 | bankfrm | 10.93.97.47:47098 | bankfrm | Sleep | 234 | | NULL | 0.000 | | 714636 | bankfrm | 10.93.97.47:47116 | bankfrm | Sleep | 234 | | NULL | 0.000 | | 714638 | bankfrm | 10.93.97.47:47130 | bankfrm | Sleep | 234 | | NULL | 0.000 | | 714640 | bankfrm | 10.93.97.47:47146 | bankfrm | Sleep | 234 | | NULL | 0.000 | | 714642 | bankfrm | 10.93.97.47:47158 | bankfrm | Sleep | 233 | | NULL | 0.000 | | 714669 | bankfrm | 10.93.97.50:32824 | bankfrm | Sleep | 229 | | NULL | 0.000 | | 714670 | bankfrm | 10.93.97.50:32836 | bankfrm | Sleep | 229 | | NULL | 0.000 | | 714672 | bankfrm | 10.93.97.50:32848 | bankfrm | Sleep | 229 | | NULL | 0.000 | | 714674 | bankfrm | 10.93.97.50:32862 | bankfrm | Sleep | 229 | | NULL | 0.000 | | 714676 | bankfrm | 10.93.97.50:32878 | bankfrm | Sleep | 229 | | NULL | 0.000 | | 714677 | bankfrm | 10.93.97.50:32890 | bankfrm | Sleep | 228 | | NULL | 0.000 | | 714679 | bankfrm | 10.93.97.50:32902 | bankfrm | Sleep | 228 | | NULL | 0.000 | | 714680 | bankfrm | 10.93.97.50:32914 | bankfrm | Sleep | 228 | | NULL | 0.000 | | 714682 | bankfrm | 10.93.97.50:32926 | bankfrm | Sleep | 228 | | NULL | 0.000 | | 714684 | bankfrm | 10.93.97.52:59868 | bankfrm | Sleep | 24 | | NULL | 0.000 | | 714685 | bankfrm | 10.93.97.50:32938 | bankfrm | Sleep | 228 | | NULL | 0.000 | | 714687 | bankfrm | 10.93.97.50:32962 | bankfrm | Sleep | 228 | | NULL | 0.000 | | 714688 | bankfrm | 10.93.97.48:42608 | bankfrm | Sleep | 24 | | NULL | 0.000 | | 714689 | bankfrm | 10.93.97.50:32982 | bankfrm | Sleep | 228 | | NULL | 0.000 | | 714691 | bankfrm | 10.93.97.50:32998 | bankfrm | Sleep | 228 | | NULL | 0.000 | | 714692 | bankfrm | 10.93.97.50:33014 | bankfrm | Sleep | 228 | | NULL | 0.000 | | 714694 | bankfrm | 10.93.97.50:33046 | bankfrm | Sleep | 228 | | NULL | 0.000 | | 714695 | bankfrm | 10.93.97.50:33064 | bankfrm | Sleep | 24 | | NULL | 0.000 | | 714696 | bankfrm | 10.93.97.50:33096 | bankfrm | Sleep | 228 | | NULL | 0.000 | | 714698 | bankfrm | 10.93.97.50:33134 | bankfrm | Sleep | 228 | | NULL | 0.000 | | 714699 | bankfrm | 10.93.97.5:58514 | bankfrm | Sleep | 24 | | NULL | 0.000 | | 714700 | bankfrm | 10.93.97.50:33150 | bankfrm | Sleep | 228 | | NULL | 0.000 | | 714702 | bankfrm | 10.93.97.50:33162 | bankfrm | Sleep | 228 | | NULL | 0.000 | | 714703 | bankfrm | 10.93.97.50:33178 | bankfrm | Sleep | 228 | | NULL | 0.000 | | 714705 | bankfrm | 10.93.97.50:33202 | bankfrm | Sleep | 228 | | NULL | 0.000 | | 714706 | bankfrm | 10.93.97.50:33218 | bankfrm | Sleep | 228 | | NULL | 0.000 | | 714707 | bankfrm | 10.93.97.49:58838 | bankfrm | Sleep | 228 | | NULL | 0.000 | | 714709 | bankfrm | 10.93.97.50:33242 | bankfrm | Sleep | 227 | | NULL | 0.000 | | 714710 | bankfrm | 10.93.97.49:58852 | bankfrm | Sleep | 227 | | NULL | 0.000 | | 714711 | bankfrm | 10.91.107.232:47216 | bankfrm | Sleep | 24 | | NULL | 0.000 | | 714712 | bankfrm | 10.93.97.49:58870 | bankfrm | Sleep | 227 | | NULL | 0.000 | | 714713 | bankfrm | 10.93.97.50:33262 | bankfrm | Sleep | 227 | | NULL | 0.000 | | 714714 | bankfrm | 10.93.97.50:33282 | bankfrm | Sleep | 227 | | NULL | 0.000 | | 714716 | bankfrm | 10.93.97.53:41368 | bankfrm | Sleep | 24 | | NULL | 0.000 | | 714718 | bankfrm | 10.93.97.48:43148 | bankfrm | Sleep | 24 | | NULL | 0.000 | | 714720 | bankfrm | 10.93.97.49:58962 | bankfrm | Sleep | 24 | | NULL | 0.000 | | 714722 | bankfrm | 10.93.97.53:41380 | bankfrm | Sleep | 24 | | NULL | 0.000 | | 714723 | bankfrm | 10.93.97.50:33446 | bankfrm | Sleep | 24 | | NULL | 0.000 | | 714725 | bankfrm | 10.93.97.51:43806 | bankfrm | Sleep | 24 | | NULL | 0.000 | | 714726 | bankfrm | 10.93.97.47:47562 | bankfrm | Sleep | 24 | | NULL | 0.000 | | 714727 | bankfrm | 10.93.97.52:59878 | bankfrm | Sleep | 24 | | NULL | 0.000 | | 714729 | bankfrm | 10.93.97.28:59734 | bankfrm | Sleep | 24 | | NULL | 0.000 | | 714730 | bankfrm | 10.93.97.5:58744 | bankfrm | Sleep | 24 | | NULL | 0.000 | | 714731 | bankfrm | 10.93.97.53:41402 | bankfrm | Sleep | 24 | | NULL | 0.000 | | 714734 | bankfrm | 10.93.97.50:33716 | bankfrm | Sleep | 24 | | NULL | 0.000 | | 714735 | bankfrm | 10.93.97.49:59240 | bankfrm | Sleep | 24 | | NULL | 0.000 | | 714737 | bankfrm | 10.93.97.53:41406 | bankfrm | Sleep | 24 | | NULL | 0.000 | | 714738 | bankfrm | 10.93.97.51:43812 | bankfrm | Sleep | 24 | | NULL | 0.000 | | 714741 | bankfrm | 10.93.97.28:59902 | bankfrm | Sleep | 24 | | NULL | 0.000 | | 714742 | bankfrm | 10.93.97.47:47570 | bankfrm | Sleep | 24 | | NULL | 0.000 | | 714743 | bankfrm | 10.93.97.5:58812 | bankfrm | Sleep | 24 | | NULL | 0.000 | | 714787 | bankfrm | 10.93.97.5:58834 | bankfrm | Sleep | 220 | | NULL | 0.000 | | 714788 | bankfrm | 10.93.97.5:58842 | bankfrm | Sleep | 220 | | NULL | 0.000 | | 714789 | bankfrm | 10.93.97.5:58850 | bankfrm | Sleep | 220 | | NULL | 0.000 | | 714790 | bankfrm | 10.93.97.5:58858 | bankfrm | Sleep | 220 | | NULL | 0.000 | | 714792 | bankfrm | 10.93.97.5:58866 | bankfrm | Sleep | 220 | | NULL | 0.000 | | 714793 | bankfrm | 10.93.97.5:58874 | bankfrm | Sleep | 219 | | NULL | 0.000 | | 714794 | bankfrm | 10.93.97.5:58882 | bankfrm | Sleep | 219 | | NULL | 0.000 | | 714795 | bankfrm | 10.93.97.5:58890 | bankfrm | Sleep | 219 | | NULL | 0.000 | | 714796 | bankfrm | 10.93.97.5:58898 | bankfrm | Sleep | 219 | | NULL | 0.000 | | 714797 | bankfrm | 10.93.97.5:58906 | bankfrm | Sleep | 219 | | NULL | 0.000 | | 714798 | bankfrm | 10.93.97.5:58914 | bankfrm | Sleep | 219 | | NULL | 0.000 | | 714799 | bankfrm | 10.93.97.5:58922 | bankfrm | Sleep | 219 | | NULL | 0.000 | | 714800 | bankfrm | 10.93.97.5:58930 | bankfrm | Sleep | 219 | | NULL | 0.000 | | 714801 | bankfrm | 10.93.97.5:58938 | bankfrm | Sleep | 219 | | NULL | 0.000 | | 714849 | bankfrm | 10.93.97.47:47594 | bankfrm | Sleep | 212 | | NULL | 0.000 | | 714850 | bankfrm | 10.93.97.47:47600 | bankfrm | Sleep | 212 | | NULL | 0.000 | | 714852 | bankfrm | 10.93.97.47:47604 | bankfrm | Sleep | 212 | | NULL | 0.000 | | 714853 | bankfrm | 10.93.97.47:47608 | bankfrm | Sleep | 212 | | NULL | 0.000 | | 715090 | myoper | localhost | NULL | Sleep | 130 | | NULL | 0.000 | | 715112 | myoper | localhost | NULL | Query | 129 | Waiting for backup lock | BACKUP STAGE BLOCK_COMMIT | 0.000 | | 715113 | myoper | localhost | NULL | Sleep | 130 | | NULL | 0.000 | | 715114 | myoper | localhost | NULL | Sleep | 130 | | NULL | 0.000 | | 715115 | myoper | localhost | NULL | Sleep | 130 | | NULL | 0.000 | | 715116 | myoper | localhost | NULL | Sleep | 130 | | NULL | 0.000 | | 715201 | bankfrm | 10.93.97.50:40854 | bankfrm | Sleep | 33 | | NULL | 0.000 | | 715202 | bankfrm | 10.93.97.50:40862 | bankfrm | Sleep | 33 | | NULL | 0.000 | | 715203 | bankfrm | 10.93.97.50:40870 | bankfrm | Sleep | 33 | | NULL | 0.000 | | 715204 | bankfrm | 10.93.97.50:40878 | bankfrm | Sleep | 33 | | NULL | 0.000 | | 715205 | bankfrm | 10.93.97.50:40886 | bankfrm | Sleep | 33 | | NULL | 0.000 | | 715206 | bankfrm | 10.93.97.50:40894 | bankfrm | Sleep | 33 | | NULL | 0.000 | | 715207 | bankfrm | 10.93.97.50:40902 | bankfrm | Sleep | 33 | | NULL | 0.000 | | 715208 | bankfrm | 10.93.97.50:40910 | bankfrm | Sleep | 33 | | NULL | 0.000 | | 715209 | bankfrm | 10.93.97.50:40918 | bankfrm | Sleep | 33 | | NULL | 0.000 | | 715210 | bankfrm | 10.93.97.50:40926 | bankfrm | Sleep | 33 | | NULL | 0.000 | | 715211 | bankfrm | 10.93.97.50:40934 | bankfrm | Sleep | 33 | | NULL | 0.000 | | 715212 | bankfrm | 10.93.97.50:40942 | bankfrm | Sleep | 33 | | NULL | 0.000 | | 715213 | bankfrm | 10.93.97.50:40950 | bankfrm | Sleep | 33 | | NULL | 0.000 | | 715214 | bankfrm | 10.93.97.50:40958 | bankfrm | Sleep | 33 | | NULL | 0.000 | | 715215 | bankfrm | 10.93.97.50:40966 | bankfrm | Sleep | 33 | | NULL | 0.000 | | 715216 | bankfrm | 10.93.97.50:40974 | bankfrm | Sleep | 33 | | NULL | 0.000 | | 715217 | bankfrm | 10.93.97.50:40982 | bankfrm | Sleep | 33 | | NULL | 0.000 | | 715218 | bankfrm | 10.93.97.50:40990 | bankfrm | Sleep | 33 | | NULL | 0.000 | | 715219 | bankfrm | 10.93.97.50:40998 | bankfrm | Sleep | 33 | | NULL | 0.000 | | 715220 | bankfrm | 10.93.97.50:41006 | bankfrm | Sleep | 33 | | NULL | 0.000 | | 715221 | bankfrm | 10.93.97.49:41306 | bankfrm | Sleep | 18 | | NULL | 0.000 | | 715222 | bankfrm | 10.93.97.49:41314 | bankfrm | Sleep | 18 | | NULL | 0.000 | | 715223 | bankfrm | 10.93.97.51:46596 | bankfrm | Sleep | 5 | | NULL | 0.000 | | 715224 | bankfrm | 10.93.97.52:34538 | bankfrm | Sleep | 5 | | NULL | 0.000 | | 715225 | bankfrm | 10.93.97.50:41274 | bankfrm | Sleep | 5 | | NULL | 0.000 | | 715226 | bankfrm | 10.91.107.232:38107 | bankfrm | Sleep | 5 | | NULL | 0.000 | | 715227 | bankfrm | 10.91.107.232:47135 | bankfrm | Sleep | 5 | | NULL | 0.000 | | 715228 | bankfrm | 10.93.97.51:46598 | bankfrm | Sleep | 5 | | NULL | 0.000 | | 715229 | bankfrm | 10.93.97.48:49942 | bankfrm | Sleep | 5 | | NULL | 0.000 | | 715230 | bankfrm | 10.93.97.48:49944 | bankfrm | Sleep | 5 | | NULL | 0.000 | | 715231 | bankfrm | 10.93.97.47:53150 | bankfrm | Sleep | 5 | | NULL | 0.000 | | 715232 | bankfrm | 10.93.97.47:53152 | bankfrm | Sleep | 5 | | NULL | 0.000 | | 715233 | bankfrm | 10.93.97.5:37734 | bankfrm | Sleep | 5 | | NULL | 0.000 | | 715234 | bankfrm | 10.91.107.232:8418 | bankfrm | Sleep | 5 | | NULL | 0.000 | | 715235 | bankfrm | 10.93.97.53:42854 | bankfrm | Sleep | 5 | | NULL | 0.000 | | 715236 | bankfrm | 10.93.97.52:34542 | bankfrm | Sleep | 5 | | NULL | 0.000 | | 715237 | bankfrm | 10.93.97.28:40930 | bankfrm | Sleep | 5 | | NULL | 0.000 | | 715238 | bankfrm | 10.93.97.49:41608 | bankfrm | Sleep | 5 | | NULL | 0.000 | | 715239 | bankfrm | 10.93.97.50:41328 | bankfrm | Sleep | 5 | | NULL | 0.000 | | 715240 | bankfrm | 10.93.97.48:49950 | bankfrm | Sleep | 5 | | NULL | 0.000 | | 715241 | bankfrm | 10.93.97.47:53154 | bankfrm | Sleep | 5 | | NULL | 0.000 | | 715242 | bankfrm | 10.93.97.28:40934 | bankfrm | Sleep | 5 | | NULL | 0.000 | | 715243 | bankfrm | 10.93.97.53:42884 | bankfrm | Sleep | 1 | | NULL | 0.000 | | 715244 | bankfrm | 10.93.97.5:37764 | bankfrm | Sleep | 1 | | NULL | 0.000 | | 715245 | bankfrm | 10.93.97.51:46648 | bankfrm | Sleep | 1 | | NULL | 0.000 | | 715256 | myoper | localhost | NULL | Query | 0 | starting | show full processlist | 0.000 | +--------+-------------+---------------------+---------+--------------+--------+--------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+ +---------------------+----------------+-------+ | DateTime | Sessions | Total | +---------------------+----------------+-------+ | 2023-01-12-03:33:02 | Total_Sessions | 517 | +---------------------+----------------+-------+ +---------------------+--------------+-------+ | DateTime | Command | Total | +---------------------+--------------+-------+ | 2023-01-12-03:33:02 | Query | 2 | | 2023-01-12-03:33:02 | Slave_IO | 1 | | 2023-01-12-03:33:02 | Slave_SQL | 1 | | 2023-01-12-03:33:02 | Slave_worker | 6 | | 2023-01-12-03:33:02 | Sleep | 507 | +---------------------+--------------+-------+ +---------------------+-------------+-------+ | DateTime | User | Total | +---------------------+-------------+-------+ | 2023-01-12-03:33:02 | bankfrm | 461 | | 2023-01-12-03:33:02 | myoper | 7 | | 2023-01-12-03:33:02 | repuser | 41 | | 2023-01-12-03:33:02 | system user | 8 | +---------------------+-------------+-------+ +---------------------+-------------+--------------+-------+ | DateTime | User | Command | Total | +---------------------+-------------+--------------+-------+ | 2023-01-12-03:33:02 | bankfrm | Sleep | 461 | | 2023-01-12-03:33:02 | myoper | Query | 2 | | 2023-01-12-03:33:02 | myoper | Sleep | 5 | | 2023-01-12-03:33:02 | repuser | Sleep | 41 | | 2023-01-12-03:33:02 | system user | Slave_IO | 1 | | 2023-01-12-03:33:02 | system user | Slave_SQL | 1 | | 2023-01-12-03:33:02 | system user | Slave_worker | 6 | +---------------------+-------------+--------------+-------+ +---------------------+-------------+-----------------+--------------+-------+ | DateTime | User | Connection_from | Command | Total | +---------------------+-------------+-----------------+--------------+-------+ | 2023-01-12-03:33:02 | bankfrm | 10.91.107.232 | Sleep | 25 | | 2023-01-12-03:33:02 | bankfrm | 10.93.97.28 | Sleep | 26 | | 2023-01-12-03:33:02 | bankfrm | 10.93.97.47 | Sleep | 63 | | 2023-01-12-03:33:02 | bankfrm | 10.93.97.48 | Sleep | 26 | | 2023-01-12-03:33:02 | bankfrm | 10.93.97.49 | Sleep | 75 | | 2023-01-12-03:33:02 | bankfrm | 10.93.97.5 | Sleep | 93 | | 2023-01-12-03:33:02 | bankfrm | 10.93.97.50 | Sleep | 76 | | 2023-01-12-03:33:02 | bankfrm | 10.93.97.51 | Sleep | 26 | | 2023-01-12-03:33:02 | bankfrm | 10.93.97.52 | Sleep | 25 | | 2023-01-12-03:33:02 | bankfrm | 10.93.97.53 | Sleep | 26 | | 2023-01-12-03:33:02 | myoper | localhost | Query | 2 | | 2023-01-12-03:33:02 | myoper | localhost | Sleep | 5 | | 2023-01-12-03:33:02 | repuser | 10.91.135.91 | Sleep | 1 | | 2023-01-12-03:33:02 | repuser | 10.91.135.92 | Sleep | 1 | | 2023-01-12-03:33:02 | repuser | 10.93.97.28 | Sleep | 1 | | 2023-01-12-03:33:02 | repuser | 10.93.97.29 | Sleep | 1 | | 2023-01-12-03:33:02 | repuser | 10.93.97.37 | Sleep | 1 | | 2023-01-12-03:33:02 | repuser | 10.93.97.38 | Sleep | 1 | | 2023-01-12-03:33:02 | repuser | 10.93.97.39 | Sleep | 1 | | 2023-01-12-03:33:02 | repuser | 10.93.97.4 | Sleep | 1 | | 2023-01-12-03:33:02 | repuser | 10.93.97.40 | Sleep | 1 | | 2023-01-12-03:33:02 | repuser | 10.93.97.41 | Sleep | 1 | | 2023-01-12-03:33:02 | repuser | 10.93.97.43 | Sleep | 1 | | 2023-01-12-03:33:02 | repuser | 10.93.97.44 | Sleep | 1 | | 2023-01-12-03:33:02 | repuser | 10.93.97.46 | Sleep | 1 | | 2023-01-12-03:33:02 | repuser | 10.93.97.47 | Sleep | 1 | | 2023-01-12-03:33:02 | repuser | 10.93.97.48 | Sleep | 1 | | 2023-01-12-03:33:02 | repuser | 10.93.97.49 | Sleep | 1 | | 2023-01-12-03:33:02 | repuser | 10.93.97.5 | Sleep | 1 | | 2023-01-12-03:33:02 | repuser | 10.93.97.50 | Sleep | 1 | | 2023-01-12-03:33:02 | repuser | 10.93.97.51 | Sleep | 1 | | 2023-01-12-03:33:02 | repuser | 10.93.97.52 | Sleep | 1 | | 2023-01-12-03:33:02 | repuser | 10.93.97.53 | Sleep | 1 | | 2023-01-12-03:33:02 | repuser | 10.93.97.54 | Sleep | 1 | | 2023-01-12-03:33:02 | repuser | 10.93.97.55 | Sleep | 1 | | 2023-01-12-03:33:02 | repuser | 10.93.97.56 | Sleep | 1 | | 2023-01-12-03:33:02 | repuser | 10.93.97.57 | Sleep | 1 | | 2023-01-12-03:33:02 | repuser | 10.93.97.58 | Sleep | 1 | | 2023-01-12-03:33:02 | repuser | 10.93.97.59 | Sleep | 1 | | 2023-01-12-03:33:02 | repuser | 10.93.97.6 | Sleep | 1 | | 2023-01-12-03:33:02 | repuser | 10.93.97.61 | Sleep | 1 | | 2023-01-12-03:33:02 | repuser | 10.93.98.28 | Sleep | 1 | | 2023-01-12-03:33:02 | repuser | 10.93.98.37 | Sleep | 1 | | 2023-01-12-03:33:02 | repuser | 10.93.98.38 | Sleep | 1 | | 2023-01-12-03:33:02 | repuser | 10.93.98.4 | Sleep | 1 | | 2023-01-12-03:33:02 | repuser | 10.93.98.40 | Sleep | 1 | | 2023-01-12-03:33:02 | repuser | 10.93.98.41 | Sleep | 1 | | 2023-01-12-03:33:02 | repuser | 10.93.99.157 | Sleep | 1 | | 2023-01-12-03:33:02 | repuser | 10.93.99.158 | Sleep | 1 | | 2023-01-12-03:33:02 | repuser | 10.93.99.159 | Sleep | 1 | | 2023-01-12-03:33:02 | repuser | 10.93.99.16 | Sleep | 1 | | 2023-01-12-03:33:02 | repuser | 10.93.99.160 | Sleep | 1 | | 2023-01-12-03:33:02 | repuser | 10.93.99.161 | Sleep | 1 | | 2023-01-12-03:33:02 | system user | | Slave_IO | 1 | | 2023-01-12-03:33:02 | system user | | Slave_SQL | 1 | | 2023-01-12-03:33:02 | system user | | Slave_worker | 6 | +---------------------+-------------+-----------------+--------------+-------+ +---------------------+-----------------+-------+ | DateTime | Connection_from | Total | +---------------------+-----------------+-------+ | 2023-01-12-03:33:02 | 10.93.97.5 | 94 | | 2023-01-12-03:33:02 | 10.93.97.50 | 77 | | 2023-01-12-03:33:02 | 10.93.97.49 | 76 | | 2023-01-12-03:33:02 | 10.93.97.47 | 64 | | 2023-01-12-03:33:02 | 10.93.97.51 | 27 | | 2023-01-12-03:33:02 | 10.93.97.48 | 27 | | 2023-01-12-03:33:02 | 10.93.97.28 | 27 | | 2023-01-12-03:33:02 | 10.93.97.53 | 27 | | 2023-01-12-03:33:02 | 10.93.97.52 | 26 | | 2023-01-12-03:33:02 | 10.91.107.232 | 25 | | 2023-01-12-03:33:02 | | 8 | | 2023-01-12-03:33:02 | localhost | 7 | | 2023-01-12-03:33:02 | 10.93.99.160 | 1 | | 2023-01-12-03:33:02 | 10.93.98.4 | 1 | | 2023-01-12-03:33:02 | 10.93.97.29 | 1 | | 2023-01-12-03:33:02 | 10.93.98.28 | 1 | | 2023-01-12-03:33:02 | 10.93.98.41 | 1 | | 2023-01-12-03:33:02 | 10.93.97.57 | 1 | | 2023-01-12-03:33:02 | 10.93.97.39 | 1 | | 2023-01-12-03:33:02 | 10.93.97.41 | 1 | | 2023-01-12-03:33:02 | 10.93.99.159 | 1 | | 2023-01-12-03:33:02 | 10.91.135.92 | 1 | | 2023-01-12-03:33:02 | 10.93.99.157 | 1 | | 2023-01-12-03:33:02 | 10.93.97.58 | 1 | | 2023-01-12-03:33:02 | 10.93.97.46 | 1 | | 2023-01-12-03:33:02 | 10.93.97.61 | 1 | | 2023-01-12-03:33:02 | 10.93.99.158 | 1 | | 2023-01-12-03:33:02 | 10.91.135.91 | 1 | | 2023-01-12-03:33:02 | 10.93.97.37 | 1 | | 2023-01-12-03:33:02 | 10.93.97.6 | 1 | | 2023-01-12-03:33:02 | 10.93.98.37 | 1 | | 2023-01-12-03:33:02 | 10.93.97.40 | 1 | | 2023-01-12-03:33:02 | 10.93.99.161 | 1 | | 2023-01-12-03:33:02 | 10.93.97.55 | 1 | | 2023-01-12-03:33:02 | 10.93.97.44 | 1 | | 2023-01-12-03:33:02 | 10.93.98.38 | 1 | | 2023-01-12-03:33:02 | 10.93.97.43 | 1 | | 2023-01-12-03:33:02 | 10.93.97.4 | 1 | | 2023-01-12-03:33:02 | 10.93.99.16 | 1 | | 2023-01-12-03:33:02 | 10.93.97.56 | 1 | | 2023-01-12-03:33:02 | 10.93.97.38 | 1 | | 2023-01-12-03:33:02 | 10.93.97.54 | 1 | | 2023-01-12-03:33:02 | 10.93.98.40 | 1 | | 2023-01-12-03:33:02 | 10.93.97.59 | 1 | +---------------------+-----------------+-------+ *********************************************************************************************************** 20230112_033302 : show engine innodb status *************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 2023-01-12 03:33:02 0x7fac80a1d700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 0 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 0 srv_active, 0 srv_shutdown, 476268 srv_idle srv_master_thread log flush and writes: 476243 ---------- SEMAPHORES ---------- ------------ TRANSACTIONS ------------ Trx id counter 12672207462 Purge done for trx's n:o < 12672207461 undo n:o < 0 state: running but idle History list length 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 12672207325, ACTIVE 129 sec 2 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 1 MariaDB thread id 3995, OS thread handle 140387326506752, query id 65321900 Waiting for prior transaction to commit ---TRANSACTION 12672207307, ACTIVE 129 sec 2 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 1 MariaDB thread id 3997, OS thread handle 140387327047424, query id 65321892 Waiting for prior transaction to commit ---TRANSACTION 12672207456, ACTIVE 129 sec 2 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 1 MariaDB thread id 3992, OS thread handle 140378919474944, query id 65321958 Waiting for prior transaction to commit ---TRANSACTION 12672207461, ACTIVE 129 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 1128, 0 row lock(s), undo log entries 1 MariaDB thread id 3993, OS thread handle 140387326236416, query id 65321959 Waiting for backup lock ---TRANSACTION 12672207049, ACTIVE (PREPARED) 129 sec recovered trx 2 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 1 ---TRANSACTION 12672207040, ACTIVE (PREPARED) 129 sec recovered trx 2 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 1 ---TRANSACTION 12672207037, ACTIVE (PREPARED) 129 sec recovered trx 2 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 1 ---TRANSACTION 12672207034, ACTIVE (PREPARED) 129 sec recovered trx 2 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 1 ---TRANSACTION 12672207185, ACTIVE (PREPARED) 129 sec recovered trx 2 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 1 ---TRANSACTION 12672207029, ACTIVE (PREPARED) 129 sec recovered trx 2 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 1 ---TRANSACTION 12672207025, ACTIVE (PREPARED) 129 sec recovered trx 2 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 1 ---TRANSACTION (0x7fb2b42a6c80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 12672206985, ACTIVE (PREPARED) 130 sec recovered trx 2 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 1 ---TRANSACTION 12672206978, ACTIVE (PREPARED) 130 sec recovered trx 2 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 1 ---TRANSACTION 12672207428, ACTIVE (PREPARED) 129 sec 3 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 2 MariaDB thread id 3996, OS thread handle 140387327317760, query id 65321941 Waiting for prior transaction to commit ---TRANSACTION 12672206714, ACTIVE (PREPARED) 130 sec recovered trx 2 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 1 ---TRANSACTION 12672206696, ACTIVE (PREPARED) 130 sec recovered trx 2 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 1 ---TRANSACTION 12672207266, ACTIVE (PREPARED) 129 sec recovered trx 2 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 1 ---TRANSACTION 12672206663, ACTIVE (PREPARED) 130 sec recovered trx 2 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 1 ---TRANSACTION 12672206637, ACTIVE (PREPARED) 130 sec recovered trx 2 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 1 ---TRANSACTION 12672206543, ACTIVE (PREPARED) 130 sec recovered trx 2 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 1 ---TRANSACTION 12672206501, ACTIVE (PREPARED) 130 sec recovered trx 2 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 1 ---TRANSACTION 12672206498, ACTIVE (PREPARED) 130 sec recovered trx 2 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 1 ---TRANSACTION 12672207022, ACTIVE (PREPARED) 129 sec recovered trx 2 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 1 ---TRANSACTION (0x7fb2b42a5680), not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION (0x7fb2b42a4b80), not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- Pending flushes (fsync) log: 0; buffer pool: 0 425519 OS file reads, 34974886 OS file writes, 34851466 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 56, seg size 58, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 6625444758596 Log flushed up to 6625444758596 Pages flushed up to 6625270847160 Last checkpoint at 6625270847160 0 pending log flushes, 0 pending chkp writes 34849934 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 17314086912 Dictionary memory allocated 106833720 Buffer pool size 1038336 Free buffers 592737 Database pages 445599 Old database pages 164468 Modified db pages 20616 Percent of dirty pages(LRU & free pages): 1.985 Max dirty pages percent: 50.000 Pending reads 0 Pending writes: LRU 0, flush list 0 Pages made young 877, not young 19 0.00 youngs/s, 0.00 non-youngs/s Pages read 425248, created 35045, written 124879 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 445599, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 read views open inside InnoDB Process ID=0, Main thread ID=0, state: sleeping Number of rows inserted 3578883, updated 10127835, deleted 3569689, read 112264653 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 23249404, updated 0, deleted 23249342, read 23249343 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ *********************************************************************************************************** 20230112_033302 : show global status +--------------------------------------------------------+-----------------------------------------------------------------------------------+ | Variable_name | Value | +--------------------------------------------------------+-----------------------------------------------------------------------------------+ | Aborted_clients | 3803 | | Aborted_connects | 0 | | Aborted_connects_preauth | 0 | | Access_denied_errors | 129 | | Acl_column_grants | 259 | | Acl_database_grants | 27 | | Acl_function_grants | 0 | | Acl_procedure_grants | 0 | | Acl_package_spec_grants | 0 | | Acl_package_body_grants | 0 | | Acl_proxy_users | 0 | | Acl_role_grants | 0 | | Acl_roles | 0 | | Acl_table_grants | 367 | | Acl_users | 63 | | Aria_pagecache_blocks_not_flushed | 0 | | Aria_pagecache_blocks_unused | 15646 | | Aria_pagecache_blocks_used | 193 | | Aria_pagecache_read_requests | 26674636 | | Aria_pagecache_reads | 3882846 | | Aria_pagecache_write_requests | 178360 | | Aria_pagecache_writes | 181636 | | Aria_transaction_log_syncs | 189 | | Binlog_commits | 23249337 | | Binlog_group_commits | 20643048 | | Binlog_group_commit_trigger_count | 0 | | Binlog_group_commit_trigger_lock_wait | 0 | | Binlog_group_commit_trigger_timeout | 0 | | Binlog_snapshot_file | bin_log.000043 | | Binlog_snapshot_position | 2829152 | | Binlog_bytes_written | 9823473494 | | Binlog_cache_disk_use | 0 | | Binlog_cache_use | 1910547 | | Binlog_stmt_cache_disk_use | 0 | | Binlog_stmt_cache_use | 0 | | Busy_time | 11269.223262 | | Bytes_received | 11694390061 | | Bytes_sent | 14994745822 | | Column_compressions | 0 | | Column_decompressions | 0 | | Com_admin_commands | 3858240 | | Com_alter_db | 0 | | Com_alter_db_upgrade | 0 | | Com_alter_event | 0 | | Com_alter_function | 0 | | Com_alter_procedure | 0 | | Com_alter_server | 0 | | Com_alter_sequence | 0 | | Com_alter_table | 0 | | Com_alter_tablespace | 0 | | Com_alter_user | 0 | | Com_analyze | 240 | | Com_assign_to_keycache | 0 | | Com_backup | 34 | | Com_backup_lock | 434 | | Com_begin | 11105116 | | Com_binlog | 0 | | Com_call_procedure | 1 | | Com_change_db | 282276 | | Com_change_master | 3 | | Com_check | 0 | | Com_checksum | 0 | | Com_commit | 17177236 | | Com_compound_sql | 0 | | Com_create_db | 0 | | Com_create_event | 0 | | Com_create_function | 0 | | Com_create_index | 0 | | Com_create_package | 0 | | Com_create_package_body | 0 | | Com_create_procedure | 1 | | Com_create_role | 0 | | Com_create_sequence | 0 | | Com_create_server | 0 | | Com_create_table | 0 | | Com_create_temporary_table | 0 | | Com_create_trigger | 0 | | Com_create_udf | 0 | | Com_create_user | 0 | | Com_create_view | 0 | | Com_dealloc_sql | 1 | | Com_delete | 3539590 | | Com_delete_multi | 0 | | Com_do | 0 | | Com_drop_db | 0 | | Com_drop_event | 0 | | Com_drop_function | 0 | | Com_drop_index | 0 | | Com_drop_procedure | 0 | | Com_drop_package | 0 | | Com_drop_package_body | 0 | | Com_drop_role | 0 | | Com_drop_server | 0 | | Com_drop_sequence | 0 | | Com_drop_table | 0 | | Com_drop_temporary_table | 0 | | Com_drop_trigger | 0 | | Com_drop_user | 0 | | Com_drop_view | 0 | | Com_empty_query | 0 | | Com_execute_immediate | 0 | | Com_execute_sql | 1 | | Com_flush | 40 | | Com_get_diagnostics | 0 | | Com_grant | 0 | | Com_grant_role | 0 | | Com_ha_close | 0 | | Com_ha_open | 0 | | Com_ha_read | 0 | | Com_help | 0 | | Com_insert | 3578883 | | Com_insert_select | 0 | | Com_install_plugin | 0 | | Com_kill | 0 | | Com_load | 0 | | Com_lock_tables | 0 | | Com_optimize | 0 | | Com_preload_keys | 0 | | Com_prepare_sql | 1 | | Com_purge | 0 | | Com_purge_before_date | 6 | | Com_release_savepoint | 0 | | Com_rename_table | 0 | | Com_rename_user | 0 | | Com_repair | 0 | | Com_replace | 0 | | Com_replace_select | 0 | | Com_reset | 3 | | Com_resignal | 0 | | Com_revoke | 0 | | Com_revoke_all | 0 | | Com_revoke_role | 0 | | Com_rollback | 0 | | Com_rollback_to_savepoint | 0 | | Com_savepoint | 0 | | Com_select | 13813605 | | Com_set_option | 565532 | | Com_show_authors | 0 | | Com_show_binlog_events | 0 | | Com_show_binlogs | 0 | | Com_show_charsets | 0 | | Com_show_collations | 1 | | Com_show_contributors | 0 | | Com_show_create_db | 0 | | Com_show_create_event | 0 | | Com_show_create_func | 0 | | Com_show_create_package | 0 | | Com_show_create_package_body | 0 | | Com_show_create_proc | 0 | | Com_show_create_table | 2 | | Com_show_create_trigger | 0 | | Com_show_create_user | 0 | | Com_show_databases | 44 | | Com_show_engine_logs | 0 | | Com_show_engine_mutex | 0 | | Com_show_engine_status | 1602 | | Com_show_errors | 0 | | Com_show_events | 1 | | Com_show_explain | 0 | | Com_show_fields | 0 | | Com_show_function_status | 2 | | Com_show_generic | 0 | | Com_show_grants | 386 | | Com_show_keys | 0 | | Com_show_binlog_status | 1637 | | Com_show_open_tables | 7 | | Com_show_package_status | 0 | | Com_show_package_body_status | 0 | | Com_show_plugins | 0 | | Com_show_privileges | 0 | | Com_show_procedure_status | 2 | | Com_show_processlist | 3817 | | Com_show_profile | 0 | | Com_show_profiles | 0 | | Com_show_relaylog_events | 0 | | Com_show_slave_hosts | 0 | | Com_show_slave_status | 3850520 | | Com_show_status | 4859 | | Com_show_storage_engines | 1 | | Com_show_table_status | 0 | | Com_show_tables | 3 | | Com_show_triggers | 2 | | Com_show_variables | 46104 | | Com_show_warnings | 0 | | Com_shutdown | 0 | | Com_signal | 0 | | Com_start_all_slaves | 0 | | Com_start_slave | 3 | | Com_stmt_close | 2 | | Com_stmt_execute | 2 | | Com_stmt_fetch | 0 | | Com_stmt_prepare | 2 | | Com_stmt_reprepare | 0 | | Com_stmt_reset | 0 | | Com_stmt_send_long_data | 0 | | Com_stop_all_slaves | 0 | | Com_stop_slave | 3 | | Com_truncate | 0 | | Com_uninstall_plugin | 0 | | Com_unlock_tables | 0 | | Com_update | 10087848 | | Com_update_multi | 0 | | Com_xa_commit | 6072102 | | Com_xa_end | 6072123 | | Com_xa_prepare | 0 | | Com_xa_recover | 13952 | | Com_xa_rollback | 1 | | Com_xa_start | 6072124 | | Compression | OFF | | Connection_errors_accept | 0 | | Connection_errors_internal | 0 | | Connection_errors_max_connections | 0 | | Connection_errors_peer_address | 0 | | Connection_errors_select | 0 | | Connection_errors_tcpwrap | 0 | | Connections | 715264 | | Cpu_time | 6651.717219 | | Created_tmp_disk_tables | 3882500 | | Created_tmp_files | 0 | | Created_tmp_tables | 3990530 | | Delayed_errors | 0 | | Delayed_insert_threads | 0 | | Delayed_writes | 0 | | Delete_scan | 0 | | Empty_queries | 3870596 | | Executed_events | 0 | | Executed_triggers | 0 | | Feature_application_time_periods | 0 | | Feature_check_constraint | 1 | | Feature_custom_aggregate_functions | 0 | | Feature_delay_key_write | 0 | | Feature_dynamic_columns | 0 | | Feature_fulltext | 0 | | Feature_gis | 0 | | Feature_insert_returning | 0 | | Feature_invisible_columns | 0 | | Feature_json | 9597 | | Feature_locale | 0 | | Feature_subquery | 114 | | Feature_system_versioning | 0 | | Feature_timezone | 0 | | Feature_trigger | 0 | | Feature_window_functions | 0 | | Feature_xml | 0 | | Handler_commit | 84080880 | | Handler_delete | 26819032 | | Handler_discover | 498 | | Handler_external_lock | 0 | | Handler_icp_attempts | 0 | | Handler_icp_match | 0 | | Handler_mrr_init | 0 | | Handler_mrr_key_refills | 0 | | Handler_mrr_rowid_refills | 0 | | Handler_prepare | 68767112 | | Handler_read_first | 628 | | Handler_read_key | 3956590 | | Handler_read_last | 0 | | Handler_read_next | 57198041 | | Handler_read_prev | 0 | | Handler_read_retry | 0 | | Handler_read_rnd | 37139921 | | Handler_read_rnd_deleted | 12 | | Handler_read_rnd_next | 61867224 | | Handler_rollback | 2 | | Handler_savepoint | 0 | | Handler_savepoint_rollback | 0 | | Handler_tmp_delete | 0 | | Handler_tmp_update | 3762064 | | Handler_tmp_write | 20400510 | | Handler_update | 10131310 | | Handler_write | 26828288 | | Innodb_adaptive_hash_hash_searches | 0 | | Innodb_adaptive_hash_non_hash_searches | 0 | | Innodb_background_log_sync | 476243 | | Innodb_buffer_pool_dump_status | | | Innodb_buffer_pool_load_status | Cannot open '/mariadb/data/ib_buffer_pool' for reading: No such file or directory | | Innodb_buffer_pool_resize_status | | | Innodb_buffer_pool_load_incomplete | OFF | | Innodb_buffer_pool_pages_data | 445599 | | Innodb_buffer_pool_bytes_data | 7300694016 | | Innodb_buffer_pool_pages_dirty | 20616 | | Innodb_buffer_pool_bytes_dirty | 337772544 | | Innodb_buffer_pool_pages_flushed | 124879 | | Innodb_buffer_pool_pages_free | 592737 | | Innodb_buffer_pool_pages_made_not_young | 19 | | Innodb_buffer_pool_pages_made_young | 877 | | Innodb_buffer_pool_pages_misc | 0 | | Innodb_buffer_pool_pages_old | 164468 | | Innodb_buffer_pool_pages_total | 1038336 | | Innodb_buffer_pool_pages_lru_flushed | 0 | | Innodb_buffer_pool_pages_lru_freed | 0 | | Innodb_buffer_pool_read_ahead_rnd | 0 | | Innodb_buffer_pool_read_ahead | 0 | | Innodb_buffer_pool_read_ahead_evicted | 0 | | Innodb_buffer_pool_read_requests | 980952662 | | Innodb_buffer_pool_reads | 425248 | | Innodb_buffer_pool_wait_free | 0 | | Innodb_buffer_pool_write_requests | 406716291 | | Innodb_checkpoint_age | 173911436 | | Innodb_checkpoint_max_age | 3478214063 | | Innodb_data_fsyncs | 34851466 | | Innodb_data_pending_fsyncs | 0 | | Innodb_data_pending_reads | 0 | | Innodb_data_pending_writes | 0 | | Innodb_data_read | 6967263232 | | Innodb_data_reads | 425519 | | Innodb_data_writes | 34974886 | | Innodb_data_written | 2046007154 | | Innodb_dblwr_pages_written | 6002 | | Innodb_dblwr_writes | 73 | | Innodb_deadlocks | 0 | | Innodb_history_list_length | 0 | | Innodb_ibuf_discarded_delete_marks | 0 | | Innodb_ibuf_discarded_deletes | 0 | | Innodb_ibuf_discarded_inserts | 0 | | Innodb_ibuf_free_list | 56 | | Innodb_ibuf_merged_delete_marks | 0 | | Innodb_ibuf_merged_deletes | 0 | | Innodb_ibuf_merged_inserts | 0 | | Innodb_ibuf_merges | 0 | | Innodb_ibuf_segment_size | 58 | | Innodb_ibuf_size | 1 | | Innodb_log_waits | 0 | | Innodb_log_write_requests | 1483033 | | Innodb_log_writes | 34849934 | | Innodb_lsn_current | 6625444758596 | | Innodb_lsn_flushed | 6625444758596 | | Innodb_lsn_last_checkpoint | 6625270847160 | | Innodb_master_thread_active_loops | 0 | | Innodb_master_thread_idle_loops | 476268 | | Innodb_max_trx_id | 12672207462 | | Innodb_mem_adaptive_hash | 0 | | Innodb_mem_dictionary | 106833720 | | Innodb_os_log_fsyncs | 34850852 | | Innodb_os_log_pending_fsyncs | 0 | | Innodb_os_log_pending_writes | 0 | | Innodb_os_log_written | 48226099200 | | Innodb_page_size | 16384 | | Innodb_pages_created | 35045 | | Innodb_pages_read | 425248 | | Innodb_pages_written | 124879 | | Innodb_row_lock_current_waits | 0 | | Innodb_row_lock_time | 0 | | Innodb_row_lock_time_avg | 0 | | Innodb_row_lock_time_max | 0 | | Innodb_row_lock_waits | 2 | | Innodb_rows_deleted | 3569689 | | Innodb_rows_inserted | 3578883 | | Innodb_rows_read | 112264653 | | Innodb_rows_updated | 10127835 | | Innodb_system_rows_deleted | 23249342 | | Innodb_system_rows_inserted | 23249404 | | Innodb_system_rows_read | 23249343 | | Innodb_system_rows_updated | 0 | | Innodb_num_open_files | 267 | | Innodb_truncated_status_writes | 0 | | Innodb_available_undo_logs | 128 | | Innodb_undo_truncations | 0 | | Innodb_page_compression_saved | 0 | | Innodb_num_pages_page_compressed | 0 | | Innodb_num_page_compressed_trim_op | 0 | | Innodb_num_pages_page_decompressed | 0 | | Innodb_num_pages_page_compression_error | 0 | | Innodb_num_pages_encrypted | 0 | | Innodb_num_pages_decrypted | 0 | | Innodb_have_lz4 | ON | | Innodb_have_lzo | OFF | | Innodb_have_lzma | ON | | Innodb_have_bzip2 | OFF | | Innodb_have_snappy | OFF | | Innodb_have_punch_hole | ON | | Innodb_defragment_compression_failures | 0 | | Innodb_defragment_failures | 0 | | Innodb_defragment_count | 0 | | Innodb_instant_alter_column | 0 | | Innodb_onlineddl_rowlog_rows | 0 | | Innodb_onlineddl_rowlog_pct_used | 0 | | Innodb_onlineddl_pct_progress | 0 | | Innodb_secondary_index_triggered_cluster_reads | 0 | | Innodb_secondary_index_triggered_cluster_reads_avoided | 0 | | Innodb_encryption_rotation_pages_read_from_cache | 0 | | Innodb_encryption_rotation_pages_read_from_disk | 0 | | Innodb_encryption_rotation_pages_modified | 0 | | Innodb_encryption_rotation_pages_flushed | 0 | | Innodb_encryption_rotation_estimated_iops | 0 | | Innodb_encryption_n_merge_blocks_encrypted | 0 | | Innodb_encryption_n_merge_blocks_decrypted | 0 | | Innodb_encryption_n_rowlog_blocks_encrypted | 0 | | Innodb_encryption_n_rowlog_blocks_decrypted | 0 | | Innodb_encryption_n_temp_blocks_encrypted | 0 | | Innodb_encryption_n_temp_blocks_decrypted | 0 | | Innodb_encryption_num_key_requests | 0 | | Key_blocks_not_flushed | 0 | | Key_blocks_unused | 53578 | | Key_blocks_used | 0 | | Key_blocks_warm | 0 | | Key_read_requests | 0 | | Key_reads | 0 | | Key_write_requests | 0 | | Key_writes | 0 | | Last_query_cost | 0.000000 | | Master_gtid_wait_count | 0 | | Master_gtid_wait_time | 0 | | Master_gtid_wait_timeouts | 0 | | Max_statement_time_exceeded | 0 | | Max_used_connections | 524 | | Memory_used | 748489176 | | Memory_used_initial | 31683464 | | Not_flushed_delayed_rows | 0 | | Open_files | 16 | | Open_streams | 4 | | Open_table_definitions | 5 | | Open_tables | 14 | | Opened_files | 15534456 | | Opened_plugin_libraries | 0 | | Opened_table_definitions | 2518 | | Opened_tables | 2678 | | Opened_views | 1833 | | Performance_schema_accounts_lost | 0 | | Performance_schema_cond_classes_lost | 0 | | Performance_schema_cond_instances_lost | 0 | | Performance_schema_digest_lost | 0 | | Performance_schema_file_classes_lost | 0 | | Performance_schema_file_handles_lost | 0 | | Performance_schema_file_instances_lost | 0 | | Performance_schema_hosts_lost | 0 | | Performance_schema_index_stat_lost | 0 | | Performance_schema_locker_lost | 0 | | Performance_schema_memory_classes_lost | 0 | | Performance_schema_metadata_lock_lost | 0 | | Performance_schema_mutex_classes_lost | 0 | | Performance_schema_mutex_instances_lost | 0 | | Performance_schema_nested_statement_lost | 0 | | Performance_schema_prepared_statements_lost | 0 | | Performance_schema_program_lost | 0 | | Performance_schema_rwlock_classes_lost | 0 | | Performance_schema_rwlock_instances_lost | 0 | | Performance_schema_session_connect_attrs_lost | 0 | | Performance_schema_socket_classes_lost | 0 | | Performance_schema_socket_instances_lost | 0 | | Performance_schema_stage_classes_lost | 0 | | Performance_schema_statement_classes_lost | 0 | | Performance_schema_table_handles_lost | 0 | | Performance_schema_table_instances_lost | 0 | | Performance_schema_table_lock_stat_lost | 0 | | Performance_schema_thread_classes_lost | 0 | | Performance_schema_thread_instances_lost | 0 | | Performance_schema_users_lost | 0 | | Prepared_stmt_count | 0 | | Qcache_free_blocks | 0 | | Qcache_free_memory | 0 | | Qcache_hits | 0 | | Qcache_inserts | 0 | | Qcache_lowmem_prunes | 0 | | Qcache_not_cached | 0 | | Qcache_queries_in_cache | 0 | | Qcache_total_blocks | 0 | | Queries | 65326900 | | Questions | 18799027 | | Resultset_metadata_skipped | 0 | | Rows_read | 135550651 | | Rows_sent | 11370982 | | Rows_tmp_read | 16620002 | | Rpl_semi_sync_master_clients | 0 | | Rpl_semi_sync_master_get_ack | 0 | | Rpl_semi_sync_master_net_avg_wait_time | 0 | | Rpl_semi_sync_master_net_wait_time | 0 | | Rpl_semi_sync_master_net_waits | 0 | | Rpl_semi_sync_master_no_times | 0 | | Rpl_semi_sync_master_no_tx | 2526108 | | Rpl_semi_sync_master_request_ack | 4 | | Rpl_semi_sync_master_status | OFF | | Rpl_semi_sync_master_timefunc_failures | 0 | | Rpl_semi_sync_master_tx_avg_wait_time | 0 | | Rpl_semi_sync_master_tx_wait_time | 0 | | Rpl_semi_sync_master_tx_waits | 0 | | Rpl_semi_sync_master_wait_pos_backtraverse | 0 | | Rpl_semi_sync_master_wait_sessions | 0 | | Rpl_semi_sync_master_yes_tx | 0 | | Rpl_semi_sync_slave_send_ack | 23021635 | | Rpl_semi_sync_slave_status | ON | | Rpl_status | AUTH_MASTER | | Rpl_transactions_multi_engine | 0 | | Select_full_join | 39845 | | Select_full_range_join | 0 | | Select_range | 14 | | Select_range_check | 0 | | Select_scan | 3936813 | | Server_audit_active | ON | | Server_audit_current_log | /mariadb/bin/logs/audit_logs/audit_mariadb.log | | Server_audit_last_error | | | Server_audit_session_filter | N/A | | Server_audit_writes_failed | 0 | | Slave_connections | 0 | | Slave_heartbeat_period | 5.000 | | Slave_open_temp_tables | 0 | | Slave_received_heartbeats | 78647 | | Slave_retried_transactions | 0 | | Slave_running | ON | | Slave_skipped_errors | 0 | | Slaves_connected | 0 | | Slaves_running | 1 | | Slow_launch_threads | 0 | | Slow_queries | 0 | | Sort_merge_passes | 0 | | Sort_priority_queue_sorts | 0 | | Sort_range | 0 | | Sort_rows | 193054 | | Sort_scan | 14376 | | Ssl_accept_renegotiates | 0 | | Ssl_accepts | 0 | | Ssl_callback_cache_hits | 0 | | Ssl_cipher | | | Ssl_cipher_list | | | Ssl_client_connects | 0 | | Ssl_connect_renegotiates | 0 | | Ssl_ctx_verify_depth | 0 | | Ssl_ctx_verify_mode | 0 | | Ssl_default_timeout | 0 | | Ssl_finished_accepts | 0 | | Ssl_finished_connects | 0 | | Ssl_server_not_after | | | Ssl_server_not_before | | | Ssl_session_cache_hits | 0 | | Ssl_session_cache_misses | 0 | | Ssl_session_cache_mode | NONE | | Ssl_session_cache_overflows | 0 | | Ssl_session_cache_size | 0 | | Ssl_session_cache_timeouts | 0 | | Ssl_sessions_reused | 0 | | Ssl_used_session_cache_entries | 0 | | Ssl_verify_depth | 0 | | Ssl_verify_mode | 0 | | Ssl_version | | | Subquery_cache_hit | 0 | | Subquery_cache_miss | 0 | | Syncs | 20655162 | | Table_locks_immediate | 103589 | | Table_locks_waited | 0 | | Table_open_cache_active_instances | 1 | | Table_open_cache_hits | 44672308 | | Table_open_cache_misses | 159215 | | Table_open_cache_overflows | 0 | | Tc_log_max_pages_used | 0 | | Tc_log_page_size | 0 | | Tc_log_page_waits | 0 | | Threadpool_idle_threads | 577 | | Threadpool_threads | 578 | | Threads_cached | 0 | | Threads_connected | 509 | | Threads_created | 352118 | | Threads_running | 10 | | Transactions_gtid_foreign_engine | 0 | | Transactions_multi_engine | 0 | | Update_scan | 0 | | Uptime | 476439 | | Uptime_since_flush_status | 12840 | | wsrep | 0 | | wsrep_applier_thread_count | 0 | | wsrep_cluster_capabilities | | | wsrep_cluster_conf_id | 18446744073709551615 | | wsrep_cluster_size | 0 | | wsrep_cluster_state_uuid | | | wsrep_cluster_status | Disconnected | | wsrep_connected | OFF | | wsrep_local_bf_aborts | 0 | | wsrep_local_index | 18446744073709551615 | | wsrep_provider_capabilities | | | wsrep_provider_name | | | wsrep_provider_vendor | | | wsrep_provider_version | | | wsrep_ready | OFF | | wsrep_rollbacker_thread_count | 0 | | wsrep_thread_count | 0 | +--------------------------------------------------------+-----------------------------------------------------------------------------------+ *********************************************************************************************************** 20230112_033302 : show global variables gtid +-------------------------+----------------+ | Variable_name | Value | +-------------------------+----------------+ | gtid_binlog_pos | 1-2-6301025976 | | gtid_binlog_state | 1-2-6301025976 | | gtid_cleanup_batch_size | 64 | | gtid_current_pos | 1-2-6301025975 | | gtid_domain_id | 1 | | gtid_ignore_duplicates | OFF | | gtid_pos_auto_engines | | | gtid_slave_pos | 1-2-6301025975 | | gtid_strict_mode | ON | | wsrep_gtid_domain_id | 0 | | wsrep_gtid_mode | OFF | +-------------------------+----------------+ *********************************************************************************************************** 20230112_033302 : show master status +----------------+----------+--------------+------------------+ | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | +----------------+----------+--------------+------------------+ | bin_log.000043 | 2829152 | | | +----------------+----------+--------------+------------------+ *********************************************************************************************************** 20230112_033302 : show slave status *************************** 1. row *************************** Connection_name: Slave_SQL_State: Slave has read all relay log; waiting for more updates Slave_IO_State: Waiting for master to send event Master_Host: 10.93.99.101 Master_User: repuser Master_Port: 6603 Connect_Retry: 10 Master_Log_File: bin_log.001019 Read_Master_Log_Pos: 30985295 Relay_Log_File: relay_log.000131 Relay_Log_Pos: 2570503 Relay_Master_Log_File: bin_log.001019 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 2570206 Relay_Log_Space: 31275705 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: 162 Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: Replicate_Ignore_Server_Ids: Master_Server_Id: 2 Master_SSL_Crl: Master_SSL_Crlpath: Using_Gtid: Slave_Pos Gtid_IO_Pos: 1-2-6301093730 Replicate_Do_Domain_Ids: Replicate_Ignore_Domain_Ids: Parallel_Mode: optimistic SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Slave_DDL_Groups: 46 Slave_Non_Transactional_Groups: 19 Slave_Transactional_Groups: 23249343 Retried_transactions: 1 Max_relay_log_size: 268435456 Executed_log_entries: 86984839 Slave_received_heartbeats: 78647 Slave_heartbeat_period: 5.000 Gtid_Slave_Pos: 1-2-6301025975 *********************************************************************************************************** 20230112_033302 : innodb trx +-------------+-----------+---------------------+-----------------------+------------------+------------+---------------------+-----------+---------------------+-------------------+-------------------+------------------+-----------------------+-----------------+-------------------+-------------------------+---------------------+-------------------+------------------------+----------------------------+------------------+----------------------------+ | trx_id | trx_state | trx_started | trx_requested_lock_id | trx_wait_started | trx_weight | trx_mysql_thread_id | trx_query | trx_operation_state | trx_tables_in_use | trx_tables_locked | trx_lock_structs | trx_lock_memory_bytes | trx_rows_locked | trx_rows_modified | trx_concurrency_tickets | trx_isolation_level | trx_unique_checks | trx_foreign_key_checks | trx_last_foreign_key_error | trx_is_read_only | trx_autocommit_non_locking | +-------------+-----------+---------------------+-----------------------+------------------+------------+---------------------+-----------+---------------------+-------------------+-------------------+------------------+-----------------------+-----------------+-------------------+-------------------------+---------------------+-------------------+------------------------+----------------------------+------------------+----------------------------+ | 12672206543 | RUNNING | 2023-01-12 03:30:52 | NULL | NULL | 3 | 0 | NULL | | 0 | 1 | 2 | 1128 | 1 | 1 | 0 | REPEATABLE READ | 1 | 1 | NULL | 0 | 0 | | 12672206501 | RUNNING | 2023-01-12 03:30:52 | NULL | NULL | 3 | 0 | NULL | | 0 | 1 | 2 | 1128 | 1 | 1 | 0 | REPEATABLE READ | 1 | 1 | NULL | 0 | 0 | | 12672206663 | RUNNING | 2023-01-12 03:30:52 | NULL | NULL | 3 | 0 | NULL | | 0 | 1 | 2 | 1128 | 1 | 1 | 0 | REPEATABLE READ | 1 | 1 | NULL | 0 | 0 | | 12672206714 | RUNNING | 2023-01-12 03:30:52 | NULL | NULL | 3 | 0 | NULL | | 0 | 1 | 2 | 1128 | 1 | 1 | 0 | REPEATABLE READ | 1 | 1 | NULL | 0 | 0 | | 12672206985 | RUNNING | 2023-01-12 03:30:52 | NULL | NULL | 3 | 0 | NULL | | 0 | 1 | 2 | 1128 | 1 | 1 | 0 | REPEATABLE READ | 1 | 1 | NULL | 0 | 0 | | 12672206498 | RUNNING | 2023-01-12 03:30:52 | NULL | NULL | 3 | 0 | NULL | | 0 | 1 | 2 | 1128 | 1 | 1 | 0 | REPEATABLE READ | 1 | 1 | NULL | 0 | 0 | | 12672206637 | RUNNING | 2023-01-12 03:30:52 | NULL | NULL | 3 | 0 | NULL | | 0 | 1 | 2 | 1128 | 1 | 1 | 0 | REPEATABLE READ | 1 | 1 | NULL | 0 | 0 | | 12672206696 | RUNNING | 2023-01-12 03:30:52 | NULL | NULL | 3 | 0 | NULL | | 0 | 1 | 2 | 1128 | 1 | 1 | 0 | REPEATABLE READ | 1 | 1 | NULL | 0 | 0 | | 12672206978 | RUNNING | 2023-01-12 03:30:52 | NULL | NULL | 3 | 0 | NULL | | 0 | 1 | 2 | 1128 | 1 | 1 | 0 | REPEATABLE READ | 1 | 1 | NULL | 0 | 0 | | 12672207029 | RUNNING | 2023-01-12 03:30:53 | NULL | NULL | 3 | 0 | NULL | | 0 | 1 | 2 | 1128 | 1 | 1 | 0 | REPEATABLE READ | 1 | 1 | NULL | 0 | 0 | | 12672207022 | RUNNING | 2023-01-12 03:30:53 | NULL | NULL | 3 | 0 | NULL | | 0 | 1 | 2 | 1128 | 1 | 1 | 0 | REPEATABLE READ | 1 | 1 | NULL | 0 | 0 | | 12672207037 | RUNNING | 2023-01-12 03:30:53 | NULL | NULL | 3 | 0 | NULL | | 0 | 1 | 2 | 1128 | 1 | 1 | 0 | REPEATABLE READ | 1 | 1 | NULL | 0 | 0 | | 12672207461 | RUNNING | 2023-01-12 03:30:53 | NULL | NULL | 2 | 3993 | NULL | | 1 | 1 | 1 | 1128 | 0 | 1 | 0 | REPEATABLE READ | 1 | 1 | NULL | 0 | 0 | | 12672207325 | RUNNING | 2023-01-12 03:30:53 | NULL | NULL | 3 | 3995 | NULL | | 0 | 1 | 2 | 1128 | 1 | 1 | 0 | REPEATABLE READ | 1 | 1 | NULL | 0 | 0 | | 12672207266 | RUNNING | 2023-01-12 03:30:53 | NULL | NULL | 3 | 0 | NULL | | 0 | 1 | 2 | 1128 | 1 | 1 | 0 | REPEATABLE READ | 1 | 1 | NULL | 0 | 0 | | 12672207428 | RUNNING | 2023-01-12 03:30:53 | NULL | NULL | 5 | 3996 | NULL | | 0 | 2 | 3 | 1128 | 1 | 2 | 0 | REPEATABLE READ | 1 | 1 | NULL | 0 | 0 | | 12672207025 | RUNNING | 2023-01-12 03:30:53 | NULL | NULL | 3 | 0 | NULL | | 0 | 1 | 2 | 1128 | 1 | 1 | 0 | REPEATABLE READ | 1 | 1 | NULL | 0 | 0 | | 12672207034 | RUNNING | 2023-01-12 03:30:53 | NULL | NULL | 3 | 0 | NULL | | 0 | 1 | 2 | 1128 | 1 | 1 | 0 | REPEATABLE READ | 1 | 1 | NULL | 0 | 0 | | 12672207049 | RUNNING | 2023-01-12 03:30:53 | NULL | NULL | 3 | 0 | NULL | | 0 | 1 | 2 | 1128 | 1 | 1 | 0 | REPEATABLE READ | 1 | 1 | NULL | 0 | 0 | | 12672207307 | RUNNING | 2023-01-12 03:30:53 | NULL | NULL | 3 | 3997 | NULL | | 0 | 1 | 2 | 1128 | 1 | 1 | 0 | REPEATABLE READ | 1 | 1 | NULL | 0 | 0 | | 12672207185 | RUNNING | 2023-01-12 03:30:53 | NULL | NULL | 3 | 0 | NULL | | 0 | 1 | 2 | 1128 | 1 | 1 | 0 | REPEATABLE READ | 1 | 1 | NULL | 0 | 0 | | 12672207040 | RUNNING | 2023-01-12 03:30:53 | NULL | NULL | 3 | 0 | NULL | | 0 | 1 | 2 | 1128 | 1 | 1 | 0 | REPEATABLE READ | 1 | 1 | NULL | 0 | 0 | | 12672207456 | RUNNING | 2023-01-12 03:30:53 | NULL | NULL | 3 | 3992 | NULL | | 0 | 1 | 2 | 1128 | 1 | 1 | 0 | REPEATABLE READ | 1 | 1 | NULL | 0 | 0 | +-------------+-----------+---------------------+-----------------------+------------------+------------+---------------------+-----------+---------------------+-------------------+-------------------+------------------+-----------------------+-----------------+-------------------+-------------------------+---------------------+-------------------+------------------------+----------------------------+------------------+----------------------------+ *********************************************************************************************************** 20230112_033302 : innodb locks *********************************************************************************************************** 20230112_033302 : innodb lock waits *********************************************************************************************************** 20230112_033302 : metadata lock wholockswho +------------------------------------------+ | WhoLocksWho | +------------------------------------------+ | Thread 715112 IS LOCKED BY Thread 715112 | | Thread 715112 IS LOCKED BY Thread 3994 | | Thread 715112 IS LOCKED BY Thread 3993 | | Thread 3993 IS LOCKED BY Thread 715112 | | Thread 3993 IS LOCKED BY Thread 3994 | | Thread 3993 IS LOCKED BY Thread 3993 | +------------------------------------------+ *********************************************************************************************************** 20230112_033302 : metadata lock info +-----------+----------------------+---------------+---------------------+--------------+-------------------------------------+ | THREAD_ID | LOCK_MODE | LOCK_DURATION | LOCK_TYPE | TABLE_SCHEMA | TABLE_NAME | +-----------+----------------------+---------------+---------------------+--------------+-------------------------------------+ | 715112 | MDL_BACKUP_WAIT_DDL | NULL | Backup lock | | | | 3994 | MDL_BACKUP_COMMIT | NULL | Backup lock | | | | 3993 | MDL_BACKUP_TRANS_DML | NULL | Backup lock | | | | 3996 | MDL_SHARED_WRITE | NULL | Table metadata lock | mysql | gtid_slave_pos | | 3993 | MDL_SHARED_WRITE | NULL | Table metadata lock | mysql | gtid_slave_pos | | 3997 | MDL_SHARED_WRITE | NULL | Table metadata lock | bankfrm | dbs_actor_logon_details_for_channel | | 3995 | MDL_SHARED_WRITE | NULL | Table metadata lock | bankfrm | dbs_actor_logon_details_for_channel | | 3992 | MDL_SHARED_WRITE | NULL | Table metadata lock | bankfrm | dbs_actor_logon_details_for_channel | | 3996 | MDL_SHARED_WRITE | NULL | Table metadata lock | bankfrm | sessionmgmt | +-----------+----------------------+---------------+---------------------+--------------+-------------------------------------+ *********************************************************************************************************** 20230112_033302 : metadata lock info with transaction details +-----------+--------------+-------------------------------------+-------------+-----------+--------------+------+-----------------------------------------+----------------------------------------------------+----------------------+---------------------+-------------+-----------+---------------------+ | THREAD_ID | TABLE_SCHEMA | TABLE_NAME | USER | HOST | COMMAND | TIME | STATE | INFO | LOCK_MODE | LOCK_TYPE | TRX_ID | TRX_STATE | TRX_STARTED | +-----------+--------------+-------------------------------------+-------------+-----------+--------------+------+-----------------------------------------+----------------------------------------------------+----------------------+---------------------+-------------+-----------+---------------------+ | 3996 | bankfrm | sessionmgmt | system user | | Slave_worker | 129 | Waiting for prior transaction to commit | NULL | MDL_SHARED_WRITE | Table metadata lock | 12672207428 | RUNNING | 2023-01-12 03:30:53 | | 3996 | mysql | gtid_slave_pos | system user | | Slave_worker | 129 | Waiting for prior transaction to commit | NULL | MDL_SHARED_WRITE | Table metadata lock | 12672207428 | RUNNING | 2023-01-12 03:30:53 | | 3993 | mysql | gtid_slave_pos | system user | | Slave_worker | 129 | Waiting for backup lock | NULL | MDL_SHARED_WRITE | Table metadata lock | 12672207461 | RUNNING | 2023-01-12 03:30:53 | | 3997 | bankfrm | dbs_actor_logon_details_for_channel | system user | | Slave_worker | 129 | Waiting for prior transaction to commit | NULL | MDL_SHARED_WRITE | Table metadata lock | 12672207307 | RUNNING | 2023-01-12 03:30:53 | | 3992 | bankfrm | dbs_actor_logon_details_for_channel | system user | | Slave_worker | 129 | Waiting for prior transaction to commit | NULL | MDL_SHARED_WRITE | Table metadata lock | 12672207456 | RUNNING | 2023-01-12 03:30:53 | | 3995 | bankfrm | dbs_actor_logon_details_for_channel | system user | | Slave_worker | 129 | Waiting for prior transaction to commit | NULL | MDL_SHARED_WRITE | Table metadata lock | 12672207325 | RUNNING | 2023-01-12 03:30:53 | | 3993 | | | system user | | Slave_worker | 129 | Waiting for backup lock | NULL | MDL_BACKUP_TRANS_DML | Backup lock | 12672207461 | RUNNING | 2023-01-12 03:30:53 | | 715112 | | | myoper | localhost | Query | 129 | Waiting for backup lock | BACKUP STAGE BLOCK_COMMIT | MDL_BACKUP_WAIT_DDL | Backup lock | NULL | NULL | NULL | | 3994 | | | system user | | Slave_worker | 129 | Waiting for prior transaction to commit | XA COMMIT X'00000000000000000000ffff0a5d63a10605f7 | MDL_BACKUP_COMMIT | Backup lock | NULL | NULL | NULL | +-----------+--------------+-------------------------------------+-------------+-----------+--------------+------+-----------------------------------------+----------------------------------------------------+----------------------+---------------------+-------------+-----------+---------------------+ *********************************************************************************************************** 20230112_033302 : waiting and blocking queries *********************************************************************************************************** 20230112_033303 : unclosed transactions *********************************************************************************************************** 20230112_033303 : ps aux mysql 27718 4.1 7.6 26881620 10036428 ? Ssl Jan06 326:16 /usr/sbin/mariadbd *********************************************************************************************************** 20230112_033303 : free -m total used free shared buff/cache available Mem: 128755 12950 7516 573 108288 114460 Swap: 8099 0 8099 Total: 136855 12950 15616 *********************************************************************************************************** 20230112_033303 : swapon -s *********************************************************************************************************** 20230112_033303 : grep Swap /proc/meminfo SwapCached: 0 kB SwapTotal: 8294396 kB SwapFree: 8294396 kB *********************************************************************************************************** 20230112_033303 : mysql or mariadbd proc 27718 io rchar: 55896864452 wchar: 138545332461 syscr: 34191397 syscw: 190567251 read_bytes: 6986571776 write_bytes: 344471777280 cancelled_write_bytes: 65388916736 *********************************************************************************************************** 20230112_033303 : mysql or mariabd proc 27718 status Name: mariadbd Umask: 0006 State: S (sleeping) Tgid: 27718 Ngid: 0 Pid: 27718 PPid: 1 TracerPid: 0 Uid: 6603 6603 6603 6603 Gid: 6603 6603 6603 6603 FDSize: 2048 Groups: 6603 VmPeak: 26881620 kB VmSize: 26881620 kB VmLck: 0 kB VmPin: 0 kB VmHWM: 10036956 kB VmRSS: 10036956 kB RssAnon: 10020404 kB RssFile: 16552 kB RssShmem: 0 kB VmData: 26673940 kB VmStk: 132 kB VmExe: 16596 kB VmLib: 4104 kB VmPTE: 22156 kB VmSwap: 0 kB Threads: 610 SigQ: 0/514931 SigPnd: 0000000000000000 ShdPnd: 0000000000000000 SigBlk: 0000000000087007 SigIgn: 0000000000001000 SigCgt: 00000001800066e9 CapInh: 0000000000000000 CapPrm: 0000000000000000 CapEff: 0000000000000000 CapBnd: 0000000020004002 CapAmb: 0000000000000000 NoNewPrivs: 0 Seccomp: 0 Speculation_Store_Bypass: thread vulnerable Cpus_allowed: ffffffff,ffffffff,ffffffff,ffffffff Cpus_allowed_list: 0-127 Mems_allowed: 00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000001 Mems_allowed_list: 0 voluntary_ctxt_switches: 352596 nonvoluntary_ctxt_switches: 75 *********************************************************************************************************** 20230112_033303 : vmstat procs -----------memory---------- ---swap-- -----io---- -system-- ------cpu----- -----timestamp----- r b swpd free buff cache si so bi bo in cs us sy id wa st +08 1 0 0 7696300 3039456 107848224 0 0 10 62 2 2 1 1 99 0 0 2023-01-12 03:33:03 1 0 0 7675972 3039456 107849952 0 0 0 497 5996 6595 1 2 97 0 0 2023-01-12 03:33:08 0 0 0 7650696 3039464 107851024 0 0 0 492 2691 3246 0 0 99 0 0 2023-01-12 03:33:13 0 0 0 7626616 3039464 107852080 0 0 0 236 2391 2824 0 0 99 0 0 2023-01-12 03:33:18 0 0 0 7604248 3039464 107853032 0 0 0 333 2653 2941 0 1 99 0 0 2023-01-12 03:33:23 *********************************************************************************************************** 20230112_033323 : top top - 03:33:24 up 13 days, 16:32, 0 users, load average: 0.85, 1.76, 1.61 Tasks: 285 total, 1 running, 283 sleeping, 0 stopped, 1 zombie %Cpu(s): 0.2 us, 0.5 sy, 0.0 ni, 99.3 id, 0.0 wa, 0.0 hi, 0.0 si, 0.0 st KiB Mem : 13184566+total, 7602828 free, 13350140 used, 11089268+buff/cache KiB Swap: 8294396 total, 8294396 free, 0 used. 11711879+avail Mem PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 27718 mysql 20 0 25.8g 9.7g 16552 S 7.9 7.7 326:18.45 mariadbd 1042 cyberea+ 20 0 2597752 288896 15804 S 3.0 0.2 751:09.81 cybereaso+ 6328 root 20 0 4007692 162648 30792 S 2.0 0.1 450:53.47 ds_am 170 root 20 0 0 0 0 S 1.0 0.0 30:44.35 kauditd 1017 root 16 -4 55528 1072 624 S 1.0 0.0 79:40.72 auditd 4133 root 20 0 2787400 27840 17648 S 1.0 0.0 68:52.03 k08agent 62788 mysql 20 0 162132 2376 1580 R 1.0 0.0 0:00.02 top 1 root 20 0 192348 5276 2612 S 0.0 0.0 50:54.19 systemd 2 root 20 0 0 0 0 S 0.0 0.0 0:02.90 kthreadd 4 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/0+ 6 root 20 0 0 0 0 S 0.0 0.0 0:41.99 ksoftirqd+ 7 root rt 0 0 0 0 S 0.0 0.0 0:22.93 migration+ 8 root 20 0 0 0 0 S 0.0 0.0 0:00.00 rcu_bh 9 root 20 0 0 0 0 S 0.0 0.0 33:03.79 rcu_sched 10 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 lru-add-d+ 11 root rt 0 0 0 0 S 0.0 0.0 0:04.62 watchdog/0 12 root rt 0 0 0 0 S 0.0 0.0 0:04.68 watchdog/1 13 root rt 0 0 0 0 S 0.0 0.0 0:23.23 migration+ 14 root 20 0 0 0 0 S 0.0 0.0 0:45.22 ksoftirqd+ 16 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/1+ 17 root rt 0 0 0 0 S 0.0 0.0 0:04.67 watchdog/2 18 root rt 0 0 0 0 S 0.0 0.0 0:23.79 migration+ 19 root 20 0 0 0 0 S 0.0 0.0 0:44.09 ksoftirqd+ 21 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/2+ 22 root rt 0 0 0 0 S 0.0 0.0 0:04.67 watchdog/3 23 root rt 0 0 0 0 S 0.0 0.0 0:23.45 migration+ 24 root 20 0 0 0 0 S 0.0 0.0 0:43.42 ksoftirqd+ 26 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/3+ 27 root rt 0 0 0 0 S 0.0 0.0 0:04.64 watchdog/4 28 root rt 0 0 0 0 S 0.0 0.0 0:22.43 migration+ 29 root 20 0 0 0 0 S 0.0 0.0 1:23.13 ksoftirqd+ 31 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/4+ 32 root rt 0 0 0 0 S 0.0 0.0 0:04.52 watchdog/5 33 root rt 0 0 0 0 S 0.0 0.0 0:21.56 migration+ 34 root 20 0 0 0 0 S 0.0 0.0 0:39.02 ksoftirqd+ 36 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/5+ 37 root rt 0 0 0 0 S 0.0 0.0 0:04.65 watchdog/6 38 root rt 0 0 0 0 S 0.0 0.0 0:20.64 migration+ 39 root 20 0 0 0 0 S 0.0 0.0 0:39.06 ksoftirqd+ 41 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/6+ 42 root rt 0 0 0 0 S 0.0 0.0 0:04.61 watchdog/7 43 root rt 0 0 0 0 S 0.0 0.0 0:20.23 migration+ 44 root 20 0 0 0 0 S 0.0 0.0 0:39.03 ksoftirqd+ 46 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/7+ 47 root rt 0 0 0 0 S 0.0 0.0 0:04.73 watchdog/8 48 root rt 0 0 0 0 S 0.0 0.0 0:21.02 migration+ 49 root 20 0 0 0 0 S 0.0 0.0 1:00.69 ksoftirqd+ 51 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/8+ 52 root rt 0 0 0 0 S 0.0 0.0 0:04.80 watchdog/9 53 root rt 0 0 0 0 S 0.0 0.0 0:21.56 migration+ 54 root 20 0 0 0 0 S 0.0 0.0 0:51.25 ksoftirqd+ 56 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/9+ 57 root rt 0 0 0 0 S 0.0 0.0 0:05.05 watchdog/+ 58 root rt 0 0 0 0 S 0.0 0.0 0:21.99 migration+ 59 root 20 0 0 0 0 S 0.0 0.0 0:54.11 ksoftirqd+ 61 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/1+ 62 root rt 0 0 0 0 S 0.0 0.0 0:04.96 watchdog/+ 63 root rt 0 0 0 0 S 0.0 0.0 0:21.98 migration+ 64 root 20 0 0 0 0 S 0.0 0.0 0:50.14 ksoftirqd+ 66 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/1+ 67 root rt 0 0 0 0 S 0.0 0.0 0:04.76 watchdog/+ 68 root rt 0 0 0 0 S 0.0 0.0 0:22.15 migration+ 69 root 20 0 0 0 0 S 0.0 0.0 0:52.05 ksoftirqd+ 71 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/1+ 72 root rt 0 0 0 0 S 0.0 0.0 0:04.47 watchdog/+ 73 root rt 0 0 0 0 S 0.0 0.0 0:22.60 migration+ 74 root 20 0 0 0 0 S 0.0 0.0 2:10.32 ksoftirqd+ 76 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/1+ 77 root rt 0 0 0 0 S 0.0 0.0 0:04.99 watchdog/+ 78 root rt 0 0 0 0 S 0.0 0.0 0:22.32 migration+ 79 root 20 0 0 0 0 S 0.0 0.0 1:00.55 ksoftirqd+ 81 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/1+ 82 root rt 0 0 0 0 S 0.0 0.0 0:04.82 watchdog/+ 83 root rt 0 0 0 0 S 0.0 0.0 0:22.48 migration+ 84 root 20 0 0 0 0 S 0.0 0.0 0:53.37 ksoftirqd+ 86 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/1+ 88 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kdevtmpfs 89 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 netns 90 root 20 0 0 0 0 S 0.0 0.0 0:02.30 khungtaskd 91 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 writeback 92 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kintegrit+ 93 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bioset 94 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bioset 95 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bioset 96 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kblockd 97 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 md 98 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 edac-poll+ 99 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 watchdogd 105 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kswapd0 106 root 25 5 0 0 0 S 0.0 0.0 0:00.00 ksmd 107 root 39 19 0 0 0 S 0.0 0.0 0:20.24 khugepaged 108 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 crypto 116 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kthrotld 120 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kmpath_rd+ 121 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kaluad 122 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kpsmoused 124 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 ipv6_addr+ 138 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 deferwq 396 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 mpt_poll_0 400 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 mpt/0 401 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 ata_sff 410 root 20 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_0 411 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 scsi_tmf_0 413 root 20 0 0 0 0 S 0.0 0.0 0:00.01 scsi_eh_1 414 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 scsi_tmf_1 415 root 20 0 0 0 0 S 0.0 0.0 0:00.71 scsi_eh_2 416 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 scsi_tmf_2 419 root -51 0 0 0 0 S 0.0 0.0 1:49.13 irq/16-vm+ 420 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 ttm_swap 483 root 0 -20 0 0 0 S 0.0 0.0 0:03.12 kworker/0+ 524 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kdmflush 525 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bioset 543 root 20 0 0 0 0 S 0.0 0.0 0:15.87 jbd2/dm-0+ 544 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 ext4-rsv-+ 617 root 20 0 81172 43128 42712 S 0.0 0.0 3:38.86 systemd-j+ 667 root 20 0 272300 1564 952 S 0.0 0.0 0:02.06 lvmetad 668 root 20 0 0 0 0 S 0.0 0.0 0:00.16 kworker/5+ 690 root 20 0 46736 4264 1328 S 0.0 0.0 0:01.02 systemd-u+ 735 root 20 0 0 0 0 S 0.0 0.0 0:00.08 kworker/0+ 736 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 nfit 834 root 20 0 0 0 0 S 0.0 0.0 0:00.00 jbd2/sda1+ 835 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 ext4-rsv-+ 842 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kdmflush 844 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bioset 846 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kdmflush 847 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bioset 849 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kdmflush 850 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bioset 852 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kdmflush 853 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bioset 874 root 20 0 0 0 0 S 0.0 0.0 1:34.31 jbd2/dm-4+ 877 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 ext4-rsv-+ 885 root 20 0 0 0 0 S 0.0 0.0 2:27.75 jbd2/dm-1+ 886 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 ext4-rsv-+ 894 root 20 0 0 0 0 S 0.0 0.0 31:59.09 jbd2/dm-3+ 895 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 ext4-rsv-+ 897 root 20 0 0 0 0 S 0.0 0.0 0:08.37 jbd2/dm-2+ 898 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 ext4-rsv-+ 900 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kdmflush 901 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bioset 903 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kdmflush 904 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bioset 905 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kdmflush 907 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bioset 909 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kdmflush 912 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bioset 914 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kdmflush 915 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bioset 917 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kdmflush 918 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bioset 945 root 20 0 0 0 0 S 0.0 0.0 0:01.52 jbd2/dm-1+ 946 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 ext4-rsv-+ 965 root 20 0 0 0 0 S 0.0 0.0 0:14.92 jbd2/dm-7+ 966 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 ext4-rsv-+ 974 root 20 0 0 0 0 S 0.0 0.0 0:35.55 jbd2/dm-8+ 975 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 ext4-rsv-+ 977 root 20 0 0 0 0 S 0.0 0.0 1:32.38 jbd2/dm-9+ 978 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 ext4-rsv-+ 983 root 20 0 0 0 0 S 0.0 0.0 0:00.00 jbd2/dm-5+ 984 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 ext4-rsv-+ 987 root 20 0 0 0 0 S 0.0 0.0 11:08.44 jbd2/dm-6+ 988 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 ext4-rsv-+ 1013 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 rpciod 1014 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 xprtiod 1040 root 20 0 21688 1340 992 S 0.0 0.0 4:00.52 irqbalance 1045 root 20 0 26492 1840 1448 S 0.0 0.0 9:11.72 systemd-l+ 1046 polkitd 20 0 612248 10056 4656 S 0.0 0.0 7:35.79 polkitd 1047 root 20 0 168152 5064 3636 S 0.0 0.0 0:00.00 VGAuthSer+ 1048 root 20 0 348812 5028 3684 S 0.0 0.0 20:55.92 vmtoolsd 1049 root 20 0 19200 1800 1544 S 0.0 0.0 0:23.67 venAgentM+ 1050 rpc 20 0 69280 1368 800 S 0.0 0.0 0:02.41 rpcbind 1053 dbus 20 0 58408 2716 1824 S 0.0 0.0 39:48.72 dbus-daem+ 1059 root 20 0 195204 1236 768 S 0.0 0.0 0:00.00 gssproxy 1060 ntp 20 0 25732 2064 1456 S 0.0 0.0 0:01.89 ntpd 1087 root 20 0 126424 1656 976 S 0.0 0.0 0:50.50 crond 1210 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 dio/dm-1 1352 root 0 -20 0 0 0 S 0.0 0.0 0:02.22 kworker/4+ 1446 root 0 -20 0 0 0 S 0.0 0.0 0:00.04 kworker/1+ 1506 root 20 0 555276 17332 8668 S 0.0 0.0 0:08.80 pxp-agent 1508 root 20 0 574016 19084 6048 S 0.0 0.0 2:21.83 tuned 1509 root 20 0 113008 4228 3188 S 0.0 0.0 0:01.26 sshd 1562 root 20 0 113008 4196 3160 S 0.0 0.0 0:00.10 sshd 1588 root 20 0 387972 59912 9700 S 0.0 0.0 0:44.10 puppet 1591 root 20 0 113008 4196 3160 S 0.0 0.0 0:00.07 sshd 1638 root 20 0 110208 840 720 S 0.0 0.0 0:00.00 agetty 1664 root 20 0 115812 696 540 S 0.0 0.0 0:00.07 rhsmcertd 1666 root 20 0 108072 620 472 S 0.0 0.0 0:00.02 rhnsd 2347 root 20 0 79996 1272 464 S 0.0 0.0 0:00.00 zabbix_ag+ 2384 root 20 0 79996 2456 1640 S 0.0 0.0 6:18.08 zabbix_ag+ 2385 root 20 0 79996 2276 1340 S 0.0 0.0 0:06.40 zabbix_ag+ 2386 root 20 0 79996 2276 1340 S 0.0 0.0 0:06.33 zabbix_ag+ 2387 root 20 0 79996 2276 1340 S 0.0 0.0 0:06.56 zabbix_ag+ 2388 root 20 0 80388 3060 1736 S 0.0 0.0 14:02.11 zabbix_ag+ 2389 root 20 0 79996 2216 1268 S 0.0 0.0 1:37.17 zabbix_ag+ 2455 root 20 0 18964 2652 1868 S 0.0 0.0 0:18.30 ndtask 2467 root 30 10 121520 1676 956 S 0.0 0.0 0:03.72 mgsusageag 3295 root 20 0 223676 12612 648 S 0.0 0.0 0:00.00 ds_agent 3296 root 20 0 1180324 230020 12912 S 0.0 0.2 78:21.05 ds_agent 3375 root 20 0 1046012 7204 3404 S 0.0 0.0 13:04.12 sisidsdae+ 3590 sisips 20 0 405208 9364 5756 S 0.0 0.0 14:17.34 sisipsdae+ 3613 sisips 20 0 97876 1716 992 S 0.0 0.0 0:00.00 sisipsuti+ 4170 root 20 0 131136 8652 4432 S 0.0 0.0 3:08.44 venAgentM+ 4260 root 20 0 636236 15652 5032 S 0.0 0.0 12:06.88 venPlatfo+ 4302 root 20 0 184996 4988 2468 S 0.0 0.0 9:04.73 venVtapSe+ 5179 root 0 -20 0 0 0 S 0.0 0.0 0:00.08 kworker/9+ 5531 root 20 0 725684 25240 4700 S 0.0 0.0 1:32.93 ds_nuagent 5541 root 20 0 734372 45716 8240 S 0.0 0.0 19:59.48 ds_nuagent 6170 root 20 0 2359636 33752 18692 S 0.0 0.0 40:39.02 klzagent 6313 root 20 0 147220 1336 700 S 0.0 0.0 0:00.00 ds_am 6821 root 0 -20 0 0 0 S 0.0 0.0 0:00.07 kworker/8+ 7395 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/8+ 7556 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/1+ 8890 root 0 -20 0 0 0 S 0.0 0.0 0:01.81 kworker/5+ 8999 root 0 -20 0 0 0 S 0.0 0.0 0:00.06 kworker/1+ 9258 root 0 -20 0 0 0 S 0.0 0.0 0:00.07 kworker/1+ 9589 root 0 -20 0 0 0 S 0.0 0.0 0:00.48 kworker/6+ 9591 root 20 0 956864 38280 24988 S 0.0 0.0 51:58.49 rsyslogd 9623 root 0 -20 0 0 0 S 0.0 0.0 0:00.06 kworker/1+ 9655 root 0 -20 0 0 0 S 0.0 0.0 0:00.04 kworker/2+ 10963 root 0 -20 0 0 0 S 0.0 0.0 0:00.10 kworker/7+ 12956 root 20 0 593684 10460 7640 S 0.0 0.0 0:54.93 kcawd 18876 root 0 -20 0 0 0 S 0.0 0.0 0:00.06 kworker/1+ 20942 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/9+ 23073 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/1+ 27158 root 0 -20 0 0 0 S 0.0 0.0 0:00.09 kworker/1+ 27237 root 0 -20 0 0 0 S 0.0 0.0 0:00.07 kworker/1+ 29670 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/1+ 32281 root 20 0 0 0 0 S 0.0 0.0 0:00.10 kworker/u+ 32836 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/7+ 35260 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/1+ 35380 root 0 -20 0 0 0 S 0.0 0.0 0:00.03 kworker/3+ 38023 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/5+ 38909 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/6+ 40721 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/1+ 41695 root 20 0 0 0 0 S 0.0 0.0 0:00.05 kworker/1+ 42229 root 20 0 879020 30460 9016 S 0.0 0.0 7:31.63 python 45001 root 20 0 0 0 0 S 0.0 0.0 0:00.05 kworker/u+ 45804 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/2+ 49028 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/1+ 49277 root 20 0 0 0 0 S 0.0 0.0 0:00.49 kworker/4+ 49923 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/3+ 51738 root 20 0 0 0 0 S 0.0 0.0 0:00.01 kworker/1+ 54082 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/5+ 55239 root 20 0 182508 2552 1576 S 0.0 0.0 0:00.00 crond 55253 mysql 20 0 113284 1200 1024 S 0.0 0.0 0:00.00 sh 55259 mysql 20 0 113552 1736 1316 S 0.0 0.0 0:00.01 backup.sh 55726 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/1+ 55976 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/1+ 56456 mysql 20 0 718460 37896 9124 S 0.0 0.0 0:06.44 mariaback+ 56738 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/7+ 57548 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/6+ 57808 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/1+ 58353 root 20 0 0 0 0 S 0.0 0.0 0:00.01 kworker/5+ 58838 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/2+ 60186 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/1+ 61052 root 20 0 182508 2548 1576 S 0.0 0.0 0:00.00 crond 61064 mysql 20 0 113284 1200 1024 S 0.0 0.0 0:00.00 sh 61069 mysql 20 0 113420 1636 1268 S 0.0 0.0 0:00.09 monitor.sh 61366 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/1+ 62789 mysql 20 0 113644 976 820 S 0.0 0.0 0:00.00 awk 79040 root 20 0 0 0 0 S 0.0 0.0 0:00.11 kworker/0+ 79424 root 20 0 0 0 0 S 0.0 0.0 0:00.19 kworker/8+ 79544 root 20 0 0 0 0 S 0.0 0.0 0:00.25 kworker/1+ 80991 root 20 0 0 0 0 S 0.0 0.0 0:00.65 kworker/1+ 82019 root 20 0 0 0 0 S 0.0 0.0 0:00.44 kworker/7+ 88466 root 20 0 0 0 0 S 0.0 0.0 0:00.43 kworker/0+ 90514 root 20 0 0 0 0 S 0.0 0.0 0:00.17 kworker/1+ 96861 root 20 0 0 0 0 S 0.0 0.0 0:00.38 kworker/2+ 105824 root 20 0 0 0 0 S 0.0 0.0 0:00.19 kworker/1+ 110047 root 20 0 182508 2548 1576 S 0.0 0.0 0:00.00 crond 110062 u01smage 20 0 0 0 0 Z 0.0 0.0 0:00.04 sh 110385 root 20 0 61188 3200 2300 S 0.0 0.0 0:00.11 pbx_excha+ 111210 u01smage 20 0 1243664 28684 9476 S 0.0 0.0 0:20.47 filebeat 111308 root 20 0 0 0 0 S 0.0 0.0 0:00.16 kworker/u+ 111779 root 20 0 1948952 20828 12204 S 0.0 0.0 0:05.23 vnetd 111781 root 20 0 1948984 20864 12288 S 0.0 0.0 0:05.34 vnetd 111838 root 20 0 94816 3752 2472 S 0.0 0.0 0:18.57 vnetd 111843 root 20 0 127972 5800 3956 S 0.0 0.0 0:06.24 bpcd 111927 root 20 0 929408 26212 18452 S 0.0 0.0 1:10.42 nbdisco 111964 root 20 0 0 0 0 S 0.0 0.0 0:00.13 kworker/1+ 123060 root 20 0 0 0 0 S 0.0 0.0 0:00.09 kworker/6+ 123368 root 20 0 0 0 0 S 0.0 0.0 0:00.12 kworker/9+ 123380 root 20 0 0 0 0 S 0.0 0.0 0:00.38 kworker/3+ 123422 root 20 0 0 0 0 S 0.0 0.0 0:00.14 kworker/1+ 127220 root 20 0 0 0 0 S 0.0 0.0 0:01.61 kworker/4+ *********************************************************************************************************** 20230112_033324 : iostat Linux 3.10.0-1160.80.1.el7.x86_64 (x01sibdb6a.vsi.uat.dbs.com) 01/12/2023 _x86_64_ (16 CPU) 01/12/2023 03:33:24 AM avg-cpu: %user %nice %system %iowait %steal %idle 0.60 0.00 0.65 0.22 0.00 98.53 Device: rrqm/s wrqm/s r/s w/s rkB/s wkB/s avgrq-sz avgqu-sz await r_await w_await svctm %util sda 0.00 18.30 0.79 15.30 5.16 186.08 23.77 0.07 4.59 7.85 4.43 0.57 0.91 sdc 0.11 48.43 0.96 105.44 156.49 809.30 18.15 0.11 1.06 25.37 0.84 0.37 3.95 sdb 0.00 0.00 0.00 0.00 0.02 0.00 10.12 0.00 0.63 0.63 0.00 0.63 0.00 x01sibdb6a-root 0.00 0.00 0.13 0.87 1.51 4.55 12.08 0.00 4.40 1.21 4.87 0.32 0.03 vg_mdb-lv_mariadb_data 0.00 0.00 1.05 41.01 156.38 205.91 17.23 0.05 1.28 25.29 0.66 0.45 1.90 vg_mdb-lv_mariadb_backup 0.00 0.00 0.01 0.22 0.03 95.16 843.93 0.03 133.70 5.12 138.23 1.95 0.04 vg_mdb-lv_mariadb_bin 0.00 0.00 0.01 110.43 0.04 491.40 8.90 0.05 0.46 2.56 0.46 0.27 2.93 vg_mdb-lv_mariadb_tmp 0.00 0.00 0.00 2.21 0.02 16.83 15.21 0.01 2.71 2.19 2.71 0.16 0.03 x01sibdb6a-kdump 0.00 0.00 0.00 0.00 0.02 0.00 9.26 0.00 0.68 0.67 1.22 0.67 0.00 x01sibdb6a-audit 0.00 0.00 0.00 21.64 0.02 115.10 10.64 0.02 0.82 1.10 0.82 0.34 0.73 x01sibdb6a-tmp 0.00 0.00 0.00 0.90 0.02 4.97 10.98 0.00 3.55 1.74 3.56 0.38 0.03 x01sibdb6a-var 0.00 0.00 0.21 3.33 1.29 26.43 15.66 0.51 145.41 26.16 152.89 0.20 0.07 x01sibdb6a-opt 0.00 0.00 0.29 6.56 1.60 33.89 10.36 0.04 6.45 1.91 6.65 0.20 0.14 x01sibdb6a-home 0.00 0.00 0.14 0.29 0.59 1.14 8.06 0.00 3.68 1.16 4.95 0.23 0.01 *********************************************************************************************************** 20230112_033324 : ulimit -a NPROC_MYSQL = 65536 NPROC_THRESH_MYSQL = 52428 NPROC_USED_BY_MYSQL = 604 core file size (blocks, -c) 0 data seg size (kbytes, -d) unlimited scheduling priority (-e) 0 file size (blocks, -f) unlimited pending signals (-i) 514931 max locked memory (kbytes, -l) 64 max memory size (kbytes, -m) unlimited open files (-n) 278528 pipe size (512 bytes, -p) 8 POSIX message queues (bytes, -q) 819200 real-time priority (-r) 0 stack size (kbytes, -s) 8192 cpu time (seconds, -t) unlimited max user processes (-u) 65536 virtual memory (kbytes, -v) unlimited file locks (-x) unlimited ***********************************************************************************************************