all of a sudden errors and speed nosedive

[neontigeruk]

I have a site that has been running quite happily for 12 months, and all of a sudden, with no alteration to the site, have had a massive nosedive in performance accompanied by the following errors ...

Code: Select all

sitenname.co.uk [Mon Jul 27 14:56:08 2015] [error] [client xx.xx.xx.xx:49764] AH01215: PHP Fatal error: Out of memory (allocated 117964800) (tried to allocate 130968 bytes) in /home/sites/sitenname.co.uk/public_html/libraries/joomla/database/query.php on line 346
sitenname.co.uk [Mon Jul 27 14:56:11 2015] [error] [client xx.xx.xx.xx:50910] AH01215: PHP Fatal error: Out of memory (allocated 117964800) (tried to allocate 130968 bytes) in /home/sites/sitenname.co.uk/public_html/libraries/joomla/database/query.php on line 346
sitenname.co.uk [Mon Jul 27 14:56:48 2015] [error] [client xx.xx.xx.xx:49496] AH01215: PHP Fatal error: Out of memory (allocated 117964800) (tried to allocate 130968 bytes) in /home/sites/sitenname.co.uk/public_html/libraries/joomla/database/query.php on line 346
sitenname.co.uk [Mon Jul 27 14:56:55 2015] [error] [client xx.xx.xx.xx:34263] AH01215: PHP Fatal error: Out of memory (allocated 117964800) (tried to allocate 130968 bytes) in /home/sites/sitenname.co.uk/public_html/libraries/joomla/database/query.php on line 346
sitenname.co.uk [Mon Jul 27 18:29:01 2015] [error] [client xx.xx.xx.xx:42537] AH01215: PHP Fatal error: Out of memory (allocated 117964800) (tried to allocate 130968 bytes) in /home/sites/sitenname.co.uk/public_html/libraries/joomla/database/query.php on line 346
sitenname.co.uk [Mon Jul 27 18:29:50 2015] [error] [client xx.xx.xx.xx:42830] End of script output before headers: index.php
sitenname.co.uk [Mon Jul 27 18:31:05 2015] [error] [client xx.xx.xx.xx:46862] AH01215: PHP Fatal error: Out of memory (allocated 117964800) (tried to allocate 130968 bytes) in /home/sites/sitenname.co.uk/public_html/libraries/joomla/database/query.php on line 346
sitenname.co.uk [Mon Jul 27 18:31:25 2015] [error] [client xx.xx.xx.xx:55795] AH01215: PHP Fatal error: Out of memory (allocated 117964800) (tried to allocate 130968 bytes) in /home/sites/sitenname.co.uk/public_html/libraries/joomla/database/query.php on line 346

on the advise of the hosting company I have upped the PHP settings to match these:

Code: Select all

upload_max_filesize = 256M
max_input_time = 120
memory_limit = 512M
max_execution_time = 120
post_max_size = 256M

personally i think its overkill - and it made no difference

original values (nice and safely backed up so i can revert if necessary

Code: Select all

upload_max_filesize = 64M
max_input_time = 60
memory_limit = 256M
max_execution_time = 60
post_max_size = 64M

my client relies on his website, so a fix needs to be found rapidly.

[itoctopus]

It seems that one of the tables on your client's Joomla website has grown significantly over time, and one of the queries grabbing data from that table (very possibly through a join with another table) has grown exponentially in size. You will need to find that query. A good start would be MySQL's error log (ask your host to send it to you if you're on a shared hosting) and MySQL' slow query log.

Also, try trimming out the assets table if you can - as an inflated assets table can do a Joomla website some significant harm.