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. |