Sql

Search

List MySQL Table and Index Size

MariaDB [(none)]> SELECT table_schema "DB Name", Round(Sum(data_length + index_length) / 1024 / 1024, 1) "DB Size in MB"
 FROM information_schema.tables
 GROUP BY table_schema;
+--------------------+---------------+
| DB Name            | DB Size in MB |
+--------------------+---------------+
| hope               |       75714.0 |
| information_schema |           0.2 |
| mysql              |           1.9 |
| performance_schema |           0.0 |
+--------------------+---------------+

Comment

PREVIOUS	NEXT

Code Example
Sql :: sql max count
Sql :: order by in codeigniter query builder
Sql :: what is top n result in sql
Sql :: convert Date to LocalDate via SQLDate
Sql :: mysql select smaller of two values
Sql :: mysql copy row with new id
Sql :: sql into
Sql :: postgres create trigger if not exists
Sql :: systems sql
Sql :: select indexname psql
Sql :: oracle list partitions
Sql :: mysql preg replace
Sql :: postgresql between
Sql :: mysql trim characters
Sql :: create user in mysql
Sql :: mysql shell set time_zone
Sql :: find the names of sailors who have reserved at least one boat
Sql :: create database with hyphen sign mysql
Sql :: trigger sql server
Sql :: psql view databases
Sql :: Should I use the datetime or timestamp data type in MySQL?
Sql :: load a log file in that format into MySQL
Sql :: timestamp type in sql
Sql :: where keyword sql
Sql :: postgresql functions
Sql :: delete from where sql
Sql :: how to use 3 fields as primary key in sql tables?
Sql :: postgres type equivalent to timespan c#
Sql :: psql fetch all rows with null
Sql :: mysql set variable in a session

Search

SQL

List MySQL Table and Index Size

ADD CONTENT