My SMF is very very low... ;(

[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.