T
T
Thomas Andersen2014-03-24 10:04:49
MySQL
Thomas Andersen, 2014-03-24 10:04:49

How to fix the error - The partition with /var/lib/mysql?

I use Zabbix 2.2
MySQL database filled the entire disk with itself, most of all it takes history.
On restart or next start it gives
Error: The partition with /var/lib/mysql
df -h
rootfs 129G 123G 0 100% /
udev 10M 0 10M 0% /dev
tmpfs 2.4G 204K 2.4G 1% /run
/dev/ mapper/zbx-root 129G 123G 0 100% /
tmpfs 5.0M 0 5.0M 0% /run/lock
tmpfs 4.8G 0 4.8G 0% /run/shm
/dev/cciss/c0d0p1 228M 15M 201M 7% /boot
tmpfs 5.9G 0 5.9G 0% /
tmp
I also looked through the winscp folder properties, they take up a lot of space.

Answer the question

In order to leave comments, you need to log in

3 answer(s)
@
@mgyk, 2014-03-24
_

Check if the mysql logs take up a lot of space. Then you can beat the oldest ones.

T
Thomas Andersen, 2014-03-24
@32neo32

I checked, it's not in the logs, they are 7 megabytes each and there are 7 of them in total ...)

R
Rsa97, 2014-03-24
@Rsa97

Connect another HDD, transfer /var/lib/mysql to it and mount to this path

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question