MariaDB [kamailio01]> show full processlist; +------+-------------+-------------------+-------------+--------------+--------+-----------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +------+-------------+-------------------+-------------+--------------+--------+-----------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+ | 1 | system user | | NULL | Daemon | NULL | InnoDB purge coordinator | NULL | 0.000 | | 3 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 | | 4 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 | | 2 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 | | 5 | system user | | NULL | Daemon | NULL | InnoDB shutdown handler | NULL | 0.000 | | 10 | system user | | NULL | Slave_IO | 181147 | Waiting for master to send event | NULL | 0.000 | | 13 | system user | | NULL | Slave_worker | 5 | Waiting for work from SQL thread | NULL | 0.000 | | 14 | system user | | NULL | Slave_worker | 5 | Waiting for work from SQL thread | NULL | 0.000 | | 12 | system user | | NULL | Slave_worker | 5 | Waiting for work from SQL thread | NULL | 0.000 | | 15 | system user | | NULL | Slave_worker | 2 | Waiting for work from SQL thread | NULL | 0.000 | | 16 | system user | | NULL | Slave_worker | 2 | Waiting for work from SQL thread | NULL | 0.000 | | 17 | system user | | NULL | Slave_worker | 5 | Waiting for work from SQL thread | NULL | 0.000 | | 19 | system user | | NULL | Slave_worker | 5 | Waiting for work from SQL thread | NULL | 0.000 | | 18 | system user | | NULL | Slave_worker | 2 | Waiting for work from SQL thread | NULL | 0.000 | | 11 | system user | | NULL | Slave_SQL | 435 | Slave has read all relay log; waiting for the slave I/O thread to update it | NULL | 0.000 | | 334 | replication | 10.10.0.4:37846 | NULL | Binlog Dump | 180250 | Master has sent all binlog to slave; waiting for binlog to be updated | NULL | 0.000 | | 4025 | voipmonitor | 41.79.80.5:58632 | voipmonitor | Sleep | 3 | | NULL | 0.000 | | 4026 | voipmonitor | 41.79.80.5:58634 | voipmonitor | Sleep | 12738 | | NULL | 0.000 | | 4984 | voipmonitor | 41.79.80.22:38936 | voipmonitor | Sleep | 17 | | NULL | 0.000 | | 4987 | root | localhost | kamailio01 | Query | 0 | Init | show full processlist | 0.000 | | 4993 | kamailio | 41.79.80.5:59098 | kamailio01 | Sleep | 3 | | NULL | 0.000 | | 4994 | kamailio | 41.79.80.5:59100 | kamailio01 | Sleep | 1 | | NULL | 0.000 | | 4995 | kamailio | 41.79.80.5:59102 | kamailio01 | Sleep | 3 | | NULL | 0.000 | | 4997 | kamailio | 41.79.80.5:59106 | kamailio01 | Sleep | 7 | | NULL | 0.000 | | 4998 | kamailio | 41.79.80.5:59108 | kamailio01 | Sleep | 1 | | NULL | 0.000 | | 4999 | kamailio | 41.79.80.5:59110 | kamailio01 | Sleep | 4 | | NULL | 0.000 | | 5000 | kamailio | 41.79.80.5:59114 | kamailio01 | Sleep | 1 | | NULL | 0.000 | | 5001 | kamailio | 41.79.80.5:59116 | kamailio01 | Sleep | 3 | | NULL | 0.000 | | 4996 | kamailio | 41.79.80.5:59104 | kamailio01 | Sleep | 3 | | NULL | 0.000 | | 5002 | kamailio | 41.79.80.5:59112 | kamailio01 | Sleep | 1 | | NULL | 0.000 | | 5003 | kamailio | 41.79.80.5:59118 | kamailio01 | Sleep | 1 | | NULL | 0.000 | | 5004 | kamailio | 41.79.80.5:59120 | kamailio01 | Sleep | 4 | | NULL | 0.000 | | 5005 | kamailio | 41.79.80.5:59122 | kamailio01 | Sleep | 5 | | NULL | 0.000 | | 5006 | kamailio | 41.79.80.5:59124 | kamailio01 | Sleep | 1 | | NULL | 0.000 | | 5007 | kamailio | 41.79.80.5:59126 | kamailio01 | Sleep | 4 | | NULL | 0.000 | | 5008 | kamailio | 41.79.80.5:59128 | kamailio01 | Sleep | 7 | | NULL | 0.000 | | 5009 | kamailio | 41.79.80.5:59130 | kamailio01 | Sleep | 1 | | NULL | 0.000 | | 5010 | kamailio | 41.79.80.5:59132 | kamailio01 | Sleep | 1 | | NULL | 0.000 | | 5011 | kamailio | 41.79.80.5:59134 | kamailio01 | Sleep | 1 | | NULL | 0.000 | | 5012 | kamailio | 41.79.80.5:59136 | kamailio01 | Sleep | 1 | | NULL | 0.000 | | 5013 | kamailio | 41.79.80.5:59138 | kamailio01 | Sleep | 1 | | NULL | 0.000 | | 5014 | kamailio | 41.79.80.5:59140 | kamailio01 | Sleep | 1 | | NULL | 0.000 | | 5015 | kamailio | 41.79.80.5:59142 | kamailio01 | Sleep | 1 | | NULL | 0.000 | | 5016 | kamailio | 41.79.80.5:59144 | kamailio01 | Sleep | 1 | | NULL | 0.000 | | 5017 | kamailio | 41.79.80.5:59146 | kamailio01 | Sleep | 1 | | NULL | 0.000 | | 5018 | kamailio | 41.79.80.5:59148 | kamailio01 | Sleep | 1 | | NULL | 0.000 | | 5019 | kamailio | 41.79.80.5:59150 | kamailio01 | Sleep | 1 | | NULL | 0.000 | | 5020 | kamailio | 41.79.80.5:59152 | kamailio01 | Sleep | 1 | | NULL | 0.000 | | 5021 | kamailio | 41.79.80.5:59154 | kamailio01 | Sleep | 1 | | NULL | 0.000 | | 5022 | kamailio | 41.79.80.5:59156 | kamailio01 | Sleep | 1 | | NULL | 0.000 | | 5023 | kamailio | 41.79.80.5:59158 | kamailio01 | Sleep | 1 | | NULL | 0.000 | | 5024 | kamailio | 41.79.80.5:59160 | kamailio01 | Sleep | 1 | | NULL | 0.000 | | 5025 | kamailio | 41.79.80.5:59162 | kamailio01 | Sleep | 7 | | NULL | 0.000 | | 5026 | kamailio | 41.79.80.5:59164 | kamailio01 | Sleep | 7 | | NULL | 0.000 | | 5027 | kamailio | 41.79.80.5:59166 | kamailio01 | Sleep | 7 | | NULL | 0.000 | | 5028 | kamailio | 41.79.80.5:59168 | kamailio01 | Sleep | 7 | | NULL | 0.000 | | 5029 | kamailio | 41.79.80.5:59170 | kamailio01 | Sleep | 7 | | NULL | 0.000 | | 5030 | kamailio | 41.79.80.5:59172 | kamailio01 | Sleep | 7 | | NULL | 0.000 | | 5031 | kamailio | 41.79.80.5:59174 | kamailio01 | Sleep | 7 | | NULL | 0.000 | | 5032 | kamailio | 41.79.80.5:59176 | kamailio01 | Sleep | 7 | | NULL | 0.000 | | 5033 | kamailio | 41.79.80.5:59178 | kamailio01 | Sleep | 7 | | NULL | 0.000 | | 5034 | kamailio | 41.79.80.5:59180 | kamailio01 | Sleep | 7 | | NULL | 0.000 | | 5035 | kamailio | 41.79.80.5:59182 | kamailio01 | Sleep | 7 | | NULL | 0.000 | | 5036 | kamailio | 41.79.80.5:59184 | kamailio01 | Sleep | 7 | | NULL | 0.000 | | 5037 | kamailio | 41.79.80.5:59186 | kamailio01 | Sleep | 7 | | NULL | 0.000 | | 5038 | kamailio | 41.79.80.5:59188 | kamailio01 | Sleep | 7 | | NULL | 0.000 | | 5039 | kamailio | 41.79.80.5:59190 | kamailio01 | Sleep | 7 | | NULL | 0.000 | | 5040 | kamailio | 41.79.80.5:59192 | kamailio01 | Sleep | 7 | | NULL | 0.000 | | 5041 | kamailio | 41.79.80.5:59194 | kamailio01 | Sleep | 7 | | NULL | 0.000 | | 5042 | kamailio | 41.79.80.5:59196 | kamailio01 | Sleep | 7 | | NULL | 0.000 | | 5043 | kamailio | 41.79.80.5:59200 | kamailio01 | Sleep | 7 | | NULL | 0.000 | | 5044 | kamailio | 41.79.80.5:59198 | kamailio01 | Sleep | 7 | | NULL | 0.000 | | 5045 | kamailio | 41.79.80.5:59202 | kamailio01 | Sleep | 7 | | NULL | 0.000 | | 5046 | kamailio | 41.79.80.5:59204 | kamailio01 | Sleep | 7 | | NULL | 0.000 | | 5047 | kamailio | 41.79.80.5:59206 | kamailio01 | Sleep | 7 | | NULL | 0.000 | | 5048 | kamailio | 41.79.80.5:59208 | kamailio01 | Sleep | 7 | | NULL | 0.000 | | 5049 | kamailio | 41.79.80.5:59210 | kamailio01 | Sleep | 7 | | NULL | 0.000 | | 5050 | kamailio | 41.79.80.5:59214 | kamailio01 | Sleep | 7 | | NULL | 0.000 | | 5051 | kamailio | 41.79.80.5:59212 | kamailio01 | Sleep | 7 | | NULL | 0.000 | | 5052 | kamailio | 41.79.80.5:59216 | kamailio01 | Sleep | 7 | | NULL | 0.000 | | 5053 | kamailio | 41.79.80.5:59218 | kamailio01 | Sleep | 7 | | NULL | 0.000 | | 5054 | kamailio | 41.79.80.5:59220 | kamailio01 | Sleep | 7 | | NULL | 0.000 | | 5055 | kamailio | 41.79.80.5:59222 | kamailio01 | Sleep | 7 | | NULL | 0.000 | | 5056 | kamailio | 41.79.80.5:59224 | kamailio01 | Sleep | 7 | | NULL | 0.000 | | 5057 | kamailio | 41.79.80.5:59226 | kamailio01 | Sleep | 7 | | NULL | 0.000 | | 5058 | kamailio | 41.79.80.5:59228 | kamailio01 | Sleep | 7 | | NULL | 0.000 | | 5059 | kamailio | 41.79.80.5:59230 | kamailio01 | Sleep | 7 | | NULL | 0.000 | | 5060 | root | localhost:59232 | kamailio01 | Query | 0 | Updating | DELETE FROM cdr_live WHERE call_id = NAME_CONST('p_call_id',_utf8mb4'7f2263a47022d98b31f9a98b5de99771@10.250.2.202:5060' COLLATE 'utf8mb4_general_ci') | 0.000 | | 5061 | root | localhost:59234 | kamailio01 | Query | 0 | Updating | DELETE FROM cdr_live WHERE call_id = NAME_CONST('p_call_id',_utf8mb4'471809ac2d0c5c5b39cd4ecd503f8360@10.250.2.231:5060' COLLATE 'utf8mb4_general_ci') | 0.000 | | 5062 | kamailio | 41.79.80.5:59236 | kamailio01 | Query | 0 | Update | INSERT INTO cdr_live (call_id, start, original_src, original_dst, final_src, final_dst, src_account, dst_account, routing_label, disposition, tag01, tag02, tag03, export_status) VALUES ('0b2210090aa51e6041b60c5053ad1415@10.250.2.202:5060', NOW(2), '', '27787560679', '+27871358599', '+27787560679', 'UBERMO16', 'MTN', 'D083', 'PENDING', '', '', '', 'L') | 0.000 | | 5063 | root | localhost:59238 | kamailio01 | Query | 0 | Sending data | INSERT INTO cdr_xfer SELECT * FROM cdr_live WHERE call_id = NAME_CONST('p_call_id',_utf8mb4'00ffba7c684481d252fc8a9a3c387637@41.79.80.133:5060' COLLATE 'utf8mb4_general_ci') | 0.000 | | 5064 | kamailio | 41.79.80.5:59240 | kamailio01 | Sleep | 7 | | NULL | 0.000 | | 5065 | kamailio | 41.79.80.5:59242 | kamailio01 | Sleep | 7 | | NULL | 0.000 | | 5066 | kamailio | 41.79.80.5:59244 | kamailio01 | Sleep | 7 | | NULL | 0.000 | | 5067 | kamailio | 41.79.80.5:59246 | kamailio01 | Sleep | 7 | | NULL | 0.000 | +------+-------------+-------------------+-------------+--------------+--------+-----------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+ 95 rows in set (0.000 sec)