SMF Support > Server Performance and Configuration
Recommended versions of PHP and MySQL for SMF?
[Unknown]:
Well... mysql and session are required. The, gd, pspell, iconv, and openssl are recommended and may be used if available.
-[Unknown]
alvinleephd:
Okay, well I contacted the server company about it and they did some tweaking and now the load average is down to 0.12, 0.12, 0.11. Which is significantly better. SMF seems to load a bit faster, but not by much. Still lags a bit but still faster than before. They said that the problem was that I am using a very high amount of mySQL resources, which is strange since my forum is pretty small, at only 150 some odd members. I don't think a small SMF forum should be slowing down the server, I may have to investigate a bit and see the resources used by the users on my server.
[Unknown]:
Interesting. You may wish to ask your host to provide details, show you what queries (if any) are eating up resources.
Page created in 2.408 seconds with 11 queries.
Load times like that are not, usually, caused by queries. If they are, it means that something is wrong with the tables in your database. If you can get me a few sample process lists where queries are taking more than 2 seconds, I can probably diagnose what might be wrong.
Pages should not load that slowly.
Make sure you have "check size every time" disabled for avatars, as well.
-[Unknown]
alvinleephd:
--- Quote ---If you can get me a few sample process lists where queries are taking more than 2 seconds, I can probably diagnose what might be wrong.
--- End quote ---
Hello, I'm not sure what you mean. Do you want me to give you an example where it takes more than two seconds for me to load?
EDIT: I was browsing the mambo forums and people have been saying mambo is starting to use quite alot of resources. read here: http://forum.mamboserver.com/showthread.php?t=17290&page=2&pp=10
Both of the websites on one of my users accounts are using the latest version of mambo, which seems to be using a hefty amount of resources. And he has used up over 80% of his bandwith, so I am quite positive this is the culprit. Because prior to creating that person's account, SMF loaded very quickly, usually in 0.0x seconds.
Navigation
[0] Message Index
[*] Previous page
Go to full version