SMF Support > Server Performance and Configuration

MySQL server is stopping

(1/2) > >>

TF_:
Hi.

I have a very big forum with big traffic. 100 000 - 120 000 sideviews. over 8000 members and 340 000 posts.

When I surf on the forum, maybe 10-15 minutes and suddenly the MySQL server is hanging and it stopp. When I have to stop and start apache server and MySQL server for view the forum again.

I have exactly upgrade the forum to SMF 1.0.5 and I have the same problem.

Is'nt SMF made for huge forums with a lot of traffic? I have a big and quick dedicated server.

Ben_S:
SMF is fine on big forums.

How about some info such as what specs the server is, what versions of php / MySQL you are running, any accelerators such as eAccelerator, MMCache etc?

Have you optimized your MySQL config as the default config is actually pretty rubbish?

How many active users do you have online in a 15 minute period?

TF_:
Forumets SMF-versjon: SMF 1.0.5 (mer detaljert)
Nyeste SMF-versjon: SMF 1.0.5
PHP-versjon: 4.3.10
MySQL-versjon: 4.0.18-log
Serverversjon: Apache/2.0.52 (FreeBSD) PHP/4.3.10
GD-versjon: bundled (2.0.28 compatible)



I have optimize tables in phpmyadmin yesterday.

I have also shut down avatars and attachments, if that takes system power.But MySQL is still hanging...  :(

Ben_S:
Any accelerators such as eAccelerator, MMCache etc?

Have you optimized your MySQL config as the default config is actually pretty rubbish [I mean my.cnf here]?

How many active users do you have online in a 15 minute period?

Also what spec if you server, what process how much ram?

Do a search for InnoDB on this forum too as switching certain tables to InnoDB can help with performance.

TF_:

--- Quote from: Ben_S on June 27, 2005, 08:44:33 AM ---Any accelerators such as eAccelerator, MMCache etc?
--- End quote ---
Not sure, will it make big differences in performance?


--- Quote ---Have you optimized your MySQL config as the default config is actually pretty rubbish [I mean my.cnf here]?
--- End quote ---
No, I haven't... but after a little research I increased a few of the variables (amon the key_buffer_size) - which seems to has solved the main problems that brought mySQL down... I found the guide at http://www.databasejournal.com/features/mysql/article.php/3367871 and changed the variables by doing "SET GLOBAL [var_name] = [number]"


--- Quote ---Also what spec if you server, what process how much ram?
--- End quote ---
Not sure either, but it should have 1GB of ram. I increased the key_buffer_size from 64M to 192MB, that helped alot!


--- Quote ---Do a search for InnoDB on this forum too as switching certain tables to InnoDB can help with performance.
--- End quote ---
Thank you for this, found a nice post about this at http://www.simplemachines.org/community/index.php?topic=30542.0

Navigation

[0] Message Index

[#] Next page