Top community members
All Wiki Articles Create Wiki Article

In the past we had a dream,
to have place where we could share IT knowledge,
to ask questions without fear that someone will judge us.

Now we are a group of people who make this dream come true. ❤ 💻

If you think sharing knowledge and helping other is valuable.

join our community - Click here

MySQL - how to check database size?

0 contributions
14 points

Using MySQL querry it is possible to check database size in following way.

1. Size in bytes query example

SELECT 
  `table_schema` AS 'database_name',
  SUM(data_length + index_length) AS 'database_size' 
FROM `information_schema`.`tables `
GROUP BY `table_schema`;

Result:

Database size in bytes MySQL query example - HeidiSQL
Database size in bytes MySQL query example - HeidiSQL

2. Size in kilobytes query example

SELECT 
  `table_schema` AS 'database_name',
  ROUND(SUM(data_length + index_length) / 1024, 2) AS 'database_size' 
FROM `information_schema`.`tables`
GROUP BY `table_schema`;

Result:

Database size in kilobytes MySQL query example - HeidiSQL
Database size in kilobytes MySQL query example - HeidiSQL

2. Size in megabytes query example

SELECT 
  `table_schema` AS 'database_name',
  ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS 'database_size' 
FROM `information_schema`.`tables`
GROUP BY `table_schema`;

Result:

Database size in megabytes MySQL query example - HeidiSQL
Database size in megabytes MySQL query example - HeidiSQL
0 contributions

Checkout latest Findings & News:

Checkout latest questions:

Checkout latest wiki articles:

Hey 👋
Would you like to know what we do?
  • Dirask is IT community, where we share coding knowledge and help each other to solve coding problems.
  • We welcome everyone,
    no matter what the experience,
    no matter how basic the question is,
    this community will help you.
Read more