Hi Mark
I would appreciate if we can define Under_extreme_conditions as you
have mentioned in this link below
http://archives.neohapsis.com/archives/mysql/2005-q3/0163.html
I would appreciate if you can give us a workaround for this, which
can eliminate this set autocommit =1 command being
I've confirmed that this does affect ALL incoming connections.
On 3/30/06, patrick <[EMAIL PROTECTED]> wrote:
> Is there any way to make this the default behaviour? I did a Google
> search, and it was suggested I put the following line in /etc/my.cnf:
>
> [mysqld]
> init
Is there any way to make this the default behaviour? I did a Google
search, and it was suggested I put the following line in /etc/my.cnf:
[mysqld]
init_connect='set autocommit=0'
This works fine, but I worry that this will affect all incoming
connections regardless of whether or no
artem wrote:
please clarify use of set autocommit
Here's an unsolicited opinion: AVOID using autocommit within
applications. Based on my experiences with other DBMSs, it's a very
likely source of hard-to-find program bugs. The problem occurs when
it's turned on and o
At 9:21 +0300 6/30/03, artem wrote:
please clarify use of set autocommit
SET AUTOCOMMIT = 0 ==> mean start transaction
... - some actions
COMMIT ==> transaction end
now to return to autocommit mode
just one line:
SET AUTOCOMMIT = 1
or two?
SET AUTOCOMMIT = 1
Hi Artem,
I understood the AUTOCOMMIT command different.
SET AUTOCOMMIT = 0 ==> deactivate AUTOCOMMIT
SET AUTOCOMMIT = 1 ==> activate AUTOCOMMIT
The commands
BEGIN
. some instructions
COMMIT
are used to start or finish a transaction.
Anybody, please correct me if I talk r
please clarify use of set autocommit
SET AUTOCOMMIT = 0 ==> mean start transaction
... - some actions
COMMIT ==> transaction end
now to return to autocommit mode
just one line:
SET AUTOCOMMIT = 1
or two?
SET AUTOCOMMIT = 1
Ben,
- Original Message -
From: "Ben Goswami" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, July 29, 2002 4:40 PM
Subject: Re: how to set autocommit
> Heikki ,
> Thanks for your reply. So wh
;
This does not work.
2. Should I use begin like ($sth is the the DB handle)
$sth->do("begin")
$sth->do("insert into...")
$sth->rollback()
or anything else.
I tried from setting up a mysql prompt, and still does not take it like
mysql>set autocommit=0
mysql>ins
day, July 29, 2002 7:52 AM
Subject: how to set autocommit
> Hi,
> Where should I change the autocommit setting to 0 (i.e no Autocommit).
I'm
> inserting row from perl script using DBI. I would like to bring up mySQL
> server with autocommit false, so that I can explicitly commit from
Hi,
Where should I change the autocommit setting to 0 (i.e no Autocommit). I'm
inserting row from perl script using DBI. I would like to bring up mySQL
server with autocommit false, so that I can explicitly commit from the front
end. But with lot of research in various docs I could not find wher
I use innodb and I want to set autocommit = 0 ( not autocommit ). I can do it on mysql
shell , mysqlfront , on but application that use myODBC I can't . I try to set on
my.cnf but mysqld-max say that don't have this variable to set ?
Thank you
Song
Andre,
I did not find such an option in my.cnf. But I agree that there should
be one. I will ask Monty to add that option to my.cnf.
Regards,
Heikki
.
Hi,
I would like to set autocommit = 0 as the default value when running the mysql
frontend. (Maybe with
Hi,
I would like to set autocommit = 0 as the default value when running the mysql
frontend. (Maybe with an entry in my.cnf)
Is that possible ???
Andre
--
E-Mail: [EMAIL PROTECTED]
Date: 08-May-01
Time: 15:42:09
() Join the ASCII ribbon campaign against html
Hi, everybody, I have a couple of quesitons
1. From the mysql manual, if I want to use 'autocommit=0', it says that I type 'set
autocommit=0' and this only applies to a session. So, when I want to back up data
using 'shell>mysql datablse < data.sql', do
Hi, everybody, I have a couple of quesitons
1. From the mysql manual, if I want to use 'autocommit=0', it says that I type 'set
autocommit=0' and this only applies to a session. So, when I want to back up data
using 'shell>mysql datablse < data.sql', do
16 matches
Mail list logo
