Tuning Drives

Purpose

A large number of logs and data are usually stored in the database, therefore, the database is a heavy I/O application. The performance of hard drives has a great impact on the database performance. Improving the performance of hard drives can greatly improve that of the database.

Procedure

If bottlenecks are detected in drives, replace the old drives with drives of higher performance or add more drives of higher performance.

Hard drive interfaces: In terms of performance, an NVMe drive is better than a SAS drive, and a SAS drive is better than a SATA drive (NVMe > SAS > SATA).
Hard drive types: In terms of performance, an SSD is better than an HDD (SSD > HDD).

Parent topic: Hardware Tuning