| Re: visits limit? how many |
Wed, 19 March 2008 20:12 |
|
|
|
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.
|
|
| Re: visits limit? how many |
Wed, 19 March 2008 15:29 |
|
|
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 |
Sun, 27 January 2008 12:37 |
|
|
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 |
Sun, 27 January 2008 11:40 |
|
|
|
Can you do "show full processlist" so that the entirety of the query can be seen.
|
|
| Re: visits limit? how many |
Fri, 25 January 2008 13:31 |
|
|
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?
|
|
| Re: visits limit? how many |
Fri, 25 January 2008 10:49 |
|
|
| 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...
|
|
|
|
| Re: visits limit? how many |
Wed, 23 January 2008 12:52 |
|
|
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
|
|
|
|
| visits limit? how many |
Tue, 15 January 2008 05:26 |
|
|
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
|
|
|
Calendar
Search
Help
Members
Control Panel
Logout [ CommonCrawl [Bot] ]
Home