What base to use for data storage from one million ROW and on 5 fields?

Question

Database

Everything is fine, but as soon as the database grows, problems begin, sometimes with communication, sometimes with backups.
Now there are 150 tables in the database, half have a million records and 3 fields, the rest have 500 thousand records, but 10 fields each.
And everything started to break down. More precisely, there is always no connection, it does not allow you to make a backup, then it falls, then it does not allow you to make a record. Now

mysql  Ver 14.14 Distrib 5.7.16, for Linux (x86_64) using  EditLine wrapper

The config is like this:

!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mysql.conf.d/

[mysqldump]
max_allowed_packet = 16M
[mysqld]
max_allowed_packet = 16M

Answer 1

I won’t tell you anything about the settings, but mysql works well for me on much larger amounts of data in tens and hundreds of millions of rows in tables. Here it seems to me that the question is more in iron and loads. I have a Xeon hardware (I don't know the exact model) with a frequency of 6 × 2.0 GHz, 32 GB of RAM and a 4 × 120 GB SSD disk (RAID 10)

Answer 2

Why postgres tags? 150 million records is boring, here postgres even has nowhere to accelerate, let alone break down. Use [normally configured] postgres :)