Possibly moving to InnoDB

[Benton, Kevin]

> > > It can be tweaked; I forget what the default is. But it doesn't
kill
> > > the *running* query - it kills the blocking one. (All together now
-
> > > eww!)
> >
> >         But wait, that makes sense. You mean if a SELECT is blocking
> everybody
> > else from running, it kills the SELECT, right?
> 
> No. It kills the other one - ie the one that is not running.

This can be configured by determining the isolation level in the server.

See
http://dev.mysql.com/doc/refman/4.1/en/innodb-transaction-isolation.html
for more information.

---
Kevin Benton
Perl/Bugzilla Developer/Administrator, Perforce SCM Administrator
AMD - ECSD Software Validation and Tools
 
The opinions stated in this communication do not necessarily reflect the
view of Advanced Micro Devices and have not been reviewed by management.
This communication may contain sensitive and/or confidential and/or
proprietary information.  Distribution of such information is strictly
prohibited without prior consent of Advanced Micro Devices.  This
communication is for the intended recipient(s) only.  If you have
received this communication in error, please notify the sender, then
destroy any remaining copies of this communication.