How do I identify the Artifactory DB schema tables size in MySQL?

How do I identify the Artifactory DB schema tables size in MySQL?

AuthorFullName__c
JFrog Support
articleNumber
000001426
ft:sourceType
Salesforce
FirstPublishedDate
2016-10-06T13:35:46Z
lastModifiedDate
2016-10-06
VersionNumber
5

If you want to identify the Artifactory DB schema tables size in MySQL, you can query the schema tables as in the following examples:

 

For a specific table (e.g. binaries) you can use the following query

SELECT table_name AS "Table", round(((data_length + index_length) / 1024 / 1024), 2) "Table size in MB" FROM information_schema.TABLES WHERE table_schema = "artdb" AND table_name = "binaries";


For all of the tables in the 'artdb' schema, you can use the following query

SELECT table_name AS "Table", round(((data_length + index_length) / 1024 / 1024), 2) "MB" FROM information_schema.TABLES WHERE table_schema = "artdb";