Computer Hope Running Slow

[drmsucks]

Seems like the board has been running 'slow' today - anyone else notice?


ADMIN NOTES FOR ISP:
3:20 PM MST --
http://www.computerhope.com/forum/index.php/topic,60680.msg371963.html#new
Page created in 21.386 seconds with 21 queries.
Total processes: 14 (1 sleeping, 2 running, 11 locked)
Copying to tmp table
Time: 16s
Query:
SELECT t.ID_TOPIC
FROM (smf_topics AS t, smf_messages AS mf)
WHERE t.ID_BOARD = 9
   AND mf.ID_MSG = t.ID_FIRST_MSG
ORDER BY isSticky, mf.subject DESC
LIMIT 6, 25

3:40 PM MST --
Creating new post getting forwarded to:
http://www.computerhope.com/forum/index.php/board,16.0.html
Page created in 1.8 seconds with 16 queries.
12 (1 sleeping, 2 running, 9 locked)
State: Sorting result
Time: 11s
Query:
SELECT ID_MSG, ID_MEMBER
FROM smf_messages
WHERE ID_TOPIC = 58243
ORDER BY ID_MSG DESC
LIMIT 0, 5


Viewing: http://www.computerhope.com/forum/index.php/topic,60027.0.html
Page created in 38.527 seconds with 20 queries.
Total processes:     40 (0 sleeping, 2 running, 38 locked)
State: Copying to tmp table
Time: 54s
Query:
SELECT
   t.ID_TOPIC, t.numReplies, t.locked, t.numViews, t.isSticky, t.ID_POLL,
   0 AS new_from,
   t.ID_LAST_MSG, ml.posterTime AS lastPosterTime, ml.ID_MSG_MODIFIED,
   ml.subject AS lastSubject, ml.icon AS lastIcon, ml.posterName AS lastMemberName,
   ml.ID_MEMBER AS lastID_MEMBER, IFNULL(meml.realName, ml.posterName) AS lastDisplayName,
   t.ID_FIRST_MSG, mf.posterTime AS firstPosterTime,
   mf.subject AS firstSubject, mf.icon AS firstIcon, mf.posterName AS firstMemberName,
   mf.ID_MEMBER AS firstID_MEMBER, IFNULL(memf.realName, mf.posterName) AS firstDisplayName,
   LEFT(ml.body, 384) AS lastBody, LEFT(mf.body, 384) AS firstBody, ml.smileysEnabled AS lastSmileys,
   mf.smileysEnabled AS firstSmileys
FROM (smf_topics AS t, smf_messages AS ml, smf_messages AS mf)
   LEFT JOIN smf_members AS meml ON (meml.ID_MEMBER = ml.ID_MEMBER)
   LEFT JOIN smf_members AS memf ON (memf.ID_MEMBER = mf.ID_MEMBER)
WHERE t.ID_BOARD = 5
   AND ml.ID_MSG = t.ID_LAST_MSG
   AND mf.ID_MSG = t.ID_FIRST_MSG
ORDER BY isSticky DESC, IFNULL(memf.realName, mf.posterName)
LIMIT 0, 25

10:54 MST - July 9, 2008
Viewing: http://www.computerhope.com/forum/index.php/topic,60833.msg387231.html#new
Page created in 14.497 seconds with 19 queries.
Total processes:     5 (1 sleeping, 2 running, 2 locked)
State: Copying to tmp table
Time: 4s
Query:
SELECT t.ID_TOPIC
FROM (smf_topics AS t, smf_messages AS mf)
   LEFT JOIN smf_members AS memf ON (memf.ID_MEMBER = mf.ID_MEMBER)
WHERE t.ID_BOARD = 9
   AND mf.ID_MSG = t.ID_FIRST_MSG
ORDER BY isSticky, IFNULL(memf.realName, mf.posterName) DESC
LIMIT 1041, 25


BRONI:
3:42 PM PST - takes 30 sec to load this page: http://www.computerhope.com/forum/index.php/topic,60663.0/topicseen.html

BRONI:
3:44 PST - takes 30 sec to load: http://www.computerhope.com/forum/index.php?action=unread;start=25

DRMSUCKS:
7/9/08, 0855 MDT, approx 2 min wait after clicking on 'Reply' button on thread: http://www.computerhope.com/forum/index.php/topic,60934.msg386801.html#msg386801.

7/9/2008, 1054 MDT, approx 15 second wait after clicking on 'notify moderator' at: http://www.computerhope.com/forum/index.php/topic,60962.0.html

7/8/2008, approx 1335 MDT, took over (quit counting!) 2 min after clicking the post button to post to: http://www.computerhope.com/forum/index.php/topic,60934.0.html

Carbon Dudeoxide:
Posting took 23.125 seconds according to Fasterfox.
(note: I use it only for the timer, everything else is set to default  Wink).
7/9/2008 1:53pm CDT - 2:38pm.

http://www.computerhope.com/forum/index.php/topic,60306.new.html#new
4:46 PST - posting reply - 37 seconds

http://www.computerhope.com/forum/index.php/topic,61026.msg387214.html#msg387214
July 9, 2008 - 10:22PM PST - page loads 1:01min

7/10/2008, 1034 MDT, approx i min 'fetching preview' here: http://www.computerhope.com/forum/index.php?action=post;quote=387382;topic=60968.0;num_replies=3;sesc=42f7b1d0361c784586527d243dc7493b#top

7/10/2008, 1035 MDT, > 1 min after clicking on Post button: http://www.computerhope.com/forum/index.php?action=post;quote=387382;topic=60968.0;num_replies=3;sesc=42f7b1d0361c784586527d243dc7493b#top

July 11
---

Carbon
4:34PM CDT    20 Seconds
Opening a topic

drmsucks
1000 MDT, appprox 30 sec to post reply here: http://www.computerhope.com/forum/index.php/topic,60742.0.html

July 12
---

Carbon
14 seconds 1:22PM CDT.
Loading recent topics.


July 13
---

Broni
http://www.computerhope.com/forum/index.php/topic,61268.new.html#new
19 sec to reply.

drmsucks
1420 MDT, 15 sec to go to 'Microsoft Windows' forum from http://www.computerhope.com/forum/index.php/topic,60867.0.html#bot

!~*:.Pink Floyd.:*~!:
It took 10 seconds to go from page 1 from page 2 on the Other forum

Broni:
http://www.computerhope.com/forum/index.php/topic,61279.new.html#new
21 sec to reply.
Additional 13 seconds to reply to this post

[soybean]

Yes, at various times, it's been slow in responding today for me.

[!~*:.Pink Floyd.:*~!]

yeah it happened a few mins ago

[Carbon Dudeoxide]

It's been happening to me all morning....and afternoon...

[drmsucks]

Thanks - I've had DSL connection issues and wanted to be sure it wasn't at my end.

[!~*:.Pink Floyd.:*~!]

Its Nathans 20 year old computer!

[squall_01]

I dont think that its a c64 or something.  It hasnt been for me?

[Computer Hope Admin]

Actually it is a c64.. curse this 64k of memory!!! Bill Gates told me I would never need more than 640k obviously he's not right. But in all serious, yeah does seem to be having some issues more and more recently. I'm in contact with the ISP to see if there is anything we can do to help relieve the stress on the servers.

[Computer Hope Admin]

Working with ISP now. However, now the forums seem to be working ok and they've indicated that the server has not set off any load alarms. So it's going to be more difficult to track down since it randomly seems to occur. However, since I've been getting more complaints about this recently I'd like for everyone to help me log when this occurs and what you were doing when it occurred to help me help the ISP determine if it is an issue with the server or maybe an issue with SMF.

Type of feedback I'd like.

Time: 1:11PM (MST)
Trying to reply to post.
URL to post and URL currently being displayed in URL bar.

All feedback would be greatly appreciated.

[michaewlewis]

1:13pm PST, slow loading trying to go into new replies to my posts from forum root

I noticed that we set a new record today, 981 users online. Maybe we need a newer server and/or more bandwidth speed.....

[Carbon Dudeoxide]

1:13pm PST, slow loading trying to go into new replies to my posts from forum root

I noticed that we set a new record today, 981 users online. Maybe we need a newer server and/or more bandwidth speed.....

I missed it again....

[Computer Hope Admin]

If the server was reaching a limitation the ISP would of handled it they've got several triggers setup to warn them if capacity has been met and/or exceeded. Bandwidth is also definately not an issue. Which is why this issue is tricky. I've been trying a few things and noticed I've been able to duplicate the issue when I've got old forum searches taking place so going to try creating an index file later tonight to see if that helps things.

[squall_01]

It seems like I missed it again.  Thats why I wanted to have some of my ideas in play so that this wouldnt happen but I dont think it would be able to prevent this.  I had a feeling this would happen any how so I'll try an take notice if I can.

[Broni]

I noticed that we set a new record today, 981 users online

WOW!

[Broni]

Around 3PM PST - getting double email notifications about very same post.