MySQL Forums
Forum List  »  InnoDB

Data length for INNODB tables
Posted by: priya ram
Date: February 14, 2018 01:05AM

I need to calculate total space,used space and free space for a table. For this I have used "Data_length","Data_free" columns of information_schema.tables.

As per Mysql documemtation data_length column gives the clustered index length in pages.

But I have not created index on that table.Soon after creating the table the data_length column shows 16384 bytes.

Also after deleting more rows from the table "data_free" column gives value zero.

The storage engine for the table is INNODB.

How to calculate exact total space,used space and free space for a table ?

Options: ReplyQuote


Subject
Views
Written By
Posted
Data length for INNODB tables
1889
February 14, 2018 01:05AM
771
February 14, 2018 12:19PM
818
February 19, 2018 07:52AM
608
February 19, 2018 01:50PM
712
February 21, 2018 06:50AM
706
February 22, 2018 03:13AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.