I am research on several commands through which I can monitor the size
of specific data of tables in different . I want to write a script that
fetches the data of different database tables & databases too daily and
write it into a file .
Is there is any way or commands to achieve this.
I researched a lot , I find commands as :
CONCAT(sum(ROUND(((DATA_LENGTH + INDEX_LENGTH - DATA_FREE) / 1024 /
1024),2))," MB") AS Size FROM INFORMATION_SCHEMA.TABLES where
TABLE_SCHEMA like 'abc' ;
Is there is any simple commands to know this.
Thanks & best Regards,
|• How to know Data Size through Scripts||Adarsh Sharma||14 Mar|