topic Re: Database Size in Alfresco Archive

Database Size

spatils — Fri, 22 Jul 2011 05:10:04 GMT

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

Re: Database Size

mrogers — Fri, 22 Jul 2011 06:44:26 GMT

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

Re: Database Size

romschn — Fri, 22 Jul 2011 06:44:42 GMT

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,

Re: Database Size

spatils — Fri, 22 Jul 2011 09:19:06 GMT

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.

Re: Database Size

mrogers — Fri, 22 Jul 2011 09:30:12 GMT

Give it a couple of G.

Re: Database Size

spatils — Fri, 22 Jul 2011 09:44:04 GMT

Thanks .

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

regards
Sameer

Re: Database Size

mrogers — Fri, 22 Jul 2011 10:43:59 GMT

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