Clena performance table

[tangogc]

I usualy use the tcadmin "clerarperformancescript" to delete the perfomance file.

I want also have mountly maintnance to truncate the Performance Table it collects all data and grow a lot now is 1gb.

 

there is a script to clean this table ?

 

thanks

[ECF]

Why don't you set the "Auto-Purge" in the System Monitor Settings?

[tangogc]

yes autopurge was always set to 31 day but the still the table is 1gb and this create problem to mysql optimization.

If you have a script to run will be nice idea.

I have another idea I can try to set autopurge 1 day to have a new clean table ?

I don't know

[ECF]

Just set the number of days lower then.

 

Example: If you set it to 1 day then TCAdmin will store 1 days worth of data. If you set it to 7 days, it will store 7 days worth of data.

 

Usually 7 days is a good number to set it at.

[tangogc]

ok I am going to try

[tangogc]

I set it as suggested ECF to 10 day, when the scheduled task run it start purging data, after 10 hours is still purging data and I stopped it.

I think an error in the purging procedure when the table is so big.

I would open a ticket but you know...........

Any suggestion ?

[ECF]

It is too large. Open a ticket and Luis will explain how to fix it.

[tangogc]

thanks kevin