Shivansh Posted November 9, 2018 Share Posted November 9, 2018 How to ruduce whmcs database size 0 Quote Link to comment Share on other sites More sharing options...
Kian Posted November 11, 2018 Share Posted November 11, 2018 (edited) Clear logs (email, activity, module, license etc.). I've seen WHMCS installations with log tables storing over 30 GB of useless information. Not only it's a waste of disk space but it also hits the performance of your CPU(s). Reindexing A_I on every new INSERT on a table that stores millions of records is heavy and can even slow your WHMCS. Edited November 11, 2018 by Kian 1 Quote Link to comment Share on other sites More sharing options...
brian! Posted November 11, 2018 Share Posted November 11, 2018 you could trim the logs stored in the database if they are large... https://docs.whmcs.com/Maximising_Performance Quote Large Log Tables - WHMCS maintains a number of logs for record-keeping and auditing purposes which are stored in a table within the MySQL database. These logs can become very large, which might cause your installation to slow whilst trying to manipulate a large table. Navigate to Utilities > System > Database Status and make note of the following tables sizes: tblactivitylog tbladminlog tblgatewaylog tblmodulelog tblemaillog tblticketmaillog tblwhoislog If any of these tables are particularly large (more than several hundred MB) consider performing some system maintenance to prune these logs. The tblmodulelog table can be emptied via the Utilities > Logs > Module Log page. 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.