FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » Bug Reports » visits limit? how many
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
visits limit? how many [message #40115] Tue, 15 January 2008 05:26 Go to next message
Serega is currently offline  Serega   Russian Federation
Messages: 26
Registered: June 2006
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
I use
FUDforum 2.7.7RC2
Apache 2.0.52
PHP 4.3.9
MySQL 4.1.20
Webalizer 2.01 (for statistics)

When visits about 10000-12000 per day - all right
But when visits up to 15000-20000 - mysql "freeze", many queries are waiting one query (insert or update, for example) - many users waiting load forum pages about 1-2 minutes. Sad

I use optimized options in admin panel and disable strong features (build message tree, for example), but I cant solve this problem.

What can I do?

RAM 2GB, 2.1 GHz

[Updated on: Tue, 15 January 2008 05:29]

Report message to a moderator

Re: visits limit? how many [message #40118 is a reply to message #40115] Tue, 15 January 2008 16:06 Go to previous messageGo to next message
Ilia is currently offline  Ilia   United States
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
What locks are being held in MySQL that are delaying other queries?

FUDforum Core Developer
Re: visits limit? how many [message #40211 is a reply to message #40115] Wed, 23 January 2008 12:52 Go to previous messageGo to next message
Serega is currently offline  Serega   
Messages: 26
Registered: June 2006
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
mysql SHOW PROCESSLIST returns:

 Locked 	 SELECT s.id AS sid, s.ses_id, s.data, s.returnto, s.sys_id, t.id AS theme_id, t.lang, t.name AS ...

 Locked 	 SELECT f.moderators FROM `fud26_forum` AS f, `fud26_thread` AS t, `fud26_msg` AS m WHERE m.id='48626 ...

 Locked 	 SELECT s.id AS sid, s.ses_id, s.data, s.returnto, s.sys_id, t.id AS theme_id, t.lang, t.name AS  ...

 Locked 	 INSERT INTO fud26_msg ( thread_id, poster_id, reply_to, ip_addr, host_name, post_s ...

Locked 	 SELECT s.id AS sid, s.ses_id, s.data, s.returnto, s.sys_id, t.id AS theme_id, t.lang, t.name AS  ...

 Locked 	 SELECT s.id AS sid, s.ses_id, s.data, s.returnto, s.sys_id, t.id AS theme_id, t.lang, t.name AS  ...

etc over 80 locks

Re: visits limit? how many [message #40214 is a reply to message #40211] Wed, 23 January 2008 17:51 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
What query is in run state (that's the one holding the lock)

FUDforum Core Developer
Re: visits limit? how many [message #40222 is a reply to message #40214] Fri, 25 January 2008 10:49 Go to previous messageGo to next message
Serega is currently offline  Serega   
Messages: 26
Registered: June 2006
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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 12:10]

Report message to a moderator

Re: visits limit? how many [message #40223 is a reply to message #40115] Fri, 25 January 2008 13:31 Go to previous messageGo to next message
Serega is currently offline  Serega   
Messages: 26
Registered: June 2006
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
when SELECT is in run, INSERT/UPDATE/DELETE are locked
when INSERT/UPDATE/DELETE in run, SELECT is locked

FUDforum use manually locks and composite queries using over one table. Example, fud_users, fud_thread, fud_sess (etc.) - all tables must by unlocked. But, when any user is login, fud_users is lock, fud_sess is lock. When any user view any thread, fud_thread is lock too. Many composite queries are waiting to unlock required tables. More users are waiting good condition to run current-session queries.

How we can fast disable manually locks in scripts, mysql must be lock tables in internal level, its faster than manually locks, manually lock not always required. I think...

webalizer reports today:
hits 527251, files 245545, pages 123437	
visits 11724, sites 5246, kbytes 5812858

its high or low statistics for fud forum?

[Updated on: Fri, 25 January 2008 13:35]

Report message to a moderator

Re: visits limit? how many [message #40240 is a reply to message #40223] Sun, 27 January 2008 11:40 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Can you do "show full processlist" so that the entirety of the query can be seen.

FUDforum Core Developer
Re: visits limit? how many [message #40242 is a reply to message #40115] Sun, 27 January 2008 12:37 Go to previous messageGo to next message
Serega is currently offline  Serega   
Messages: 26
Registered: June 2006
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
We (with sysadmin, I am webmaster) can find problem location. When we stop NetAMS service - all right, work faster withtout locked querires. With NetAMS - we have a problem.

NetAMS settings its no for this forum, I think.
Thanks.
Re: visits limit? how many [message #40249 is a reply to message #40242] Mon, 28 January 2008 16:50 Go to previous messageGo to next message
Ilia is currently offline  Ilia   United States
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
What is NetAMS?

FUDforum Core Developer
Re: visits limit? how many [message #40558 is a reply to message #40249] Wed, 19 March 2008 15:29 Go to previous messageGo to next message
Serega is currently offline  Serega   
Messages: 26
Registered: June 2006
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
I have this problem again...

and research it:
if mysql connection was closed (mysql_close(fud_sql_lnk)) before printing any data, loading speed is not very slow.
but this forum includes sql-query in header and footer too (mysql connection is up permanently) and speed slow. How I can disable "footer sql queries" for speed up?

P.S. NetAMS - Network Traffic Accounting and Monitoring Software
for technical reasons
Re: visits limit? how many [message #40562 is a reply to message #40558] Wed, 19 March 2008 20:12 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Well, not really, since there are not queries in the footer, just some tracking queries at the bottom of some pages. You can try commenting them out on the msg.php.t and thread.php.t source files.

FUDforum Core Developer
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
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) ] [ RSS ]

Current Time: Mon Oct 23 22:14:40 EDT 2017

Total time taken to generate the page: 0.01007 seconds