How to reduce RAM used by mysql process while my.cnf is empty?

Hello, im a noob, but isnt it that my mysql process is using around 1,8GB RAM?

top -c commands sorted by “VIRT” shows “1859152” next to mysql process

# ps aux --sort -rss | grep 822
mysql      822  1.2 21.8 1859152 457924 ?      Sl   07:22   0:16 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/hostname.err --open-files-limit=10000 --pid-file=/var/lib/mysql/
root     12956  0.0  0.0   6384   680 pts/0    S+   07:45   0:00 grep 822
# cat /proc/822/status | grep Size
FDSize: 256
VmSize:  1859152 kB
# cat /etc/my.cnf

Why is it using that much and how can i exactly reduce the usage? As im on the VPS and it is reaching its RAM limit (fatal failures because of that, Unable to fork) & i dont wish to upgrade.

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.