AnsweredAssumed Answered

MySQL query to count records in table

Question asked by bensewell on Mar 14, 2011
Latest reply on Mar 16, 2011 by bensewell
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, table size

Has anyone done this before?  I don't want to install the GUI tools to get round it if someone else has done this before?

Thanks

Outcomes