Would migrating MySQL to a different drive help reduce the load on the drives?

Question

MySQL

There is a server with one 500 gigabyte hard drive, ext4 file system.
The server runs ISPmanager + Apache + nginx + MySQL + mail server.
In general, the operation of the system is satisfactory, but at the same time, you can often see in iotop that jdb2/sda6-8 constantly loads the system, especially when actively writing data to MySQL databases.
Tell me, will it help to reduce the load by adding a second similar disk and transferring databases to a second disk? What is the best file system for the second disk?

Answer 1

quite
sqlinfo.ru/forum/viewtopic.php?id=6127

Answer 2

moving the database to a separate disk will still give a certain performance, but! all this is lost if you do not have caching configured, the frontend code is not optimized, and table indexes are not built.
switching to a separate disk is only the first step towards optimization, but not a solution to the problem

Answer 3

Why transfer the database to another disk, if almost no one except the muscle uses you first (unless, of course, Apache processes thousands of simultaneous requests)? It is necessary to improve the performance of the disk subsystem, and not change the awl for soap.

Answer 4

This is not a solution, but a temporary option is to disable logging. At one point, I had a lot of traffic to the database, and the IO of the disk was under 100%. By disabling logging, the disk was completely unloaded, but there was a sudden shutdown option, and data loss was unacceptable. we solved the problem in a different way.