FUDforum: Bug Reports » visits limit? how many

Home » FUDforum Development » Bug Reports » visits limit? how many

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

Re: visits limit? how many [message #40222 is a reply to message #40214]

Fri, 25 January 2008 15:49

Serega

Messages: 26
Registered: June 2006

Karma:

Junior Member

Ilia wrote on Wed, 23 January 2008 17:51

What query is in run state (that's the one holding the lock)

...
I cant detect what query is in run state, because its fast process. I see query status such as:

Copying to tmp table SELECT m.*, u.alias, t.forum_id, p.name AS poll_name, p.total_votes, m2.sub

preparing SELECT fud26_msg.id, login, replies, views, post_stamp, thread_id, poster_id, attach_cnt, root_msg_i

and other query status with more locks, but its normal,
may be you have opinion about optimal settings (max*, limits) for mysql?

-----------
I commented in FUDforum/src/th.inc.t:19:

q('UPDATE fud26_thread SET views=views+1 WHERE id='.$id);

because I cant found thsi feature in admin panel and its mysql intensive process (table locks when increment views counter Sad

)

now all right... continue monitoring...

[Updated on: Fri, 25 January 2008 17:10]

Report message to a moderator

[Message index]

		visits limit? how many By: Serega on Tue, 15 January 2008 10:26
		Re: visits limit? how many By: Ilia on Tue, 15 January 2008 21:06
		Re: visits limit? how many By: Serega on Wed, 23 January 2008 17:52
		Re: visits limit? how many By: Ilia on Wed, 23 January 2008 22:51
		Re: visits limit? how many By: Serega on Fri, 25 January 2008 15:49
		Re: visits limit? how many By: Serega on Fri, 25 January 2008 18:31
		Re: visits limit? how many By: Ilia on Sun, 27 January 2008 16:40
		Re: visits limit? how many By: Serega on Sun, 27 January 2008 17:37
		Re: visits limit? how many By: Ilia on Mon, 28 January 2008 21:50
		Re: visits limit? how many By: Serega on Wed, 19 March 2008 19:29
		Re: visits limit? how many By: Ilia on Thu, 20 March 2008 00:12

Previous Topic:	Topic description sometimes vanishes (V2.7.7 + move topic patch)
Next Topic:	posts get chopped

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 01:26:44 GMT 2024

Total time taken to generate the page: 0.04951 seconds