use cmon; alter table mysql_server add column role varchar(64) default 'none'; alter table mysql_server add column socket varchar(64) default ''; create index mysql_idx on mysql_statistics(mysqlid,report_ts); create index report_ts_idx on mysql_statistics(report_ts); create index mysql_idx on mysql_variables(mysqlid,report_ts); create index report_ts_idx on mysql_variables(report_ts);