摘要:
#查看表的所有索引show index from tblname;#删除表的索引drop index index_name on tblname;#表添加索引(btree)alter table tblname add index using btree(column_name); 阅读全文
摘要:
1.show OPEN TABLES where In_use > 0;2.show processlist;3.kill thread_id;其中thread_id为processlist的ID 阅读全文