My SMF is very very low... ;(

[JuhaS14]

Hi,

I have nervous problem with SMF, i have forum: http://www.dnsf.org/forum/index.php and sometimes site IS VERY VERY FAST, but about 15 min for 60 min board stucking very very badly. ;(

I have this problem before SMF too (with YabbSE), but now it's even worse than with YaBBSE.

My forum history is: Yabb Gold -> Yabb SE -> SMF, so quite many convertation...

Any hints about this problem?

Br,

Juha Söderholm



Edited by pmp6nl: Marked as solved

[JuhaS14]

Well, my loads average are: load average: 0.83, 0.75, 0.76 in server...

I have new server ready to waiting installation, but i don't thinks that problem is in server. Could it be possible that there something "weird" in my Mysql?

I have tried optimation, but it didn't fix the problem.

[JuhaS14]

Well, I host my own server. So there is should't be anything in mysql (everything else works fine with MYSQL).

[David]

While Homie might have been right with the server, I doubt it or at least we need to get a bit more specific.  Your load averages look fine to me.  I would, if you have not already, install a tool like MRTG so you can graph load averages, memory usage, and cpu load, over time.  Is there any specific pattern to when it gets slow?  Also have you tuned Apache and MySQL at all?  Doing that can help drastically since the default configuration file for MySQL does not enable query caching nor really make use of your ram as it should.

[Spaceman-Spiff]

it was quite fast when i opened it
you mentioned that you host your own server, what internet connection are you using?

[[Unknown]]

Try disabling the search feature.  Changes have been made to it that I am not happy with, making it very slow.

Also, you should update to Beta 4.1.

-[Unknown]

[JuhaS14]

it was quite fast when i opened it
you mentioned that you host your own server, what internet connection are you using?

4mb/4mb dsl connection. Everything else works fine.

This problems was in YaBBSE too... About 50 000 messages and it's works fine, but then it's start go slow..

I need to install that MRTG.

It's works sometimes very fast, but try to surfing lots in many topics - then you can see problem. Sometimes it lag totally!

[[Unknown]]

When it's lagging, can you try the "SHOW PROCESSLIST" in phpMyAdmin as root?

-[Unknown]

[JuhaS14]

Well, I don't use PHPMyAdmin....

I use only mysql in shell....

But I install that MRTG...


WOW ****** (sorry) now board lag again and i write uptime:

2 users,  load average: 9.26, 5.93, 4.14

HUH!

[[Unknown]]

Okay, can use use the shell, while it's lagging, to show the processlist?

-[Unknown]

[JuhaS14]

Here is the "top" -stats when it lags:

112 processes: 95 sleeping, 17 running, 0 zombie, 0 stopped
CPU states:  92.8% user,   7.0% system,   0.0% nice,   0.2% idle
Mem:    386216K total,   308756K used,    77460K free,     3212K buffers
Swap:   746980K total,    16708K used,   730272K free,   125928K cached

  PID USER     PRI  NI  SIZE  RSS SHARE STAT %CPU %MEM   TIME COMMAND
21378 www-data  20   0  6960 6280  3260 R     5.8  1.6   0:01 apache
18758 www-data  13   0  7420 6748  3284 S     5.4  1.7   0:29 apache
21258 www-data  16   0  7348 6688  3256 R     5.4  1.7   0:04 apache
18811 www-data  17   0  7496 6804  3316 R     4.8  1.7   0:28 apache
21046 www-data  16   0  7100 6440  3232 R     4.8  1.6   0:03 apache
21486 www-data  16   0  6012 5312  3060 R     4.7  1.3   0:00 apache
20017 www-data  16   0  7580 6920  3324 R     4.5  1.7   0:17 apache
21410 www-data  17   0  6868 6192  3216 R     4.4  1.6   0:01 apache
21188 www-data  15   0  6820 6152  3236 R     4.2  1.5   0:02 apache
21426 www-data   8   0  7032 6348  3120 S     4.2  1.6   0:00 apache
21385 www-data  12   0  6516 5844  3228 S     3.9  1.5   0:02 apache
21483 www-data  11   0  7096 6400  3096 S     3.9  1.6   0:00 apache
21491 www-data  14   0  5620 4904  2968 R     3.9  1.2   0:00 apache
21189 www-data  16   0  7224 6552  3252 R     3.6  1.6   0:05 apache
21194 www-data  10   0  7272 6596  3224 S     3.6  1.7   0:01 apache
21380 www-data  11   0  7312 6644  3248 S     3.5  1.7   0:01 apache
20210 www-data  10   0  7112 6448  3276 S     2.9  1.6   0:07 apache
21490 www-data  10   0  5196 4472  2872 S     2.9  1.1   0:00 apache
20651 www-data  16   0  7476 6820  3304 R     2.7  1.7   0:11 apache
18743 www-data  10   0  7420 6732  3308 S     2.4  1.7   0:22 apache
21485 www-data  10   0  5848 5156  3076 S     2.4  1.3   0:00 apache
21416 root      17   0  1028 1028   796 R     2.3  0.2   0:02 top
21379 www-data  10   0  6488 5792  3172 S     1.9  1.4   0:01 apache
21515 www-data  19   0  4076 3228  2112 R     1.7  0.8   0:00 apache

I think that server is overload? Am I right?

I have new server waiting installation Celeron 2.6ghz / 1024MB, this current is P200/192MB, could this help some who? My server is powered by Debian.

[[Unknown]]

Well, you sure have a lot of Apache processes... I've seen something like this before, some IOWAIT issue... but a "SHOW PROCESSLIST" from MySQL would help me a lot more.

-[Unknown]

[JuhaS14]

mysql> SHOW PROCESSLIST;
+--------+--------+-----------+--------+---------+------+-------+------------------+
| Id     | User   | Host      | db     | Command | Time | State | Info             |
+--------+--------+-----------+--------+---------+------+-------+------------------+
| 336427 | dnsf01 | localhost | dnsfdb | Sleep   | 32   |       | NULL             |
| 336459 | dnsf01 | localhost | dnsfdb | Sleep   | 95   |       | NULL             |
| 336460 | dnsf01 | localhost | dnsfdb | Sleep   | 94   |       | NULL             |
| 336518 | dnsf01 | localhost | NULL   | Query   | 0    | NULL  | SHOW PROCESSLIST |
| 336522 | dnsf01 | localhost | dnsfdb | Sleep   | 0    |       | NULL             |
+--------+--------+-----------+--------+---------+------+-------+------------------+
5 rows in set (0.02 sec)

[David]

Hmm, that seems awfully calm for a long load time.

[[Unknown]]

It means it's the infamous Apache issue (IOWAIT) and has nothing to do with SMF - as far as I can tell.

-[Unknown]

[trparky]

I would re-download the Apache 1.3.29 source code and re-compile it myself.  I remember that at one time or another, the 1.3.29 version had an issue with child-processes not being closed and thus lingering.

The version was quickly retracted and re-released with a fix.

[[Unknown]]

Yep, that would be the one .

-[Unknown]

[JuhaS14]

Is there any problems with Apache 2?

Here is some info about my PHP & Apache: http://juha.dnsf.org/info.php

[[Unknown]]

I've heard and experienced nothing but good things about Apache 2 with prefork..

-[Unknown]

[dschwab9]

I've been running my forum on apache 2 for a year now with zero problems.  Currently running Apache 2.0.48 and PHP 4.3.6RC1.  Just have to make sure if you use it in production that you are using prefork mode until they get all the multithread issues fixed.  It's also easier to compile than apache 1, which a lot more items being config file based rather than compile time settings.