Re: Transactions in MySQL.

2006-09-28 Thread Visolve DB Team
Hi, All locking in *MySQL* is deadlock-free. This is managed by always requesting all needed locks at once at the beginning of a query and always locking the tables in the same order. The --external-locking and --skip-external-locking options explicitly enable and disable external locking. Th

Re: Transactions in MySQL.

2006-09-25 Thread Carlos Proal
It only works with engines that support transactions like innodb and solid, i strongly sugget to read these links from the manual. http://dev.mysql.com/doc/refman/5.0/en/ansi-diff-transactions.html http://dev.mysql.com/doc/refman/5.0/en/innodb-transaction-model.html Carlos On 9/25/06, [EMAIL

Re: Transactions in MySql

2001-04-10 Thread Gerald Clark
ons that support BDB and InnoBase, > it's probably more appropriate to point out to them that they have to build > their own distribution with BDB and/or InnoBase, and *then* tell them to > continue on and RTFM.. > > -Original Message- > From: Gerald Clark [mailto:[EMA

RE: Transactions in MySql

2001-04-09 Thread Shankar Unni
7;s probably more appropriate to point out to them that they have to build their own distribution with BDB and/or InnoBase, and *then* tell them to continue on and RTFM.. -Original Message- From: Gerald Clark [mailto:[EMAIL PROTECTED]] Sent: Monday, April 09, 2001 6:19 AM To: Marco Baldacchi

Re: Transactions in MySql

2001-04-09 Thread Rodney J. Woodruff
Look at the following pages in the manual: http://www.mysql.com/doc/M/i/Missing_Transactions.html http://www.mysql.com/doc/T/a/Table_types.html -- Rodney Gerald Clark wrote: > Marco Baldacchini wrote: > > > > MySql support transactions? > > The OLE-DB provider support transactions? > > Call th

Re: Transactions in MySql

2001-04-09 Thread Gerald Clark
Marco Baldacchini wrote: > > MySql support transactions? > The OLE-DB provider support transactions? > Call the method Begintrans on a connection object (ADO) return an error!!! And you read the manual, right? Transaction support depends on the version of MySQL you are running, and the table ty