Adarsh Sharma How to know Data Size through Scripts
Mar 14, 2011; 12:41
Adarsh Sharma
How to know Data Size through Scripts
Dear all,
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 :
SELECT 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,
Adarsh Sharma
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=listsearcharchive@lassosoft.com
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!