169 reputation
1113
bio website trevorburnham.com
location Cambridge, MA
age 29
visits member for 4 years
seen Oct 17 '13 at 19:27

Aug
24
awarded  Popular Question
Nov
18
awarded  Famous Question
Oct
24
awarded  Tumbleweed
Oct
17
asked Django HttpResponseRedirect acting as proxy rather than 302
Feb
28
comment Setting a time limit for a transaction in MySQL/InnoDB
Thanks, I really appreciate the answer!
Feb
28
accepted Setting a time limit for a transaction in MySQL/InnoDB
Aug
8
awarded  Notable Question
Jan
22
awarded  Popular Question
Jul
7
awarded  Autobiographer
Mar
5
awarded  Citizen Patrol
Mar
5
comment Setting a time limit for a transaction in MySQL/InnoDB
@hobodave Yes, that edit was erroneous and has been corrected. To be clear: The timeout method will roll back the transaction, but not until the MySQL database responds to a query. So the timeout method is suitable for preventing long transactions on the client side or long transactions that consist of several relatively short queries, but not for long transactions in which a single query is the culprit.
Mar
5
revised Setting a time limit for a transaction in MySQL/InnoDB
deleted 53 characters in body
Mar
5
comment Setting a time limit for a transaction in MySQL/InnoDB
I was actually more concerned in my question with a scenario in which the client app hangs (say, gets caught in an infinite loop) during the course of a transaction than with one in which the transaction takes a long time on MySQL's end. But thanks, that's a good point. I've updated the question to note it.)
Mar
5
revised Setting a time limit for a transaction in MySQL/InnoDB
Oops: the transaction will be rolled back if the server takes more than (timeout) seconds to respond, but not until after the server responds
Mar
5
answered Setting a time limit for a transaction in MySQL/InnoDB
Mar
3
revised Setting a time limit for a transaction in MySQL/InnoDB
Adding link to test case showing how KILL can be harmful
Mar
3
accepted Installing newer version of installed RPM from source (CentOS)
Mar
3
revised Installing newer version of installed RPM from source (CentOS)
Pointing to gnaman's answer for the `which` part of the question
Mar
3
comment Installing newer version of installed RPM from source (CentOS)
Thanks, you're right: which tells you what the path to something will be when you open a new session, not what it is in the current session.
Mar
3
revised Setting a time limit for a transaction in MySQL/InnoDB
Telling another story to try to explain what I want to achieve