MySQL Performance: MySQL => Data size

Data size [message #97]

Tue, 22 August 2006 23:10

mysqlmagyar
Messages: 4
Registered: August 2006

Junior Member

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.

Report message to a moderator