Tracker table - what does it do

[mikesolomon]

What does the tracker table do?

It is by far the biggest table on my system

[eggsurplus]

It keeps track of every action a user has made in Sugar.

[mikesolomon]

It keeps track of every action a user has made in Sugar.

Thanks - is this necessary & if not can it be turned off?

[mikesolomon]

Answered my own question

found how to turn it off

[goko]

It keeps track of every action a user has made in Sugar.

... and not only "normal" users...
The reason the table grows so big is that a bug: http://www.sugarcrm.com/crm/sugarbug...g_number=25957 causes all the Schedulers actions being inserted into the tracker table. The fix for 25957 is supposed to be included in 520.Solana.

If you want the "Last viewed" feature to work you need to have tracker enabled.
If you are running Pro or Ent you also get Module usage charts/reports if tracker is enabled.

There are two things you can do to keep the table smaller:

• Change the interval at which the tracker table is pruned (the default is 02:00am; 1st of each month )
  To do that go to Admin->Scheduler->Prune Tracker Tables
  My suggestion is to set it to run at 02:00am every day.
  To do that simply change the Date-field from '1' to '*'
  
• Change how many days of data will be saved when the table is pruned (default is 30),
  To do that go to Admin->Tracker Settings
  Change to whatever number of days you like in the "Number of days..." field

[mikesolomon]

... and not only "normal" users...
The reason the table grows so big is that a bug: http://www.sugarcrm.com/crm/sugarbug...g_number=25957 causes all the Schedulers actions being inserted into the tracker table. The fix for 25957 is supposed to be included in 520.Solana.

If you want the "Last viewed" feature to work you need to have tracker enabled.
If you are running Pro or Ent you also get Module usage charts/reports if tracker is enabled.

There are two things you can do to keep the table smaller:

• Change the interval at which the tracker table is pruned (the default is 02:00am; 1st of each month )
  To do that go to Admin->Scheduler->Prune Tracker Tables
  My suggestion is to set it to run at 02:00am every day.
  To do that simply change the Date-field from '1' to '*'
  
• Change how many days of data will be saved when the table is pruned (default is 30),
  To do that go to Admin->Tracker Settings
  Change to whatever number of days you like in the "Number of days..." field

Thanks - very helpful

[eggsurplus]

How do you turn it off in case someone comes across this thread?

[mikesolomon]

How do you turn it off in case someone comes across this thread?

There is an tracker options section in admin

you can turn enabled off

[etzapata]

Hi All,

I can't see the any option regarding this tracker in Admin. We are using Community Edition Version 5.0.0b (Build 3150) with CentOS.

My tracker table has already reach 5 million plus records. Is it okay if i'll just truncate this table? Or say delete records which are more than a month?

Please enlighten us as this is a big factor we're considering why our Sugar is still slow despite all the tweaks we've done.

Hope someone out there can help.

EriC

[mikesolomon]

Hi All,

I can't see the any option regarding this tracker in Admin. We are using Community Edition Version 5.0.0b (Build 3150) with CentOS.

My tracker table has already reach 5 million plus records. Is it okay if i'll just truncate this table? Or say delete records which are more than a month?

Please enlighten us as this is a big factor we're considering why our Sugar is still slow despite all the tweaks we've done.

Hope someone out there can help.

EriC

In admin in the Schedulers there is a job 'Prune Tracker tables'

You can also tutn off trackers in the Tracker Section located under System in admin