Support Forum
Support Forum
Offline
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
Offline
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.
Visit Cruise Talk Central and Mr Papa's World
Offline
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
Offline
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.
Visit Cruise Talk Central and Mr Papa's World
Offline
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!
Offline
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.
 |
YELLOW
SWORDFISH
|
Offline
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...
Visit Cruise Talk Central and Mr Papa's World
Offline
Glad it's not a fatal problem.. phew 
Any other thoughts?
Offline
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?
|
YELLOW
SWORDFISH
|
Offline
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.
All RSS1 Guest(s)