| visits limit? how many [message #40115] |
Tue, 15 January 2008 05:26  |
Serega
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. 
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 #40211 is a reply to message #40115] |
Wed, 23 January 2008 12:52  |
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 #40222 is a reply to message #40214] |
Fri, 25 January 2008 10:49 |
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 )
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 |
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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
Calendar
Search
Help
Members
Control Panel
Logout [ CommonCrawl [Bot] ]
Home
]