bottlenecked by IO, meaning CPUs were constantly waiting on HDDs to respond. But when we replace HDDs with NVMe SSDs on a Dual Socket Best Practices for MySQL with SSDs Page 4 Server, the CPU becomes the Storage SAS HDD 2x SEAGATE ST600MP0005 15K rpm SATA SSD 2x Samsung 850 PRO NVMe SSD 2x Samsung XS1715 Quad‐socket (28 Core) Configuration Database Server (Client) 2x SEAGATE ST600MP0005 15K rpm SATA SSD 2x Samsung 850 Pro SAS SSD 2x Samsung PM1633 NVMe 2x Samsung PM1725 It is generally accepted that OLTP database applications have been I/O bound

{device}/queue/ scheduler 配置IO调度，deadline或者noop更 适用于MySQL数据库场景。命令中 的${device}为数据盘名称，根据实 际磁盘名称进行修改。NVME盘不 支持此操作。 echo deadline > /sys/ block/${device}/queue/ scheduler /sys/block/$ {device}/queue/ nr_requests