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

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";