Speed issues... - Page 3

Xyzzy · 2002-10-21, 17:42

Over the last few days it appears the BBS has slowed down some during peak hours, so we might have to move to another database server like we did before... Please let me know if you are experiencing these slowdowns as well...

I've gotten several 4-6 second times today... This isn't as bad as before, but it is still unacceptable...

Deamiter · 2002-10-25, 07:36

Just got 1-2 seconds with a peak just over 2 secs at 2:33 in the morning (Central Time). Definately not a peak time... Doesn't bother me or anything, just looks kind of weird after my usual .1 or .2...

Quote:

phpBB Created this page in 2.084728 seconds : 18 queries executed : GZIP compression enabled

Xyzzy · 2002-10-26, 03:53

I just moved our database to another server... Let me know if this helps... We have at least 41 different database servers to choose from...

The changeover took about ten minutes... This time I even put up a little sign saying the BBS was down for maintenance... That was Alf's idea... :)

patrik · 2003-07-29, 20:39

Quote:

phpBB Created this page in 3.593454 seconds : 16 queries executed

It was a lot longer than this---a couple of minutes. I think I actually got over a minute just before, when I posted my power failure post. I also got a timeout the first time I tried posting.

Edit: To be precise the "timeout" message was

Quote:

phpBB : Critical Error

Could not connect to the database

(This post also serves the purpose of me bragging about being a forum regular, since I know there is an old thread like this to reply in. ;) )

asdf · 2003-08-01, 15:56

phpBB Created this page in 60.512705 seconds : 14 queries executed
phpBB Created this page in 12.429743 seconds : 16 queries executed
phpBB Created this page in 44.819093 seconds : 13 queries executed

Then it was fast:

phpBB Created this page in 0.151868 seconds : 13 queries executed

Xyzzy · 2003-08-02, 06:48

I'm still trying to figure out why this happens... Everything on our end looks fine so it may to be something we don't have control over... I recently added an extra index to speed up some operations related to editing posts... I think lately the slow times have been less frequent... When we had 66 people online at one time we didn't slow down, so that shows that we have a bit of headroom... Of course, they were just reading and not searching or posting so maybe that has something to do with it...

Xyzzy · 2003-09-03, 18:22

The last few days the server has been slow in responding to our queries so I think I'm going to move our database to a new server tonight... I think the downtime will be just a few minutes...

E_tron · 2003-09-03, 20:46

I noticed it was really bad around noon central time

. 41 sec, ouch!!
That time may have been in conjunction with a bogged down T1 over here ;) .

Maybeso · 2003-09-03, 20:57

hmm,

If 40+ people drilling into forums thru topics to unread posts; reading; clicking post-a-reply, writing - previewing - writing - and submitting new posts; doesn't produce a measurable slowdown, then I'm stumped.

(I suppose the reading and writing are an eternity of inactivity to the server.)

The only way an individual could contribute more to the traffic load would be to clear the browser cache, open every forum to a separate window, then open every topic to a new window while running one of those optimizers that pre-loads every link on a page. And then cycle thru the topic windows hitting refresh as fast as possible.

Maybe I can write a script ...

Xyzzy · 2003-09-04, 23:33

Still working on it... Please be patient!

Xyzzy · 2003-09-05, 11:34

I ran some optimizations tonight... (Thanks Alf and Marc!) Those of you online during that period may have noticed that it killed the server...

I hope this speeds up some stuff... There was one table that was really huge that took forever to run...

[code:1]mysql> optimize table phpbb_search_wordmatch;
+-----------------------------------------+----------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+-----------------------------------------+----------+----------+----------+
| xyzzy_gimpsforum.phpbb_search_wordmatch | optimize | status | OK |
+-----------------------------------------+----------+----------+----------+
1 row in set (2 min 28.76 sec)[/code:1]

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
ECM RAM issues	yoyo	GMP-ECM	7	2018-04-28 05:51
Windows 10 Issues	Sulamandora	Software	5	2015-08-13 06:47
Mersenne.org Issues	SiliconSentry	Information & Answers	3	2014-05-21 22:36
New GPU; new issues...	chalsall	GPU Computing	18	2013-06-12 19:28
memory issues?	jcjuice	Hardware	7	2006-01-11 20:41

2002-10-21, 17:42	#23
Xyzzy Aug 2002 8658₁₀ Posts	Over the last few days it appears the BBS has slowed down some during peak hours, so we might have to move to another database server like we did before... Please let me know if you are experiencing these slowdowns as well... I've gotten several 4-6 second times today... This isn't as bad as before, but it is still unacceptable...

2002-10-26, 03:53	#25
Xyzzy Aug 2002 2×3²×13×37 Posts	I just moved our database to another server... Let me know if this helps... We have at least 41 different database servers to choose from... The changeover took about ten minutes... This time I even put up a little sign saying the BBS was down for maintenance... That was Alf's idea... :)

2003-08-01, 15:56	#27
asdf Sep 2002 3C₁₆ Posts	phpBB Created this page in 60.512705 seconds : 14 queries executed phpBB Created this page in 12.429743 seconds : 16 queries executed phpBB Created this page in 44.819093 seconds : 13 queries executed Then it was fast: phpBB Created this page in 0.151868 seconds : 13 queries executed

2003-08-02, 06:48	#28
Xyzzy Aug 2002 21D2₁₆ Posts	I'm still trying to figure out why this happens... Everything on our end looks fine so it may to be something we don't have control over... I recently added an extra index to speed up some operations related to editing posts... I think lately the slow times have been less frequent... When we had 66 people online at one time we didn't slow down, so that shows that we have a bit of headroom... Of course, they were just reading and not searching or posting so maybe that has something to do with it...

2003-09-03, 18:22	#29
Xyzzy Aug 2002 2×3²×13×37 Posts	The last few days the server has been slow in responding to our queries so I think I'm going to move our database to a new server tonight... I think the downtime will be just a few minutes...

2003-09-03, 20:46	#30
E_tron Sep 2002 Austin, TX 3×11×17 Posts	I noticed it was really bad around noon central time . 41 sec, ouch!! That time may have been in conjunction with a bogged down T1 over here ;) .

2003-09-03, 20:57	#31
Maybeso Aug 2002 Portland, OR USA 2×137 Posts	hmm, If 40+ people drilling into forums thru topics to unread posts; reading; clicking post-a-reply, writing - previewing - writing - and submitting new posts; doesn't produce a measurable slowdown, then I'm stumped. (I suppose the reading and writing are an eternity of inactivity to the server.) The only way an individual could contribute more to the traffic load would be to clear the browser cache, open every forum to a separate window, then open every topic to a new window while running one of those optimizers that pre-loads every link on a page. And then cycle thru the topic windows hitting refresh as fast as possible. Maybe I can write a script ...

2003-09-04, 23:33	#32
Xyzzy Aug 2002 2·3²·13·37 Posts	Still working on it... Please be patient!

2003-09-05, 11:34	#33
Xyzzy Aug 2002 2×3²×13×37 Posts	I ran some optimizations tonight... (Thanks Alf and Marc!) Those of you online during that period may have noticed that it killed the server... I hope this speeds up some stuff... There was one table that was really huge that took forever to run... [code:1]mysql> optimize table phpbb_search_wordmatch; +-----------------------------------------+----------+----------+----------+ \| Table \| Op \| Msg_type \| Msg_text \| +-----------------------------------------+----------+----------+----------+ \| xyzzy_gimpsforum.phpbb_search_wordmatch \| optimize \| status \| OK \| +-----------------------------------------+----------+----------+----------+ 1 row in set (2 min 28.76 sec)[/code:1]