High volume usage but i have only a small dump
samson
HOBBYOP

7 months ago

Hey, i have a mysql database on railway and i wanted to import a dump via dbeaver.
But when i want to import it i get following error:
dbeaver import ERROR 1114 (HY000) at line 2170: The table 'xy' is full

I then saw that the usage iss nearly 500MB but the dump is only 25MB large.
How can this be?

And can i wipe the volume to retry the import?

ID: 24415e1c-9ff5-4133-b834-05af53c29590

Solved

10 Replies

samson
HOBBYOP

7 months ago

okay i solved it but now my db is at max usage.

samson
HOBBYOP

7 months ago

can't see why

samson
HOBBYOP

7 months ago

db largest table is 126MB and the rest is like 2MB

samson
HOBBYOP

7 months ago

my volume is 1GB large

samson
HOBBYOP

7 months ago

even here it says 244MB

1367296737840074800

samson
HOBBYOP

7 months ago

1367296912008413400

brody
EMPLOYEE

7 months ago

there are many contributing factors to disk usage outside of raw data in the table, such as indexes, and Wal files, amoung many other things.

samson
HOBBYOP

7 months ago

Ahh okay! So it could shrink again

brody
EMPLOYEE

7 months ago

If you clear out data, yes, absolutely!

brody
EMPLOYEE

7 months ago

!s

Status changed to Solved brody • 7 months ago

Loading...