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=gcdmg-mysql-2 [at] m.gmane.org
