You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@syncope.apache.org by "yuefei.liu@intelliprogroup.com" <yu...@intelliprogroup.com> on 2024/02/04 05:40:43 UTC
Acitiviti tables "act_ru_actinst" too many
Hello,
I hope this email finds you well. I am currently using Apache Syncope as a user synchronization tool to sync user and user group information from one system to another. The number of users is approximately 10,000+.
After running scheduled push and pull tasks for 2-3 months, I have noticed that the 'act_ru_actinst' table in the database has accumulated millions of records, leading to a slowdown in synchronization efficiency.
I would like to inquire if it is safe to directly delete these data records. Your guidance on this matter would be greatly appreciated.
Best regards,
yuefei.liu
Re: Acitiviti tables "act_ru_actinst" too many
Posted by Francesco Chicchiriccò <il...@apache.org>.
Hi,
for 10k users with default settings, you are not expected to accumulate so many entries in the history tables, unless you are continuously updating them.
Anyway, especially, if you are not using User Requests, cleaning up those tables provides no harm.
Regards.
On 06/02/24 14:50, yuefei.liu@intelliprogroup.com wrote:
> Hi Francesco,
> I am using Apache Syncope version 3.0.5, database: pgsql 15 and running in a docker container, using the image apache/syncope:3.0.5
> Best regards,
>> yuefei.liu
> ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
> yuefei.liu@intelliprogroup.com
>
> *From:* Francesco Chicchiriccò <ma...@apache.org>
> *Date:* 2024-02-05 17:30
> *To:* user <ma...@syncope.apache.org>
> *Subject:* Re: Acitiviti tables "act_ru_actinst" too many
> Hi yuefei.liu,
> you should provide at least which Syncope version you are running, and also something about the environment (database? Tomcat? which versions?).
>
> Regards.
>
> On 04/02/24 06:40, yuefei.liu@intelliprogroup.com wrote:
>> Hello,
>>
>> I hope this email finds you well. I am currently using Apache Syncope as a user synchronization tool to sync user and user group information from one system to another. The number of users is approximately 10,000+.
>>
>> After running scheduled push and pull tasks for 2-3 months, I have noticed that the 'act_ru_actinst' table in the database has accumulated millions of records, leading to a slowdown in synchronization efficiency.
>>
>> I would like to inquire if it is safe to directly delete these data records. Your guidance on this matter would be greatly appreciated.
>>
>> Best regards,
>> yuefei.liu
>
--
Francesco Chicchiriccò
Tirasa - Open Source Excellence
http://www.tirasa.net/
Member at The Apache Software Foundation
Syncope, Cocoon, Olingo, CXF, OpenJPA, PonyMail
http://home.apache.org/~ilgrosso/
Re: Re: Acitiviti tables "act_ru_actinst" too many
Posted by "yuefei.liu@intelliprogroup.com" <yu...@intelliprogroup.com>.
Hi Francesco,
I am using Apache Syncope version 3.0.5, database: pgsql 15 and running in a docker container, using the image apache/syncope:3.0.5
Best regards,
yuefei.liu
yuefei.liu@intelliprogroup.com
From: Francesco Chicchiriccò
Date: 2024-02-05 17:30
To: user
Subject: Re: Acitiviti tables "act_ru_actinst" too many
Hi yuefei.liu,
you should provide at least which Syncope version you are running, and also something about the environment (database? Tomcat? which versions?).
Regards.
On 04/02/24 06:40, yuefei.liu@intelliprogroup.com wrote:
Hello,
I hope this email finds you well. I am currently using Apache Syncope as a user synchronization tool to sync user and user group information from one system to another. The number of users is approximately 10,000+.
After running scheduled push and pull tasks for 2-3 months, I have noticed that the 'act_ru_actinst' table in the database has accumulated millions of records, leading to a slowdown in synchronization efficiency.
I would like to inquire if it is safe to directly delete these data records. Your guidance on this matter would be greatly appreciated.
Best regards,
yuefei.liu
--
Francesco Chicchiriccò
Tirasa - Open Source Excellence
http://www.tirasa.net/
Member at The Apache Software Foundation
Syncope, Cocoon, Olingo, CXF, OpenJPA, PonyMail
http://home.apache.org/~ilgrosso/
Re: Acitiviti tables "act_ru_actinst" too many
Posted by Francesco Chicchiriccò <il...@apache.org>.
Hi yuefei.liu,
you should provide at least which Syncope version you are running, and also something about the environment (database? Tomcat? which versions?).
Regards.
On 04/02/24 06:40, yuefei.liu@intelliprogroup.com wrote:
> Hello,
>
> I hope this email finds you well. I am currently using Apache Syncope as a user synchronization tool to sync user and user group information from one system to another. The number of users is approximately 10,000+.
>
> After running scheduled push and pull tasks for 2-3 months, I have noticed that the 'act_ru_actinst' table in the database has accumulated millions of records, leading to a slowdown in synchronization efficiency.
>
> I would like to inquire if it is safe to directly delete these data records. Your guidance on this matter would be greatly appreciated.
>
> Best regards,
> yuefei.liu
--
Francesco Chicchiriccò
Tirasa - Open Source Excellence
http://www.tirasa.net/
Member at The Apache Software Foundation
Syncope, Cocoon, Olingo, CXF, OpenJPA, PonyMail
http://home.apache.org/~ilgrosso/