| 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.
|
|
|
| Re: Data size [message #101 is a reply to message #97 ] |
Wed, 23 August 2006 10:57  |
 Peter
Messages: 405
Registered: August 2006 |
Senior Member
Super Guru |
|
|
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.
Peter Zaitsev, MySQL Performance Expert
MySQL Performance Blog - http://www.mysqlperformanceblog.com
MySQL Consulting http://www.mysqlperformanceblog.com/mysql-consulting/
|
|
|
| Re: Data size [message #105 is a reply to message #101 ] |
Wed, 23 August 2006 12:24 |
mysqlmagyar
Messages: 4
Registered: August 2006 |
Junior Member |
|
|
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.
|
|
|
|
Members
Search
Help
Register
Login
Home
