NetBackup for MySQL Agent
Licensing for MySQL is specific to the DataStore policy for protecting MySQL Instances. NetBackup collects the data for any MySQL backup that can be restored.
In the case of MySQL, the sizing information is gathered by listing the size of the Instance data directory of MySQL.
The following commands and queries are used to verify the size that the accurate licensing method reports:
Windows platform
Lists the files on the system and their sizes.
Dir <Instance data directory>
Get the database size using MySQL query.
SELECT ROUND(SUM(data_length + index_length), 1) FROM information_schema.tables WHERE table_schema = 'DBNAME' GROUP BY table_schema;
Linux Platform
Lists the files on the system and their sizes.
ls <Instance data directory>
Get the database size using MySQL query.
SELECT ROUND(SUM(data_length + index_length), 1) FROM information_schema.tables WHERE table_schema = 'DBNAME' GROUP BY table_schema;