# Total DB Size and Table

**URL:** <https://forums.percona.com/t/total-db-size-and-table/3750>\
**Category:** Percona Toolkit\
**Created:** [September 18, 2014, 2:04am UTC](https://forums.percona.com/t/total-db-size-and-table/3750 "2014-09-18T02:04:27Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![nima0102](https://avatars.discourse-cdn.com/v4/letter/n/dec6dc/32.png) [@nima0102](https://forums.percona.com/u/nima0102)\
**Post date:** [September 18, 2014, 2:04am UTC](https://forums.percona.com/t/total-db-size-and-table/3750/1 "2014-09-18T02:04:27Z")

</div>

Hi eveybody,

Does pt-toolkit have any command or option to view size of databases and tables? I could not fine such command or option in pt-toolkit package.

Thanks in advance

---

<div class="post-metadata">

**Author:** ![scott.nemes](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/scott.nemes/32/5_2.png) [@scott.nemes](https://forums.percona.com/u/scott.nemes)\
**Post date:** [September 18, 2014, 9:41am UTC](https://forums.percona.com/t/total-db-size-and-table/3750/2 "2014-09-18T09:41:18Z")

</div>

Hi Nima0102;

There is no specific tool that I know of to show table data size.

You can get an estimate from within MySQL using the following query:

SELECT table\_name AS “Table”,round(((data\_length + index\_length) / 1024 / 1024), 2) “Size in MB” FROM information\_schema.TABLES WHERE table\_schema = “DB\_NAME” AND table\_name = “TABLE\_NAME”;

This data also shows up if you run “show table status like ‘TABLE\_NAME’”.

Note that it is just an estimate, and could vary quite a bit depending on how accurate the internal statistics are currently.

-Scott