As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.
SELECT table_schema "Database name", sum( data_length + index_length ) / 1024 / 1024 "Database size in MB" FROM information_schema.TABLES GROUP BY table_schema ;
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 ;
No. It depends upon your models and requirements. The database size is unlikely to be a problem.
I could not understand why are you looking for alfresco database consumption..
