0

We are deleting data from the EAV Table. We want to estimate how much of the data has been deleted from mysql table. As of now 20GB of data is deleted. Is it exactly equal to the mysql table data size or more/less ?

Santhosh Tangudu
  • 759
  • 9
  • 19
  • http://stackoverflow.com/questions/9620198/how-to-get-the-sizes-of-the-tables-of-a-mysql-database – cetver Aug 14 '15 at 10:49
  • I know how to findout the sizes of the table. when you insert 20GB of data (using load command) into mysql, will the size of the table get increased or decreased ? – Santhosh Tangudu Aug 14 '15 at 10:52
  • 1 select table size 2 delete data 3 select table size – cetver Aug 14 '15 at 10:55
  • until we run optimize on table, it will not claim the space back. I can do these steps. But before doing that, can we estimate the size of the table ? – Santhosh Tangudu Aug 14 '15 at 11:45

0 Answers0