<span>add unique index 注意事项</span>

select   count( distinct app_id,count_date,cluster,priority) from events  ;   

select   count( *) from events  ;   


select   app_id,count_date,cluster,priority ,count(*)  from events group by  app_id,count_date,cluster,priority  having count(*) >1 limit 20;   

alter table events  add unique index uk_app(app_id,count_date,cluster,priority);       

ERROR 1062 (23000): Duplicate entry '2882303761517233197-2020-09-21-ALL-1' for key 'uk_id'