求助,mysql5.6改不了表结构,没有事务没有锁。在线求等大神解答,解决了马上给分
liu志坚 2018-01-18 11:28:51 ALTER TABLE `t_order` MODIFY COLUMN `fcomment_status` varchar(30) ;
select * from information_schema.PROCESSLIST t where
id in (SELECT a.trx_mysql_thread_id FROM information_schema.INNODB_TRX a )
and t.db='mshz-order';
没有数据,说明没有想关事务。
select t.DB,t.`USER`,t.COMMAND,t.TIME,t.STATE,t.INFO from information_schema.PROCESSLIST t where COMMAND!='Sleep' and INFO is not null order by TIME desc;
mshz-order root Query 162 Waiting for table metadata lock ALTER TABLE `t_order` MODIFY COLUMN `fcomment_status` varchar(30)
状态是:“Waiting for table metadata lock”
。