Where to see information about my managed Mysql DB size etc.

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


This comment has been deleted

Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

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