by eggsurplus

Control what your users can access and save time, money, and frustrations. Lock down sensitive data in SugarCRM or SuiteCRM to specific groups or teams. Supports unlimited assigned users, unlimited group assignments to records, custom layouts for each group, login/sudo capabilities and much more.

Free Trial

By clicking you consent to share your profile with the developer

#187 - Safe Table Maintenance

Closed Bug? created by sparcusa 9 years ago

My securitygroups_records table is getting very large (over 1.2 millions records). How do I safely delete some of this data?

  1. sparcusa member avatar

    sparcusa

    9 years ago

    +-------------------+----------+ | module | count(*) | +-------------------+----------+ | ProjectTask | 5 | | Accounts | 4043 | | Project | 5 | | Documents | 44 | | csg_Merchants | 1 | | Users | 17 | | Bugs | 78 | | Releases | 4 | | SavedSearch | 1 | | UserPreferences | 157 | | Notes | 461 | | SugarFeed | 9943 | | Campaigns | 84 | | Import | 10556 | | SecurityGroups | 10 | | DocumentRevisions | 6 | | Meetings | 218 | | Contacts | 329 | | Cases | 3182 | | Employees | 3 | | ACLRoles | 6 | | Emails | 4774 | | DynamicFields | 3 | | Schedulers | 3 | | SchedulersJobs | 1208194 | | Leads | 34995 | | ProspectLists | 59 | | Tasks | 63 | | InboundEmail | 6 | | Prospects | 8103 | | ACLActions | 24 | | Administration | 4 | | Opportunities | 5 | | vCals | 3 | | Calls | 41 | | EmailMarketing | 45 | | EmailTemplates | 29 | | CampaignLog | 801 | | CampaignTrackers | 43 | +-------------------+----------+

    • eggsurplus member avatar

      eggsurplus Provider Affiliate

      9 years ago

      That's the SchedulersJobs table with 1.2 million records. That should be safe to purge. If your securitygroups_records table ever does get large you can delete those that are set to deleted = 1.

  2. eggsurplus member avatar

    eggsurplus Provider Affiliate

    8 years ago

    It was found that SchedulersJobs did cause the securitygroups_records table to inflate dramatically. This was fixed as of 2.7.2.

    -Jason

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
Rating
  • "Good product, but we need to support 'Quick Create' feature. and raised up this request to your page." - lcyang

    Read More Reviews