Database Size

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-22-2011 01:10 AM
Hello,
Are there any guidelines to project database size consumed by Alfresco repository?
regards
Sameer
Are there any guidelines to project database size consumed by Alfresco repository?
regards
Sameer
Labels:
- Labels:
-
Archive
6 REPLIES 6
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-22-2011 02:44 AM
No. It depends upon your models and requirements. The database size is unlikely to be a problem.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-22-2011 02:44 AM
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
———
Query-2 - shows free space for the database.
Hope this helps.
Thanks,
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.TABLESGROUP BY table_schema ;
Hope this helps.
Thanks,

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-22-2011 05:19 AM
Thanks For response.
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 am not sure how much data alfresco stores/ per document in the database.
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.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-22-2011 05:30 AM
Give it a couple of G.

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-22-2011 05:44 AM
Thanks .
So I can assume that Alfresco does not store metadata in the database.
regards
Sameer
So I can assume that Alfresco does not store metadata in the database.
regards
Sameer
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-22-2011 06:43 AM
Alfresco does store metadata in the DB. However your requirements are small and disk space is cheap!
