Will the load decrease if I move the table to another ssd?

Question

MySQL

There is a server that has an ssd disk with a website and mysql on the same server, the load on ssd during peak hours is close to 100% (looked at atop). If you add another ssd and put some tables (inndob) on it, this, in theory, should unload the first ssd? Are there any pitfalls of such a solution? This is still much cheaper than making a separate server for mysql.
Addition:
According to atop, I see that the load on ssd comes almost exclusively from mysql, that is, it turns out that if you take one additional server purely from mysql, then this entire load will simply go to the new server and will also load ssd there. Am I talking right?
Addendum 2:
Output of atop -r -D for the last 10 minutes is here
The database is constantly writing, deleting, updating data, a lot, so I think the disk is loaded, if you look at the show process list in mysql, then queries that take more than a second are very rare. There are several tables with tens/hundreds of millions of rows. Removed the superfluous indexes already.

Answer 1

it is better to put Redis.

Answer 2

This is still much cheaper than making a separate server for mysql.

Hm. How many visitors are on the site?
If 100 people a day and they create a 100% load on disk, then the application architecture and sql queries suck. Throw out all the shitty code and hire a normal programmer to write it right from scratch.
If there are 1000 people a day or more, and at the same time there is not even 300 rubles / month for VPS - hire a normal marketer and think about how you can monetize the site.

Answer 3

Alternatively, if power permits, mysql can be moved to RAM.