Resolve Disk Issue on AWS RDS MYSQL

I was having a lot of trouble with my RDS instances running MySql 5.1 with respect to the disk usage ,

they were 40 GB instances and were almost full thought deletion of unused records was taking no effect on the RDS console monitoring screen for the disk space 

there were no binary logs , late query logs , general logs ,every thing was appearing to be good but server was restricting operations on tables due to disk space shortage . 

i tried to delete unused data but what i got that the freeable space is increased by the disk space was having same issues i checked into specific tables for their sized by using query 

SELECT table_name "Table Name",

SUM( data_length + index_length ) / 1024 /

1024 "Table Size in MB",

SUM( data_free )/ 1024 / 1024 "Free Space in MB"

FROM information_schema.TABLES where table_schema='test-socerwar'

GROUP BY table_NAME

order by data_length desc;

here I found the tables which were having large free able memory and after running the command 

Optimize table  TABLENAME

 for those specific tables , every thing turned to be good for me.

hope it will help others who are new to  MySQL like Me.