root@db01.ecc /home/f.seidel # mysql Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 36216776 Server version: 10.3.16-MariaDB-log MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> show master status; +------------------+-----------+--------------+------------------+ | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | +------------------+-----------+--------------+------------------+ | mysql-bin.000658 | 852412937 | | | +------------------+-----------+--------------+------------------+ 1 row in set (0.038 sec) MariaDB [(none)]> purge binary logs to 'mysql-bin.000658'; Query OK, 0 rows affected (2.139 sec) MariaDB [(none)]> Bye root@db01.ecc /home/f.seidel # df -h Filesystem Size Used Avail Use% Mounted on /dev/vda1 4.8G 1.7G 3.0G 36% / devtmpfs 3.9G 0 3.9G 0% /dev tmpfs 3.9G 0 3.9G 0% /dev/shm tmpfs 3.9G 202M 3.7G 6% /run tmpfs 3.9G 0 3.9G 0% /sys/fs/cgroup /dev/vdc1 4.8G 278M 4.3G 6% /var /dev/vdd1 4.8G 135M 4.4G 3% /var/log /dev/vde 59G 19G 39G 33% /var/lib/mysql tmpfs 783M 0 783M 0% /run/user/286100510 root@db01.ecc /home/f.seidel # VG Felix -------- Weitergeleitete Nachricht -------- Betreff: ** PROBLEM Service: db01.ecc.xres.rz1.xtrav.de/Disk_MySQL is WARNING ** Datum: Sat, 1 Feb 2020 11:36:21 +0100 (CET) Von: nagios@monitor01.app.infra.rz1.xtrav.de An: f.seidel@traso.de Service: Disk_MySQL Host: db01.ecc.xres.rz1.xtrav.de Hostalias: db01.ecc State: WARNING Address: 10.21.7.31 Info: DISK WARNING - free space: /var/lib/mysql 11438 MB (19.87% inode=100%): Date/Time: Sat Feb 1 11:36:21 CET 2020