SWAP qui monte depuis la 4.1 et Buster (MySQL)

Bonjour,

depuis la 4.1 & Debian 10, j’observe plus d’utilisation de la SWAP :

Après un petit coup de smem -t -p, j’ai remarqué que c’est MySQL qui prend toute la SWAP. Suis je le seul à avoir le problème ? Quelque chose à changé avec Buster ?

Merci.

J’ai restart MySQL mais ça remonte…

root@jeedom:~# smem -t -p
  PID User     Command                         Swap      USS      PSS      RSS
 2900 root     /sbin/agetty -o -p -- \u --    0.00%    0.01%    0.01%    0.08%
 2895 root     /sbin/agetty -o -p -- \u --    0.00%    0.01%    0.01%    0.10%
 3530 root     sudo /usr/bin/python3 /var/    0.04%    0.00%    0.01%    0.15%
 2858 root     /usr/sbin/rngd -r /dev/uran    0.00%    0.01%    0.01%    0.07%
 2488 root     sudo /usr/bin/python3 /var/    0.04%    0.00%    0.01%    0.15%
 2886 daemon   /usr/sbin/atd -f               0.00%    0.01%    0.01%    0.10%
 2868 root     /usr/sbin/cron -f              0.01%    0.01%    0.01%    0.12%
 3922 root     sudo /usr/bin/python3 /var/    0.04%    0.00%    0.01%    0.15%
 2202 root     /usr/sbin/alsactl -E HOME=/    0.00%    0.01%    0.02%    0.10%
 3827 root     sudo /usr/bin/python /var/w    0.00%    0.02%    0.03%    0.17%
 1688 _rpc     /sbin/rpcbind -f -w            0.00%    0.03%    0.03%    0.15%
10708 root     su -                           0.00%    0.03%    0.03%    0.16%
 8789 llaumgui sshd: llaumgui@pts/0           0.00%    0.01%    0.05%    0.22%
 2323 root     /usr/sbin/sshd -D              0.00%    0.04%    0.06%    0.27%
 2316 ntp      /usr/sbin/ntpd -p /var/run/    0.00%    0.06%    0.06%    0.16%
 2211 messagebus /usr/bin/dbus-daemon --syst    0.00%    0.06%    0.07%    0.19%
 7745 root     sshd: llaumgui [priv]          0.00%    0.01%    0.07%    0.36%
 2221 root     /sbin/wpa_supplicant -u -s     0.00%    0.08%    0.08%    0.22%
 2232 root     /usr/lib/bluetooth/bluetoot    0.00%    0.07%    0.08%    0.24%
 2718 root     /sbin/dhclient -d -q -sf /u    0.03%    0.08%    0.08%    0.20%
 1404 root     /lib/systemd/systemd-udevd     0.01%    0.08%    0.09%    0.22%
 2205 root     /lib/systemd/systemd-logind    0.00%    0.06%    0.09%    0.31%
 8658 llaumgui (sd-pam)                       0.24%    0.06%    0.09%    0.19%
 2466 root     /usr/lib/policykit-1/polkit    0.00%    0.05%    0.10%    0.29%
11018 root     -bash                          0.00%    0.08%    0.11%    0.24%
 8794 llaumgui -bash                          0.00%    0.08%    0.11%    0.24%
    1 root     /sbin/init                     0.26%    0.05%    0.13%    0.41%
 2196 root     /usr/sbin/rsyslogd -n -iNON    0.04%    0.15%    0.16%    0.25%
 8657 llaumgui /lib/systemd/systemd --user    0.00%    0.10%    0.16%    0.42%
 2974 root     /usr/sbin/apache2 -k start     0.36%    0.11%    0.24%    1.28%
 9078 www-data /usr/sbin/apache2 -k start     0.32%    0.19%    0.33%    1.86%
 2219 root     /usr/sbin/NetworkManager --    0.03%    0.30%    0.37%    0.70%
 2230 root     /usr/bin/python3 /usr/bin/n    0.07%    0.35%    0.39%    0.72%
 3924 root     /usr/bin/python3 /var/www/h    0.63%    0.40%    0.43%    0.77%
 3624 www-data php /var/www/html/core/clas    1.05%    0.23%    0.45%    1.28%
 1684 root     /lib/systemd/systemd-journa    0.18%    0.43%    0.45%    0.67%
11284 root     /usr/bin/python /usr/bin/sm    0.00%    0.45%    0.47%    0.64%
 2305 root     /usr/bin/python3 /usr/share    0.01%    0.46%    0.51%    0.91%
 3531 root     /usr/bin/python3 /var/www/h    0.98%    0.50%    0.52%    0.85%
 2492 root     /usr/bin/python3 /var/www/h    0.78%    0.59%    0.63%    1.02%
 4155 www-data /usr/bin/python /var/www/ht    0.19%    0.63%    0.67%    0.93%
 3831 root     /usr/bin/python /var/www/ht    0.17%    0.64%    0.67%    0.94%
 2313 root     /usr/bin/python3 /usr/bin/f    0.02%    0.63%    0.67%    1.03%
24154 www-data /usr/sbin/apache2 -k start     0.32%    0.59%    0.69%    1.97%
31186 www-data /usr/sbin/apache2 -k start     0.32%    0.59%    0.70%    2.07%
25672 www-data /usr/sbin/apache2 -k start     0.32%    0.59%    0.71%    2.12%
17650 www-data /usr/sbin/apache2 -k start     0.32%    0.59%    0.72%    2.17%
 4255 www-data php /var/www/html/core/clas    0.53%    0.52%    0.73%    1.56%
17424 www-data /usr/sbin/apache2 -k start     0.32%    0.60%    0.73%    2.19%
30507 www-data /usr/sbin/apache2 -k start     0.32%    0.60%    0.74%    2.26%
  651 www-data /usr/sbin/apache2 -k start     0.32%    0.60%    0.74%    2.22%
22082 www-data /usr/sbin/apache2 -k start     0.32%    0.60%    0.74%    2.28%
23975 www-data /usr/sbin/apache2 -k start     0.32%    0.61%    0.75%    2.28%
 4275 www-data /usr/bin/python /var/www/ht    0.02%    1.27%    1.30%    1.60%
 2295 telegraf /usr/bin/telegraf -config /    0.23%    1.60%    1.60%    1.60%
 3134 www-data /usr/bin/python3 /var/www/h    0.33%    1.72%    1.77%    2.20%
 3755 www-data /var/www/html/plugins/jeedo    0.83%    1.95%    1.98%    2.25%
23682 www-data /usr/bin/python3 /var/www/h    0.00%    2.04%    2.11%    2.56%
 4435 www-data /usr/bin/python /var/www/ht    0.01%    2.30%    2.40%    2.90%
 2456 mysql    /usr/sbin/mysqld              16.88%   18.04%   18.06%   18.23%
-------------------------------------------------------------------------------
   60 9                                      27.21%   41.95%   45.08%   71.98%

J’ai trouvé le problème : https://github.com/armbian/build/blob/master/lib/makeboarddeb.sh#L85

C’est dans Armbian pour Odroid que la swapiness et mise à 100… Du coup je passe à 10 et je remet à 10 à chaque upgrade du kernel.

Ce sujet a été automatiquement fermé après 24 heures suivant le dernier commentaire. Aucune réponse n’est permise dorénavant.