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

10 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

10 months ago

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

samson
HOBBYOP

10 months ago

can't see why

samson
HOBBYOP

10 months ago

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

samson
HOBBYOP

10 months ago

my volume is 1GB large

samson
HOBBYOP

10 months ago

even here it says 244MB

1367296737840074800

samson
HOBBYOP

10 months ago

1367296912008413400

brody
EMPLOYEE

10 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

10 months ago

Ahh okay! So it could shrink again

brody
EMPLOYEE

10 months ago

If you clear out data, yes, absolutely!

brody
EMPLOYEE

10 months ago

!s

Status changed to Solved brody • 10 months ago

Loading...