SMF Support > Server Performance and Configuration

Yet another connection problem

(1/2) > >>

Pyrhel:
Hello everyone :)

I have the usual problem with the connection error:

--- Quote ---Sorry, SMF was unable to connect to the database. This may be caused by the server being busy.
--- End quote ---

It happens time to time (i suppose when the server is under load). The overall performance and uptime is great.
It's hosted on my own server with FreeBSD 8.2 amd64. PHP version 5.3.10 and mysql 5.5.22.

I thought the error was connected to the max_connections and I changed them (to test the forum for a few days) to 100. Maybe a little better, but sometimes still happens that the error is displayed.

In the MySQL error log there is nothing relevant with that. Can you give me some hints or ideas what to check and how to tune the server to avoid such errors.

Thanks!

Doctor Deejay:
What host are you using?

Pyrhel:
mysql is installed in a FreeBSD jail, and the hostname of the jail is server.supersecurity.org. But if that was wrong the forum won't work on every request. But that not the case, this happens very rarely. You can see the forum here: http://fordclub.bg/forum

青山 素子:
Are you using persistent connections for connecting to the database? This can be checked in the server options area of SMF's admin section.

Usually, if you hit the maximum number of connections, it will be logged in the MySQL error log.

Also, double-check the database connection information. If you're using a DNS name, you may be having occasional trouble resolving the name which will cause connection trouble as well.

Pyrhel:
Thank you, Motoko!

The persistent connections is disabled. It's a good idea to try them enabled. The hostname is "localhost" and won't be causing the problems.

Thanks again,
Anatoliy

Navigation

[0] Message Index

[#] Next page