Andreas Posted October 6, 2014 Share Posted October 6, 2014 Hello I noticed my WHMCS DB has grown to be very large. (745MB). In WHMCS most of it is in the tblmodulelog (645MB ) is that the same System Module Debug Log? I have that disabled already and I reset it anyways and it had no affect. Any information on this would be great thank you 0 Quote Link to comment Share on other sites More sharing options...
WHMCS Ryan Posted October 6, 2014 Share Posted October 6, 2014 @Andreas - Yes the tblmodulelog is the System Module Debug Log. Disabling it won't clear out the entries in the DB but if you do not wish to use the log you can manually delete the entries from within MySQL. I would suggest that before you do anything you take a backup of the DB and be sure you do not delete the table itself, just the rows inside the table. --Thanks 0 Quote Link to comment Share on other sites More sharing options...
Andreas Posted October 6, 2014 Author Share Posted October 6, 2014 Hey ryan thanks for replying back So just to verify, this table "tblmodulelog" is just for debugging purposes only. Nothing else will be lost? 0 Quote Link to comment Share on other sites More sharing options...
Andreas Posted October 6, 2014 Author Share Posted October 6, 2014 I went and took a look and the table said it was empty. Something seemed odd so in PHPMySQL i saw an optimise link. Once I clicked on that it instantly fixed it and now its reading properly. It looks like it was 640MB of nothing Thanks for the help 0 Quote Link to comment Share on other sites More sharing options...
vec Posted October 6, 2014 Share Posted October 6, 2014 that's right... but why do you have it on in the first place? I'd see why you have it on first then turn it off or it will grow that big again in no time... 0 Quote Link to comment Share on other sites More sharing options...
Andreas Posted October 6, 2014 Author Share Posted October 6, 2014 It has been off for a bit now. I had it on a few month ago and left it while doing some testing. I disabled it but never knew it would have added so much data. its off now, and now I know to go back and remove those entries in the future thanks for the replies guys 0 Quote Link to comment Share on other sites More sharing options...
Jesús Yael Ortega Aguilar Posted April 5, 2021 Share Posted April 5, 2021 Hi Andreas How did you turn off this log? I have the same problem as you. Regards. 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.