Hi,
MySQL supports transactions on INNOB tables. Does this mean that DBI
on MySQL has transaction support? Do I have to set any variables on MySQL
to support the transactions does support.
mary anderson
Others on this list may know more about the MySQL specifics, but in
general DBI has transaction support for all databases.
You turn it on in DBI with this:
$dbh->{AutoCommit} =3D 0;
Or by setting AutoCommit to 0 in the connect() parameters.
Consult the man pages for more information.
-Will
-----Original Message-----
From: Mary Anderson [mailto:mfanderson@ucdavis.edu]=20
Sent: Friday 03 March 2006 15:00
To: dbi-users@perl.org
Subject: DBI support transactions on MySQL 5.0?
Hi,
MySQL supports transactions on INNOB tables. Does this mean that
DBI
on MySQL has transaction support? Do I have to set any variables on
MySQL
to support the transactions does support.
mary anderson
- - - - - Appended by Scientific Atlanta a cisco company - - - - - =20
This e-mail and any attachments may contain information which is confidenti=
al, proprietary, privileged or otherwise protected by law. The information =
is solely intended for the named addressee (or a person responsible for del=
ivering it to the addressee). If you are not the intended recipient of this=
message, you are not authorized to read, print, retain, copy or disseminat=
e this message or any part of it. If you have received this e-mail in error=
, please notify the sender immediately by return e-mail and delete it from =
your computer.
As Will writes, I use transactions within DBD::mysql with MySQL 5 but
ONLY if using innodb tables. i.e. you need to add the innodb to the
create table defn.
Typically, I ignore Autocommit and do a $dbh->begin_work then
a $dbh->commit - works fine so long as you remember transaction
timeout which can be adjusted in the innodb section of mysql.conf
(I think the default is something like 30s).
Martin
Rutherdale, Will wrote:
> Others on this list may know more about the MySQL specifics, but in
> general DBI has transaction support for all databases.
>
> You turn it on in DBI with this:
>
> $dbh->{AutoCommit} = 0;
>
> Or by setting AutoCommit to 0 in the connect() parameters.
>
> Consult the man pages for more information.
>
> -Will
>
>
> -----Original Message-----
> From: Mary Anderson [mailto:mfanderson@ucdavis.edu]
> Sent: Friday 03 March 2006 15:00
> To: dbi-users@perl.org
> Subject: DBI support transactions on MySQL 5.0?
>
>
>
> Hi,
>
> MySQL supports transactions on INNOB tables. Does this mean that
> DBI
> on MySQL has transaction support? Do I have to set any variables on
> MySQL
> to support the transactions does support.
>
> mary anderson
>
>
>
> - - - - - Appended by Scientific Atlanta a cisco company - - - - -
> This e-mail and any attachments may contain information which is confidential, proprietary, privileged or otherwise protected by law. The information is solely intended for the named addressee (or a person responsible for delivering it to the addressee). If you are not the intended recipient of this message, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this e-mail in error, please notify the sender immediately by return e-mail and delete it from your computer.
>
>
>