MySQL database 'Disk is full'
Started to get the error below, what's wrong?
2024-01-22T16:56:50.873312Z 9 [ERROR] [MY-000035] [Server] Disk is full writing './binlog.000006' (OS errno 28 - No space left on device). Waiting for someone to free space... Retry in 60 secs. Message reprinted in 600 secs.
Solution:Jump to solution
you would want to upgrade to pro so you could then grow your volume to 50gb and successfully restart your database
27 Replies
Project ID:
f38b84de-cc94-4845-a0c3-3dfcb1f9d42f
f38b84de-cc94-4845-a0c3-3dfcb1f9d42f
what does the graph for disk (volume) usage look like?
that's the service metrics, please click on the volume to view the volume usage
Where is that?
the volume is attached to the service block on the canvas, looks like a little tab and will say something like "mysql data"
yep definitely out of storage
So my plan support 5gb of data?
that's correct, can you tell me the start command your database is using? that would be in the service settings
docker-entrypoint.sh mysqld --innodb-use-native-aio=0
then we might be able to regain some of that storage
My plan doesn't show any where that there is a limit of 5gb??
the hobby plan has a 5gb volume limit
The other plans?
the pro plan has a 50gb volume limit
is your database crashed?
Yes
ah then unfortunately we are to late to be able to free disk space because the database needs to be active
Solution
you would want to upgrade to pro so you could then grow your volume to 50gb and successfully restart your database
50gb per each database?
correct!
Thanks
50gb volume per any service actually
Thanks for quick reply
no problem, after you upgrade if you need any specific help growing your database's volume I'll be around
since it's a manual process
Thanks