mysql sql语句整理

1.增加一个新的主键字段，自增，非空

alter table FLEX_MACHINE_PARRECORD add column id int not null AUTO_INCREMENT primary key first;

2.查看线程占用的内存。

select m.thread_id tid, USER, esc.DIGEST_TEXT, total_allocated FROM sys.memory_by_thread_by_current_bytes m, performance_schema.events_statements_current esc WHERE m.`thread_id` = esc.THREAD_ID\G