Related

WordPress database error: [Expression #1 of ORDER BY clause is not in SELECT list... Question Question
Private connection to Managed DB not working from within same region droplet. Question Question

Question

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

Posted December 18, 2019 2k 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

Add a comment
Giroin
By:
Giroin

Related

WordPress database error: [Expression #1 of ORDER BY clause is not in SELECT list... Question Question
Private connection to Managed DB not working from within same region droplet. Question Question

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
thbarrons April 29, 2020

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.

Reply Report
Giroin December 21, 2019

Hi KDSys,

I know this dashboard but there is only latency and throughput statistics there. Nothing about hard disk or other data.

Thanks,
Giorgos

Reply Report
KFSys December 18, 2019

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

Reply Report
  • Giroin December 19, 2019

    Hi,

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

    Thanks,
    G

    Reply Report
    • KFSys December 21, 2019

      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

      Reply Report
waituk7 April 14, 2020

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.

Reply Report
Submit an Answer

Related

Looking for something else?

Ask a new question Search for more help