System volume root's usage is 82%. Mysql seems to be the offender… ReadyNAS 202

[themediapot]

Hi there,

I have been getting this email alert for the past few days, and have been looking through the forum for past guidance over the last few days.  But as of today it has gone to 87% from 80% a few days ago, so I'm starting to to get worried.

I've run df -h and du -hxm --max-depth=1 . | sort -h to identify what may be the offending directories/files.  And it looks like /var/lib/mysql may be the one:

df -h:

udev 10M 4.0K 10M 1% /dev
/dev/md0 3.7G 3.1G 469M 87% /
tmpfs 1009M 8.0K 1009M 1% /dev/shm
tmpfs 1009M 480K 1009M 1% /run
tmpfs 505M 284K 505M 1% /run/lock
tmpfs 1009M 0 1009M 0% /sys/fs/cgroup
/dev/md127 3.7T 2.5T 1.2T 69% /data
/dev/md127 3.7T 2.5T 1.2T 69% /home
/dev/md127 3.7T 2.5T 1.2T 69% /apps

du -hxm --max-depth=1 . | sort -h:

1 ./connman
1 ./dbus
1 ./initscripts
1 ./insserv
1 ./libuuid
1 ./logrotate
1 ./mdadm
1 ./misc
1 ./mysql-files
1 ./nfs
1 ./nut
1 ./pam
1 ./php5
1 ./replisync
1 ./snmp
1 ./systemd
1 ./ucf
1 ./update-rc.d
1 ./urandom
1 ./vim
3 ./samba
16 ./dpkg
70 ./apt
77 ./collectd
416 ./clamav
1678 ./mysql
2258 .

And just for completeness, /tmp, /opt and /usr don't appear to have anything unusually large in them:

root@node01:/usr# du -hxm --max-depth=1 . | sort -h
1 ./games
1 ./include
1 ./src
4 ./local
26 ./sbin
96 ./share
107 ./bin
223 ./lib
454 .
root@node01:/usr# du -hxm --max-depth=1 /tmp | sort -h
1 /tmp
1 /tmp/.font-unix
1 /tmp/.ICE-unix
1 /tmp/resilio_dumps
1 /tmp/.Test-unix
1 /tmp/.X11-unix
1 /tmp/.XIM-unix
root@node01:/usr# du -hxm --max-depth=1 /opt | sort -h
1 /opt/p2p
1 /opt/readydrop
1 /opt/remote
1 /opt/replication
1 /opt/xcloud
3 /opt/readycloud
12 /opt/ctch
16 /opt
root@node01:/usr# du -hxm --max-depth=1 /usr | sort -h
1 /usr/games
1 /usr/include
1 /usr/src
4 /usr/local
26 /usr/sbin
96 /usr/share
107 /usr/bin
223 /usr/lib
454 /usr

 Can anyone please confirm if mysql is indeed the offender, and if so, what are the remedial action/s?

I appreciate any advice/assistance.

Thank you.

[Michel-jacobs]

Remove loganalyzer, delete /var/lib/mysql

and peer pressure THE author of the Loganalyzer app to write data to data not to to var

[themediapot]

Thank you Michel-Jacobs.  I am pretty sure that I have other programs that uses mysql, like rsyslog.  

BTW, do you have an alternative suggestion for Loganalyzer?

[StephenB]

You can also try moving mysql to the data volume (perhaps replacing the /mysql folder with a soft link when you are done).