Mysqltmp - transfer to RAM, did you do it right - SWAP?

Question

linux

Question to experts - I killed SWAP or what? The server has 20 GB of RAM and it is planned to expand. Is this a normal in-memory database transfer configuration?
Thank you in advance!
/var/lib/mysql/tmp - drwx------ 2 mysql mysql
id mysql - uid=27(mysql) gid=27(mysql) groups=27(mysql)

/dev/mapper/vg_alfa-lv_root /                       ext4    defaults,grpquota,usrquota,noatime        1 1
UUID=fc5893c0-56c4-40c5-af58-239ed7a67365 /boot                   ext4    defaults        1 2
/dev/mapper/vg_alfa-lv_swap swap                    swap    defaults        0 0
# tmpfs                   /dev/shm                tmpfs   defaults        0 0
tmpfs                   /var/lib/mysql/tmp tmpfs rw,gid=27,uid=27,size=4G,nr_inodes=10k,mode=0700       0 0
devpts                  /dev/pts                devpts  gid=5,mode=620  0 0
sysfs                   /sys                    sysfs   defaults        0 0
proc                    /proc                   proc    defaults        0 0

/etc/mysql/my.cnf
[mysqld] tmpdir=/var/lib/mysql/tmp

[[email protected] mysql]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/vg_alfa-lv_root
                      220G   79G  130G  38% /
/dev/sda1             477M   48M  405M  11% /boot
tmpfs                 4.0G     0  4.0G   0% /var/lib/mysql/tmp

Answer 1

If there are a lot of requests, then as I understand it, it starts to eat hard as needed, I can be wrong

Answer 2

Forgive me if I'm wrong, but the muscle itself knows how to eat operatives as needed.

Answer 3

Why move the entire database to RAM? What if the server goes down by mistake? Rollback a few hours ago, data loss. Set up MySQL properly and everything will work fine. There are already built-in caching functions, he himself knows how to store frequent data in RAM

Answer 4

If your mysql goes into swap, then you are completely correct.
fomistoklus business speaks - to transfer basis to RAM - very bad idea.
Set up mysql correctly and everything will be fine.
For swap I will add the following:
free -m will show that there is some data in swap, but it may not be used at the moment. Possibly used before. You can verify this with the vmstat 1 command, where si is the current swap in, and so is the current swap out.