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:
[server]
[mysqld]
[galera]
[embedded]
[mariadb]
[mariadb-10.5]
the server has 4 CPUs and 16 GB RAM.