topic MySQL query to count records in table in Alfresco Archive

MySQL query to count records in table

bensewell — Mon, 14 Mar 2011 16:27:54 GMT

Hi,Wanting to run a regular MySQL query through a cronjob that lists the Alfresco tables and the number of records and size of the table. I can do this per table easy enough but don't know where to start gettnig all the tables in one query. I'm after something like this:table name, no of records,

Re: MySQL query to count records in table

mikeh — Mon, 14 Mar 2011 21:30:46 GMT

Have you tried the MySQL forums? What you're asking isn't really Alfresco specific.

Thanks,
Mike

Re: MySQL query to count records in table

bensewell — Tue, 15 Mar 2011 09:21:12 GMT

OK Thanks, Yes I've put a post on but think i've worked it out anyway.

Thanks,

Re: MySQL query to count records in table

bensewell — Wed, 16 Mar 2011 13:16:39 GMT

For all of you who want to do this. Here goes:

If you run this on your MySQL database prior to doing a backup then you will get the number of records backed up etc then you can see how quickly your system is growing.

select table_catalog, table schema, table_name, table_type, table_rows, update_time from information_schema.tables where table_schema='alfresco';

run this against your information_schema database and it will show you the information you require.