techfolks mysql tutorials
db size query Mysql Mysql database query query to get db size

How to Get Size of a Database in Mysql

To Get Data Base Size in MB  and Free Space in MB
SELECT table_schema “dbName”,
    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 ;

To Get Size in GB:

SELECT  sum(round(((data_length + index_length) / 1024 / 1024 / 1024), 2))  as “Size in GB” FROM information_schema.TABLES  WHERE table_schema = “dbName”

Found on Stackoverflow.

Related Articles

techfolks mysql tutorials
Mysql

How to Add Column to Mysql Table and Auto Increment with Primary Key

viveik

Check below on How to Add a Column to Mysql Table with Auto Increment and Primary Key You can achieve it by doing Alter Command: Add Column to Mysql To Modify Column and add Auto Increment with Primary Key Query: ALTER TABLE test MODIFY COLUMN ID INT(10) PRIMARY KEY  auto_increment; ALTER TABLE users ADD id […]

techfolks mysql tutorials
Mysql

MySQL Offset Limit Data Selections

viveik

MySQL provides a LIMIT clause that is used to specify the number of records to return. The LIMIT clause makes it easy to code multi page results or pagination with SQL, and is very useful on large tables. Assume we wish to select all records from 1 – 30 (inclusive) from a table called “Orders”. […]
Mysql

Decimal(5,3) in Mysql is always 99.999

viveik

The maximum value for decimal(5,3) is 99.999, it means 5 digits with 3 digits after decimal, and whenever you try to insert or update more than 99.999 value it is automatically capped to 9.99 in mysql. This Try decimal(5, 2) Decimal(5,3) is used for financial values or less than 100% values. If you want to […]