What minimum specifications for a DB of 10 million leads? With 100k send every day?

Your software
My Mautic version is: v4.4.7
My PHP version is: docker version of v4.4.7 Mautic image (PHP_VERSION=7.4.33 )
My Database type and version is: Pecorna 5.7.34

I’m trying to figure out any sending limits I might encounter. The SMTP servers will be external to Amazon AWS in IP pools. But I would like to understand what kind of VM I could buy. Compared to memry, CPU and Storage which will be of the 3 most stressed elements?

Could be a VM with 2 CPUs with 16 RAM on RHEL a good base?
It’s better more CPU or RAM?

I red other threads where some guys talk about importing millions of records directly into the DB (which I would like to do too) at least for the initial photo. Aside from the logs, is there any other sneaky process I should be aware of? I saw that in the DB there is a calculated column for the first level domain, but apart from the logging it doesn’t seem to me that there is anything else.

Can you give me your opinion?

These errors are showing in the log:

Steps I have tried to fix the problem: