I’ve been having ongoing issues with my website and my host is trying to figure out what the problem is, they brought up this, can you shed any light on this?
Following up on our conversation from before, one weird call we are seeing is below.
57MB and complete CPU spike. Do you have any idea what it might be?
57Mb 423.283ms pid=11359 99.22% – – 18/Sep/2012:04:00:53 -0700 “GET /index.php?sp_ahah=pm-manage&target=inbox&sfnonce=3a648e7b7d&rnd=1347966058019” 200 /var/www/mydomain.net/index.php
That is the pm inbox auto update. Where it updates the inbox count if you have been on page for a while.
No clue why it would spike. It’s a simple small Ajax request. So, unless the server is not liking the Ajax request to update one lite number in the inbox count, should be very small and quick.
You can turn off the auto update Ajax feature in forum – options global options.
hmm… I only turned on auto update with the last upgrade so I guess that isn’t the source of the problem, though given that issue I’ll turn it off again all the same
Tal, don’t you have a mess of forums and sub forums? Seem to remember such. What might be the total number of forums, treating forums and sub forums equally.
Asking because of something else that came up today.
Umm.. yes.. lots… 121 forums, approx 100 of those would be sub forums… please don’t tell me this is a fatal problem ’cause that would mean having to give up on SP and moving to other software and I couldn’t bear to do that!
No it is not a fatal problem and should have no effect on, as Steve said, the rather simple ajax request that retrieves the PM count.
But – I am a little unsure where Steve’s thinking was going as he is the PM ‘guru’ so I need him to chime back in with his thoughts.
was asking about the number of forums because I remember seeing a bunch of them… generally not an issue though the more forums you have the slower the group view page and forum view (displaying sub forums) will be… more db query power required…
and earlier yesterday, we were working with a user with about 300 forums who was having a slow down for logged in users… he seemed to have a bloated sfmembers table from all the permissions cache stuff that happens… now, we have not come up with a definitive link there, research going on…. but was just checking on number of forums…
To be honest – not really at the moment.
Having turned off the auto-update of the inbox count are you still seeing such spikes?
I suppose it is also worth asking if your sfmessages table – which holds PM’s – is on the large side? That might be a factor perhaps… Oh – and does it need optimising.. i.e., if you look at t in phpMyAdmin is there are large overhead?
disabling the auto update didn’t make much difference to the memory problems.
I also have consistent issues viewing the members page (via the front end) or trying to perform functions like adding members to groups (via the back end), I get timeout issues almost every time. We have 9680 members but we were having this issue long before we had that many members.
I’ve confirmed that this problem remains with all other plugins disabled.
It is possible you have quite a small timeout period set on your server ‘posting’ options. Can you find out what it is and I will try and look up what is a common and usable value and we can compare notes.
didnt think it would do anything for memory.. very small footprint… would be good question on the one log entry you posted why your server was wigging out on it and using up huge memory… and doubt is user related either… we generally only load up info for the current user…
anything else change on the server? settings, etc?
on these other servers, do you have large number of forums too? the more forums or topics displayed on a single page obviously will have some effect…
