FUDforum: Bug Reports » Slow posting

Home » FUDforum Development » Bug Reports » Slow posting

Show: Today's Messages :: Polls :: Message Navigator

Re: Slow posting [message #12130 is a reply to message #11695]

Tue, 29 July 2003 20:57

ctbk

Messages: 142
Registered: April 2002
Location: Milan, Italy

Karma:

Senior Member

I don't think it's a gzip problem.

Tonight, while I was browsing the forum (and it was fast as usual) I performed a search, and noticed how the results page wasn't delivered at all. I tried another search: same behaviour. I suspected some load problem, but after some checking I excluded it (in effect the forum browsing and the other non-forum parts of the site were fast, as I said): after logging I could see the CPUs not loaded at all.
Then I tried to post, and the usual bug presented itself: no response from the site, but the post was inserted in the right place.

Taking advantage of this situation, I checked the status of db tables with mysqladmin processlist, and I couldn't help noticing how many processes (maybe 30-40) where waiting to write in the index tables, those tables were locked.

I stopped and restarted mysql, and the problem disappeared: fast searches, posting without problems.

I think it's a deadlock problem, occurring while index/search tables are updated.
The more users post at the same time, the more likely the bug is triggered.

~
~
:wq

[Updated on: Tue, 29 July 2003 21:00]

Report message to a moderator

[Message index]

		Slow posting By: ctbk on Mon, 14 July 2003 15:52
		Re: Slow posting By: Ilia on Mon, 14 July 2003 15:59
		Re: Slow posting By: ctbk on Mon, 14 July 2003 16:00
		Re: Slow posting By: Ilia on Mon, 14 July 2003 16:32
		Re: Slow posting By: ctbk on Mon, 14 July 2003 16:36
		Re: Slow posting By: Ilia on Mon, 14 July 2003 16:40
		Re: Slow posting By: ctbk on Mon, 14 July 2003 16:56
		Re: Slow posting By: Ilia on Mon, 14 July 2003 17:23
		Re: Slow posting By: ctbk on Mon, 14 July 2003 18:14
		Re: Slow posting By: Ilia on Mon, 14 July 2003 19:35
		Re: Slow posting By: ctbk on Mon, 14 July 2003 19:37
		Re: Slow posting By: Ilia on Mon, 14 July 2003 19:53
		Re: Slow posting By: ctbk on Mon, 14 July 2003 19:57
		Re: Slow posting By: Ilia on Mon, 14 July 2003 23:20
		Re: Slow posting By: ctbk on Fri, 18 July 2003 08:12
		Re: Slow posting By: Ilia on Fri, 18 July 2003 13:10
		Re: Slow posting By: ctbk on Tue, 29 July 2003 20:57
		Re: Slow posting By: Ilia on Tue, 29 July 2003 21:47
		Re: Slow posting By: ctbk on Tue, 29 July 2003 21:58
		Re: Slow posting By: ctbk on Tue, 29 July 2003 22:01
		Re: Slow posting By: Ilia on Tue, 29 July 2003 22:01
		Re: Slow posting By: andy_scouser on Thu, 17 June 2004 22:28
		Re: Slow posting By: Ilia on Fri, 18 June 2004 01:08
		Re: Slow posting By: andy_scouser on Sat, 19 June 2004 18:55
		Re: Slow posting By: Ilia on Mon, 21 June 2004 13:02
		Re: Slow posting By: andy_scouser on Tue, 22 June 2004 17:05
		Re: Slow posting By: viktor on Sat, 18 November 2006 16:05
		Re: Slow posting By: Ilia on Sun, 19 November 2006 16:30
		Re: Slow posting By: angryowl on Fri, 06 April 2007 16:30
		Re: Slow posting By: Ilia on Sun, 08 April 2007 15:33

Previous Topic:	2.7.6: Link to "new in topic" from topic list often only shows first post...
Next Topic:	forum rank system - inconsistent rank display

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Sep 29 01:22:27 GMT 2024

Total time taken to generate the page: 0.04728 seconds