I need to create a new index on large table in RDS MySQL. This index is needed to reduce the scan time on this table. Below is the configuration:
- Table size: 400 GB
- Records: 400 Million
- column - Timestamp-col
- RDS MySQL - db.m5.4xlarge, Engine - MySQL Community
Looking for below details:
- How long such index creation takes place.
- Will there be any outage to production DB. If so how to mange with lower impact.
- Any good/bad experiences and lessons learned on such deployment.
Appreciate your inputs.