Sqlyog Vs. Kaspersky Anti-Virus (Keepalive)

[larsen]

Hi,

we´ve got KAV 6.0 installed and the included firewall seems to drop idle connections after some time. I couldn´t find an option in KAV to prevent this and their support needs weeks to answer.

Perhaps, SQLyog could implement some kind of keepalive.

Lars

[peterlaursen]

we won't do like that anything except for what we already did. We reconnent through setting the reconnect option to the mysql_real_connect() function the MySQL API.  That is the correct way to do it.

Please report the problem to Kaspersky.

[larsen]

Ok, I already did that.

[peterlaursen]

But anyway please tell: Doesn't SQLyog reconnect seamlessly?  Does KAV prevent that or does it cause some slowness? 

What could be the problem is that if KAV terminates the connection somehow in the OS socket layer and the connection thread is still running in the MySQL server you could easily read max-connections setting and no new connections will be possible.  

There is only one correct way to terminate a MySQL connection and that is to execute mysql_close() or mysql_kill() from a MySQL client.  As KAV is not a MySQL client it cannot and shall not terminate a MySQL client<->server connection.

[larsen]

'peterlaursen' wrote on '31:

But anyway please tell: Doesn't SQLyog reconnect seamlessly?  Does KAV prevent that or does it cause some slowness? 

SQLyog works just fine, it just needs around 45-60 seconds to reconnect according to my co-worker. “Feels” less at my PC, but still 15-30 seconds.

[peterlaursen]

   It may not be a Kaspersky issue.  It may be the global 'wait_timeout' setting.  Please read this Blog:

http://www.webyog.co…ession-timeout/

What does “SHOW GLOBAL VARIABLES LIKE 'wait_timeout';” return?  If the global setting is low you can override the setting for the SESSION in SQLyog connection manager. 

[larsen]

“wait_timeout” is set to “28800”. It certainly is a Kaspersky issue as I can disable KAV and get rid of that annoying feature =)

[Clinton Asher]

We are users of SQL Yog at my office and have recently begun deployment of Kaspersky AV in our enterprise and ran into this same issue. We have been able to get rid of it by adding our local network as a “trusted zone” through the Anti-Hacker module (basically what they call their firewall). After we did that the issue went away. YMMV.

[Author]

Posts