Hello and good morning! What can I do to get more speed for my database server? it runs at 100% swap - and is it possible to add more space to the mysql partition?
Â
My current config:
df -h
devtmpfs                                                     7,8G      0 7,8G   0% /dev
tmpfs                                                        7,8G      0 7,8G   0% /dev/shm
tmpfs                                                        7,8G   145M 7,7G   2% /run
tmpfs                                                        7,8G      0 7,8G   0% /sys/fs/cgroup
/dev/mapper/centos_****-root                       25G   3,3G  22G  14% /
/dev/sda1Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â 1014MÂ Â Â 273MÂ 742MÂ Â 27% /boot
/dev/mapper/centos_****-var_log                    10G   131M 9,9G   2% /var/log
/dev/mapper/centos_****-var_lib_centreon           49M   2,8M  46M   6% /var/lib/centreon
/dev/mapper/centos_****-var_cache_centreon_backup  20G    33M  20G   1% /var/cache/centreon/backup
/dev/mapper/centos_****-var_lib_mysql             185G   181G 4,5G  98% /var/lib/mysql
tmpfs                                                        1,6G      0 1,6G   0% /run/user/0
Â
top
13014 mysql    20  0 2756332  1,2g  9368 S 17,9 7,9 17134:40 mariadbd
Â
Â
server.cnf:
1server]
cmysqld]
pgalera]
pembedded]
-mariadb]
mariadb-10.5]
Â
the server has 4 CPUs and 16 GB RAM.