I just had some problems with an update exhausting my memory. But I already had the PHP memory limit at 512 MB, and I had to take it up to 1024 MB! I know this is relative but, is this too much?

How can I know if this is within normal range or if I should be working to improve it?

This is the site for a newspaper in a small province (~10 posts/day). After the latest update, the database is at ~600mb.

  • "database is at ~600M" – what do you mean with that? 600 million entries? 600 MB database dump, including template caches?
    – carlcs
    Apr 8, 2017 at 14:53
  • Sorry, I was still writing as if i was in my config file, I meant 600Mb. And that was the size of the database in my drive, a backup is at 250Mb. Just database. Not sure if that's an accurate way of measuring it... probably not now that I think about it.
    – cballenar
    Apr 8, 2017 at 14:57
  • You can export a backup using the tool in CP > Settings, which removes all template caches (which can be a lot). Should be a better indicator for size of your actual data. Another interesting figure is the amount of rows in craft_elements.
    – carlcs
    Apr 8, 2017 at 15:06
  • Gotcha! The 250Mb backup was done form the CP. The entries table is at 10,000 rows while the elements table is at 63,000 rows. Could this justify that much memory?
    – cballenar
    Apr 8, 2017 at 15:31
  • Oh wow... my server keeps crashing since I updated, it looks like 1Gb of memory isn't enough :| MySQL seems to be hogging most of it but I don't know what is doing to exhaust it. How can I troubleshoot this?
    – cballenar
    Apr 8, 2017 at 18:14


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.