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.

×
4 answers

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.

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

  • Hi,

    This is about DO managed database, it’s not actually located on the droplet.

    Thanks,
    G

    • Hi @Giroin,

      Please excuse me for overlooking this, so in this case you’ll to check that you could do the following:

      1. Go to your control panel at https://cloud.digitalocean.com/
      2. Then go to your managed database instance
      3. Click on ‘Insights’ then from the dropdown choose the name of your cluster

      There you would be able to see all kinds of different metrics including your disk usage.

      Regards,
      KDSys

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.

Submit an Answer