Astonished, fact I have discovered

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,,,

留下你的评论