# Case study: Database outages caused by adding index
![`smart`](OnlineDDLMySQL_aa_001_20240125.png)
------------------------------------------------------------
When there are a huge number of transactions waiting, the resource of MySQL will be exhausted, and MySQL will crash.