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

JFrog Support
2016-10-06 13:35

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