window杀进程,mysql杀死锁

前提：环境变量需要配置jdk

1.查看java进程 一般用来记pid

jps -l

杀死进程

taskkill /pid 14396 -t -f

-f 用来强制执行

-t 终止指定的进程与该进程启动的任何子进程

2.mysql杀死当前锁

MariaDB [(none)]> show processlist;
+--------+------------+-----------+------------+---------+------+---------------------------------+-----------------------------+----------+
| Id | User | Host | db | Command | Time | State | Info | Progress |
+--------+------------+-----------+------------+---------+------+---------------------------------+-----------------------------+----------+
| 566697 | jour_wp | localhost | jour_wp | Query | 1130 | Waiting for table metadata lock | OPTIMIZE TABLE wp_comments | 0.000 |
| 566698 | jour_wp | localhost | jour_wp | Query | 1130 | Waiting for table level lock | OPTIMIZE TABLE wp_comments | 0.000 |

MariaDB [(none)]> kill 566697;
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> kill 566698;
Query OK, 0 rows affected (0.00 sec)