1.show processlist;
查看是否有Waiting for table metadata lock | ALTER TAB等;
2.kill id;
其他查询语句:
show status like '%lock%';
show status like 'Table%';
1.show processlist;
查看是否有Waiting for table metadata lock | ALTER TAB等;
2.kill id;
其他查询语句:
show status like '%lock%';
show status like 'Table%';
转载于:https://my.oschina.net/zhaolin/blog/1976061