Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- After restarting opensips total 58 connections
- MariaDB [(none)]> show processlist;
- +-------+-------------+-----------+--------+---------+--------+-----------------------------------------------------------------------------+------------------+----------+
- | Id | User | Host | db | Command | Time | State | Info | Progress |
- +-------+-------------+-----------+--------+---------+--------+-----------------------------------------------------------------------------+------------------+----------+
- | 2 | system user | | NULL | Connect | 497596 | Waiting for master to send event | NULL | 0.000 |
- | 1 | system user | | NULL | Connect | 42 | Slave has read all relay log; waiting for the slave I/O thread to update it | NULL | 0.000 |
- | 24916 | root | localhost | NULL | Query | 0 | NULL | show processlist | 0.000 |
- | 24933 | avpops | localhost | VCASWT | Sleep | 4 | | NULL | 0.000 |
- | 24934 | permissions | localhost | VCASWT | Sleep | 4 | | NULL | 0.000 |
- | 24935 | dispatcher | localhost | VCASWT | Sleep | 4 | | NULL | 0.000 |
- | 24936 | avpops | localhost | VCASWT | Sleep | 4 | | NULL | 0.000 |
- | 24937 | avpops | localhost | VCASWT | Sleep | 4 | | NULL | 0.000 |
- | 24938 | dispatcher | localhost | VCASWT | Sleep | 4 | | NULL | 0.000 |
- | 24939 | dispatcher | localhost | VCASWT | Sleep | 4 | | NULL | 0.000 |
- | 24940 | avpops | localhost | VCASWT | Sleep | 4 | | NULL | 0.000 |
- | 24941 | dispatcher | localhost | VCASWT | Sleep | 4 | | NULL | 0.000 |
- | 24942 | avpops | localhost | VCASWT | Sleep | 4 | | NULL | 0.000 |
- | 24943 | dispatcher | localhost | VCASWT | Sleep | 4 | | NULL | 0.000 |
- | 24944 | avpops | localhost | VCASWT | Sleep | 4 | | NULL | 0.000 |
- | 24945 | dispatcher | localhost | VCASWT | Sleep | 4 | | NULL | 0.000 |
- | 24946 | avpops | localhost | VCASWT | Sleep | 4 | | NULL | 0.000 |
- | 24947 | dispatcher | localhost | VCASWT | Sleep | 4 | | NULL | 0.000 |
- | 24948 | avpops | localhost | VCASWT | Sleep | 4 | | NULL | 0.000 |
- | 24949 | dispatcher | localhost | VCASWT | Sleep | 4 | | NULL | 0.000 |
- | 24950 | avpops | localhost | VCASWT | Sleep | 4 | | NULL | 0.000 |
- | 24951 | dispatcher | localhost | VCASWT | Sleep | 4 | | NULL | 0.000 |
- | 24952 | avpops | localhost | VCASWT | Sleep | 4 | | NULL | 0.000 |
- | 24953 | dispatcher | localhost | VCASWT | Sleep | 4 | | NULL | 0.000 |
- | 24954 | avpops | localhost | VCASWT | Sleep | 4 | | NULL | 0.000 |
- | 24955 | dispatcher | localhost | VCASWT | Sleep | 4 | | NULL | 0.000 |
- | 24956 | avpops | localhost | VCASWT | Sleep | 4 | | NULL | 0.000 |
- | 24957 | dispatcher | localhost | VCASWT | Sleep | 4 | | NULL | 0.000 |
- | 24958 | avpops | localhost | VCASWT | Sleep | 4 | | NULL | 0.000 |
- | 24959 | dispatcher | localhost | VCASWT | Sleep | 4 | | NULL | 0.000 |
- | 24960 | avpops | localhost | VCASWT | Sleep | 4 | | NULL | 0.000 |
- | 24961 | dispatcher | localhost | VCASWT | Sleep | 4 | | NULL | 0.000 |
- | 24962 | avpops | localhost | VCASWT | Sleep | 4 | | NULL | 0.000 |
- | 24963 | dispatcher | localhost | VCASWT | Sleep | 4 | | NULL | 0.000 |
- | 24964 | avpops | localhost | VCASWT | Sleep | 4 | | NULL | 0.000 |
- | 24965 | dispatcher | localhost | VCASWT | Sleep | 4 | | NULL | 0.000 |
- | 24966 | avpops | localhost | VCASWT | Sleep | 4 | | NULL | 0.000 |
- | 24967 | dispatcher | localhost | VCASWT | Sleep | 4 | | NULL | 0.000 |
- | 24968 | avpops | localhost | VCASWT | Sleep | 4 | | NULL | 0.000 |
- | 24969 | dispatcher | localhost | VCASWT | Sleep | 4 | | NULL | 0.000 |
- | 24970 | avpops | localhost | VCASWT | Sleep | 4 | | NULL | 0.000 |
- | 24971 | dispatcher | localhost | VCASWT | Sleep | 4 | | NULL | 0.000 |
- | 24972 | avpops | localhost | VCASWT | Sleep | 4 | | NULL | 0.000 |
- | 24973 | avpops | localhost | VCASWT | Sleep | 4 | | NULL | 0.000 |
- | 24974 | dispatcher | localhost | VCASWT | Sleep | 4 | | NULL | 0.000 |
- | 24975 | dispatcher | localhost | VCASWT | Sleep | 4 | | NULL | 0.000 |
- | 24976 | avpops | localhost | VCASWT | Sleep | 4 | | NULL | 0.000 |
- | 24977 | dispatcher | localhost | VCASWT | Sleep | 4 | | NULL | 0.000 |
- | 24978 | avpops | localhost | VCASWT | Sleep | 4 | | NULL | 0.000 |
- | 24979 | dispatcher | localhost | VCASWT | Sleep | 4 | | NULL | 0.000 |
- | 24980 | avpops | localhost | VCASWT | Sleep | 4 | | NULL | 0.000 |
- | 24981 | dispatcher | localhost | VCASWT | Sleep | 4 | | NULL | 0.000 |
- | 24982 | avpops | localhost | VCASWT | Sleep | 4 | | NULL | 0.000 |
- | 24983 | dispatcher | localhost | VCASWT | Sleep | 4 | | NULL | 0.000 |
- | 24984 | avpops | localhost | VCASWT | Sleep | 4 | | NULL | 0.000 |
- | 24985 | dispatcher | localhost | VCASWT | Sleep | 4 | | NULL | 0.000 |
- | 24986 | dispatcher | localhost | VCASWT | Sleep | 4 | | NULL | 0.000 |
- | 24987 | rtpproxy | localhost | VCASWT | Sleep | 4 | | NULL | 0.000 |
- +-------+-------------+-----------+--------+---------+--------+-----------------------------------------------------------------------------+------------------+----------+
- 58 rows in set (0.00 sec)
- After calling connections increases and never reduces(1000 calls 100 cps)
- MariaDB [(none)]> show processlist;
- +-------+-------------+-----------+--------+---------+--------+-----------------------------------------------------------------------------+------------------+----------+
- | Id | User | Host | db | Command | Time | State | Info | Progress |
- +-------+-------------+-----------+--------+---------+--------+-----------------------------------------------------------------------------+------------------+----------+
- | 2 | system user | | NULL | Connect | 500754 | Waiting for master to send event | NULL | 0.000 |
- | 1 | system user | | NULL | Connect | 6 | Slave has read all relay log; waiting for the slave I/O thread to update it | NULL | 0.000 |
- | 24916 | root | localhost | NULL | Query | 0 | NULL | show processlist | 0.000 |
- | 25150 | avpops | localhost | VCASWT | Sleep | 666 | | NULL | 0.000 |
- | 25151 | permissions | localhost | VCASWT | Sleep | 666 | | NULL | 0.000 |
- | 25152 | avpops | localhost | VCASWT | Sleep | 294 | | NULL | 0.000 |
- | 25153 | dispatcher | localhost | VCASWT | Sleep | 666 | | NULL | 0.000 |
- | 25154 | avpops | localhost | VCASWT | Sleep | 294 | | NULL | 0.000 |
- | 25155 | avpops | localhost | VCASWT | Sleep | 292 | | NULL | 0.000 |
- | 25156 | dispatcher | localhost | VCASWT | Sleep | 666 | | NULL | 0.000 |
- | 25157 | dispatcher | localhost | VCASWT | Sleep | 666 | | NULL | 0.000 |
- | 25158 | avpops | localhost | VCASWT | Sleep | 294 | | NULL | 0.000 |
- | 25159 | dispatcher | localhost | VCASWT | Sleep | 666 | | NULL | 0.000 |
- | 25160 | dispatcher | localhost | VCASWT | Sleep | 666 | | NULL | 0.000 |
- | 25161 | avpops | localhost | VCASWT | Sleep | 295 | | NULL | 0.000 |
- | 25162 | dispatcher | localhost | VCASWT | Sleep | 666 | | NULL | 0.000 |
- | 25163 | avpops | localhost | VCASWT | Sleep | 293 | | NULL | 0.000 |
- | 25164 | avpops | localhost | VCASWT | Sleep | 294 | | NULL | 0.000 |
- | 25165 | dispatcher | localhost | VCASWT | Sleep | 666 | | NULL | 0.000 |
- | 25166 | avpops | localhost | VCASWT | Sleep | 294 | | NULL | 0.000 |
- | 25167 | dispatcher | localhost | VCASWT | Sleep | 666 | | NULL | 0.000 |
- | 25168 | dispatcher | localhost | VCASWT | Sleep | 666 | | NULL | 0.000 |
- | 25169 | avpops | localhost | VCASWT | Sleep | 294 | | NULL | 0.000 |
- | 25170 | dispatcher | localhost | VCASWT | Sleep | 666 | | NULL | 0.000 |
- | 25171 | avpops | localhost | VCASWT | Sleep | 294 | | NULL | 0.000 |
- | 25172 | dispatcher | localhost | VCASWT | Sleep | 666 | | NULL | 0.000 |
- | 25173 | avpops | localhost | VCASWT | Sleep | 293 | | NULL | 0.000 |
- | 25174 | dispatcher | localhost | VCASWT | Sleep | 666 | | NULL | 0.000 |
- | 25175 | avpops | localhost | VCASWT | Sleep | 293 | | NULL | 0.000 |
- | 25176 | dispatcher | localhost | VCASWT | Sleep | 666 | | NULL | 0.000 |
- | 25177 | avpops | localhost | VCASWT | Sleep | 293 | | NULL | 0.000 |
- | 25178 | dispatcher | localhost | VCASWT | Sleep | 666 | | NULL | 0.000 |
- | 25179 | avpops | localhost | VCASWT | Sleep | 292 | | NULL | 0.000 |
- | 25180 | dispatcher | localhost | VCASWT | Sleep | 666 | | NULL | 0.000 |
- | 25181 | avpops | localhost | VCASWT | Sleep | 292 | | NULL | 0.000 |
- | 25182 | dispatcher | localhost | VCASWT | Sleep | 666 | | NULL | 0.000 |
- | 25183 | avpops | localhost | VCASWT | Sleep | 292 | | NULL | 0.000 |
- | 25184 | dispatcher | localhost | VCASWT | Sleep | 666 | | NULL | 0.000 |
- | 25185 | avpops | localhost | VCASWT | Sleep | 666 | | NULL | 0.000 |
- | 25186 | dispatcher | localhost | VCASWT | Sleep | 666 | | NULL | 0.000 |
- | 25187 | avpops | localhost | VCASWT | Sleep | 666 | | NULL | 0.000 |
- | 25188 | dispatcher | localhost | VCASWT | Sleep | 666 | | NULL | 0.000 |
- | 25189 | avpops | localhost | VCASWT | Sleep | 666 | | NULL | 0.000 |
- | 25190 | dispatcher | localhost | VCASWT | Sleep | 666 | | NULL | 0.000 |
- | 25191 | avpops | localhost | VCASWT | Sleep | 666 | | NULL | 0.000 |
- | 25192 | dispatcher | localhost | VCASWT | Sleep | 666 | | NULL | 0.000 |
- | 25193 | avpops | localhost | VCASWT | Sleep | 666 | | NULL | 0.000 |
- | 25194 | dispatcher | localhost | VCASWT | Sleep | 666 | | NULL | 0.000 |
- | 25195 | avpops | localhost | VCASWT | Sleep | 666 | | NULL | 0.000 |
- | 25196 | dispatcher | localhost | VCASWT | Sleep | 666 | | NULL | 0.000 |
- | 25197 | avpops | localhost | VCASWT | Sleep | 666 | | NULL | 0.000 |
- | 25198 | dispatcher | localhost | VCASWT | Sleep | 666 | | NULL | 0.000 |
- | 25199 | avpops | localhost | VCASWT | Sleep | 666 | | NULL | 0.000 |
- | 25200 | dispatcher | localhost | VCASWT | Sleep | 666 | | NULL | 0.000 |
- | 25201 | avpops | localhost | VCASWT | Sleep | 666 | | NULL | 0.000 |
- | 25202 | dispatcher | localhost | VCASWT | Sleep | 666 | | NULL | 0.000 |
- | 25203 | dispatcher | localhost | VCASWT | Sleep | 666 | | NULL | 0.000 |
- | 25204 | rtpproxy | localhost | VCASWT | Sleep | 666 | | NULL | 0.000 |
- | 25205 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25206 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25207 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25208 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25209 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25210 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25211 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25212 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25213 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25214 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25215 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25216 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25217 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25218 | avpops | localhost | VCASWT | Sleep | 302 | | NULL | 0.000 |
- | 25219 | avpops | localhost | VCASWT | Sleep | 302 | | NULL | 0.000 |
- | 25220 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25222 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25223 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25224 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25225 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25226 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25227 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25228 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25229 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25230 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25231 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25232 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25233 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25235 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25236 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25237 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25238 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25239 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25240 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25241 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25242 | avpops | localhost | VCASWT | Sleep | 304 | | NULL | 0.000 |
- | 25243 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25244 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25245 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25246 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25247 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25248 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25249 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25250 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25251 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25252 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25253 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25254 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25255 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25256 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25257 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25258 | avpops | localhost | VCASWT | Sleep | 304 | | NULL | 0.000 |
- | 25259 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25260 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25261 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25262 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25263 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25264 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25265 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25266 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25267 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25268 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25269 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25270 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25271 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25272 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25273 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25274 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25275 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25276 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25277 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25278 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25279 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25280 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25281 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25282 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25283 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25284 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25285 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25286 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25287 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25288 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25289 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25290 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25292 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25293 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25294 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25295 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25296 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25297 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25298 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25299 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25300 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25301 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25302 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25303 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25304 | avpops | localhost | VCASWT | Sleep | 302 | | NULL | 0.000 |
- | 25305 | avpops | localhost | VCASWT | Sleep | 302 | | NULL | 0.000 |
- | 25306 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- | 25307 | avpops | localhost | VCASWT | Sleep | 302 | | NULL | 0.000 |
- | 25308 | avpops | localhost | VCASWT | Sleep | 302 | | NULL | 0.000 |
- | 25309 | avpops | localhost | VCASWT | Sleep | 302 | | NULL | 0.000 |
- | 25310 | avpops | localhost | VCASWT | Sleep | 302 | | NULL | 0.000 |
- | 25311 | avpops | localhost | VCASWT | Sleep | 302 | | NULL | 0.000 |
- | 25312 | avpops | localhost | VCASWT | Sleep | 302 | | NULL | 0.000 |
- | 25313 | avpops | localhost | VCASWT | Sleep | 302 | | NULL | 0.000 |
- | 25314 | avpops | localhost | VCASWT | Sleep | 302 | | NULL | 0.000 |
- | 25315 | avpops | localhost | VCASWT | Sleep | 302 | | NULL | 0.000 |
- | 25316 | avpops | localhost | VCASWT | Sleep | 302 | | NULL | 0.000 |
- | 25317 | avpops | localhost | VCASWT | Sleep | 302 | | NULL | 0.000 |
- | 25318 | avpops | localhost | VCASWT | Sleep | 302 | | NULL | 0.000 |
- | 25319 | avpops | localhost | VCASWT | Sleep | 476 | | NULL | 0.000 |
- +-------+-------------+-----------+--------+---------+--------+-----------------------------------------------------------------------------+------------------+----------+
- 170 rows in set (0.00 sec)
Add Comment
Please, Sign In to add comment