eugenevdm Posted September 8, 2010 Share Posted September 8, 2010 I get this sometimes on a daily basis: Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 128712635 bytes) in /var/www/vhosts/snowball.co.za/httpdocs/support/admin/../includes/backupfunctions.php on line 0 Just so you know I have 512M (!) specified as allowed memory. Why on earth would "backupfunctions.php" use so much memory? 0 Quote Link to comment Share on other sites More sharing options...
HerrZ Posted September 8, 2010 Share Posted September 8, 2010 What is your "Total Size" on http://snowball.co.za/support/admin/systemdatabase.php ? 0 Quote Link to comment Share on other sites More sharing options...
eugenevdm Posted September 8, 2010 Author Share Posted September 8, 2010 (edited) OMG it's 630415.69 Kb !! Thank you for pointing that out. Clearly I need to go in there and start trimming. Some years ago we made a development decision to have some of our own tables also in the WHMCS database, but I am starting to regret that now. Edited September 8, 2010 by eugenevdm 0 Quote Link to comment Share on other sites More sharing options...
HerrZ Posted September 8, 2010 Share Posted September 8, 2010 i recommend to use an external database backup tool. best tool so far is http://www.mysqldumper.net. after this deactivate whmcs db backup. 0 Quote Link to comment Share on other sites More sharing options...
eugenevdm Posted September 10, 2010 Author Share Posted September 10, 2010 Interesting, after deleting many rows out of the database the size reported is still the same. Is there a way of 'compacting' a MySQL database? 0 Quote Link to comment Share on other sites More sharing options...
sparky Posted September 10, 2010 Share Posted September 10, 2010 (edited) Try adding this line to the top of your .htaccess file in the document root RLimitMem max Also you can refer to this post that may help http://forum.whmcs.com/showthread.php?p=140844#post140844 Edited September 10, 2010 by sparky 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.