mysql5.7的sleep状态连接过多导致修改表结构无法正常执行的问题
# 生产环境的表 send_invites 里面存取了邮件内容，text类型不够用，需要修改成longtext。
CREATE TABLE `send_invites` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '# 自增ID',
`product_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '# 产品名称',
`product_url` varchar(512) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '# 产品地址',
`company` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '# 公司',
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '# 标题',
`body` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '# 内容',
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '# 名称',
`email` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '# 邮件',
`channel_id` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '# 频道ID',
`user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '# 用户ID',
`is_send` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '# 是否成功，0未 1成功',
`draft` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '# 是否暂存，0否 1是',
`created_at` datetime DEFAULT NULL COMMENT '# 创建时间',
`updated_at` datetime DEFAULT NULL COMMENT '# 创建时间',
`template` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '# 模板ID',
`from` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '# 发件人',
`schedule` datetime DEFAULT NULL COMMENT '# 定时发送的时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10193 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
# 修改语句如下，发现执行了1个小时没有反应，中断再次执行问题依旧，表只有1万多行，不正常
# alter table send_invites change body body LONGTEXT COMMENT '# 内容';
# 执行下面的锁表，然后修改类型操作，发现表锁不住
lock table send_invites write;
alter table chinasoft_api.send_invites change body body LONGTEXT COMMENT '# 内容';
unlock tables
# 发现大量的sleep连接，初步判断是因为里面的连接占用了数据库的资源
mysql> show full processlist;
+--------+------------------------+-----------------------+-------------------+------------------+---------+---------------------------------------------------------------+-----------------------+-----------+---------------+
| Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_examined |
+--------+------------------------+-----------------------+-------------------+------------------+---------+---------------------------------------------------------------+-----------------------+-----------+---------------+
| 24 | rep | 172.16.0.240:20818 | NULL | Binlog Dump GTID | 7429796 | Master has sent all binlog to slave; waiting for more updates | NULL | 0 | 0 |
| 326698 | chinasoft_api_user | 172.16.0.237:8614 | chinasoft_api | Sleep | 7006 | | NULL | 0 | 0 |
| 327356 | chinasoft_api_user | 172.16.0.237:16982 | chinasoft_api | Sleep | 11091 | | NULL | 0 | 0 |
| 328368 | chinasoft_api_user | 172.16.0.232:25684 | chinasoft_api | Sleep | 2402 | | NULL | 0 | 0 |
| 357945 | chinasoft_api_user | 172.16.0.237:5393 | chinasoft_api | Sleep | 1548 | | NULL | 0 | 0 |
| 371007 | chinasoft_api_user | 172.16.0.237:17833 | chinasoft_api | Sleep | 1612 | | NULL | 0 | 0 |
| 728718 | chinasoft_api_user | 172.16.0.237:41001 | chinasoft_api | Sleep | 2387 | | NULL | 0 | 0 |
| 759633 | chinasoft_api_user | 172.16.0.232:57089 | chinasoft_api | Sleep | 416 | | NULL | 0 | 0 |
| 760470 | chinasoft_api_user | 172.16.0.232:37010 | chinasoft_api | Sleep | 4082 | | NULL | 0 | 0 |
| 760725 | chinasoft_api_user | 172.16.0.237:13570 | chinasoft_api | Sleep | 7006 | | NULL | 0 | 0 |
| 762085 | chinasoft_api_user | 172.16.0.237:50957 | chinasoft_api | Sleep | 10276 | | NULL | 0 | 0 |
| 762632 | chinasoft_api_user | 172.16.0.232:15920 | chinasoft_api | Sleep | 17757 | | NULL | 0 | 0 |
| 762829 | chinasoft_api_user | 172.16.0.237:32606 | chinasoft_api | Sleep | 10972 | | NULL | 0 | 0 |
| 765862 | chinasoft_api_user | 172.16.0.237:32761 | chinasoft_api | Sleep | 11568 | | NULL | 0 | 0 |
| 766089 | chinasoft_api_user | 172.16.0.237:45755 | chinasoft_api | Sleep | 10685 | | NULL | 0 | 0 |
| 766827 | chinasoft_api_user | 172.16.0.232:26937 | chinasoft_api | Sleep | 14275 | | NULL | 0 | 0 |
| 769505 | chinasoft_api_user | 172.16.0.232:17603 | chinasoft_api | Sleep | 4068 | | NULL | 0 | 0 |
| 769511 | chinasoft_api_user | 172.16.0.232:17705 | chinasoft_api | Sleep | 10984 | | NULL | 0 | 0 |
| 770855 | chinasoft_api_user | 172.16.0.232:13928 | chinasoft_api | Sleep | 3154 | | NULL | 0 | 0 |
| 774117 | chinasoft_api_user | 172.16.0.232:44074 | chinasoft_api | Sleep | 17336 | | NULL | 0 | 0 |
| 777954 | chinasoft_api_user | 172.16.0.237:36383 | chinasoft_api | Sleep | 11496 | | NULL | 0 | 0 |
| 778705 | chinasoft_api_user | 172.16.0.237:23422 | chinasoft_api | Sleep | 1198 | | NULL | 0 | 0 |
| 778879 | chinasoft_api_user | 172.16.0.237:36842 | chinasoft_api | Sleep | 8068 | | NULL | 0 | 0 |
| 780325 | chinasoft_api_user | 172.16.0.232:31486 | chinasoft_api | Sleep | 22057 | | NULL | 0 | 0 |
| 780474 | chinasoft_api_user | 172.16.0.237:20398 | chinasoft_api | Sleep | 1185 | | NULL | 0 | 0 |
| 780862 | chinasoft_api_user | 172.16.0.237:43324 | chinasoft_api | Sleep | 11568 | | NULL | 0 | 0 |
| 781196 | chinasoft_api_user | 172.16.0.237:3057 | chinasoft_api | Sleep | 11555 | | NULL | 0 | 0 |
| 781244 | chinasoft_api_user | 172.16.0.237:7207 | chinasoft_api | Sleep | 3162 | | NULL | 0 | 0 |
| 781245 | chinasoft_api_user | 172.16.0.237:7213 | chinasoft_api | Sleep | 10321 | | NULL | 0 | 0 |
| 782417 | chinasoft_api_user | 172.16.0.232:7040 | chinasoft_api | Sleep | 930 | | NULL | 0 | 0 |
| 782682 | chinasoft_api_user | 172.16.0.232:19852 | chinasoft_api | Sleep | 2647 | | NULL | 0 | 0 |
| 782739 | chinasoft_api_user | 172.16.0.237:50740 | chinasoft_api | Sleep | 8828 | | NULL | 0 | 0 |
| 782964 | chinasoft_api_user | 172.16.0.237:1181 | chinasoft_api | Sleep | 18645 | | NULL | 0 | 0 |
| 783244 | chinasoft_api_user | 172.16.0.232:48672 | chinasoft_api | Sleep | 416 | | NULL | 0 | 0 |
| 783656 | chinasoft_api_user | 172.16.0.232:5605 | chinasoft_api | Sleep | 5342 | | NULL | 0 | 0 |
| 783716 | chinasoft_api_user | 172.16.0.232:8599 | chinasoft_api | Sleep | 2262 | | NULL | 0 | 0 |
| 783717 | chinasoft_api_user | 172.16.0.232:8603 | chinasoft_api | Sleep | 11022 | | NULL | 0 | 0 |
| 783749 | chinasoft_api_user | 172.16.0.232:10175 | chinasoft_api | Sleep | 2395 | | NULL | 0 | 0 |
| 783789 | chinasoft_api_user | 172.16.0.232:12431 | chinasoft_api | Sleep | 8175 | | NULL | 0 | 0 |
| 783841 | chinasoft_api_user | 172.16.0.232:15103 | chinasoft_api | Sleep | 1107 | | NULL | 0 | 0 |
| 783942 | chinasoft_api_user | 172.16.0.237:2326 | chinasoft_api | Sleep | 11433 | | NULL | 0 | 0 |
| 783948 | chinasoft_api_user | 172.16.0.237:2620 | chinasoft_api | Sleep | 118 | | NULL | 0 | 0 |
| 784269 | chinasoft_api_user | 172.16.0.232:37141 | chinasoft_api | Sleep | 18101 | | NULL | 0 | 0 |
| 784499 | chinasoft_api_user | 172.16.0.232:49135 | chinasoft_api | Sleep | 5873 | | NULL | 0 | 0 |
| 784500 | chinasoft_api_user | 172.16.0.232:49137 | chinasoft_api | Sleep | 4945 | | NULL | 0 | 0 |
| 784796 | chinasoft_api_user | 172.16.0.232:61785 | chinasoft_api | Sleep | 12010 | | NULL | 0 | 0 |
| 784820 | chinasoft_api_user | 172.16.0.232:62589 | chinasoft_api | Sleep | 15164 | | NULL | 0 | 0 |
| 784829 | chinasoft_api_user | 172.16.0.232:62959 | chinasoft_api | Sleep | 14969 | | NULL | 0 | 0 |
| 784834 | chinasoft_api_user | 172.16.0.232:63179 | chinasoft_api | Sleep | 978 | | NULL | 0 | 0 |
| 784847 | chinasoft_api_user | 172.16.0.232:63551 | chinasoft_api | Sleep | 21755 | | NULL | 0 | 0 |
| 785414 | chinasoft_api_user | 172.16.0.232:23114 | chinasoft_api | Sleep | 10984 | | NULL | 0 | 0 |
| 785466 | chinasoft_api_user | 172.16.0.232:26030 | chinasoft_api | Sleep | 1620 | | NULL | 0 | 0 |
| 785471 | chinasoft_api_user | 172.16.0.232:26278 | chinasoft_api | Sleep | 2210 | | NULL | 0 | 0 |
| 785482 | chinasoft_api_user | 172.16.0.237:27869 | chinasoft_api | Sleep | 1611 | | NULL | 0 | 0 |
| 785515 | chinasoft_api_user | 172.16.0.232:28552 | chinasoft_api | Sleep | 396 | | NULL | 0 | 0 |
| 785527 | chinasoft_api_user | 172.16.0.237:30975 | chinasoft_api | Sleep | 2152 | | NULL | 0 | 0 |
| 785713 | chinasoft_api_user | 172.16.0.232:39486 | chinasoft_api | Sleep | 118 | | NULL | 0 | 0 |
| 785723 | chinasoft_api_user | 172.16.0.232:39980 | chinasoft_api | Sleep | 4081 | | NULL | 0 | 0 |
| 785936 | chinasoft_api_user | 172.16.0.237:60407 | chinasoft_api | Sleep | 3589 | | NULL | 0 | 0 |
| 786147 | chinasoft_api_user | 172.16.0.232:62854 | chinasoft_api | Sleep | 11483 | | NULL | 0 | 0 |
| 786148 | chinasoft_api_user | 172.16.0.237:11014 | chinasoft_api | Sleep | 19677 | | NULL | 0 | 0 |
| 786155 | chinasoft_api_user | 172.16.0.232:63098 | chinasoft_api | Sleep | 25174 | | NULL | 0 | 0 |
| 786156 | chinasoft_api_user | 172.16.0.232:63104 | chinasoft_api | Sleep | 7588 | | NULL | 0 | 0 |
| 786157 | chinasoft_api_user | 172.16.0.237:11312 | chinasoft_api | Sleep | 118 | | NULL | 0 | 0 |
| 786160 | chinasoft_api_user | 172.16.0.237:11514 | chinasoft_api | Sleep | 978 | | NULL | 0 | 0 |
| 786163 | chinasoft_api_user | 172.16.0.237:11628 | chinasoft_api | Sleep | 11360 | | NULL | 0 | 0 |
| 786164 | chinasoft_api_user | 172.16.0.237:11700 | chinasoft_api | Sleep | 9865 | | NULL | 0 | 0 |
| 786167 | chinasoft_api_user | 172.16.0.237:11798 | chinasoft_api | Sleep | 18655 | | NULL | 0 | 0 |
| 786367 | chinasoft_api_user | 172.16.0.237:26972 | chinasoft_api | Sleep | 3236 | | NULL | 0 | 0 |
| 786370 | chinasoft_api_user | 172.16.0.237:27058 | chinasoft_api | Sleep | 11092 | | NULL | 0 | 0 |
| 786424 | chinasoft_api_user | 172.16.0.237:30918 | chinasoft_api | Sleep | 118 | | NULL | 0 | 0 |
| 786432 | chinasoft_api_user | 172.16.0.237:31406 | chinasoft_api | Sleep | 10587 | | NULL | 0 | 0 |
| 786440 | chinasoft_api_user | 172.16.0.237:31922 | chinasoft_api | Sleep | 18499 | | NULL | 0 | 0 |
| 786443 | chinasoft_api_user | 172.16.0.237:31998 | chinasoft_api | Sleep | 2413 | | NULL | 0 | 0 |
| 786447 | chinasoft_api_user | 172.16.0.237:32126 | chinasoft_api | Sleep | 4961 | | NULL | 0 | 0 |
| 786470 | chinasoft_api_user | 172.16.0.237:33088 | chinasoft_api | Sleep | 10872 | | NULL | 0 | 0 |
| 786488 | chinasoft_api_user | 172.16.0.237:34398 | chinasoft_api | Sleep | 8787 | | NULL | 0 | 0 |
| 786498 | chinasoft_api_user | 172.16.0.237:34824 | chinasoft_api | Sleep | 10947 | | NULL | 0 | 0 |
| 786499 | chinasoft_api_user | 172.16.0.237:34848 | chinasoft_api | Sleep | 10946 | | NULL | 0 | 0 |
| 786500 | chinasoft_api_user | 172.16.0.237:34898 | chinasoft_api | Sleep | 9337 | | NULL | 0 | 0 |
| 786505 | chinasoft_api_user | 172.16.0.237:35190 | chinasoft_api | Sleep | 11447 | | NULL | 0 | 0 |
| 786506 | chinasoft_api_user | 172.16.0.237:35196 | chinasoft_api | Sleep | 1056 | | NULL | 0 | 0 |
| 786514 | chinasoft_api_user | 172.16.0.232:15867 | chinasoft_api | Sleep | 396 | | NULL | 0 | 0 |
| 786517 | chinasoft_api_user | 172.16.0.232:16033 | chinasoft_api | Sleep | 3705 | | NULL | 0 | 0 |
| 786558 | chinasoft_api_user | 172.16.0.232:18031 | chinasoft_api | Sleep | 22080 | | NULL | 0 | 0 |
| 786562 | chinasoft_api_user | 172.16.0.237:38816 | chinasoft_api | Sleep | 4081 | | NULL | 0 | 0 |
| 786565 | chinasoft_api_user | 172.16.0.232:18265 | chinasoft_api | Sleep | 3443 | | NULL | 0 | 0 |
| 786566 | chinasoft_api_user | 172.16.0.232:18273 | chinasoft_api | Sleep | 882 | | NULL | 0 | 0 |
| 786567 | chinasoft_api_user | 172.16.0.232:18349 | chinasoft_api | Sleep | 13595 | | NULL | 0 | 0 |
| 786569 | chinasoft_api_user | 172.16.0.232:18411 | chinasoft_api | Sleep | 17697 | | NULL | 0 | 0 |
| 786571 | chinasoft_api_user | 172.16.0.232:18433 | chinasoft_api | Sleep | 5424 | | NULL | 0 | 0 |
| 786572 | chinasoft_api_user | 172.16.0.232:18461 | chinasoft_api | Sleep | 8090 | | NULL | 0 | 0 |
| 786610 | chinasoft_api_user | 172.16.0.232:20647 | chinasoft_api | Sleep | 1119 | | NULL | 0 | 0 |
| 786625 | chinasoft_api_user | 172.16.0.232:21123 | chinasoft_api | Sleep | 6852 | | NULL | 0 | 0 |
| 786640 | chinasoft_api_user | 172.16.0.232:21969 | chinasoft_api | Sleep | 5341 | | NULL | 0 | 0 |
| 786646 | chinasoft_api_user | 172.16.0.232:22235 | chinasoft_api | Sleep | 7763 | | NULL | 0 | 0 |
| 786773 | chinasoft_api_user | 172.16.0.237:52486 | chinasoft_api | Sleep | 116 | | NULL | 0 | 0 |
| 786831 | chinasoft_api_user | 172.16.0.232:31845 | chinasoft_api | Sleep | 11532 | | NULL | 0 | 0 |
| 786869 | chinasoft_api_user | 172.16.0.232:33907 | chinasoft_api | Sleep | 7764 | | NULL | 0 | 0 |
| 787011 | chinasoft_api_user | 172.16.0.237:3693 | chinasoft_api | Sleep | 10588 | | NULL | 0 | 0 |
| 787073 | chinasoft_api_user | 172.16.0.237:7979 | chinasoft_api | Sleep | 5605 | | NULL | 0 | 0 |
| 787282 | chinasoft_api_user | 172.16.0.237:22457 | chinasoft_api | Sleep | 8474 | | NULL | 0 | 0 |
| 787349 | chinasoft_api_user | 172.16.0.237:26057 | chinasoft_api | Sleep | 1692 | | NULL | 0 | 0 |
| 787459 | chinasoft_admin_user | 172.16.0.237:33107 | chinasoft_admin | Sleep | 28418 | | NULL | 0 | 0 |
| 787460 | chinasoft_admin_user | 172.16.0.237:33111 | chinasoft_admin | Sleep | 28417 | | NULL | 0 | 0 |
| 787461 | chinasoft_api_user | 172.16.0.237:33113 | chinasoft_api | Sleep | 7948 | | NULL | 0 | 0 |
| 787466 | chinasoft_admin_user | 172.16.0.237:33269 | chinasoft_admin | Sleep | 28360 | | NULL | 0 | 0 |
| 787471 | chinasoft_admin_user | 172.16.0.237:33369 | chinasoft_admin | Sleep | 28344 | | NULL | 0 | 0 |
| 787473 | chinasoft_admin_user | 172.16.0.237:33419 | chinasoft_admin | Sleep | 28333 | | NULL | 0 | 0 |
| 787494 | chinasoft_api_user | 172.16.0.237:34703 | chinasoft_api | Sleep | 11450 | | NULL | 0 | 0 |
| 787511 | chinasoft_api_user | 172.16.0.237:35687 | chinasoft_api | Sleep | 10552 | | NULL | 0 | 0 |
| 787552 | chinasoft_api_user | 172.16.0.232:3466 | chinasoft_api | Sleep | 8385 | | NULL | 0 | 0 |
| 787560 | chinasoft_admin_user | 172.16.0.237:38005 | chinasoft_admin | Sleep | 19417 | | NULL | 0 | 0 |
| 787563 | chinasoft_admin_user | 172.16.0.237:38193 | chinasoft_admin | Sleep | 26640 | | NULL | 0 | 0 |
| 787567 | chinasoft_admin_user | 172.16.0.237:38415 | chinasoft_admin | Sleep | 24022 | | NULL | 0 | 0 |
| 787570 | chinasoft_admin_user | 172.16.0.237:38491 | chinasoft_admin | Sleep | 26541 | | NULL | 0 | 0 |
| 787571 | chinasoft_admin_user | 172.16.0.237:38565 | chinasoft_admin | Sleep | 26514 | | NULL | 0 | 0 |
| 787581 | chinasoft_admin_user | 172.16.0.232:4592 | chinasoft_admin | Sleep | 26300 | | NULL | 0 | 0 |
| 787582 | chinasoft_admin_user | 172.16.0.232:4596 | chinasoft_admin | Sleep | 1994 | | NULL | 0 | 0 |
| 787583 | chinasoft_api_user | 172.16.0.232:4598 | chinasoft_api | Sleep | 377 | | NULL | 0 | 0 |
| 787584 | chinasoft_admin_user | 172.16.0.232:4626 | chinasoft_admin | Sleep | 1984 | | NULL | 0 | 0 |
| 787585 | chinasoft_api_user | 172.16.0.232:4628 | chinasoft_api | Sleep | 1984 | | NULL | 0 | 0 |
| 787588 | chinasoft_admin_user | 172.16.0.232:4732 | chinasoft_admin | Sleep | 26235 | | NULL | 0 | 0 |
| 787589 | chinasoft_admin_user | 172.16.0.232:4746 | chinasoft_admin | Sleep | 26233 | | NULL | 0 | 0 |
| 787595 | chinasoft_admin_user | 172.16.0.237:39827 | chinasoft_admin | Sleep | 26079 | | NULL | 0 | 0 |
| 787598 | chinasoft_admin_user | 172.16.0.237:39925 | chinasoft_admin | Sleep | 26058 | | NULL | 0 | 0 |
| 787599 | chinasoft_admin_user | 172.16.0.237:39933 | chinasoft_admin | Sleep | 26054 | | NULL | 0 | 0 |
| 787606 | chinasoft_admin_user | 172.16.0.237:40313 | chinasoft_admin | Sleep | 25896 | | NULL | 0 | 0 |
| 787609 | chinasoft_admin_user | 172.16.0.237:40425 | chinasoft_admin | Sleep | 19409 | | NULL | 0 | 0 |
| 787613 | chinasoft_admin_user | 172.16.0.237:40495 | chinasoft_admin | Sleep | 25827 | | NULL | 0 | 0 |
| 787665 | chinasoft_api_user | 172.16.0.237:42669 | chinasoft_api | Sleep | 10689 | | NULL | 0 | 0 |
| 787746 | chinasoft_admin_user | 172.16.0.237:44543 | chinasoft_admin | Sleep | 24584 | | NULL | 0 | 0 |
| 787754 | chinasoft_admin_user | 172.16.0.237:44855 | chinasoft_admin | Sleep | 24497 | | NULL | 0 | 0 |
| 787755 | chinasoft_admin_user | 172.16.0.237:44873 | chinasoft_admin | Sleep | 23700 | | NULL | 0 | 0 |
| 787756 | chinasoft_admin_user | 172.16.0.237:44877 | chinasoft_admin | Sleep | 12063 | | NULL | 0 | 0 |
| 787844 | chinasoft_admin_user | 172.16.0.237:46657 | chinasoft_admin | Sleep | 23908 | | NULL | 0 | 0 |
| 787861 | chinasoft_admin_user | 172.16.0.236:10824 | chinasoft_admin | Sleep | 554 | | NULL | 0 | 0 |
| 787862 | chinasoft_admin_user | 172.16.0.236:10828 | chinasoft_admin | Sleep | 519 | | NULL | 0 | 0 |
| 787863 | chinasoft_api_user | 172.16.0.236:10830 | chinasoft_api | Sleep | 11820 | | NULL | 0 | 0 |
| 787864 | chinasoft_admin_user | 172.16.0.236:10902 | chinasoft_admin | Sleep | 517 | | NULL | 0 | 0 |
| 787865 | chinasoft_admin_user | 172.16.0.236:10920 | chinasoft_admin | Sleep | 512 | | NULL | 0 | 0 |
| 787866 | chinasoft_api_user | 172.16.0.236:10922 | chinasoft_api | Sleep | 23698 | | NULL | 0 | 0 |
| 787867 | chinasoft_admin_user | 172.16.0.236:10926 | chinasoft_admin | Sleep | 505 | | NULL | 0 | 0 |
| 787868 | chinasoft_api_user | 172.16.0.236:10928 | chinasoft_api | Sleep | 11258 | | NULL | 0 | 0 |
| 787871 | chinasoft_admin_user | 172.16.0.237:47489 | chinasoft_admin | Sleep | 23650 | | NULL | 0 | 0 |
| 787872 | chinasoft_admin_user | 172.16.0.236:11058 | chinasoft_admin | Sleep | 11244 | | NULL | 0 | 0 |
| 787873 | chinasoft_api_user | 172.16.0.236:11060 | chinasoft_api | Sleep | 11244 | | NULL | 0 | 0 |
| 787874 | chinasoft_admin_user | 172.16.0.236:11068 | chinasoft_admin | Sleep | 310 | | NULL | 0 | 0 |
| 787875 | chinasoft_api_user | 172.16.0.236:11070 | chinasoft_api | Sleep | 310 | | NULL | 0 | 0 |
| 787877 | chinasoft_admin_user | 172.16.0.236:11074 | chinasoft_admin | Sleep | 304 | | NULL | 0 | 0 |
| 787878 | chinasoft_api_user | 172.16.0.236:11076 | chinasoft_api | Sleep | 304 | | NULL | 0 | 0 |
| 787881 | chinasoft_admin_user | 172.16.0.236:11086 | chinasoft_admin | Sleep | 302 | | NULL | 0 | 0 |
| 787882 | chinasoft_api_user | 172.16.0.236:11088 | chinasoft_api | Sleep | 10933 | | NULL | 0 | 0 |
| 787883 | chinasoft_admin_user | 172.16.0.236:11092 | chinasoft_admin | Sleep | 134 | | NULL | 0 | 0 |
| 787884 | chinasoft_api_user | 172.16.0.236:11094 | chinasoft_api | Sleep | 10928 | | NULL | 0 | 0 |
| 787886 | chinasoft_admin_user | 172.16.0.236:11098 | chinasoft_admin | Sleep | 125 | | NULL | 0 | 0 |
| 787887 | chinasoft_api_user | 172.16.0.236:11100 | chinasoft_api | Sleep | 10915 | | NULL | 0 | 0 |
| 787888 | chinasoft_admin_user | 172.16.0.236:11138 | chinasoft_admin | Sleep | 10263 | | NULL | 0 | 0 |
| 787889 | chinasoft_api_user | 172.16.0.236:11140 | chinasoft_api | Sleep | 18976 | | NULL | 0 | 0 |
| 787890 | chinasoft_admin_user | 172.16.0.236:11172 | chinasoft_admin | Sleep | 10222 | | NULL | 0 | 0 |
| 787891 | chinasoft_api_user | 172.16.0.236:11174 | chinasoft_api | Sleep | 20645 | | NULL | 0 | 0 |
| 787892 | chinasoft_admin_user | 172.16.0.236:11184 | chinasoft_admin | Sleep | 10215 | | NULL | 0 | 0 |
| 787893 | chinasoft_api_user | 172.16.0.236:11186 | chinasoft_api | Sleep | 20636 | | NULL | 0 | 0 |
| 787894 | chinasoft_admin_user | 172.16.0.236:11216 | chinasoft_admin | Sleep | 10194 | | NULL | 0 | 0 |
| 787897 | chinasoft_admin_user | 172.16.0.236:11276 | chinasoft_admin | Sleep | 10191 | | NULL | 0 | 0 |
| 787906 | chinasoft_admin_user | 172.16.0.236:11634 | chinasoft_admin | Sleep | 10186 | | NULL | 0 | 0 |
| 787922 | chinasoft_api_user | 172.16.0.232:11576 | chinasoft_api | Sleep | 3315 | | NULL | 0 | 0 |
| 787936 | chinasoft_admin_user | 172.16.0.236:12082 | chinasoft_admin | Sleep | 10140 | | NULL | 0 | 0 |
| 787940 | chinasoft_admin_user | 172.16.0.236:12202 | chinasoft_admin | Sleep | 10129 | | NULL | 0 | 0 |
| 787948 | chinasoft_api_user | 172.16.0.237:49621 | chinasoft_api | Sleep | 10089 | | NULL | 0 | 0 |
| 787956 | chinasoft_admin_user | 172.16.0.236:12886 | chinasoft_admin | Sleep | 10059 | | NULL | 0 | 0 |
| 787957 | chinasoft_admin_user | 172.16.0.236:12892 | chinasoft_admin | Sleep | 9980 | | NULL | 0 | 0 |
| 787958 | chinasoft_admin_user | 172.16.0.236:12910 | chinasoft_admin | Sleep | 9975 | | NULL | 0 | 0 |
| 787959 | chinasoft_admin_user | 172.16.0.236:12924 | chinasoft_admin | Sleep | 9972 | | NULL | 0 | 0 |
| 787964 | chinasoft_admin_user | 172.16.0.236:13126 | chinasoft_admin | Sleep | 9547 | | NULL | 0 | 0 |
| 787965 | chinasoft_admin_user | 172.16.0.236:13144 | chinasoft_admin | Sleep | 18595 | | NULL | 0 | 0 |
| 787966 | chinasoft_admin_user | 172.16.0.236:13154 | chinasoft_admin | Sleep | 18561 | | NULL | 0 | 0 |
| 787969 | chinasoft_api_user | 172.16.0.232:13132 | chinasoft_api | Sleep | 1669 | | NULL | 0 | 0 |
| 787973 | chinasoft_admin_user | 172.16.0.236:13332 | chinasoft_admin | Sleep | 18549 | | NULL | 0 | 0 |
| 787991 | chinasoft_admin_user | 172.16.0.236:13816 | chinasoft_admin | Sleep | 18547 | | NULL | 0 | 0 |
| 787992 | chinasoft_admin_user | 172.16.0.236:13828 | chinasoft_admin | Sleep | 18541 | | NULL | 0 | 0 |
| 787996 | chinasoft_admin_user | 172.16.0.236:13890 | chinasoft_admin | Sleep | 18539 | | NULL | 0 | 0 |
| 787997 | chinasoft_admin_user | 172.16.0.236:13900 | chinasoft_admin | Sleep | 18527 | | NULL | 0 | 0 |
| 787998 | chinasoft_admin_user | 172.16.0.236:13910 | chinasoft_admin | Sleep | 2318 | | NULL | 0 | 0 |
| 788000 | chinasoft_api_user | 172.16.0.237:51395 | chinasoft_api | Sleep | 9303 | | NULL | 0 | 0 |
| 788001 | chinasoft_admin_user | 172.16.0.236:13928 | chinasoft_admin | Sleep | 2318 | | NULL | 0 | 0 |
| 788002 | chinasoft_admin_user | 172.16.0.236:13938 | chinasoft_admin | Sleep | 2307 | | NULL | 0 | 0 |
| 788005 | chinasoft_admin_user | 172.16.0.236:14040 | chinasoft_admin | Sleep | 2232 | | NULL | 0 | 0 |
| 788009 | chinasoft_admin_user | 172.16.0.236:14340 | chinasoft_admin | Sleep | 2208 | | NULL | 0 | 0 |
| 788017 | chinasoft_admin_user | 172.16.0.236:14586 | chinasoft_admin | Sleep | 2199 | | NULL | 0 | 0 |
| 788019 | chinasoft_admin_user | 172.16.0.236:14594 | chinasoft_admin | Sleep | 2174 | | NULL | 0 | 0 |
| 788022 | chinasoft_admin_user | 172.16.0.236:14600 | chinasoft_admin | Sleep | 2163 | | NULL | 0 | 0 |
| 788023 | chinasoft_admin_user | 172.16.0.236:14610 | chinasoft_admin | Sleep | 2141 | | NULL | 0 | 0 |
| 788024 | chinasoft_admin_user | 172.16.0.236:14622 | chinasoft_admin | Sleep | 1701 | | NULL | 0 | 0 |
| 788025 | chinasoft_admin_user | 172.16.0.236:14682 | chinasoft_admin | Sleep | 1689 | | NULL | 0 | 0 |
| 788026 | chinasoft_api_user | 172.16.0.236:14684 | chinasoft_api | Sleep | 21972 | | NULL | 0 | 0 |
| 788028 | chinasoft_admin_user | 172.16.0.236:14700 | chinasoft_admin | Sleep | 1633 | | NULL | 0 | 0 |
| 788029 | chinasoft_api_user | 172.16.0.236:14702 | chinasoft_api | Sleep | 19857 | | NULL | 0 | 0 |
| 788030 | chinasoft_admin_user | 172.16.0.236:14724 | chinasoft_admin | Sleep | 1624 | | NULL | 0 | 0 |
| 788059 | chinasoft_admin_user | 172.16.0.236:15816 | chinasoft_admin | Sleep | 1597 | | NULL | 0 | 0 |
| 788064 | chinasoft_admin_user | 172.16.0.236:15840 | chinasoft_admin | Sleep | 1588 | | NULL | 0 | 0 |
| 788065 | chinasoft_admin_user | 172.16.0.236:15862 | chinasoft_admin | Sleep | 1459 | | NULL | 0 | 0 |
| 788066 | chinasoft_admin_user | 172.16.0.236:15886 | chinasoft_admin | Sleep | 1452 | | NULL | 0 | 0 |
| 788067 | chinasoft_admin_user | 172.16.0.236:15896 | chinasoft_admin | Sleep | 1446 | | NULL | 0 | 0 |
| 788068 | chinasoft_admin_user | 172.16.0.236:15908 | chinasoft_admin | Sleep | 1443 | | NULL | 0 | 0 |
| 788069 | chinasoft_admin_user | 172.16.0.236:15916 | chinasoft_admin | Sleep | 1432 | | NULL | 0 | 0 |
| 788070 | chinasoft_admin_user | 172.16.0.236:15926 | chinasoft_admin | Sleep | 1429 | | NULL | 0 | 0 |
| 788071 | chinasoft_admin_user | 172.16.0.236:15932 | chinasoft_admin | Sleep | 1427 | | NULL | 0 | 0 |
| 788072 | chinasoft_admin_user | 172.16.0.236:15938 | chinasoft_admin | Sleep | 19454 | | NULL | 0 | 0 |
| 788073 | chinasoft_admin_user | 172.16.0.236:15948 | chinasoft_admin | Sleep | 1423 | | NULL | 0 | 0 |
| 788074 | chinasoft_admin_user | 172.16.0.236:15972 | chinasoft_admin | Sleep | 1406 | | NULL | 0 | 0 |
| 788075 | chinasoft_api_user | 172.16.0.236:15974 | chinasoft_api | Sleep | 19444 | | NULL | 0 | 0 |
| 788076 | chinasoft_admin_user | 172.16.0.236:16004 | chinasoft_admin | Sleep | 19440 | | NULL | 0 | 0 |
| 788077 | chinasoft_admin_user | 172.16.0.236:16010 | chinasoft_admin | Sleep | 11915 | | NULL | 0 | 0 |
| 788080 | chinasoft_admin_user | 172.16.0.236:16070 | chinasoft_admin | Sleep | 11910 | | NULL | 0 | 0 |
| 788082 | chinasoft_admin_user | 172.16.0.236:16120 | chinasoft_admin | Sleep | 11907 | | NULL | 0 | 0 |
| 788083 | chinasoft_admin_user | 172.16.0.236:16128 | chinasoft_admin | Sleep | 570 | | NULL | 0 | 0 |
| 788084 | chinasoft_admin_user | 172.16.0.236:16138 | chinasoft_admin | Sleep | 569 | | NULL | 0 | 0 |
| 788206 | chinasoft_api_user | 172.16.0.236:17664 | chinasoft_api | Sleep | 18961 | | NULL | 0 | 0 |
| 788209 | chinasoft_api_user | 172.16.0.236:17674 | chinasoft_api | Sleep | 20614 | | NULL | 0 | 0 |
| 788226 | chinasoft_api_user | 172.16.0.236:18288 | chinasoft_api | Sleep | 18918 | | NULL | 0 | 0 |
| 788228 | chinasoft_api_user | 172.16.0.236:18322 | chinasoft_api | Sleep | 18896 | | NULL | 0 | 0 |
| 788229 | chinasoft_api_user | 172.16.0.236:18330 | chinasoft_api | Sleep | 20341 | | NULL | 0 | 0 |
| 788230 | chinasoft_admin_user | 172.16.0.236:18334 | chinasoft_admin | Sleep | 10094 | | NULL | 0 | 0 |
| 788235 | chinasoft_api_user | 172.16.0.236:18428 | chinasoft_api | Sleep | 18613 | | NULL | 0 | 0 |
| 788236 | chinasoft_api_user | 172.16.0.236:18436 | chinasoft_api | Sleep | 18598 | | NULL | 0 | 0 |
| 788237 | chinasoft_api_user | 172.16.0.237:58121 | chinasoft_api | Sleep | 2691 | | NULL | 0 | 0 |
| 788238 | chinasoft_api_user | 172.16.0.232:18438 | chinasoft_api | Sleep | 964 | | NULL | 0 | 0 |
| 788265 | chinasoft_api_user | 172.16.0.236:19246 | chinasoft_api | Sleep | 18561 | | NULL | 0 | 0 |
| 788266 | chinasoft_api_user | 172.16.0.236:19254 | chinasoft_api | Sleep | 19994 | | NULL | 0 | 0 |
| 788267 | chinasoft_api_user | 172.16.0.236:19328 | chinasoft_api | Sleep | 19987 | | NULL | 0 | 0 |
| 788268 | chinasoft_api_user | 172.16.0.236:19336 | chinasoft_api | Sleep | 19981 | | NULL | 0 | 0 |
| 788270 | chinasoft_api_user | 172.16.0.236:19352 | chinasoft_api | Sleep | 19979 | | NULL | 0 | 0 |
| 788274 | chinasoft_api_user | 172.16.0.236:19386 | chinasoft_api | Sleep | 19959 | | NULL | 0 | 0 |
| 788281 | chinasoft_api_user | 172.16.0.236:19422 | chinasoft_api | Sleep | 19949 | | NULL | 0 | 0 |
| 788282 | chinasoft_api_user | 172.16.0.236:19516 | chinasoft_api | Sleep | 19897 | | NULL | 0 | 0 |
| 788285 | chinasoft_api_user | 172.16.0.236:19568 | chinasoft_api | Sleep | 2163 | | NULL | 0 | 0 |
| 788286 | chinasoft_api_user | 172.16.0.236:19574 | chinasoft_api | Sleep | 2141 | | NULL | 0 | 0 |
| 788287 | chinasoft_api_user | 172.16.0.236:19594 | chinasoft_api | Sleep | 19873 | | NULL | 0 | 0 |
| 788346 | chinasoft_api_user | 172.16.0.236:20136 | chinasoft_api | Sleep | 1624 | | NULL | 0 | 0 |
| 788379 | chinasoft_api_user | 172.16.0.236:20612 | chinasoft_api | Sleep | 1597 | | NULL | 0 | 0 |
| 788380 | chinasoft_api_user | 172.16.0.236:20616 | chinasoft_api | Sleep | 19479 | | NULL | 0 | 0 |
| 788382 | chinasoft_api_user | 172.16.0.236:20620 | chinasoft_api | Sleep | 19477 | | NULL | 0 | 0 |
| 788390 | chinasoft_api_user | 172.16.0.236:20656 | chinasoft_api | Sleep | 1432 | | NULL | 0 | 0 |
| 788391 | chinasoft_api_user | 172.16.0.236:20660 | chinasoft_api | Sleep | 1429 | | NULL | 0 | 0 |
| 788392 | chinasoft_api_user | 172.16.0.236:20668 | chinasoft_api | Sleep | 1427 | | NULL | 0 | 0 |
| 788393 | chinasoft_api_user | 172.16.0.236:20672 | chinasoft_api | Sleep | 19454 | | NULL | 0 | 0 |
| 788394 | chinasoft_api_user | 172.16.0.236:20680 | chinasoft_api | Sleep | 1423 | | NULL | 0 | 0 |
| 788398 | chinasoft_admin_user | 172.16.0.236:20694 | chinasoft_admin | Sleep | 1372 | | NULL | 0 | 0 |
| 788399 | chinasoft_api_user | 172.16.0.236:20696 | chinasoft_api | Sleep | 19443 | | NULL | 0 | 0 |
| 788405 | chinasoft_api_user | 172.16.0.236:20720 | chinasoft_api | Sleep | 19433 | | NULL | 0 | 0 |
| 788407 | chinasoft_admin_user | 172.16.0.237:60857 | chinasoft_admin | Sleep | 19413 | | NULL | 0 | 0 |
| 788409 | chinasoft_api_user | 172.16.0.236:20760 | chinasoft_api | Sleep | 19414 | | NULL | 0 | 0 |
| 788410 | chinasoft_api_user | 172.16.0.236:20764 | chinasoft_api | Sleep | 19412 | | NULL | 0 | 0 |
| 788421 | chinasoft_api_user | 172.16.0.237:61189 | chinasoft_api | Sleep | 19252 | | NULL | 0 | 0 |
| 788422 | chinasoft_api_user | 172.16.0.237:61195 | chinasoft_api | Sleep | 9640 | | NULL | 0 | 0 |
| 788423 | chinasoft_api_user | 172.16.0.237:61199 | chinasoft_api | Sleep | 7816 | | NULL | 0 | 0 |
| 788458 | chinasoft_api_user | 172.16.0.236:22122 | chinasoft_api | Sleep | 18785 | | NULL | 0 | 0 |
| 788469 | chinasoft_api_user | 172.16.0.236:22272 | chinasoft_api | Sleep | 18699 | | NULL | 0 | 0 |
| 788470 | chinasoft_api_user | 172.16.0.236:22280 | chinasoft_api | Sleep | 18697 | | NULL | 0 | 0 |
| 788475 | chinasoft_api_user | 172.16.0.236:22472 | chinasoft_api | Sleep | 18617 | | NULL | 0 | 0 |
| 788477 | chinasoft_api_user | 172.16.0.236:22504 | chinasoft_api | Sleep | 18595 | | NULL | 0 | 0 |
| 788505 | chinasoft_api_user | 172.16.0.232:24956 | chinasoft_api | Sleep | 12641 | | NULL | 0 | 0 |
| 788577 | chinasoft_api_user | 172.16.0.232:32790 | chinasoft_api | Sleep | 8048 | | NULL | 0 | 0 |
| 788628 | chinasoft_admin_user | 172.16.0.237:14962 | chinasoft_admin | Sleep | 12063 | | NULL | 0 | 0 |
| 788630 | chinasoft_api_user | 172.16.0.232:37806 | chinasoft_api | Sleep | 4829 | | NULL | 0 | 0 |
| 788631 | chinasoft_admin_user | 172.16.0.237:15120 | chinasoft_admin | Sleep | 11976 | | NULL | 0 | 0 |
| 788634 | chinasoft_api_user | 172.16.0.236:35734 | chinasoft_api | Sleep | 11915 | | NULL | 0 | 0 |
| 788635 | chinasoft_api_user | 172.16.0.236:35898 | chinasoft_api | Sleep | 11878 | | NULL | 0 | 0 |
| 788640 | chinasoft_api_user | 172.16.0.236:36314 | chinasoft_api | Sleep | 11717 | | NULL | 0 | 0 |
| 788644 | chinasoft_api_user | 172.16.0.232:38690 | chinasoft_api | Sleep | 1993 | | NULL | 0 | 0 |
| 788648 | chinasoft_api_user | 172.16.0.237:16664 | chinasoft_api | Sleep | 118 | | NULL | 0 | 0 |
| 788649 | chinasoft_api_user | 172.16.0.237:16764 | chinasoft_api | Sleep | 10641 | | NULL | 0 | 0 |
| 788672 | chinasoft_api_user | 172.16.0.237:19482 | chinasoft_api | Sleep | 3183 | | NULL | 0 | 0 |
| 788688 | chinasoft_api_user | 172.16.0.236:39886 | chinasoft_api | Sleep | 9340 | | NULL | 0 | 0 |
| 788691 | chinasoft_admin_user | 172.16.0.236:40164 | chinasoft_admin | Sleep | 57 | | NULL | 0 | 0 |
| 788696 | chinasoft_admin_user | 172.16.0.236:40366 | chinasoft_admin | Sleep | 83 | | NULL | 0 | 0 |
| 788697 | chinasoft_api_user | 172.16.0.236:40368 | chinasoft_api | Sleep | 83 | | NULL | 0 | 0 |
| 788699 | chinasoft_admin_user | 172.16.0.236:40532 | chinasoft_admin | Sleep | 1103 | | NULL | 0 | 0 |
| 788700 | chinasoft_api_user | 172.16.0.236:40534 | chinasoft_api | Sleep | 1103 | | NULL | 0 | 0 |
| 788701 | chinasoft_admin_user | 172.16.0.236:40592 | chinasoft_admin | Sleep | 1046 | | NULL | 0 | 0 |
| 788703 | common_user | 172.16.0.236:40732 | common | Sleep | 138 | | NULL | 0 | 0 |
| 788711 | chinasoft_api_user | 172.16.0.236:41146 | chinasoft_api | Sleep | 91 | | NULL | 0 | 0 |
| 788718 | common_user | 172.16.0.236:41838 | common | Sleep | 6137 | | NULL | 0 | 0 |
| 788729 | chinasoft_api_user | 172.16.0.236:42230 | chinasoft_api | Sleep | 95 | | NULL | 0 | 0 |
| 788744 | chinasoft_extend_user | 172.16.0.236:42516 | chinasoft_extend | Sleep | 8658 | | NULL | 0 | 0 |
| 788819 | chinasoft_extend_user | 172.16.0.237:25632 | chinasoft_extend | Sleep | 90 | | NULL | 0 | 0 |
| 788820 | chinasoft_daily_user | 172.16.0.237:25636 | chinasoft_daily | Sleep | 116 | | NULL | 0 | 0 |
| 788821 | chinasoft_extend_user | 172.16.0.237:25642 | chinasoft_extend | Sleep | 7 | | NULL | 0 | 0 |
| 788822 | chinasoft_daily_user | 172.16.0.237:25644 | chinasoft_daily | Sleep | 7 | | NULL | 0 | 0 |
| 788823 | chinasoft_extend_user | 172.16.0.237:25684 | chinasoft_extend | Sleep | 126 | | NULL | 0 | 0 |
| 788824 | chinasoft_daily_user | 172.16.0.237:25686 | chinasoft_daily | Sleep | 126 | | NULL | 0 | 0 |
| 788825 | chinasoft_admin_user | 172.16.0.237:25704 | chinasoft_admin | Sleep | 126 | | NULL | 0 | 0 |
| 788826 | chinasoft_api_user | 172.16.0.237:25706 | chinasoft_api | Sleep | 185 | | NULL | 0 | 0 |
| 788827 | chinasoft_extend_user | 172.16.0.232:46994 | chinasoft_extend | Sleep | 1 | | NULL | 0 | 0 |
| 788828 | chinasoft_daily_user | 172.16.0.232:46998 | chinasoft_daily | Sleep | 1 | | NULL | 0 | 0 |
| 788829 | chinasoft_admin_user | 172.16.0.237:25708 | chinasoft_admin | Sleep | 7 | | NULL | 0 | 0 |
| 788830 | chinasoft_api_user | 172.16.0.237:25710 | chinasoft_api | Sleep | 30 | | NULL | 0 | 0 |
| 788831 | chinasoft_extend_user | 172.16.0.232:47004 | chinasoft_extend | Sleep | 2 | | NULL | 0 | 0 |
| 788832 | chinasoft_daily_user | 172.16.0.232:47006 | chinasoft_daily | Sleep | 2 | | NULL | 0 | 0 |
| 788833 | chinasoft_extend_user | 172.16.0.232:47012 | chinasoft_extend | Sleep | 6 | | NULL | 0 | 0 |
| 788834 | chinasoft_daily_user | 172.16.0.232:47014 | chinasoft_daily | Sleep | 6 | | NULL | 0 | 0 |
| 788835 | chinasoft_extend_user | 172.16.0.232:47024 | chinasoft_extend | Sleep | 28 | | NULL | 0 | 0 |
| 788836 | chinasoft_daily_user | 172.16.0.232:47026 | chinasoft_daily | Sleep | 28 | | NULL | 0 | 0 |
| 788837 | chinasoft_admin_user | 172.16.0.232:47034 | chinasoft_admin | Sleep | 1 | | NULL | 0 | 0 |
| 788838 | chinasoft_api_user | 172.16.0.232:47042 | chinasoft_api | Sleep | 48 | | NULL | 0 | 0 |
| 788839 | chinasoft_admin_user | 172.16.0.232:47094 | chinasoft_admin | Sleep | 0 | | NULL | 0 | 0 |
| 788840 | chinasoft_daily_user | 172.16.0.232:47098 | chinasoft_daily | Sleep | 1 | | NULL | 0 | 0 |
| 788841 | chinasoft_extend_user | 172.16.0.232:47100 | chinasoft_extend | Sleep | 1 | | NULL | 0 | 0 |
| 788843 | chinasoft_admin_user | 172.16.0.232:47128 | chinasoft_admin | Sleep | 2 | | NULL | 0 | 0 |
| 788844 | chinasoft_api_user | 172.16.0.232:47130 | chinasoft_api | Sleep | 11 | | NULL | 0 | 0 |
| 788845 | chinasoft_extend_user | 172.16.0.237:25748 | chinasoft_extend | Sleep | 7 | | NULL | 0 | 0 |
| 788846 | chinasoft_daily_user | 172.16.0.237:25750 | chinasoft_daily | Sleep | 7 | | NULL | 0 | 0 |
| 788847 | chinasoft_extend_user | 172.16.0.237:25814 | chinasoft_extend | Sleep | 129 | | NULL | 0 | 0 |
| 788848 | chinasoft_admin_user | 172.16.0.237:25826 | chinasoft_admin | Sleep | 29 | | NULL | 0 | 0 |
| 788849 | chinasoft_api_user | 172.16.0.237:25828 | chinasoft_api | Sleep | 90 | | NULL | 0 | 0 |
| 788850 | chinasoft_daily_user | 172.16.0.237:25834 | chinasoft_daily | Sleep | 129 | | NULL | 0 | 0 |
| 788851 | chinasoft_extend_user | 172.16.0.232:47184 | chinasoft_extend | Sleep | 87 | | NULL | 0 | 0 |
| 788852 | chinasoft_daily_user | 172.16.0.232:47186 | chinasoft_daily | Sleep | 87 | | NULL | 0 | 0 |
| 788853 | chinasoft_admin_user | 172.16.0.232:47218 | chinasoft_admin | Sleep | 1 | | NULL | 0 | 0 |
| 788854 | chinasoft_api_user | 172.16.0.232:47220 | chinasoft_api | Sleep | 40 | | NULL | 0 | 0 |
| 788857 | chinasoft_admin_user | 172.16.0.232:47276 | chinasoft_admin | Sleep | 8 | | NULL | 0 | 0 |
| 788858 | chinasoft_api_user | 172.16.0.232:47278 | chinasoft_api | Sleep | 8 | | NULL | 0 | 0 |
| 788859 | chinasoft_daily_user | 172.16.0.237:26012 | chinasoft_daily | Sleep | 34 | | NULL | 0 | 0 |
| 788860 | chinasoft_api_user | 172.16.0.232:47306 | chinasoft_api | Sleep | 1 | | NULL | 0 | 0 |
| 788861 | chinasoft_admin_user | 172.16.0.237:26052 | chinasoft_admin | Sleep | 30 | | NULL | 0 | 0 |
| 788862 | chinasoft_extend_user | 172.16.0.237:26056 | chinasoft_extend | Sleep | 30 | | NULL | 0 | 0 |
| 788863 | chinasoft_extend_user | 172.16.0.237:26080 | chinasoft_extend | Sleep | 30 | | NULL | 0 | 0 |
| 788864 | chinasoft_daily_user | 172.16.0.237:26082 | chinasoft_daily | Sleep | 91 | | NULL | 0 | 0 |
| 788866 | chinasoft_api_user | 172.16.0.237:26108 | chinasoft_api | Sleep | 173 | | NULL | 0 | 0 |
| 788867 | chinasoft_extend_user | 172.16.0.237:26120 | chinasoft_extend | Sleep | 150 | | NULL | 0 | 0 |
| 788868 | chinasoft_admin_user | 172.16.0.232:47442 | chinasoft_admin | Sleep | 44 | | NULL | 0 | 0 |
| 788869 | chinasoft_api_user | 172.16.0.232:47444 | chinasoft_api | Sleep | 209 | | NULL | 0 | 0 |
| 788870 | chinasoft_extend_user | 172.16.0.232:47464 | chinasoft_extend | Sleep | 75 | | NULL | 0 | 0 |
| 788871 | chinasoft_daily_user | 172.16.0.232:47466 | chinasoft_daily | Sleep | 75 | | NULL | 0 | 0 |
| 788872 | chinasoft_admin_user | 172.16.0.232:47486 | chinasoft_admin | Sleep | 0 | | NULL | 0 | 0 |
| 788873 | chinasoft_extend_user | 172.16.0.232:47494 | chinasoft_extend | Sleep | 79 | | NULL | 0 | 0 |
| 788874 | chinasoft_daily_user | 172.16.0.232:47496 | chinasoft_daily | Sleep | 79 | | NULL | 0 | 0 |
| 788876 | chinasoft_api_user | 172.16.0.237:26268 | chinasoft_api | Sleep | 37 | | NULL | 0 | 0 |
| 788877 | chinasoft_api_user | 172.16.0.232:47608 | chinasoft_api | Sleep | 183 | | NULL | 0 | 0 |
| 788879 | chinasoft_admin_user | 172.16.0.237:26534 | chinasoft_admin | Sleep | 11 | | NULL | 0 | 0 |
| 788881 | chinasoft_admin_user | 172.16.0.237:26690 | chinasoft_admin | Sleep | 7 | | NULL | 0 | 0 |
| 788882 | chinasoft_api_user | 172.16.0.237:26692 | chinasoft_api | Sleep | 352 | | NULL | 0 | 0 |
| 788883 | chinasoft_admin_user | 172.16.0.232:47810 | chinasoft_admin | Sleep | 8 | | NULL | 0 | 0 |
| 788884 | chinasoft_api_user | 172.16.0.232:47812 | chinasoft_api | Sleep | 12 | | NULL | 0 | 0 |
| 788885 | common_user | 172.16.0.232:47814 | common | Sleep | 1878 | | NULL | 0 | 0 |
| 788887 | common_user | 172.16.0.232:47908 | common | Sleep | 125 | | NULL | 0 | 0 |
| 788890 | chinasoft_admin_user | 172.16.0.237:27030 | chinasoft_admin | Sleep | 88 | | NULL | 0 | 0 |
| 788891 | common_user | 172.16.0.232:48058 | common | Sleep | 446 | | NULL | 0 | 0 |
| 788892 | common_user | 172.16.0.237:27210 | common | Sleep | 7496 | | NULL | 0 | 0 |
| 788893 | chinasoft_api_user | 172.16.0.237:27224 | chinasoft_api | Sleep | 324 | | NULL | 0 | 0 |
| 788894 | chinasoft_admin_user | 172.16.0.237:27226 | chinasoft_admin | Sleep | 445 | | NULL | 0 | 0 |
| 788895 | chinasoft_admin_user | 172.16.0.237:27264 | chinasoft_admin | Sleep | 125 | | NULL | 0 | 0 |
| 788896 | chinasoft_api_user | 172.16.0.237:27266 | chinasoft_api | Sleep | 150 | | NULL | 0 | 0 |
| 788897 | chinasoft_daily_user | 172.16.0.237:27272 | chinasoft_daily | Sleep | 208 | | NULL | 0 | 0 |
| 788899 | common_user | 172.16.0.237:27310 | common | Sleep | 4279 | | NULL | 0 | 0 |
| 788900 | chinasoft_api_user | 172.16.0.237:27324 | chinasoft_api | Sleep | 673 | | NULL | 0 | 0 |
| 788901 | chinasoft_admin_user | 172.16.0.237:27326 | chinasoft_admin | Sleep | 794 | | NULL | 0 | 0 |
| 788903 | chinasoft_admin_user | 172.16.0.236:45472 | chinasoft_admin | Sleep | 1018 | | NULL | 0 | 0 |
| 788905 | common_user | 172.16.0.236:45524 | common | Sleep | 5226 | | NULL | 0 | 0 |
| 788910 | chinasoft_api_user | 172.16.0.237:27662 | chinasoft_api | Sleep | 30 | | NULL | 0 | 0 |
| 788914 | chinasoft_admin_user | 172.16.0.236:45980 | chinasoft_admin | Sleep | 95 | | NULL | 0 | 0 |
| 788915 | common_user | 172.16.0.237:28096 | common | Sleep | 1701 | | NULL | 0 | 0 |
| 788916 | common_user | 172.16.0.237:28108 | common | Sleep | 4097 | | NULL | 0 | 0 |
| 788917 | chinasoft_api_user | 172.16.0.232:48712 | chinasoft_api | Sleep | 5404 | | NULL | 0 | 0 |
| 788943 | root | 127.0.0.1:42478 | chinasoft_api | Sleep | 192 | | NULL | 17 | 122 |
| 788950 | common_user | 172.16.0.236:48310 | common | Sleep | 5970 | | NULL | 0 | 0 |
| 788956 | common_user | 172.16.0.236:48832 | common | Sleep | 5779 | | NULL | 0 | 0 |
| 788960 | chinasoft_admin_user | 172.16.0.236:48998 | chinasoft_admin | Sleep | 1900 | | NULL | 0 | 0 |
| 788961 | chinasoft_admin_user | 172.16.0.236:49004 | chinasoft_admin | Sleep | 5672 | | NULL | 0 | 0 |
| 788962 | chinasoft_api_user | 172.16.0.236:49008 | chinasoft_api | Sleep | 1900 | | NULL | 0 | 0 |
| 788964 | common_user | 172.16.0.236:49026 | common | Sleep | 5672 | | NULL | 0 | 0 |
| 788971 | chinasoft_api_user | 172.16.0.236:49636 | chinasoft_api | Sleep | 1900 | | NULL | 0 | 0 |
| 788972 | common_user | 172.16.0.236:49880 | common | Sleep | 5386 | | NULL | 0 | 0 |
| 788974 | chinasoft_api_user | 172.16.0.232:53370 | chinasoft_api | Sleep | 415 | | NULL | 0 | 0 |
| 788977 | chinasoft_admin_user | 172.16.0.236:50246 | chinasoft_admin | Sleep | 2566 | | NULL | 0 | 0 |
| 788978 | chinasoft_api_user | 172.16.0.236:50252 | chinasoft_api | Sleep | 2566 | | NULL | 0 | 0 |
| 788983 | common_user | 172.16.0.232:54006 | common | Sleep | 658 | | NULL | 0 | 0 |
| 788986 | chinasoft_api_user | 172.16.0.237:33778 | chinasoft_api | Sleep | 441 | | NULL | 0 | 0 |
| 788990 | common_user | 172.16.0.232:54944 | common | Sleep | 657 | | NULL | 0 | 0 |
| 789000 | chinasoft_api_user | 172.16.0.237:34730 | chinasoft_api | Sleep | 327 | | NULL | 0 | 0 |
| 789005 | chinasoft_api_user | 150.242.228.234:56623 | chinasoft_admin | Sleep | 4393 | | NULL | 0 | 0 |
| 789016 | chinasoft_api_user | 172.16.0.237:36184 | chinasoft_api | Sleep | 661 | | NULL | 0 | 0 |
| 789033 | chinasoft_admin_user | 172.16.0.232:59122 | chinasoft_admin | Sleep | 3154 | | NULL | 0 | 0 |
| 789048 | chinasoft_api_user | 150.242.228.234:61018 | chinasoft_api | Sleep | 388 | | NULL | 3 | 421 |
| 789052 | chinasoft_api_user | 150.242.228.234:57974 | NULL | Sleep | 401 | | NULL | 5 | 5 |
| 789054 | chinasoft_api_user | 150.242.228.234:57981 | chinasoft_api | Sleep | 399 | | NULL | 0 | 0 |
| 789057 | chinasoft_daily_user | 150.242.228.234:38470 | chinasoft_api | Sleep | 1718 | | NULL | 143 | 143 |
| 789059 | chinasoft_api_user | 150.242.228.234:58021 | chinasoft_api | Sleep | 2262 | | NULL | 6 | 6 |
| 789060 | chinasoft_api_user | 150.242.228.234:58023 | chinasoft_api | Sleep | 2254 | | NULL | 0 | 0 |
| 789069 | chinasoft_admin_user | 172.16.0.232:61764 | chinasoft_admin | Sleep | 1993 | | NULL | 0 | 0 |
| 789071 | chinasoft_api_user | 172.16.0.236:57096 | chinasoft_api | Sleep | 1897 | | NULL | 0 | 0 |
| 789072 | chinasoft_admin_user | 172.16.0.237:40788 | chinasoft_admin | Sleep | 441 | | NULL | 0 | 0 |
| 789073 | chinasoft_admin_user | 172.16.0.237:40792 | chinasoft_admin | Sleep | 448 | | NULL | 0 | 0 |
| 789074 | chinasoft_admin_user | 172.16.0.237:40794 | chinasoft_admin | Sleep | 661 | | NULL | 0 | 0 |
| 789075 | chinasoft_api_user | 172.16.0.232:62008 | chinasoft_api | Sleep | 679 | | NULL | 0 | 0 |
| 789077 | chinasoft_api_user | 172.16.0.232:62066 | chinasoft_api | Sleep | 655 | | NULL | 0 | 0 |
| 789078 | chinasoft_admin_user | 172.16.0.232:62068 | chinasoft_admin | Sleep | 656 | | NULL | 0 | 0 |
| 789082 | chinasoft_api_user | 150.242.228.234:64519 | chinasoft_api | Sleep | 388 | | NULL | 40 | 40 |
| 789088 | common_user | 172.16.0.232:62894 | common | Sleep | 1580 | | NULL | 0 | 0 |
| 789089 | root | localhost | chinasoft_api | Sleep | 975 | | NULL | 10 | 10 |
| 789092 | chinasoft_api_user | 150.242.228.234:63247 | chinasoft_api | Sleep | 1513 | | NULL | 0 | 0 |
| 789093 | chinasoft_api_user | 150.242.228.234:64581 | chinasoft_api | Sleep | 1513 | | NULL | 0 | 0 |
| 789094 | chinasoft_api_user | 150.242.228.234:61758 | chinasoft_api | Sleep | 1513 | | NULL | 0 | 0 |
| 789095 | chinasoft_api_user | 150.242.228.234:63755 | chinasoft_api | Sleep | 1513 | | NULL | 0 | 0 |
| 789096 | chinasoft_api_user | 150.242.228.234:64370 | chinasoft_api | Sleep | 1514 | | NULL | 0 | 0 |
| 789097 | chinasoft_api_user | 150.242.228.234:64564 | chinasoft_api | Sleep | 1514 | | NULL | 0 | 0 |
| 789098 | chinasoft_api_user | 150.242.228.234:62766 | chinasoft_api | Sleep | 1514 | | NULL | 0 | 0 |
| 789099 | chinasoft_api_user | 150.242.228.234:63075 | chinasoft_api | Sleep | 1513 | | NULL | 0 | 0 |
| 789100 | chinasoft_api_user | 150.242.228.234:63134 | chinasoft_api | Sleep | 1514 | | NULL | 0 | 0 |
| 789101 | chinasoft_api_user | 150.242.228.234:61175 | chinasoft_api | Sleep | 1513 | | NULL | 0 | 0 |
| 789102 | chinasoft_api_user | 150.242.228.234:61250 | chinasoft_api | Sleep | 1513 | | NULL | 0 | 0 |
| 789103 | chinasoft_api_user | 150.242.228.234:63136 | chinasoft_api | Sleep | 1513 | | NULL | 0 | 0 |
| 789104 | chinasoft_api_user | 150.242.228.234:62228 | chinasoft_api | Sleep | 1513 | | NULL | 0 | 0 |
| 789106 | common_user | 172.16.0.232:63182 | common | Sleep | 1463 | | NULL | 0 | 0 |
| 789107 | chinasoft_api_user | 172.16.0.236:58004 | chinasoft_api | Sleep | 1452 | | NULL | 0 | 0 |
| 789108 | chinasoft_api_user | 172.16.0.236:58018 | chinasoft_api | Sleep | 1446 | | NULL | 0 | 0 |
| 789109 | chinasoft_api_user | 172.16.0.236:58026 | chinasoft_api | Sleep | 1443 | | NULL | 0 | 0 |
| 789122 | chinasoft_api_user | 172.16.0.232:64156 | chinasoft_api | Sleep | 175 | | NULL | 0 | 0 |
| 789123 | chinasoft_api_user | 172.16.0.232:64158 | chinasoft_api | Sleep | 124 | | NULL | 0 | 0 |
| 789136 | chinasoft_admin_user | 172.16.0.232:64412 | chinasoft_admin | Sleep | 957 | | NULL | 0 | 0 |
| 789137 | chinasoft_admin_user | 172.16.0.232:64414 | chinasoft_admin | Sleep | 358 | | NULL | 0 | 0 |
| 789139 | root | 127.0.0.1:44248 | chinasoft_api | Sleep | 194 | | NULL | 17 | 17 |
| 789140 | root | 127.0.0.1:44252 | chinasoft_admin | Sleep | 938 | | NULL | 0 | 0 |
| 789143 | chinasoft_admin_user | 172.16.0.232:64676 | chinasoft_admin | Sleep | 801 | | NULL | 0 | 0 |
| 789149 | chinasoft_api_user | 172.16.0.236:59822 | chinasoft_api | Sleep | 631 | | NULL | 0 | 0 |
| 789151 | chinasoft_api_user | 172.16.0.236:59956 | chinasoft_api | Sleep | 569 | | NULL | 0 | 0 |
| 789158 | chinasoft_api_user | 172.16.0.236:60616 | chinasoft_api | Sleep | 215 | | NULL | 0 | 0 |
| 789159 | chinasoft_admin_user | 172.16.0.236:60618 | chinasoft_admin | Sleep | 240 | | NULL | 0 | 0 |
| 789165 | root | localhost | chinasoft_api | Query | 0 | starting | show full processlist | 0 | 0 |
+--------+------------------------+-----------------------+-------------------+------------------+---------+---------------------------------------------------------------+-----------------------+-----------+---------------+
441 rows in set (0.00 sec)
# 编写shell 杀掉这些sleep状态的进程
mysql -uroot -p -e 'show full processlist' 2>/dev/null | grep -i "sleep"|wc -l
for id in `mysqladmin -uroot -p"pass" processlist|grep -i "sleep"|awk '{print $1}'`
do
mysqladmin -uroot -p"pass" kill ${id}
done
# 再次执行下面的写锁，然后修改类型操作，发现1秒就完成了
lock table send_invites write;
alter table send_invites change body body LONGTEXT COMMENT '# 内容';
unlock tables