Skip to content
HostFav Blog

HostFav Blog

Cloud Service Provider

Tag: MySQL

Posted on August 11, 2017August 11, 2017

How to Get All Databases Size from MySQL Server

Get all Databases size from MySQL Server

SELECT table_schema "Database Name", 
 Round(Sum(data_length + index_length) / 1024 / 1024, 1) "Size (MB)" 
FROM information_schema.tables 
GROUP BY table_schema;
HostFav

Recent Posts

  • Mount S3 Bucket to Ubuntu Server
  • Proxmox – Delete Disk Image on ZFS storage
  • Mikrotik DDoS Protection
  • Mikrotik Router SYN Flood Protection
  • HostFav’s Cloud VPS – Install Windows

Recent Comments

  • james on Add a new physical hard drive to Proxmox VE 4x 5x
  • Friendly Nigerian on Add a new physical hard drive to Proxmox VE 4x 5x
  • hostfav on Add a new physical hard drive to Proxmox VE 4x 5x
  • Shah Ahmed Raquib on Add a new physical hard drive to Proxmox VE 4x 5x

Archives

  • May 2018
  • February 2018
  • December 2017
  • November 2017
  • October 2017
  • September 2017
  • August 2017
  • July 2017
  • May 2017
  • April 2017
  • March 2017
  • February 2017
  • January 2017
  • February 2016

Categories

  • HostFav
  • HostFav cPanel
  • Troubleshooting
  • Tutorial
  • Uncategorized

Tags

  • AWS (1)
  • Centos (1)
  • CentOS 7 (1)
  • Certificate (1)
  • Command (1)
  • cPanel (1)
  • DFS (1)
  • DNS (2)
  • Email (1)
  • Error (1)
  • GitLab (1)
  • GoDaddy (1)
  • HostFav (1)
  • KVM (3)
  • Letsencrypt (2)
  • Linux (3)
  • Locked (1)
  • LXC (3)
  • MySQL (1)
  • Nagios (1)
  • Proxmox (9)
  • RDNS (1)
  • Replication (1)
  • S3 Bucket (1)
  • Script (1)
  • SFTP (1)
  • Shell (1)
  • SSH (2)
  • SSL (3)
  • Storage (1)
  • Ubuntu (4)
  • VMware (1)
  • Webmin (1)
  • Windows (2)
  • HostFav FaceBook
  • HostFav Twitter
Proudly powered by WordPress