Database Size

[spatils]

Hello,

Are there any guidelines to project database size consumed by Alfresco repository?

regards
Sameer

[mrogers]

No.   It depends upon your models and requirements.   The database size is unlikely to be a problem.

[romschn]

I could not understand why are you looking for alfresco database consumption.

Mainly the indexes of the documents in alfresco repository are stored in alfresco database. Actual documents are stored in file system.

However, if you are using mysql as database, I found below 2 queries which you may find useful.

Query-1 - shows size of the database in MB
———

SELECT table_schema "Database name", sum( data_length + index_length ) / 1024 / 1024 "Database size in MB"
FROM information_schema.TABLES GROUP BY table_schema ; ‍‍

Query-2 - shows free space for the database.

SELECT table_schema "Database name",
sum( data_length + index_length ) / 1024 /
1024 "Database size in MB",
sum( data_free )/ 1024 / 1024 "Free space in MB"
FROM information_schema.TABLES
GROUP BY table_schema ; ‍‍‍‍‍‍

Hope this helps.

Thanks,

[spatils]

Thanks For response.

No. It depends upon your models and requirements. The database size is unlikely to be a problem.

I am storing around 50 bytes of custom metadata along with each document.
How much space it would consume / per document in database in this scenario ?

I could not understand why are you looking for alfresco database consumption..

I am planning to store 10 million document in alfresco repository and wondering how much space should I allocate for database.
I am not sure how much data alfresco stores/ per document in the database.

[mrogers]

Give it a couple of G.

[spatils]

Thanks .

So I can assume that Alfresco does not store metadata in the database.

regards
Sameer

[mrogers]

Alfresco does store metadata in the DB.   However your requirements are small and disk space is cheap!