show processlist;找到锁进程,kill id ;
mysql>UNLOCK TABLES;
锁定数据表,避免在备份过程中,表被更新mysql>LOCK TABLES tbl_name READ;为表增加一个写锁定:mysql>LOCK TABLES tbl_name WRITE;