improve database design for monitoring application
Add an index, not a unique key:

ALTER TABLE md_metrics_status ADD INDEX (`timestamp`);


I believe you are using PHPMyAdmin to add the index, and in PMA, unique is the default choice when you want to add an index, and that is why you are getting the duplicate key error.