View previous topic :: View next topic |
Author |
Message |
JeroenV Guru
Joined: 16 Jul 2002 Posts: 447 Location: Amsterdam / Hamburg
|
Posted: Mon Oct 28, 2002 9:08 am Post subject: mysql fills up disk (too much) |
|
|
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 _________________ Cheers
Jeroen
~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~
May The Source be with you! |
|
Back to top |
|
|
rac Bodhisattva
Joined: 30 May 2002 Posts: 6553 Location: Japanifornia
|
Posted: Mon Oct 28, 2002 9:20 am Post subject: |
|
|
You could try turning logging off in /etc/mysql/my.cnf. _________________ For every higher wall, there is a taller ladder |
|
Back to top |
|
|
JeroenV Guru
Joined: 16 Jul 2002 Posts: 447 Location: Amsterdam / Hamburg
|
Posted: Mon Oct 28, 2002 9:45 am Post subject: |
|
|
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 _________________ Cheers
Jeroen
~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~
May The Source be with you! |
|
Back to top |
|
|
rac Bodhisattva
Joined: 30 May 2002 Posts: 6553 Location: Japanifornia
|
Posted: Mon Oct 28, 2002 10:00 am Post subject: |
|
|
There's also the error log. _________________ For every higher wall, there is a taller ladder |
|
Back to top |
|
|
Roc n00b
Joined: 19 Jul 2002 Posts: 35
|
Posted: Wed Oct 30, 2002 7:35 pm Post subject: |
|
|
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 |
|
|
rac Bodhisattva
Joined: 30 May 2002 Posts: 6553 Location: Japanifornia
|
Posted: Thu Oct 31, 2002 2:46 am Post subject: |
|
|
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 |
|
|
Roc n00b
Joined: 19 Jul 2002 Posts: 35
|
Posted: Thu Oct 31, 2002 9:19 am Post subject: |
|
|
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 |
|
|
rac Bodhisattva
Joined: 30 May 2002 Posts: 6553 Location: Japanifornia
|
Posted: Thu Oct 31, 2002 11:42 am Post subject: |
|
|
I'm working off 4.9.2 The General Query Log. _________________ For every higher wall, there is a taller ladder |
|
Back to top |
|
|
Roc n00b
Joined: 19 Jul 2002 Posts: 35
|
Posted: Fri Nov 01, 2002 10:21 am Post subject: |
|
|
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 |
|
|
|