Hi Daniel,

You can check db utilization to see the total available storage for Guardium internal MySQL database in Manage-->System Monitor.

Also you can have an df-h output if you collect system level must gather logs to see all the file system.

For a table there is no max size until there is space in db. This is my understanding from MySQL perspective.

Guardium will start sending health self monitoring alerts to Administrator with an expected internal database being full date e.g. You tables utilization is this much mb last 24 hours and expected that your database will be full in next 10 days.

Hope this helps.

Regards,
Rizwan

Hello Daniel:
That's depend on the size of space of collector, you can size the machine with 2TB of HD in a Virtual Machine. As my experience, I make the collectors with 1TB all time. But the size of DB is direct on size of information that you collect. In the policies you must discriminate the relevant information that you  monitor. 
I have a 2 months of retention data in the collector, and daily I archive the data to an SFTP server. If an auditor request information about old data, I download from SFTP to an special collector where I made the reports that the auditor needs.
Based on this, I think that the one year of retention isn't possible.

Regards,