[smdb]

'peterlaursen' wrote on '25:

Is it possible to ensure only one connection per host is active at any given time?

This can be defined when creating a user or a global setting can be defined in server configuration. In both cases it is a server-side setting. Once defined with any client it has effect for all clients. Start here: http://dev.mysql.com…-resources.html

What happens to SQLyog if you set it up this way given it requires up to for connections? Will it function?

'peterlaursen' wrote on '25:

If the host kills the connection, is it possible to avoid the client automatically re-connecting?

I think I'm not being clear here: when the host kills a connection from a standard command line client, the connection is not renewed until the user executes another command. What happens with SQLyog? Does the client automatically reconnect when it is booted by the host without user intervention? Or must the user do something? Basically, we don't want a whole bunch of idle clients eating up connections.

'peterlaursen' wrote on '25:

Then raise the max_connections setting in server configuration. Refer to: http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_max_connections

This unfortunately is not an option for us for various reasons.

Thanks for your informative replies.

[smdb]

'Sayan wrote on '25:

Hi,

I suppose you are referring to SQLyog. This forum is for MONyog — MySQL monitor. I'll move this topic to the SQLyog forums, and I'm sure you have a reply pretty soon!

Thanks Sayan, I definitely posted in the wrong forum.

[Author]

Posts