469,081 Members | 1,892 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,081 developers. It's quick & easy.

Dropped Connections, Abandoned Queries

Can anyone point to documentation, or pass along some insight on how MySQL
handles dropped connections and abandoned queries?

How does MySQL cope with people/processes that log on and then neglect/fail
to logout properly? Clearly multiple logons to the same user id are
permitted. Do abandoned sessions stack up chewing up system resources or do
they timeout from inactivity?

What happens to queries that are initiated but the requester simply quits
before results are returned?

What happens when a usr:
initiates a slow query
abandons the session (cold!) before results are returned
logs on (again) and reissue the same slow query
over and over and over again!

What are some variables - timeouts and such - that might be associated with
these situations? Other than identifying certain users/abusers and whacking
them upside the head, how does one tweak the MySQL server to cope better.

All comments, experiences, and insights appreciated.
Thomas Bartkus
Jul 23 '05 #1
1 1549
Thomas Bartkus wrote:
Can anyone point to documentation, or pass along some insight on how MySQL
handles dropped connections and abandoned queries?


http://dev.mysql.com/doc/mysql/en/co...on-errors.html

Regards,
Bill K.
Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Mudge | last post: by
4 posts views Thread by pardhi a via SQLMonster.com | last post: by
2 posts views Thread by Gregory S. Williamson | last post: by
12 posts views Thread by Peter Eisentraut | last post: by
37 posts views Thread by Joshua Ruppert | last post: by
13 posts views Thread by PRP | last post: by
1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.