Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-1925

The number of client connections through maxscale are spread to all nodes in the group

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Incomplete
    • Affects Version/s: 2.2.9
    • Fix Version/s: N/A
    • Component/s: galeramon
    • Labels:
      None
    • Environment:
      CentOS 7.4; 1 MaxScale Node; 3 Master-Master Galera Nodes

      Description

      The number of client connections through maxctrl are spread to all nodes in the group

      that is exhausting the mysql connection limit N times faster , where N is the Number of the
      Servers in the Cluster

      how to repeat
      1 .establish one mysql connection through max scale to galera cluster
      2. check the maxctrl connection counters – the counters of all Nodes in the cluster increased with 1 .
      3. start to open mysql connections . it's received Error 1040, Msg : Too many connections,
      before the mysql connection limit is being reached.

      [root@t4w1 ~]#  maxctrl  list servers
      ┌─────────┬─────────────────┬──────┬─────────────┬─────────────────────────┬──────┐
      │ Server  │ Address         │ Port │ Connections │ State                   │ GTID │
      ├─────────┼─────────────────┼──────┼─────────────┼─────────────────────────┼──────┤
      │ server1 │ 192.168.104.193 │ 3306 │ 0           │ Slave, Synced, Running  │      │
      ├─────────┼─────────────────┼──────┼─────────────┼─────────────────────────┼──────┤
      │ server2 │ 192.168.104.195 │ 3306 │ 0           │ Slave, Synced, Running  │      │
      ├─────────┼─────────────────┼──────┼─────────────┼─────────────────────────┼──────┤
      │ server3 │ 192.168.104.196 │ 3306 │ 0           │ Master, Synced, Running │      │
      ├─────────┼─────────────────┼──────┼─────────────┼─────────────────────────┼──────┤
      │ server4 │ 172.20.2.208    │ 3306 │ 1           │ Running                 │      │
      ├─────────┼─────────────────┼──────┼─────────────┼─────────────────────────┼──────┤
      │ server5 │ 172.20.2.206    │ 3306 │ 0           │ Running                 │      │
      └─────────┴─────────────────┴──────┴─────────────┴─────────────────────────┴──────┘
      
      

      establish one connection through max scale to the cluster

      ~$ mysql -h t4w1 -P 3307 -u root -p1
      Warning: Using a password on the command line interface can be insecure.
      Welcome to the MySQL monitor.  Commands end with ; or \g.
      Your MySQL connection id is 5
      Server version: 5.5.5-10.2.12 2.2.9-maxscale MariaDB Server
       
      Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
       
      Oracle is a registered trademark of Oracle Corporation and/or its
      affiliates. Other names may be trademarks of their respective
      owners.
       
      Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
       
      mysql> show variables like '%hostname%' ;
      +---------------+-----------------+
      | Variable_name | Value           |
      +---------------+-----------------+
      | hostname      | t4w3.xentio.lan |
      +---------------+-----------------+
      1 row in set (0.00 sec)
       
      
      

      [root@t4w1 ~]#  maxctrl  list servers
      ┌─────────┬─────────────────┬──────┬─────────────┬─────────────────────────┬──────┐
      │ Server  │ Address         │ Port │ Connections │ State                   │ GTID │
      ├─────────┼─────────────────┼──────┼─────────────┼─────────────────────────┼──────┤
      │ server1 │ 192.168.104.193 │ 3306 │ 1           │ Slave, Synced, Running  │      │
      ├─────────┼─────────────────┼──────┼─────────────┼─────────────────────────┼──────┤
      │ server2 │ 192.168.104.195 │ 3306 │ 1           │ Slave, Synced, Running  │      │
      ├─────────┼─────────────────┼──────┼─────────────┼─────────────────────────┼──────┤
      │ server3 │ 192.168.104.196 │ 3306 │ 1           │ Master, Synced, Running │      │
      ├─────────┼─────────────────┼──────┼─────────────┼─────────────────────────┼──────┤
      │ server4 │ 172.20.2.208    │ 3306 │ 1           │ Running                 │      │
      ├─────────┼─────────────────┼──────┼─────────────┼─────────────────────────┼──────┤
      │ server5 │ 172.20.2.206    │ 3306 │ 0           │ Running                 │      │
      └─────────┴─────────────────┴──────┴─────────────┴────────
      

      the Error received on the Client
      [149] ERROR 2013 (HY000) at line 1: Lost connection to MySQL server during query

      the Errors on maxscale
      2018-06-15 17:19:23 error : (2724) [mariadbbackend] Invalid authentication message from backend 'server1'. Error code: 1040, Msg : Too many connections
      2018-06-15 17:19:23 error : [mariadbbackend] Unable to write to backend 'server1' due to authentication failure. Server in state RUNNING SLAVE.

      [root@t4w1 ~]#  maxctrl  list servers
      ┌─────────┬─────────────────┬──────┬─────────────┬─────────────────────────┬──────┐
      │ Server  │ Address         │ Port │ Connections │ State                   │ GTID │
      ├─────────┼─────────────────┼──────┼─────────────┼─────────────────────────┼──────┤
      │ server1 │ 192.168.104.193 │ 3306 │ 149         │ Slave, Synced, Running  │      │
      ├─────────┼─────────────────┼──────┼─────────────┼─────────────────────────┼──────┤
      │ server2 │ 192.168.104.195 │ 3306 │ 148         │ Master, Synced, Running │      │
      ├─────────┼─────────────────┼──────┼─────────────┼─────────────────────────┼──────┤
      │ server3 │ 192.168.104.196 │ 3306 │ 149         │ Slave, Synced, Running  │      │
      ├─────────┼─────────────────┼──────┼─────────────┼─────────────────────────┼──────┤
      │ server4 │ 172.20.2.208    │ 3306 │ 1           │ Running                 │      │
      ├─────────┼─────────────────┼──────┼─────────────┼─────────────────────────┼──────┤
      │ server5 │ 172.20.2.206    │ 3306 │ 0           │ Running                 │      │
      └─────────┴─────────────────┴──────┴─────────────┴─────────────────────────┴──────┘
      
      

      server 3

      MariaDB [(none)]> show processlist ;
      +-----+-------------+-----------------------+------+---------+------+--------------------------+--------------------+----------+
      | Id  | User        | Host                  | db   | Command | Time | State                    | Info               | Progress |
      +-----+-------------+-----------------------+------+---------+------+--------------------------+--------------------+----------+
      |   1 | system user |                       | NULL | Daemon  | NULL | InnoDB purge worker      | NULL               |    0.000 |
      |   2 | system user |                       | NULL | Daemon  | NULL | InnoDB purge worker      | NULL               |    0.000 |
      |   3 | system user |                       | NULL | Daemon  | NULL | InnoDB purge coordinator | NULL               |    0.000 |
      |   4 | system user |                       | NULL | Daemon  | NULL | InnoDB purge worker      | NULL               |    0.000 |
      |   5 | system user |                       | NULL | Daemon  | NULL | InnoDB shutdown handler  | NULL               |    0.000 |
      |   6 | system user |                       | NULL | Sleep   | 3437 | NULL                     | NULL               |    0.000 |
      |   8 | system user |                       | NULL | Sleep   | 3437 | WSREP aborter idle       | NULL               |    0.000 |
      |  11 | root        | 192.168.104.191:51062 | NULL | Sleep   |    1 |                          | NULL               |    0.000 |
      |  12 | root        | 192.168.104.191:51128 | NULL | Sleep   | 3385 |                          | NULL               |    0.000 |
      | 162 | root        | 192.168.104.191:52148 | NULL | Sleep   |  812 |                          | NULL               |    0.000 |
      | 163 | root        | 192.168.104.191:52154 | NULL | Sleep   |  810 |                          | NULL               |    0.000 |
      | 164 | root        | 192.168.104.191:52160 | NULL | Sleep   |  808 |                          | NULL               |    0.000 |
      | 165 | root        | 192.168.104.191:52164 | NULL | Query   |  806 | User sleep               | select sleep(1000) |    0.000 |
      | 166 | root        | 192.168.104.191:52172 | NULL | Sleep   |  804 |                          | NULL               |    0.000 |
      | 167 | root        | 192.168.104.191:52178 | NULL | Sleep   |  802 |                          | NULL               |    0.000 |
      | 168 | root        | 192.168.104.191:52184 | NULL | Sleep   |  800 |                          | NULL               |    0.000 |
      | 169 | root        | 192.168.104.191:52188 | NULL | Query   |  798 | User sleep               | select sleep(1000) |    0.000 |
      | 170 | root        | 192.168.104.191:52196 | NULL | Sleep   |  796 |                          | NULL               |    0.000 |
      | 171 | root        | 192.168.104.191:52202 | NULL | Sleep   |  794 |                          | NULL               |    0.000 |
      | 172 | root        | 192.168.104.191:52208 | NULL | Sleep   |  792 |                          | NULL               |    0.000 |
      | 173 | root        | 192.168.104.191:52212 | NULL | Query   |  789 | User sleep               | select sleep(1000) |    0.000 |
      | 174 | root        | 192.168.104.191:52220 | NULL | Sleep   |  787 |                          | NULL               |    0.000 |
      | 175 | root        | 192.168.104.191:52226 | NULL | Sleep   |  785 |                          | NULL               |    0.000 |
      | 176 | root        | 192.168.104.191:52232 | NULL | Sleep   |  783 |                          | NULL               |    0.000 |
      | 177 | root        | 192.168.104.191:52236 | NULL | Query   |  781 | User sleep               | select sleep(1000) |    0.000 |
      | 178 | root        | 192.168.104.191:52244 | NULL | Sleep   |  779 |                          | NULL               |    0.000 |
      | 179 | root        | 192.168.104.191:52250 | NULL | Sleep   |  777 |                          | NULL               |    0.000 |
      | 180 | root        | 192.168.104.191:52256 | NULL | Sleep   |  775 |                          | NULL               |    0.000 |
      | 181 | root        | 192.168.104.191:52260 | NULL | Query   |  773 | User sleep               | select sleep(1000) |    0.000 |
      | 182 | root        | 192.168.104.191:52268 | NULL | Sleep   |  771 |                          | NULL               |    0.000 |
      | 183 | root        | 192.168.104.191:52274 | NULL | Sleep   |  769 |                          | NULL               |    0.000 |
      | 184 | root        | 192.168.104.191:52280 | NULL | Sleep   |  767 |                          | NULL               |    0.000 |
      | 185 | root        | 192.168.104.191:52284 | NULL | Query   |  765 | User sleep               | select sleep(1000) |    0.000 |
      | 186 | root        | 192.168.104.191:52292 | NULL | Sleep   |  763 |                          | NULL               |    0.000 |
      | 187 | root        | 192.168.104.191:52298 | NULL | Sleep   |  761 |                          | NULL               |    0.000 |
      | 188 | root        | 192.168.104.191:52304 | NULL | Sleep   |  759 |                          | NULL               |    0.000 |
      | 189 | root        | 192.168.104.191:52308 | NULL | Query   |  757 | User sleep               | select sleep(1000) |    0.000 |
      | 190 | root        | 192.168.104.191:52316 | NULL | Sleep   |  755 |                          | NULL               |    0.000 |
      | 191 | root        | 192.168.104.191:52322 | NULL | Sleep   |  753 |                          | NULL               |    0.000 |
      | 192 | root        | 192.168.104.191:52328 | NULL | Sleep   |  751 |                          | NULL               |    0.000 |
      | 193 | root        | 192.168.104.191:52332 | NULL | Query   |  749 | User sleep               | select sleep(1000) |    0.000 |
      | 194 | root        | 192.168.104.191:52340 | NULL | Sleep   |  747 |                          | NULL               |    0.000 |
      | 195 | root        | 192.168.104.191:52346 | NULL | Sleep   |  745 |                          | NULL               |    0.000 |
      | 196 | root        | 192.168.104.191:52352 | NULL | Sleep   |  743 |                          | NULL               |    0.000 |
      | 197 | root        | 192.168.104.191:52356 | NULL | Query   |  741 | User sleep               | select sleep(1000) |    0.000 |
      | 198 | root        | 192.168.104.191:52364 | NULL | Sleep   |  739 |                          | NULL               |    0.000 |
      | 199 | root        | 192.168.104.191:52370 | NULL | Sleep   |  737 |                          | NULL               |    0.000 |
      | 200 | root        | 192.168.104.191:52376 | NULL | Sleep   |  735 |                          | NULL               |    0.000 |
      | 201 | root        | 192.168.104.191:52380 | NULL | Query   |  733 | User sleep               | select sleep(1000) |    0.000 |
      | 202 | root        | 192.168.104.191:52388 | NULL | Sleep   |  731 |                          | NULL               |    0.000 |
      | 203 | root        | 192.168.104.191:52394 | NULL | Sleep   |  729 |                          | NULL               |    0.000 |
      | 204 | root        | 192.168.104.191:52400 | NULL | Sleep   |  727 |                          | NULL               |    0.000 |
      | 205 | root        | 192.168.104.191:52404 | NULL | Query   |  725 | User sleep               | select sleep(1000) |    0.000 |
      | 206 | root        | 192.168.104.191:52412 | NULL | Sleep   |  723 |                          | NULL               |    0.000 |
      | 207 | root        | 192.168.104.191:52418 | NULL | Sleep   |  721 |                          | NULL               |    0.000 |
      | 208 | root        | 192.168.104.191:52424 | NULL | Sleep   |  719 |                          | NULL               |    0.000 |
      | 209 | root        | 192.168.104.191:52428 | NULL | Query   |  717 | User sleep               | select sleep(1000) |    0.000 |
      | 210 | root        | 192.168.104.191:52436 | NULL | Sleep   |  715 |                          | NULL               |    0.000 |
      | 211 | root        | 192.168.104.191:52442 | NULL | Sleep   |  713 |                          | NULL               |    0.000 |
      | 212 | root        | 192.168.104.191:52448 | NULL | Sleep   |  711 |                          | NULL               |    0.000 |
      | 213 | root        | 192.168.104.191:52452 | NULL | Query   |  709 | User sleep               | select sleep(1000) |    0.000 |
      | 214 | root        | 192.168.104.191:52460 | NULL | Sleep   |  707 |                          | NULL               |    0.000 |
      | 215 | root        | 192.168.104.191:52466 | NULL | Sleep   |  705 |                          | NULL               |    0.000 |
      | 216 | root        | 192.168.104.191:52472 | NULL | Sleep   |  703 |                          | NULL               |    0.000 |
      | 217 | root        | 192.168.104.191:52476 | NULL | Query   |  701 | User sleep               | select sleep(1000) |    0.000 |
      | 218 | root        | 192.168.104.191:52484 | NULL | Sleep   |  699 |                          | NULL               |    0.000 |
      | 219 | root        | 192.168.104.191:52490 | NULL | Sleep   |  697 |                          | NULL               |    0.000 |
      | 220 | root        | 192.168.104.191:52496 | NULL | Sleep   |  695 |                          | NULL               |    0.000 |
      | 221 | root        | 192.168.104.191:52500 | NULL | Query   |  693 | User sleep               | select sleep(1000) |    0.000 |
      | 222 | root        | 192.168.104.191:52508 | NULL | Sleep   |  691 |                          | NULL               |    0.000 |
      | 223 | root        | 192.168.104.191:52514 | NULL | Sleep   |  689 |                          | NULL               |    0.000 |
      | 224 | root        | 192.168.104.191:52520 | NULL | Sleep   |  687 |                          | NULL               |    0.000 |
      | 225 | root        | 192.168.104.191:52524 | NULL | Query   |  685 | User sleep               | select sleep(1000) |    0.000 |
      | 226 | root        | 192.168.104.191:52532 | NULL | Sleep   |  683 |                          | NULL               |    0.000 |
      | 227 | root        | 192.168.104.191:52538 | NULL | Sleep   |  681 |                          | NULL               |    0.000 |
      | 228 | root        | 192.168.104.191:52544 | NULL | Sleep   |  679 |                          | NULL               |    0.000 |
      | 229 | root        | 192.168.104.191:52548 | NULL | Query   |  677 | User sleep               | select sleep(1000) |    0.000 |
      | 230 | root        | 192.168.104.191:52556 | NULL | Sleep   |  675 |                          | NULL               |    0.000 |
      | 231 | root        | 192.168.104.191:52562 | NULL | Sleep   |  673 |                          | NULL               |    0.000 |
      | 232 | root        | 192.168.104.191:52568 | NULL | Sleep   |  671 |                          | NULL               |    0.000 |
      | 233 | root        | 192.168.104.191:52572 | NULL | Query   |  669 | User sleep               | select sleep(1000) |    0.000 |
      | 234 | root        | 192.168.104.191:52580 | NULL | Sleep   |  667 |                          | NULL               |    0.000 |
      | 235 | root        | 192.168.104.191:52586 | NULL | Sleep   |  665 |                          | NULL               |    0.000 |
      | 236 | root        | 192.168.104.191:52592 | NULL | Sleep   |  663 |                          | NULL               |    0.000 |
      | 237 | root        | 192.168.104.191:52596 | NULL | Query   |  661 | User sleep               | select sleep(1000) |    0.000 |
      | 238 | root        | 192.168.104.191:52604 | NULL | Sleep   |  659 |                          | NULL               |    0.000 |
      | 239 | root        | 192.168.104.191:52610 | NULL | Sleep   |  657 |                          | NULL               |    0.000 |
      | 240 | root        | 192.168.104.191:52616 | NULL | Sleep   |  655 |                          | NULL               |    0.000 |
      | 241 | root        | 192.168.104.191:52620 | NULL | Query   |  653 | User sleep               | select sleep(1000) |    0.000 |
      | 242 | root        | 192.168.104.191:52628 | NULL | Sleep   |  651 |                          | NULL               |    0.000 |
      | 243 | root        | 192.168.104.191:52634 | NULL | Sleep   |  649 |                          | NULL               |    0.000 |
      | 244 | root        | 192.168.104.191:52640 | NULL | Sleep   |  647 |                          | NULL               |    0.000 |
      | 245 | root        | 192.168.104.191:52644 | NULL | Query   |  645 | User sleep               | select sleep(1000) |    0.000 |
      | 246 | root        | 192.168.104.191:52652 | NULL | Sleep   |  643 |                          | NULL               |    0.000 |
      | 247 | root        | 192.168.104.191:52658 | NULL | Sleep   |  641 |                          | NULL               |    0.000 |
      | 248 | root        | 192.168.104.191:52664 | NULL | Sleep   |  639 |                          | NULL               |    0.000 |
      | 249 | root        | 192.168.104.191:52668 | NULL | Query   |  637 | User sleep               | select sleep(1000) |    0.000 |
      | 250 | root        | 192.168.104.191:52676 | NULL | Sleep   |  635 |                          | NULL               |    0.000 |
      | 251 | root        | 192.168.104.191:52682 | NULL | Sleep   |  633 |                          | NULL               |    0.000 |
      | 252 | root        | 192.168.104.191:52688 | NULL | Sleep   |  631 |                          | NULL               |    0.000 |
      | 253 | root        | 192.168.104.191:52692 | NULL | Query   |  629 | User sleep               | select sleep(1000) |    0.000 |
      | 254 | root        | 192.168.104.191:52700 | NULL | Sleep   |  627 |                          | NULL               |    0.000 |
      | 255 | root        | 192.168.104.191:52706 | NULL | Sleep   |  625 |                          | NULL               |    0.000 |
      | 256 | root        | 192.168.104.191:52712 | NULL | Sleep   |  623 |                          | NULL               |    0.000 |
      | 257 | root        | 192.168.104.191:52716 | NULL | Query   |  621 | User sleep               | select sleep(1000) |    0.000 |
      | 258 | root        | 192.168.104.191:52724 | NULL | Sleep   |  619 |                          | NULL               |    0.000 |
      | 259 | root        | 192.168.104.191:52730 | NULL | Sleep   |  617 |                          | NULL               |    0.000 |
      | 260 | root        | 192.168.104.191:52736 | NULL | Sleep   |  615 |                          | NULL               |    0.000 |
      | 261 | root        | 192.168.104.191:52740 | NULL | Query   |  613 | User sleep               | select sleep(1000) |    0.000 |
      | 262 | root        | 192.168.104.191:52748 | NULL | Sleep   |  611 |                          | NULL               |    0.000 |
      | 263 | root        | 192.168.104.191:52754 | NULL | Sleep   |  608 |                          | NULL               |    0.000 |
      | 264 | root        | 192.168.104.191:52760 | NULL | Sleep   |  606 |                          | NULL               |    0.000 |
      | 265 | root        | 192.168.104.191:52764 | NULL | Query   |  604 | User sleep               | select sleep(1000) |    0.000 |
      | 266 | root        | 192.168.104.191:52772 | NULL | Sleep   |  602 |                          | NULL               |    0.000 |
      | 267 | root        | 192.168.104.191:52778 | NULL | Sleep   |  600 |                          | NULL               |    0.000 |
      | 268 | root        | 192.168.104.191:52784 | NULL | Sleep   |  598 |                          | NULL               |    0.000 |
      | 269 | root        | 192.168.104.191:52788 | NULL | Query   |  596 | User sleep               | select sleep(1000) |    0.000 |
      | 270 | root        | 192.168.104.191:52796 | NULL | Sleep   |  594 |                          | NULL               |    0.000 |
      | 271 | root        | 192.168.104.191:52802 | NULL | Sleep   |  592 |                          | NULL               |    0.000 |
      | 272 | root        | 192.168.104.191:52808 | NULL | Sleep   |  590 |                          | NULL               |    0.000 |
      | 273 | root        | 192.168.104.191:52812 | NULL | Query   |  588 | User sleep               | select sleep(1000) |    0.000 |
      | 274 | root        | 192.168.104.191:52820 | NULL | Sleep   |  586 |                          | NULL               |    0.000 |
      | 275 | root        | 192.168.104.191:52826 | NULL | Sleep   |  584 |                          | NULL               |    0.000 |
      | 276 | root        | 192.168.104.191:52832 | NULL | Sleep   |  582 |                          | NULL               |    0.000 |
      | 277 | root        | 192.168.104.191:52836 | NULL | Query   |  580 | User sleep               | select sleep(1000) |    0.000 |
      | 278 | root        | 192.168.104.191:52844 | NULL | Sleep   |  578 |                          | NULL               |    0.000 |
      | 279 | root        | 192.168.104.191:52850 | NULL | Sleep   |  576 |                          | NULL               |    0.000 |
      | 280 | root        | 192.168.104.191:52856 | NULL | Sleep   |  574 |                          | NULL               |    0.000 |
      | 281 | root        | 192.168.104.191:52860 | NULL | Query   |  572 | User sleep               | select sleep(1000) |    0.000 |
      | 282 | root        | 192.168.104.191:52868 | NULL | Sleep   |  570 |                          | NULL               |    0.000 |
      | 283 | root        | 192.168.104.191:52874 | NULL | Sleep   |  568 |                          | NULL               |    0.000 |
      | 284 | root        | 192.168.104.191:52880 | NULL | Sleep   |  566 |                          | NULL               |    0.000 |
      | 285 | root        | 192.168.104.191:52884 | NULL | Query   |  564 | User sleep               | select sleep(1000) |    0.000 |
      | 286 | root        | 192.168.104.191:52892 | NULL | Sleep   |  562 |                          | NULL               |    0.000 |
      | 287 | root        | 192.168.104.191:52898 | NULL | Sleep   |  560 |                          | NULL               |    0.000 |
      | 288 | root        | 192.168.104.191:52904 | NULL | Sleep   |  558 |                          | NULL               |    0.000 |
      | 289 | root        | 192.168.104.191:52908 | NULL | Query   |  556 | User sleep               | select sleep(1000) |    0.000 |
      | 290 | root        | 192.168.104.191:52916 | NULL | Sleep   |  554 |                          | NULL               |    0.000 |
      | 291 | root        | 192.168.104.191:52922 | NULL | Sleep   |  552 |                          | NULL               |    0.000 |
      | 292 | root        | 192.168.104.191:52928 | NULL | Sleep   |  550 |                          | NULL               |    0.000 |
      | 293 | root        | 192.168.104.191:52932 | NULL | Query   |  548 | User sleep               | select sleep(1000) |    0.000 |
      | 294 | root        | 192.168.104.191:52940 | NULL | Sleep   |  546 |                          | NULL               |    0.000 |
      | 295 | root        | 192.168.104.191:52946 | NULL | Sleep   |  544 |                          | NULL               |    0.000 |
      | 296 | root        | 192.168.104.191:52952 | NULL | Sleep   |  542 |                          | NULL               |    0.000 |
      | 297 | root        | 192.168.104.191:52956 | NULL | Query   |  540 | User sleep               | select sleep(1000) |    0.000 |
      | 298 | root        | 192.168.104.191:52964 | NULL | Sleep   |  538 |                          | NULL               |    0.000 |
      | 299 | root        | 192.168.104.191:52970 | NULL | Sleep   |  536 |                          | NULL               |    0.000 |
      | 300 | root        | 192.168.104.191:52976 | NULL | Sleep   |  534 |                          | NULL               |    0.000 |
      | 301 | root        | 192.168.104.191:52980 | NULL | Query   |  532 | User sleep               | select sleep(1000) |    0.000 |
      | 302 | root        | 192.168.104.191:52988 | NULL | Sleep   |  530 |                          | NULL               |    0.000 |
      | 303 | root        | 192.168.104.191:52994 | NULL | Sleep   |  528 |                          | NULL               |    0.000 |
      | 304 | root        | 192.168.104.191:53000 | NULL | Sleep   |  526 |                          | NULL               |    0.000 |
      | 305 | root        | 192.168.104.191:53004 | NULL | Query   |  524 | User sleep               | select sleep(1000) |    0.000 |
      | 306 | root        | 192.168.104.191:53012 | NULL | Sleep   |  522 |                          | NULL               |    0.000 |
      | 307 | root        | 192.168.104.191:53018 | NULL | Sleep   |  520 |                          | NULL               |    0.000 |
      | 308 | root        | 192.168.104.191:53024 | NULL | Sleep   |  518 |                          | NULL               |    0.000 |
      | 309 | root        | 192.168.104.191:53028 | NULL | Query   |  516 | User sleep               | select sleep(1000) |    0.000 |
      | 317 | root        | localhost             | NULL | Query   |    0 | Init                     | show processlist   |    0.000 |
      +-----+-------------+-----------------------+------+---------+------+--------------------------+--------------------+----------+
      158 rows in set (0.001 sec)
       
      
      

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            winstone Zdravelina Sokolovska
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: