serverbd Posted February 4, 2014 Share Posted February 4, 2014 My WHMCS database going heavy day by day Can I clear Activity log from table "tblactivitylog" is it make any problem in my site ? My database size now 28.66 MB is it normal ya too heavy plz ans me ? Link to comment Share on other sites More sharing options...
WHMCS Support Manager WHMCS John Posted February 5, 2014 WHMCS Support Manager Share Posted February 5, 2014 Hi, As your company grows the database will get bigger as you get more customers and they do more things, Circa 30MB is not large. You can limit the size of the Activity Log under Setup > General Settings, however I would recommend keeping it above 10,000 so that a decent history gets logged. If you run into a problem in future and need to check your logs only to find out it's not there any more, that would be an annoyance. You can certainly clear some other less important tables via Utilities > System > System Cleanup. Link to comment Share on other sites More sharing options...
snake Posted January 10, 2018 Share Posted January 10, 2018 I have cleared the activity log via system tools, and the max rows setting is 10000, however the tblactivitylog table has 29108 rows and tbladminlog has 153082 rows I think this may be impacting the website performance as it has been getting sluggish lately and taking a while to load pages. Link to comment Share on other sites More sharing options...
Recommended Posts