mysql 常用命令

表被锁处理方式

SELECT * FROM information_schema.innodb_trx; //查询被锁的进程

SELECT * FROM information_schema.`PROCESSLIST` WHERE TIME > 1 AND USER = 'root' ORDER BY TIME DESC; //查询用户占长时间占用线程的用户

KILL 873728

--数据库表数据排序
SELECT TABLE_NAME,TABLE_ROWS FROM information_schema.`TABLES`

WHERE TABLE_SCHEMA = (SELECT DATABASE())

ORDER BY TABLE_ROWS DESC;