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.

[el-brujo]

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 the same problem

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

But i don't have any problems with Yabbse.

What is  Apache issue (IOWAIT) ?

The solution is  disable the search feature. ¿?

[[Unknown]]

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]

[el-brujo]

mmm okz, thank you for apache issue!!

I'm using Apache 1.3.27 and PHP 4.2.2 with 4.0.18-standard

I'm looking for Optimitzing MySQL and i found this:

/etc/my.cnf

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
set-variable = max_connections=250
set-variable = max_connect_errors=1000
set-variable = interactive_timeout=440
set-variable = wait_timeout=440
set-variable = connect_timeout=2
skip-locking
skip-innodb
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
thread_cache_size=50
key_buffer=40M
table_cache=384
join_buffer=1M
sort_buffer_size=768K
read_buffer_size=512K
read_rnd_buffer_size=512K
max_allowed_packet=16M
record_buffer=1M
thread_concurrency=2

I think now my forum is working better, but i still doing more things.

But the problem in fact is the same:

sometimes site IS VERY VERY FAST, but about 15 min for 60 min board stucking very very badly. ;(

[Ben_S]

It could be because of people searching

[el-brujo]

could be, but this is not a solution

SMF uses UNLOCK TABLES; ¿? or maybe this is not a problem (the locked tables) ¿? I have no idea.

STATUS           QUERY
Locked       UPDATE yabbse_topics SET numViews = numViews +1 WHERE ID_TOPIC =9647 LIMIT 1 

But i think this is normal, lock and unlock tables......

I want to know why before my yabbse rules fast and now, sometimes my smf runs slow.

Thank you in advance.

[[Unknown]]

Try denying the search permission and see if that changes anything.

-[Unknown]

[el-brujo]

Try denying the search permission and see if that changes anything.

Yes, I think this is the problem, but  i want my visitors can search......

Disabling the search feature is not a solution.

Why this forum searchs fast and my forum search very slow?

Why before my yabbse search very fast (until using max day 9999) and now my smf search slow?

how can avoid "State" "Locked table" ¿?

I'll try with this:

interactive_timeout=100
wait_timeout=100

Because i think any query can't take more than 100 seconds.

I'm not shure but sometimes, i think when the query "Update yabbse_topics views + 1" or something like this, takes more than 10 seconds ¿?

[[Unknown]]

That probably means someting else is causing problems.

-[Unknown]

[el-brujo]

That probably means someting else is causing problems.

The only difference between before and now, is that, before i used yabbse and now i'm using smf.

I'm doing more tests, and yes the search option takes 10 secons or more and while the query is executing the other sql querys are LOCKED, that means the forum "is blocked".

Why in this forum runs normally?

I have --> Topics: 25782      Posts: 131160

But this forum has --> Total Topics: 8724     Total Posts: 80631 and takes 0.00 seconds in search something.

And before, with yabbse, this problem doesn't happen.

I hope SMF can improve the search feature or i can fix this problem.

Thank you.

Sorry for my bad english in all posts.

Best regards from Spain.

[[Unknown]]

I will say this one last time.  I know this has been stated in at least 5 other topics I can remember, as well as this one.

The search function is very slow in Beta 4.x.  Please accept our apologies, and disable it for now while you wait for Beta 5 which should solve the problem.

-[Unknown]

[el-brujo]

ok [Unknown], no problem.

I saw simple machines are using now the "new version" --> SMF 1.0 Beta 5 with improved search function xDDDD

[Shadowc]

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

-[Unknown]

If i search on Apache homepage, and updates there is nothing about any IOWAIT issue, my MySQL answers fast, and then after the querie and SMF contacts the Apache nothing happends.

I had this problem since i installed SMF, and now i have HUGE problems with pageloadingtime over 250sec, and the day after everything is normal for a day or two, then the loadtime problem is back again for 1-24 hrs.

I really need help with this, and i need some hardcore information about the IOWAIT problem, so i can give it to my provider since he only says that i have a ******ty forum software

Before i used Yabb, and i used the Supermod, with tha latest Supermod upgrade i got the extreme loadtime, and i made a new and fresh install of Yabb but kept the database intact, the forum was very fast, then i upgraded to SMF and the forum got even faster, but after 8-10 days this problem started.

I have also installed a fresh SMF 4.1 installation and point to the same database for comparance, but its the same problem there...


PLZ HELP... im realy stuck and my users have gone crazy.


Regards.

// Mats Larsson
// Edgeflyfishing

Link to the board: www.edgeflyfishing.com/forum

Link to the fresh SMF: http://www.edgeflyfishing.com/SMF

[Shadowc]

Hello... can Unknown, or anyone else respond

[el-brujo]

Shadowc the problem is here:

The search function is very slow in Beta 4.x.  Please accept our apologies, and disable it for now while you wait for Beta 5 which should solve the problem.

I don't think your problem is the  Apache  IOWAIT issue.

I had this problem since i installed SMF, and now i have HUGE problems with pageloadingtime over 250sec, and the day after everything is normal for a day or two, then the loadtime problem is back again for 1-24 hrs.

When your forum is slow (like my forum) is for that, someone is searching something, and the tables are locked.

I have the same problem, with Yabbse everithing goes fast, and now, NO.

Do not be crazy (like me) searching for Apache/MySQL problems, the problem are SMF forum.

And you are using --> "SMF 1.0 Beta 4 Public.", try with "SMF 1.0 Beta 4.1 Public."

[[Unknown]]

I have seen a person who had the IOWAIT issue, and recompiling Apache fixed it.

-[Unknown]

[Shadowc]

Shadowc the problem is here:

The search function is very slow in Beta 4.x.  Please accept our apologies, and disable it for now while you wait for Beta 5 which should solve the problem.

I don't think your problem is the  Apache  IOWAIT issue.

I had this problem since i installed SMF, and now i have HUGE problems with pageloadingtime over 250sec, and the day after everything is normal for a day or two, then the loadtime problem is back again for 1-24 hrs.

When your forum is slow (like my forum) is for that, someone is searching something, and the tables are locked.

I have the same problem, with Yabbse everithing goes fast, and now, NO.

Do not be crazy (like me) searching for Apache/MySQL problems, the problem are SMF forum.

And you are using --> "SMF 1.0 Beta 4 Public.", try with "SMF 1.0 Beta 4.1 Public."

I have also installed a fresh SMF 4.1 installation and point to the same database for comparance, but its the same problem there...

How do i diable the search function ?, don't think this is the problem since the forum can be slow for hours, with only 2-3 users online i the middle of the night.

[Shadowc]

I have seen a person who had the IOWAIT issue, and recompiling Apache fixed it.

-[Unknown]

I have read this a couple of times now, but it's impossible to find any information about this problem on the net, when i tell my provider it's the IOWAIT issue, he searched apache logs, and check the updatelist, but not one word about any IOWAIT issue, on the other hand, there could be a IOWAIT issue with the linux core, but i still need some hardcore information about this issue before i can get my provider to recompile a server with 40+ customers.

What to do ?

[panter011]

Hello guys, I am using smf 1.1.1 and I have the same problem. IS VERY slow.

What is the solution to this?

thank you

[Fiery]

Hello guys, I am using smf 1.1.1 and I have the same problem. IS VERY slow.

What is the solution to this?

thank you

Hello,

I am cleaning up old support topics.

Please do not post on extremely old posts like this.

Please start a new topic and describe your issues.  Be sure to read the stickied topics.