On Do, 2008-10-30 at 11:17 -0500, Kevin Lewis wrote:
> >> From: "Lars-Erik Bjørk"
> >> Do we abort transactions that have been idle for a certain period of
> >> time to avoid a malicious user keeping transactions open in order to
> >> fill up our disks?
> >Philip Stoev wrote:
> > The server has some idle timeouts on the network level that will kill a
> > completely idle connection after a few days, but those can easily be
> > circumvented by sending select 1 over the wire.
> > To the best of my knowledge, Falcon and the server do not have any
> > definite transaction-level timeouts or limits. I believe Jim's opinion
> > is that if you have given access to somebody to your database servers,
> > you deserve everything that will happen.
> Pervasive.SQL and some other database systems have the ability to allow
> a DBA to selectively kill a long running transaction or connection from
> a separate connection. I do not know if this can be done in MySQL. But
> it would be a server feature, not Falcon.
That would be the kill command within mysql client kill <thread_id>
Hakan Küçükyılmaz, Senior Software Engineer DBTG/MySQL +49 160
Sun Microsystems GmbH Sonnenallee 1, DE-85551 Kirchheim-Heimstetten
Geschaeftsfuehrer: Thomas Schroeder, Wolfang Engels, Dr. Roland Boemer
Vorsitz d. Aufs.rat.: Martin Haering HRB MUC 161028 49.011, 8.376