Gentoo Archives: gentoo-user

From: Jarry <mr.jarry@×××××.com>
To: gentoo-user@l.g.o
Subject: [gentoo-user] A lot of big files in /var/lib/mysql/ => /var full!
Date: Fri, 23 Apr 2010 16:26:09
Message-Id: 4BD1CA06.6010207@gmail.com
1 Hi,
2 today I discovered mysql is slowly eating my disk space!
3 Actually, one web-server already had /var 98% full.
4
5 After a little search I found more than 200 files in
6 /var/lib/mysql/mysqld-bin.000001 -~ 000214 of various
7 size, but together take ~10GB of disk space. Yet phpmyadmin
8 shows I have only one database ~15MB. So what is all this
9 mysqld-bin.* crap doing in /var/lib/mysql? I increased
10 /var, but it does not solve the problem. How can I prevent
11 mysql from filling up my whole /var partition?
12
13 I looked into /var/log/mysql, mysql.err and mysql.log
14 are empty, in mysqld.err there are these messages:
15 -------------------
16 100423 15:47:05 [Warning] No argument was provided to --log-bin, and
17 --log-bin-index was not used; so replication may break when this MySQL
18 server acts as a master and has his hostname changed!! Please use
19 '--log-bin=mysqld-bin' to avoid this problem.
20 InnoDB: The InnoDB memory heap is disabled
21 InnoDB: use atomic builtins.
22 100423 15:47:05 InnoDB: Started; log sequence number 0 43715
23 100423 15:47:05 [Note] /usr/sbin/mysqld: ready for connections.
24 Version: '5.0.90-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306
25 Gentoo Linux mysql-5.0.90-r2
26 -------------------
27
28 I must admit I didt not play with mysql configutation much,
29 just followed gentoo MySQL Startup Guide and everything
30 seemed to work...
31
32 Jarry
33
34 --
35 _______________________________________________________________
36 This mailbox accepts e-mails only from selected mailing-lists!
37 Everything else is considered to be spam and therefore deleted.

Replies

Subject Author
Re: [gentoo-user] A lot of big files in /var/lib/mysql/ => /var full! Paul Hartman <paul.hartman+gentoo@×××××.com>
Re: [gentoo-user] A lot of big files in /var/lib/mysql/ => /var full! kashani <kashani-list@××××××××.net>