Stating mysql table sizes in all databases, I found something surprising, my database size had grown a lot though really I did not pay attention to site, and site went down, after investigation, I figured it is the database backup size since I 'm keeping several backups regularly, several tables were dubious, I stated the Log table, and found there were over 2 million records which are not necessary most of the time, then how about the other tables? below script can stat out all table sizes in mysql
```
SELECT TABLE_SCHEMA AS `Database`,
TABLE_NAME AS `Table`,
ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024) AS `Size (MB)`
FROM information_schema.TABLES
ORDER BY (DATA_LENGTH + INDEX_LENGTH) DESC;
```
, when I was not noticing, they have grown a lot, the tables, I am paying attention, mainteining,,,