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.
P.S. just curious, what HTML editor are you using in this site?