To Nha Notes | April 21, 2021, 4:12 p.m.
When working with database, if a table get huge data, we may need to partition it to improve performance. Partitioning is also helpful to quickly delete unneeded data by dropping a partition.
But be careful when we do alter operation to add/drop partition. Because it will consume a lost of disk write/read IO which lead to impact to response time of other normal access. Thus, to do this, we may need a a few minutes downtime.