Will the load / response from the server be greatly reduced in this scenario?

Question

PHP

Hello.
I’m thinking of making the entire MySQL main database on the Memory engine (so that everything is stored in the RAM),
and by cron (once a minute) run a php script that would dump the database to a file through the ssh2 *** function, and one more that was done once a day
Total expected 5 databases with approximately 2000 rows each. Will there be a heavy load? If not, will the response from the server be greatly accelerated? (with 1 request, there are about 3 requests by type: SELECT `id` FROM `users` WHERE `id`=1, etc.)
Or should I take a ready-made database that stores information in RAM?

Answer 1

Option 1: Use Redis instead of MySQL.
Option 2: Continue using MySQL but add cache to Memcached/Redis.