topic No primary key in AMC's tables in Talend Studio

No primary key in AMC's tables

tdaget — Sat, 16 Nov 2024 11:59:06 GMT

Hi,
In my company, as we use the Talend Data Integration (professional edition) we use the AMC database to track job executions.
As explained in the documentation (and on the Talend's web site) we had created the stats, flows and logs table in a MySql database and it work fine.
Some slow execution event make me watch in this database and I note that there is no primary key on these table.
tStatCatch component schema do not give us any primary key ...
Do anybody known if any primary key would be created on these tables ? where to find any (official ?) documentation about this ?
Thanks
Thomas DAGET

Re: No primary key in AMC's tables

Anonymous — Thu, 04 Jul 2013 02:58:16 GMT

Hi Thomas
Yes, there is no primary key defined in these three tables. These tables are created base on the schema of the three log&stat component, tLogCatcher, tStatCatcher and tFlowMeterCatcher.
Shong

Re: No primary key in AMC's tables

Anonymous — Thu, 04 Jul 2013 22:20:22 GMT

Actually these tables does not need a primary key because the AMC feature only appends to them. BUT it helps a lot to have some indexes for improving the performance of the AMC web application!