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
    Commented 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
    Commented 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
    Commented 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
    Commented 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
    Commented Apr 8, 2017 at 18:14


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.