Creating post or reply in some sections slow

[mrhope]

I've been trying to track down some random slowness on our forums and for the life of me can't seem to find the cause. For some reason on some of the boards when trying to post a reply or a new post the forums (I assume) can take around 10 seconds to respond, even though the page says it was created in very little time (Page created in 0.047 seconds with 17 queries.) Everything else on the forums is extremely fast and the server as far as I can tell seems fine and is not getting overloaded.

It seems as if the issues may have started occurring after I updated the Apache version (2.4.7) and MySQL (5.5.34-cll) on the server. I was  hoping that updating to the latest SMF was going to fix it, but even after getting 2.0.7 installed it still seems to be having the same issue.

Any thoughts would be great.

Server Status info

Operating System:   Linux 2.6.24.2.dn.p4
Processor:   Intel® Core(TM)2 Duo CPU E7200 @ 2.53GHz (2527.004MHz)
Load averages:   0.25, 0.29, 0.26
Current processes:   135 (134 sleeping, 1 running, 0 zombie)
Processes by CPU:   httpd (21) 12.0%, mysqld (1) 6.0%, (other) (65) 0.1%
Memory usage:    97.187% (7947292k / 8177300k)
Swap: 0% (4k / 2096440k)

Connections per second:    2.3444
Kilobytes received per second:    12.9049
Kilobytes sent per second:    96.7416
Queries per second:    48.1887
Percentage of slow queries:    0
Opened vs. Open tables:
(table_cache)    4.0735 (should be <= 80)
Key buffer read hit rate:
(key_buffer_size)    0 (should be <= 0.01)
Key buffer write hit rate:
(key_buffer_size)    0.5691 (should be <= 0.5)
Thread cache hit rate:
(thread_cache_size)    75734.6047 (should be >= 30 )
Thread cache usage:
(thread_cache_size)    0.0025 (should be >= 0.7 and <= 0.9)
Temporary table disk usage:
(tmp_table_size)    0.3172 (should be <= 0.5)
Sort merge pass rate:
(sort_buffer)    0 (should be <= 0.001)
Query cache enabled:
(query_cache_type)    1 (should be >= 1 and <= 1)
Query cache miss rate:
(query_cache_limit)    0.4264 (should be <= 0.5)
Query cache prune rate:
(query_cache_size)    0.0238 (should be <= 0.05)

[Illori]

are you on a shared/VPS/dedicated server? and who is your host?

[Storman™]

Do other members (apart from yourself) also have an issue.

Do you have any ads on the forum (like Adsense) ?

[mrhope]

are you on a shared/VPS/dedicated server? and who is your host?

Practically Dedicated, but technically shared between two other sites that I also run on the server. Host is Dedicated Now.

Do other members (apart from yourself) also have an issue.

Yes. Members originally reported the problem which is why I'm looking into the problem. I'm able to duplicate the problem in one section of the forum every attempt. Other users report similar problems in other places in the forum and with other features such as Messaging and the Report feature.

Do you have any ads on the forum (like Adsense) ?

No ads are shown on any of the forum pages.

[zarachrome]

Hi;

I've got the exact same problem here:
http://fotograncanaria.org/foro [nofollow]

No adds, and other users with the same problem.
Shared server at small orange.com [nofollow]

Any help would be appreciated.
Thank you.

[mrhope]

Bump, anyone have thoughts on this or suggestions on isolating the cause to the problem?

[mrhope]

Sorry to keep bumping, this well be my last bump. Just thought I'd do one more to see if anyone has any thoughts or ideas.

[青山 素子]

My one big suggestion is to first run a network monitor such as that included with Firebug or the Chrome developer tools. See what the loading times are for the various assets. If that fails, you could try something more invasive, if you're willing to put the forum into maintenance mode to test and have enough permissions on the host to use xdebug.

[mrhope]

First, thank you for reply. I have run a Network monitor on the site and can duplicate at least a 10second wait time every time in one section of the forum when creating or replying. Below is the first line, that seems to be where the issue is occurring since it always has a response time of over 10seconds.

action,post2.html | POST | Status 302 | Size 448 B | Time 10.32s

Yet in other places I can create a post and get a less than a second response.

index.php?action=post2;start=0;board=20 | GET | Status 304 | Size = 448 B | Time 209 ms

Normally, I'd think that a 302 redirect would be something to do with the server, but the server is very responsive on everything else, just random places throughout the forum that seem to be responding slowly.

I'd be more than happy to put the forum in maintenance mode and have full access to the server to do anything with xdebug if you could give me some pointers or maybe a page that explains steps that can be done to troubleshoot and hopefully locate the cause to the problem.

Thanks again

[青山 素子]

Use xdebug's profiler. It'll show where the code spends time. It may be a bit of information overload at first, but hopefully you'll be able to see where all the time is spent in the code.

[Arantor]

I'd suggest putting the mail queue on.

[mrhope]

I'd suggest putting the mail queue on.

Thank you for this suggestion. I did this Sunday and no one has been able to duplicate the problem since. So issue has been solved.