Making best use of server resources – memory & 404s

  • I look after https://www.oldies.org.uk/ – a website run by volunteers aimed at rehoming elderly rescue dogs. Each dog has a page written up by a volunteer, and when the dog is rehomed, we move it from the ‘Adopt an Oldie’ category to the ‘rehomed’ category. This was originally done so our volunteers could see that dogs were going home and feel they were achieving things, and it turned out to have the welcome side-effect that people searching for dogs often found one of our ‘rehomed’ pages and moved on to look at dogs still in need of homes.

    The site has been running since 2005 and is fairly popular, and we’re now finding that we’re struggling for server resources and sometimes get out of memory errors. I’ve done the usual tweaks (caching with w3 total cache, cloudflare, an increased memory allowance, removing a couple of theme customisations that were running uncached queries), but it’s a small charity without much budget. Searches across 11,652 Posts are taxing our resources.

    I could trim the older posts, but I’m concerned that if I do that, I will then get a pile of 404 traffic for those old posts, and I don’t think 404s can be cached either, so that will make the problem worse not better.

    What can I do to make best use of our limited server resources so that users can still run searches and access other uncached content?

    The page I need help with: [log in to see the link]

Viewing 5 replies - 1 through 5 (of 5 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    Is this on a VPS or shared hosting?

    Thread Starter cycas

    (@cycas)

    The site shares a cloudlinux cpanel VPS. I can allocate resources within the VPS, but I am hoping not to have to add further resources to the VPS system for use by this site, since then I would have to bill the charity for them.

    • This reply was modified 6 years, 9 months ago by cycas.
    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    What does ‘top’ tell you about available resources at the system level?

    You might try tuning the mysql server and change the tables from myisam to innodb.

    Thread Starter cycas

    (@cycas)

    Top says I average around 2Gb of memory free across the server (this site has 2Gb of memory allocated) I’m generally over-provided with processor, but a bit light on memory.

    I could try innodb, that’s a good idea. I meant to do that before but ran into some hitch, but that was a while ago.

    Are there any better (cheap!) approaches to searching across relatively large numbers of posts beyond the wordpress standard search and innodb? Is there a good way of handling removing the old posts so that 404’s won’t create excessive strain?

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    Give MySQL more memory if you have that much free. Read up on tuning mysql. There’s also a perl script you can use to analyze it — https://linode.com/docs/databases/mysql/how-to-optimize-mysql-performance-using-mysqltuner/

    You can always switch out the internal search for a custom Google search

    https://www.ads-software.com/plugins/wp-google-search/

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Making best use of server resources – memory & 404s’ is closed to new replies.