Question

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

Posted December 18, 2019 393 views
DigitalOcean Managed MySQL Database

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.

×
2 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

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

Submit an Answer