Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
mysql fills up disk (too much)
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Other Things Gentoo
View previous topic :: View next topic  
Author Message
JeroenV
Guru
Guru


Joined: 16 Jul 2002
Posts: 447
Location: Amsterdam / Hamburg

PostPosted: Mon Oct 28, 2002 9:08 am    Post subject: mysql fills up disk (too much) Reply with quote

Hi,

I'm having a weird problem here. I try to put a large database in mysql from a bzip2 archive like so:
Code:

bzcat /share/dbarchive/mydb_dump.bz2 | mysql -u info -p mydb

The archive is approx. 100M and I seem to remember the mysql database should be around 500M on disk, though after a while, about 900M of diskspace has disappeared, but the database at that point is only about 300M:?: :!:

The problem is, that I run out of diskspace on / faster than /var/lib/mysql/mydb grows.
When I checked, there was a 900M /var/log/mysql/mysql.log file :!:
I aborted, deleted mydb, did a
Code:

ln -s /dev/null /var/log/mysql/mysql.log

and started allover.
Now I still the same problem, though I can't seem to track what fills up the disk so fast, it's not the database itself...

Some info:
/, /var, /usr are on the same partition, other partitions are not affected (and of course shouldn't be!)

Any ideas?

Cheers 8)
_________________
Cheers 8)
Jeroen
~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~
May The Source be with you!
Back to top
View user's profile Send private message
rac
Bodhisattva
Bodhisattva


Joined: 30 May 2002
Posts: 6553
Location: Japanifornia

PostPosted: Mon Oct 28, 2002 9:20 am    Post subject: Reply with quote

You could try turning logging off in /etc/mysql/my.cnf.
_________________
For every higher wall, there is a taller ladder
Back to top
View user's profile Send private message
JeroenV
Guru
Guru


Joined: 16 Jul 2002
Posts: 447
Location: Amsterdam / Hamburg

PostPosted: Mon Oct 28, 2002 9:45 am    Post subject: Reply with quote

Hi,

I turned logging off, on first sight the problem doesn't seem to be solved, though I have no time to test further now...(will be away for a few days)
I'll check back later...

Cheers 8)
_________________
Cheers 8)
Jeroen
~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~
May The Source be with you!
Back to top
View user's profile Send private message
rac
Bodhisattva
Bodhisattva


Joined: 30 May 2002
Posts: 6553
Location: Japanifornia

PostPosted: Mon Oct 28, 2002 10:00 am    Post subject: Reply with quote

There's also the error log.
_________________
For every higher wall, there is a taller ladder
Back to top
View user's profile Send private message
Roc
n00b
n00b


Joined: 19 Jul 2002
Posts: 35

PostPosted: Wed Oct 30, 2002 7:35 pm    Post subject: Reply with quote

rac wrote:
You could try turning logging off in /etc/mysql/my.cnf.


How can I do that?

By setting log=/dev/null ?

Is there any better way? I read the manual but didn't get it...
Back to top
View user's profile Send private message
rac
Bodhisattva
Bodhisattva


Joined: 30 May 2002
Posts: 6553
Location: Japanifornia

PostPosted: Thu Oct 31, 2002 2:46 am    Post subject: Reply with quote

I think just commenting out the "log = " line in /etc/mysql/my.cnf should do it.
_________________
For every higher wall, there is a taller ladder
Back to top
View user's profile Send private message
Roc
n00b
n00b


Joined: 19 Jul 2002
Posts: 35

PostPosted: Thu Oct 31, 2002 9:19 am    Post subject: Reply with quote

rac wrote:
I think just commenting out the "log = " line in /etc/mysql/my.cnf should do it.


No, I think this doesn't work since the default destination (location of databases) would be used for logging then - this is what the manual says.
Back to top
View user's profile Send private message
rac
Bodhisattva
Bodhisattva


Joined: 30 May 2002
Posts: 6553
Location: Japanifornia

PostPosted: Thu Oct 31, 2002 11:42 am    Post subject: Reply with quote

I'm working off 4.9.2 The General Query Log.
_________________
For every higher wall, there is a taller ladder
Back to top
View user's profile Send private message
Roc
n00b
n00b


Joined: 19 Jul 2002
Posts: 35

PostPosted: Fri Nov 01, 2002 10:21 am    Post subject: Reply with quote

rac wrote:
I'm working off 4.9.2 The General Query Log.


Yes, you're right, it works. I had an older version of the manual installed locally, where it was described differently.

Thanks
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Other Things Gentoo All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum