unable to connect to database mysql

dario borsotti on November 14, 2011

Hi community,

I use MashZone 2.1.0.2.1238 (Professional Edition) connected to a single mysql database.

I created during last months a lot of datafeed that use mysql tables as data sources.

Yesterday I found this error message, creating a new datafeed:

"unable to connect to database because all database connection are in use", as you can see in attached picture.

I obtain same error also changing mysql user. But if I try to connect to the DB, at the same time, with the same user, using a normal DB browser I can do queries without problem.

There is a maximum number of connection that MZ is able to manage?

thanks a lot

Dario Borsotti

Attachments

mysql_db_connection_0.PNG

Notify Moderator

1 Reply

Helmut Barro on November 15, 2011

This error occurs when the database pool limit of parallel user connections has been reached. You can configure this limit in the MashZone database connection administration - the default number of maximum parallel connections is "2".

This means that this database connection can be used by a maximum of 2 users in parallel within MashZone, which is some sort of security mechanism to avoid database overload, especially if the requested database is a productive database and feeds other applications as well. Other connections outside of MashZone, like the DB browser you mentioned, are of course not affected by this limit.

For testing or development databases which are not being used by other applications, you can safely increase that value - for productive systems please ask your Database Administrator in advance, as increasing this value (and using the increased number of parallel clients) could influence the database's performance for other applications.

Like

Sign in
or register to reply.

Notify Moderator

There are currently no upcoming events.