Skip to content
tech.tutulutu.ee
Simple Blog about Tech – written for myself. Use with caution.
  • Home
  • Links
Uncategorized

Show sql database size

Posted July 27, 2016
SELECT table_schema "Data Base Name",
    sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB",
    sum( data_free )/ 1024 / 1024 "Free Space in MB"
FROM information_schema.TABLES
GROUP BY table_schema ; 

Thanks to: http://stackoverflow.com/questions/14714750/how-to-get-true-size-of-mysql-database

Post navigation

Older post
Install node and npm without having to sudo
Newer post
Unpack and import mysql database from *.sql.gz file on command line

Recent Posts

  • Change Moodle domain
  • Get Moodle version
  • How to begin with your code like from scratch in git context
  • Get info about network
  • Git tutorials

Categories

  • Angularjs
  • apache
  • Atom
  • aws
  • bootstrap
  • command-line
  • css
  • docker
  • firefox
  • Git
  • gmail
  • https
  • Java
  • jQuery
  • LAN
  • laravel
  • linux
  • music
  • MySQL
  • network
  • nginx
  • nodejs
  • npm
  • php
  • phpunit
  • printers
  • Python
  • Sailsjs
  • sql
  • ssh
  • SSL and HTTPS
  • thunderbird
  • Uncategorized
  • vim
  • web
  • woocommerce
  • wordpress

Tags

angularjs apache atom aws bootstrap browser command line cron css dns docker dpkg find find file firefox gedit git htaccess html htpasswd https java laravel linux lvm moodle mysql nautilus network nginx npm php phpunit port printers rsync s3cmd scp server ssh ssl thunderbird ubuntu woocommerce wordpress
© 2026 tech.tutulutu.ee
Powered by WordPress | Theme: Graphy by Themegraphy