# Data size

**URL:** <https://forums.percona.com/t/data-size/69>\
**Category:** Other MySQL® Questions\
**Created:** [August 22, 2006, 9:40pm UTC](https://forums.percona.com/t/data-size/69 "2006-08-22T21:40:39Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![mysqlmagyar](https://avatars.discourse-cdn.com/v4/letter/m/da6949/32.png) [@mysqlmagyar](https://forums.percona.com/u/mysqlmagyar)\
**Post date:** [August 22, 2006, 9:40pm UTC](https://forums.percona.com/t/data-size/69/1 "2006-08-22T21:40:39Z")

</div>

Hello,

I was wondering how to determine the total size of the data contained in tables (tables + indices).  
I am using only InnoDB tables and my /etc/my.cnf contains the following relevant items:

innodb\_data\_file\_path = ibdata1:1700M;ibdata2:10M:autoextend

Now in my mysql data directory  
1.7G Aug 22 20:05 mysql-home/data/ibdata1

Obviously this file was created upon starting mysql for the first time, irrespective of the data (which I’m sure is smaller than 1.7G)

I want to know what part of ibdata1 is “in use”.  
Kind of basic question I know, and I can guess that somewhere the answer is in SHOW INNODB STATUS, but I couldn’t find it in the documentation or deduce it myself.

Thanks.

P.S. just curious, what HTML editor are you using in this site?  
Pretty cool.

---

<div class="post-metadata">

**Author:** ![Peter](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/peter/32/2_2.png) [@Peter](https://forums.percona.com/u/Peter)\
**Post date:** [August 23, 2006, 9:27am UTC](https://forums.percona.com/t/data-size/69/2 "2006-08-23T09:27:05Z")

</div>

Run SHOW TABLE STATUS, in the Comment field there will be the message saying how much space is free in Innodb tablespace, so you can compute how much is busy.

From the same statement output you can see sizes for data and index for individual tables adding these up is yet another way.

This site use FUDForum, I’m not sure what you mean by HTML editor.

---

<div class="post-metadata">

**Author:** ![mysqlmagyar](https://avatars.discourse-cdn.com/v4/letter/m/da6949/32.png) [@mysqlmagyar](https://forums.percona.com/u/mysqlmagyar)\
**Post date:** [August 23, 2006, 10:54am UTC](https://forums.percona.com/t/data-size/69/3 "2006-08-23T10:54:25Z")

</div>

Yes, SHOW TABLE STATUS is just what I need.

Thanks.

BTW The HTML Editor is the gui “control” that you type the posts in (with the Bold, Italic, et al buttons). There are a variety out there, I just hadn’t seen one exactly like this.