| visits limit? how many [message #40115] |
Tue, 15 January 2008 10:26  |
Serega
Messages: 26
Registered: June 2006
Karma: 0
|
Junior Member |
|
|
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 10:29] Report message to a moderator |
|
|
|
|
|
| Re: visits limit? how many [message #40211 is a reply to message #40115] |
Wed, 23 January 2008 17:52  |
Serega
Messages: 26
Registered: June 2006
Karma: 0
|
Junior Member |
|
|
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 15:49 |
Serega
Messages: 26
Registered: June 2006
Karma: 0
|
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 )
now all right... continue monitoring...
[Updated on: Fri, 25 January 2008 17:10] Report message to a moderator |
|
|
|
| Re: visits limit? how many [message #40223 is a reply to message #40115] |
Fri, 25 January 2008 18:31 |
Serega
Messages: 26
Registered: June 2006
Karma: 0
|
Junior Member |
|
|
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 18:35] Report message to a moderator |
|
|
|
| Re: visits limit? how many [message #40240 is a reply to message #40223] |
Sun, 27 January 2008 16:40 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
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 #40562 is a reply to message #40558] |
Thu, 20 March 2008 00:12 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
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
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]