Question

Database Swap at 100%

  • 23 January 2023
  • 2 replies
  • 31 views

Badge +2

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.


2 replies

Userlevel 1
Badge +11

Hi,

Not sure it would help for the swap usage but yes, if I were you I’d give more space for the /var/lib/mysql partition. Because you’ll run into problems if it gets full.

Userlevel 5
Badge +14

But is swap is used, it means that you don’t have enough memory (RAM)

Reply