I got a managed database (Mysql). At the moment I use the first package 1CPU, 10GB of space etc. Last few days I am getting a system notification like
*Your mysql service, db-mysql-------, is running low on disk. If your service runs out of disk space, writes will be denied and other functionality could be rendered unavailable. Either delete unnecessary data or upgrade to a larger plan to avoid service outage.
Where can I see the size of my db, just got one. Any other options to avoid upgrading to a more expensive package?
Thanks, G
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Hi KDSys,
I know this dashboard but there is only latency and throughput statistics there. Nothing about hard disk or other data.
Thanks, Giorgos
I had this same question which lead me to this discussion. I too kept going to the insights page and only seeing Throughput and Latency graphs. It wasn’t obvious at first, but I eventually figured it out so putting it here in case original poster still needs help or others stumble on this thread.
There is a menu called “Select Object” just above the Throughput graph, that has a database selected. Use this menu to go up the hierarchy and select the server. Here you’ll see other information about CPU, Load, Memory and Disk.
I am getting the same warning message on my managed database (MySQL) - / 2 GB RAM / 1vCPU / 25 GB Disk / Primary only / NYC3 - MySQL 8
I have sent several support requests by=ut they keep reverting back with same message as the warning, no help at all.
I just want to see the information on disk space used, but no luck at all! This is becoming pain with the managed database.
Hi @Giroin,
You can SSH to your droplet doing
ssh root@DropletIp
To check the current disk size available as a whole on your droplet, type in the following
df -h
You’ll receive an output looking like this
Filesystem Size Used Avail Use% Mounted on
udev 481M 0 481M 0% /dev
tmpfs 99M 592K 98M 1% /run
/dev/vda1 25G 1.6G 23G 7% /
tmpfs 493M 0 493M 0% /dev/shm
tmpfs 5.0M 0 5.0M 0% /run/lock
tmpfs 493M 0 493M 0% /sys/fs/cgroup
/dev/vda15 105M 3.6M 101M 4% /boot/efi
tmpfs 99M 0 99M 0% /run/user/0
The main disk partion is / - /dev/vda1. Now the above example is with a newly created droplet so you might have more Disk Used.
Now to check how much disk space your MySQL is actually using type in
du -sh /var/lib/mysql
This will check provide you with the MySQL’s folder size.
Regards, KDSys
This comment has been deleted