Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2018 Server version: 6.0.9-alpha-community-log MySQL Community Server (GPL) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> show processlist -> ; +------+-----------------+--------------------+---------+---------+-------+-----------------------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +------+-----------------+--------------------+---------+---------+-------+-----------------------------+------------------------------------------------------------------------------------------------------+ | 1 | event_scheduler | localhost | NULL | Daemon | 79 | Waiting for next activation | NULL | | 713 | OS1001 | 10.3.9.110:3537 | origins | Sleep | 9 | NULL | NULL | | 714 | OS1001 | 10.3.9.110:3538 | origins | Sleep | 7 | NULL | NULL | | 715 | OS2001 | 10.3.9.121:1845 | origins | Sleep | 9 | NULL | NULL | | 717 | OS2001 | 10.3.9.121:1847 | origins | Sleep | 2 | NULL | NULL | | 721 | root | localhost:1851 | origins | Query | 13051 | init | SELECT Inventory_View.* FROM Inventory_View, FactionInv WHERE Inventory_View.InventoryKey IN ( | | 724 | OS2002 | 10.3.9.122:4852 | origins | Sleep | 6 | NULL | NULL | | 726 | OS2002 | 10.3.9.122:4854 | origins | Sleep | 27 | NULL | NULL | | 730 | root | localhost:4858 | origins | Query | 14064 | init | SELECT Inventory_View.* FROM Inventory_View, FactionInv WHERE Inventory_View.InventoryKey IN ( | | 743 | OS3001 | 10.3.9.131:1025 | origins | Sleep | 6 | NULL | NULL | | 1738 | OS2001 | 10.3.9.121:1923 | origins | Sleep | 4078 | NULL | NULL | | 1739 | OS2002 | 10.3.9.122:1188 | origins | Sleep | 13268 | NULL | NULL | | 1740 | OS2001 | 10.3.9.121:1924 | origins | Sleep | 13475 | NULL | NULL | | 1741 | OS2002 | 10.3.9.122:1189 | origins | Sleep | 13054 | NULL | NULL | | 1744 | OS2002 | 10.3.9.122:1192 | origins | Sleep | 14064 | NULL | NULL | | 1745 | OS2001 | 10.3.9.121:1925 | origins | Sleep | 13114 | NULL | NULL | | 1747 | OS2001 | 10.3.9.121:1926 | origins | Sleep | 13051 | NULL | NULL | | 1753 | OS3001 | 10.3.9.131:1109 | origins | Sleep | 4484 | NULL | NULL | | 1823 | OS2002 | 10.3.9.122:1216 | origins | Sleep | 4505 | NULL | NULL | | 2009 | vstokes | 61.172.29.81:63011 | NULL | Sleep | 192 | NULL | NULL | | 2012 | vstokes | 61.172.29.81:63013 | NULL | Sleep | 170 | NULL | NULL | | 2014 | vstokes | 61.172.29.81:63015 | NULL | Sleep | 164 | NULL | NULL | | 2015 | vstokes | 61.172.29.81:63016 | NULL | Sleep | 0 | NULL | NULL | | 2018 | vstokes | 61.172.29.81:63018 | NULL | Query | 0 | NULL | show processlist | +------+-----------------+--------------------+---------+---------+-------+-----------------------------+------------------------------------------------------------------------------------------------------+ 24 rows in set (0.28 sec) mysql> kill 721; Query OK, 0 rows affected (0.27 sec) mysql> kill 730; Query OK, 0 rows affected (0.28 sec) mysql> show processlist; +------+-----------------+--------------------+---------+---------+-------+-----------------------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +------+-----------------+--------------------+---------+---------+-------+-----------------------------+------------------------------------------------------------------------------------------------------+ | 1 | event_scheduler | localhost | NULL | Daemon | 117 | Waiting for next activation | NULL | | 713 | OS1001 | 10.3.9.110:3537 | origins | Sleep | 2 | NULL | NULL | | 714 | OS1001 | 10.3.9.110:3538 | origins | Sleep | 5 | NULL | NULL | | 715 | OS2001 | 10.3.9.121:1845 | origins | Sleep | 2 | NULL | NULL | | 717 | OS2001 | 10.3.9.121:1847 | origins | Sleep | 10 | NULL | NULL | | 721 | root | localhost:1851 | origins | Killed | 13209 | init | SELECT Inventory_View.* FROM Inventory_View, FactionInv WHERE Inventory_View.InventoryKey IN ( | | 724 | OS2002 | 10.3.9.122:4852 | origins | Sleep | 14 | NULL | NULL | | 726 | OS2002 | 10.3.9.122:4854 | origins | Sleep | 5 | NULL | NULL | | 730 | root | localhost:4858 | origins | Killed | 14222 | init | SELECT Inventory_View.* FROM Inventory_View, FactionInv WHERE Inventory_View.InventoryKey IN ( | | 743 | OS3001 | 10.3.9.131:1025 | origins | Sleep | 14 | NULL | NULL | | 1738 | OS2001 | 10.3.9.121:1923 | origins | Sleep | 4236 | NULL | NULL | | 1739 | OS2002 | 10.3.9.122:1188 | origins | Sleep | 13426 | NULL | NULL | | 1740 | OS2001 | 10.3.9.121:1924 | origins | Sleep | 13633 | NULL | NULL | | 1741 | OS2002 | 10.3.9.122:1189 | origins | Sleep | 13212 | NULL | NULL | | 1744 | OS2002 | 10.3.9.122:1192 | origins | Sleep | 14222 | NULL | NULL | | 1745 | OS2001 | 10.3.9.121:1925 | origins | Sleep | 13272 | NULL | NULL | | 1747 | OS2001 | 10.3.9.121:1926 | origins | Sleep | 13209 | NULL | NULL | | 1753 | OS3001 | 10.3.9.131:1109 | origins | Sleep | 4642 | NULL | NULL | | 1823 | OS2002 | 10.3.9.122:1216 | origins | Sleep | 4663 | NULL | NULL | | 2009 | vstokes | 61.172.29.81:63011 | NULL | Sleep | 350 | NULL | NULL | | 2012 | vstokes | 61.172.29.81:63013 | NULL | Sleep | 328 | NULL | NULL | | 2014 | vstokes | 61.172.29.81:63015 | NULL | Sleep | 322 | NULL | NULL | | 2015 | vstokes | 61.172.29.81:63016 | NULL | Sleep | 0 | NULL | NULL | | 2018 | vstokes | 61.172.29.81:63018 | NULL | Query | 0 | NULL | show processlist | | 2020 | OS2001 | 10.3.9.121:1950 | origins | Sleep | 16 | NULL | NULL | | 2021 | OS2001 | 10.3.9.121:1951 | origins | Sleep | 1 | NULL | NULL | | 2022 | OS2002 | 10.3.9.122:1286 | origins | Sleep | 5 | NULL | NULL | | 2023 | OS2002 | 10.3.9.122:1287 | origins | Sleep | 5 | NULL | NULL | +------+-----------------+--------------------+---------+---------+-------+-----------------------------+------------------------------------------------------------------------------------------------------+ 28 rows in set (0.28 sec) mysql>