Hi,
I've a problem with transaction
I initiate a transaction with start transaction. Soon i execute
following query:
* update t1 set t=12; and by I complete I execute rollback but when I do
it I obtain the following thing:
non-transactional Some changed tables couldn't be rolled back and
Hi,
[EMAIL PROTECTED] wrote:
Hi list!
I've a problem with transaction
I initiate a transaction with start transaction. Soon i execute
following query:
* update t1 set t=12; and by I complete I execute rollback but when I do
it I obtain the following thing:
non-transactional Some changed
On 13 Mar 2007, at 13:44, JamesDR wrote:
With what you've provided us: You can not prevent this. You are
running
in a transaction which is isolated from any others.
But doesn't that isolation provide atomicity, i.e. the first
transaction to commit will act as if all of its component
On 14 Mar 2007, at 18:02, Michael Dykman wrote:
SELECT * from process WHERE WHERE id = 123 AND status = 'init' FOR
UPDATE;
-- do a bunch of other stuff ...
UPDATE process SET status = 'ready' WHERE id = 123 AND status =
'init';
I get what you're doing here, but I don't see why it's
The difference here, is that any row locked via the SELECT .. FOR
UPDATE will not even allows readers access to that record until, so
you will not have processes concurrently trrying to process. This
means that, for each row, any processes acting on it are force to be
seqential each each
Marcus Bointon wrote:
Hi,
(repeat posting)
I have a simple PHP function that initialises a process definition. To
prevent it happening more than once, I'm wrapping it in a transaction,
however, it doesn't seem to be working and I get multiple
initialisations. In pseudocode:
BEGIN;
On Tue, Oct 31, 2006 at 08:58:04PM +0300, Ahmad Al-Twaijiry wrote:
is it possible that one of my script process will select the same data
that the other process is selecting or updating ? or if I run a second
process of my script it will not be able to read/write anything until
the first
Ok Dan.
Thanks a lot for your answer.
An other doubt about transaction is in the foreign key case. If in a
transaction i insert a certain register and get the last insert id and after
i try to insert another register using this id because this table has a
foreign key, it gives me a
Hi,
2006/7/22, João Cândido de Souza Neto [EMAIL PROTECTED]:
Ok Dan.
Thanks a lot for your answer.
An other doubt about transaction is in the foreign key case. If in a
transaction i insert a certain register and get the last insert id and after
i try to insert another register using this id
In the last episode (Jul 22), Joπo CΓndido de Souza Neto said:
I've getting something wrong in transaction in Mysql 5.0.22 on
windows that i don't know way it's happen.
I've got a script in php which starts a transaction and when if fails
and rollbacks, the autoincrement do not back.
e.g.
Apologies for a late reply.
1) The query that tries to insert the invalid entry into Table2 fails.
Therefore, if you have 3 separate queries as in the first case, the
last one fails, but the first 2 are successful. In the second case,
they're all in one query, and if one fails, they all fail.
Bdb tables locks are at page level, how can I determine the number of
pages of my table?
mysql show variables like '%binlog_cache_size%';
+---++
| Variable_name | Value |
+---++
| binlog_cache_size | 32768 |
|
Hi, here's my create table:
mysql show create table parametrivaloriplc;
++-+
| Table | Create Table|
++-+
| parametrivaloriplc | CREATE
Maybe i got it! For the chronicle:
I resolved the problem decreasing the max_bdb_lock to the default value
and creating an index on the column used in the where clause of my
query. Probably mysql tried to lock the whole table because the primary
key wasn't in the where clause.
Cheers,
Marco
Hi Marco,
My hint is to read the BDB section of the manual:
http://dev.mysql.com/doc/refman/5.0/en/bdb-start.html
specifically the part that says:
With the bdb_max_lock variable, you can specify the maximum number
of locks that can be active on a BDB table. The default is 10,000. You
should
On 12/7/05, Marco Baroetto [EMAIL PROTECTED] wrote:
Hi,
I have a berkeley db table containing about 5 rows where I do this
transaction (pseudocode follows):
begin work
delete from mytable where myfield='boo' /*delete about 100 rows*/
for (i=0; i=100; i++){
insert into mytable
See below
- Original Message -
From: Jeremy Smith [EMAIL PROTECTED]
To: [EMAIL PROTECTED] Mysql. Com [EMAIL PROTECTED]
Sent: Sunday, May 09, 2004 9:31 PM
Subject: Transaction question - no rollback needed?
Does it make sense to use a transaction just for the row locking
properties,
]
To: [EMAIL PROTECTED]
Sent: Wednesday, March 31, 2004 9:02 AM
Subject: Re: Transaction Not supported
On Tuesday 30 March 2004 09:35 pm, Jonas Lindén said something like:
I dont think that transactions are supported (yet?) by the PERL DBI.
to Mike Blezien [EMAIL PROTECTED]. My response follows
: Re: Transaction Not supported
On Tuesday 30 March 2004 09:35 pm, Jonas Lindén said something like:
I dont think that transactions are supported (yet?) by the PERL DBI.
to Mike Blezien [EMAIL PROTECTED]. My response follows.
Yes they are...at least I have used them in a project
Subject: Re: Transaction Not supported
On Tuesday 30 March 2004 09:35 pm, Jonas Lindén said something like:
I dont think that transactions are supported (yet?) by the PERL DBI.
to Mike Blezien [EMAIL PROTECTED]. My response follows.
Yes they are...at least I have used them in a project before using
I dont think that transactions are supported (yet?) by the PERL DBI.
/Jonas
- Original Message -
From: Mike Blezien [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Tuesday, March 30, 2004 9:42 PM
Subject: Transaction Not supported
Hello,
I keep getting this error when
On Tuesday 30 March 2004 09:35 pm, Jonas Lindén said something like:
I dont think that transactions are supported (yet?) by the PERL DBI.
to Mike Blezien [EMAIL PROTECTED]. My response follows.
Yes they are...at least I have used them in a project before using Perl::DBI.
[EMAIL PROTECTED]
Luiz Rafael Culik Guimaraes wrote:
Dear Friends
Does mysql version 4.0.x support the follow sql commands
begin transaction
commit
rollback
Regards
Luiz
Yes.
Your time would have been better spent searching on the MySQL web site
or in the documentation that posting that question here.
--
CanIt Vote for ID 3429Daniel
I searched all myql 4.0 what new page and did found any reference, is their
other page
Regards
Luiz
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.588 / Virus Database: 372 - Release Date:
Luiz Rafael Culik Guimaraes wrote:
Daniel
I searched all myql 4.0 what new page and did found any reference, is their
other page
Regards
Luiz
Press Release:
http://www.mysql.com/press/release_2002_11.html
Documentation:
http://www.mysql.com/doc/en/InnoDB_transaction_model.html
Hi Chris,
My apologies, I didn't correctly explain what I was looking for. I mean
more of a solution to creating a client program. I'm thinking of php-gtk
but not sure how well this works under windows, especially for printing
reports.
Thanks,
Bryan
On Sat, 17 Jan 2004, Chris Nolan
I wanted to thank everyone for their responses and information regarding
this. I apologize, I thought I had already replied.
Anyhow, I proved my point to our software guy, enough that he is willing
to look into it further. Although I have a feeling he isn't going to want
to do it (but at least he
Hmm...have you looked at Rekall?
www.total-rekall.co.uk
Also, you might want to check out OpenOffice.org's database interface
features
Regards,
Chris
On Sat, 2004-01-17 at 11:12, Bryan Koschmann - GKT wrote:
I wanted to thank everyone for their responses and information regarding
this. I
Direct your developer to www.vbmysql.com. This site is dedicated to supporting
developers who want to use MySQL with VB. We will be happy to help him with anything
he runs into while writing your system for you.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Morten Gulbrandsen wrote:
http://www.google.com/groups?hl=enlr=ie=UTF-8oe=UTF-8q=MySQL+toy+marston
Subject: Re: Can MySQL table handle 3 million+ entries?
Newsgroups: comp.lang.php
Date: 2003-04-11 15:20:10 PST
MySQL is NOT a toy database - it is far superior to many I have used in my
long
At 09:37 PM 1/5/2004, Bryan Koschmann - GKT wrote:
Hi,
I'm trying to get a software designer to write us some software using
MySQL as the database server (he currently requires MS SQL). It is all
windows based software (written in VB).
So far his arguments against it are this (not my words):
-No
Bryan Koschmann - GKT wrote:
Hi,
I'm trying to get a software designer to write us some software using
MySQL as the database server (he currently requires MS SQL). It is all
windows based software (written in VB).
So far his arguments against it are this (not my words):
-No explicit
Bryan,
Although this doesn't answer your initial request...why are you wanting to
'argue' with this guy over the database to use. If he won't code for the
application to use MySQL (which isn't all that hard in VB regardless of what
he says) then get another coder...as simple as that.
On Jan 5, 2004, at 9:37 PM, Bryan Koschmann - GKT wrote:
-No explicit transactional support
Wrong. InnoDB tables support transactions.
-MySQL is still buggy
Care to have him specify what bugs he is referring to? I've been using
MySQL for 2 years now, and use Microsoft SQL Server for about 3
On Mon, 5 Jan 2004, Craig Vincent wrote:
Although this doesn't answer your initial request...why are you wanting to
'argue' with this guy over the database to use. If he won't code for the
application to use MySQL (which isn't all that hard in VB regardless of what
he says) then get
Well,
I think this statement does it all,
http://www.google.com/groups?hl=enlr=ie=UTF-8oe=UTF-8q=MySQL+toy+marston
Subject: Re: Can MySQL table handle 3 million+ entries?
Newsgroups: comp.lang.php
Date: 2003-04-11 15:20:10 PST
MySQL is NOT a toy database - it is far superior to many I have
Bryan Koschmann - GKT [EMAIL PROTECTED] [2004:01:05:18:58:12-0800] scribed:
snip /
Here is the explanation I just received when asking for the difference
between transaction support:
-
MySQL uses single-action implicit and explicit transactions, but they do
not
automatically roll
Bryan Koschmann - GKT wrote:
[MySQL]
1: START TRANSACTION
2: WITHDRAW $50 from account 32146.
3: DEPOSIT $50 into account 12345.
4: LOG transfer (date/time/teller/etc...) for auditing.
5: COMMIT TRANSACTION
if this failed at step 3 the transaction would be hung and even if rolled
back by server
Hi,
I have been using MySQL since 3.2x and now 4.0.1x in Windows NT and Windows
2000 IIS / .asp environment including MyODBC for more than 4 years now, and
never lost any data. Setup problems have been solved by reading and
following instruction in the manual, or asking in the support /
Hi
We have been running MySql since 1998 and have never had any data corruption
We have servers running millions of queries a day and they are bullet proof.
Hi,
I'm trying to get a software designer to write us some software using
MySQL as the database server (he currently requires MS
Thanks Peter.
I strongly suspect that I'm getting deadlocks where it's simply a lock contention.
Grrr.
I chose BDB because my client has it available on his installation. I'll configure
InnoDB support
if necessary. It looks like a LOT less headache.
Thanks.
- Mike.
OK, I don't seem to be getting a response. Let me try to simplify:
I'm running a PHP application with MySQL.
I'm in a transaction involving only BDB tables. Actually the whole database has
nothing but BDB
tables.
I attempt a query which fails with error number 1213. The full text message is
12:38 AM
Subject: Re: Transaction newbie question
OK, I don't seem to be getting a response. Let me try to simplify:
I'm running a PHP application with MySQL.
I'm in a transaction involving only BDB tables. Actually the whole
database has nothing but BDB
tables.
I attempt a query which
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
---Original Message-
--From: Arnoldus Th.J. Koeleman [mailto:[EMAIL PROTECTED]
--Sent: Thursday, November 06, 2003 1:24 PM
--To: [EMAIL PROTECTED]
--Subject:
Robert Morgan [EMAIL PROTECTED] wrote:
Hi I'm running mysql 4.0.14
I'm doing an update from a webpage involving 3 tabIes, using 3 update queries and
need to be able to roll back to
before the first update query if the second or third query go pear shape. So I need
to set a savepoint to
# [EMAIL PROTECTED] / 2003-06-24 15:15:33 +0530:
Does MYSQL support transaction concept, which includes issues
like commiting data , rollbacking etc???
Did you know MySQL has documentation?
--
If you cc me or remove the list(s) completely I'll most likely ignore
your message.
# [EMAIL PROTECTED] / 2003-06-24 12:29:33 +0200:
# [EMAIL PROTECTED] / 2003-06-24 15:15:33 +0530:
Does MYSQL support transaction concept, which includes issues
like commiting data , rollbacking etc???
Did you know MySQL has documentation?
# [EMAIL PROTECTED] / 2003-06-24
Palaparthy [EMAIL PROTECTED] wrote:
Does MYSQL support transaction concept, which includes issues
like commiting data , rollbacking etc???
Yes.
http://www.mysql.com/doc/en/ANSI_diff_Transactions.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
On Wed, Mar 26, 2003 at 09:03:35PM -0800, Nitin Nanivadekar wrote:
Dear Friends,
The last help I got was truly worth a zillion.
Such a bargin!
1. How can i have commit/rollback functions using
MyIsam database which is default database engine for
MySql? i am using vb
You cannot. MyISAM
]
Sent: Wednesday, March 26, 2003 11:48 PM
To: Nitin Nanivadekar
Cc: [EMAIL PROTECTED]
Subject: Re: Transaction Support with MyISAM
On Wed, Mar 26, 2003 at 09:03:35PM -0800, Nitin Nanivadekar wrote:
Dear Friends,
The last help I got was truly worth a zillion.
Such a bargin!
1. How can i have
Hello Ramanan-
First off, make sure you create tables of type InnoDB, Berkeley, or
Gemini. [My]ISAM tables don't do transactions.
The simplest way to do a transaction is
mysql BEGIN;
mysql # successful edit
mysql COMMIT;
or
mysql BEGIN;
mysql # failed edit, or dropped connection implies
mysql
Mark, Steff,
- Original Message -
From: Mark Matthews [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, February 12, 2003 3:09 AM
Subject: Re: Transaction problems using InnoDB, not locked with LOCKTABLES
-BEGIN PGP SIGNED MESSAGE
: Heikki Tuuri [EMAIL PROTECTED]
To: Mark Matthews [EMAIL PROTECTED],
[EMAIL PROTECTED]
Copies to: [EMAIL PROTECTED]
Subject:Re: Transaction problems using InnoDB, not
locked with LOCKTABLES
Date sent: Thu, 13 Feb 2003 16
Steff,
- Original Message -
From: [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, February 13, 2003 7:21 PM
Subject: Re: Transaction problems using InnoDB, not locked with LOCKTABLES
Heikki,
Thanks for the reply.
My confusion
be greatly appreciated.
Thanks
Steff
On 13 Feb 2003 at 20:03, Heikki Tuuri wrote:
From: Heikki Tuuri [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Copies to: [EMAIL PROTECTED]
Subject:Re: Transaction problems using InnoDB, not
locked
SET autocommit=1
- Original Message -
From: [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Thursday, February 13, 2003 8:54 PM
Subject: Re: Transaction problems using InnoDB, not locked with LOCKTABLES
Heikki
PROTECTED],
[EMAIL PROTECTED],
[EMAIL PROTECTED]
Subject:Re: Transaction problems using InnoDB, not
locked with LOCKTABLES
Date sent: Thu, 13 Feb 2003 21:59:22 +0200
Steff,
a note on terminology: every query inside InnoDB always happens inside
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
[EMAIL PROTECTED] wrote:
Heikki,
The application which is having this problem is used to read an
XML document and update a database. The application is part of a
website, so there are always other interactions with the database
while the
:Re: Transaction problems using InnoDB, not
locked with LOCKTABLES
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
[EMAIL PROTECTED] wrote:
Heikki,
The application which is having this problem is used to read an
XML document and update a database. The application
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
[EMAIL PROTECTED] wrote:
Hello,
We are experiencing severe problems when running MySql with
INNODB in a production environment. Applications which work
fine under light load fail when under production load.
Our MySql environment is as
sent: Tue, 11 Feb 2003 19:09:16 -0600
From: Mark Matthews [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Copies to: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject:Re: Transaction problems using InnoDB, not
locked
hi,
i have installed mysql3.23.54 on windows and have
followed all instructions as required for using
mysqld-max to have transaction support.
i have created a table using TYPE=INNODB, but cannot
use rollback on it.
the error i get in my jsp is transactions not
supported.
please advice me on how i
Correct me if I am wrong, but I believe mysql 3.23.54 does not support
transaction support, version 3.23.54 has row locking only. Transaction
feature starts with version 4.0.x.
Bob
- Original Message -
From: Nirmal Shah [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wednesday 22 January 2003 08:56 pm, Nirmal Shah wrote:
hi,
i have installed mysql3.23.54 on windows and have
followed all instructions as required for using
mysqld-max to have transaction support.
i have created a table using TYPE=INNODB, but
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Robert Tam wrote:
Correct me if I am wrong, but I believe mysql 3.23.54 does not support
transaction support, version 3.23.54 has row locking only. Transaction
feature starts with version 4.0.x.
Bob
You're corrected :)
3.23.54 supports InnoDB
PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Thursday, January 23, 2003 9:44 AM
Subject: Re: Transaction Support in mysql13.23.54
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wednesday 22 January 2003 08:56 pm, Nirmal Shah wrote:
hi,
i have installed mysql3.23.54 on windows and have
Robert,
- Original Message -
From: Robert Tam [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Friday, January 10, 2003 7:43 AM
Subject: Transaction and Row Locking Feature
Hello,
I am a new user to MySQL. I need innoDB's transaction and row locking
feature in MySQL.
Amine Korch wrote:
Hello all.
I have encountered an really annoying problem in MySQL 3.23.49 on Win32.
I am using InnoDB because I need transactions. I use autocommit off.
I'll try best to describe the problem I have:
I have two sessions to my DB.
Session 1 inserts some data into a
Hi!
- Original Message -
From: Mark Matthews [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Tuesday, October 08, 2002 5:07 AM
Subject: Re: transaction isolation level
Jianliang Zhao wrote:
...
I am connecting to MySql 3.23(innodb) with
mysql-connector-java-2.0.14-bin.jar
]
Subject: Re: transaction isolation level
Hi!
- Original Message -
From: Mark Matthews [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Tuesday, October 08, 2002 5:07 AM
Subject: Re: transaction isolation level
Jianliang Zhao wrote:
...
I am connecting to MySql 3.23(innodb
]; Mark Matthews
[EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, October 08, 2002 7:40 PM
Subject: RE: transaction isolation level
Thanks for all your help. Then it's more confusing to me. I opened two MySql
windows and set autocommit=0 and then update one column and then issue the
command COMMIT
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: 2002?10?8? 9:56
To: Jianliang Zhao; Mark Matthews
Cc: [EMAIL PROTECTED]
Subject: Re: transaction isolation level
Jianliang,
I tested that with two mysql clients, and it appeared to work ok. Check with
SHOW CREATE
On Mon, Oct 07, 2002 at 05:30:57PM -0700, Jianliang Zhao wrote:
Hi,
I am connecting to MySql 3.23(innodb) with
mysql-connector-java-2.0.14-bin.jar. I set the global transaction
isolation level to READ COMMITTED. However, I still couldn't see the
committed changes through JDBC client. Does
: [EMAIL PROTECTED]
Subject: Re: transaction isolation level
On Mon, Oct 07, 2002 at 05:30:57PM -0700, Jianliang Zhao wrote:
Hi,
I am connecting to MySql 3.23(innodb) with
mysql-connector-java-2.0.14-bin.jar. I set the global transaction
isolation level to READ COMMITTED. However, I still
:36
To: Jianliang Zhao
Cc: [EMAIL PROTECTED]
Subject: Re: transaction isolation level
On Mon, Oct 07, 2002 at 05:30:57PM -0700, Jianliang Zhao wrote:
Hi,
I am connecting to MySql 3.23(innodb) with
mysql-connector-java-2.0.14-bin.jar. I set the global transaction
isolation level to READ
Randy,
Tuesday, August 20, 2002, 8:51:36 AM, you wrote:
RJ Here is an insert from the innodb reference manual
[skip]
RJ The solution is to perform the SELECT in a locking mode, LOCK IN SHARE MODE.
RJ SELECT * FROM PARENT WHERE NAME = 'Jones' LOCK IN SHARE MODE;
[skip]
RJ This means that if
Randy,
Monday, August 19, 2002, 7:29:43 PM, you wrote:
RJ Thanks for your reply, is it documented somewhere?
That COMMIT and ROLLBACK release locks? Of course, look at:
http://www.mysql.com/doc/en/InnoDB_transaction_model.html
--
For technical support contracts, goto
On Tuesday 20 August 2002 01:26 pm, Randy Johnson wrote:
I am confused. (innodb table type)
I'm really not so sure about the 'lock in share mode' thing, but to the best
of my knowledge if you do a
SET TRANSACTION_ISOLATION_LEVEL=SERIALIZABLE
and then start a transaction where you read data
Randy,
Sunday, August 18, 2002, 10:57:54 AM, you wrote:
RJ I am using innodb tables via mysql max
RJ if i do a select * for update
RJ and then do an update statement
RJ will this unlock the record for another update or will it wait for me to do
RJ a commit?
It will wait for
Thanks for your reply, is it documented somewhere?
Randy
- Original Message -
From: Victoria Reznichenko [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, August 19, 2002 10:07 AM
Subject: Re: Transaction Question
Randy,
Sunday, August 18, 2002, 10:57:54 AM, you wrote:
RJ I
are you familiar with the different MySQL table types?
they are:
MyISAM
BDB
Gemini
InnoDB
but InnoDB is the most robust, supports row-level locking, ACID transactions (no dirty
reads), and foreign key restraints... read up on it here: http://www.innodb.com
but InnoDB does
Andrew,
MySQL-Max-3.23 also supports transactions, and that is a stable release.
Best regards,
Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, row level locking, and foreign key support for MySQL
See http://www.innodb.com, download MySQL-Max from http://www.mysql.com
- Original
Hi there, correct me if I am wrong. Only verion 4.x of MySQL supports
transaction.
If I remember correctly, BDB has transaction support and was released during
3.23 development.
Sincerely,
Craig Vincent
-
Before posting,
* Andrew Chan
Hi there, correct me if I am wrong. Only verion 4.x of MySQL supports
transaction.
You are wrong. :)
3.23.*-max binaries support BDB and InnoDB tables, both support
transactions.
URL: http://www.mysql.com/doc/B/D/BDB.html
URL: http://www.mysql.com/doc/I/n/InnoDB.html
--
Yes MySQL supports transaction.
But you have to use certain table types : for example InnoDB or BDB (and not
MyISAM).
I use InnoDB ; read the following section of the manual :
http://www.mysql.com/documentation/mysql/bychapter/manual_Table_types.html#I
nnoDB
it will tell you which options you may
Hi Arawind,
Could any one help how to cope up without transactons
in mysql. The Help manual provided with the software
doesn't help a great deal.
Oneway is to incorporte transaction processing functionalities in the
middle layer application. eg. before commiting persistent objects used for
Luca,
Hi, I need transaction in my db. I installed Mysql max and I'm usind
InnoDb tables.
When an error occurred during the transaction the mysql continue with
the execution. Do I need to manually check every query result to
know if query get ok and then in case of error make a rollback?
I
On Mon, Oct 22, 2001 at 11:14:58AM -0400, Victor wrote:
Hello
As I understand it, MySQL with InnoDB or BDB support can support
transactions. Is there a doc on the shortcomings of these tables and
which one is better? MySQL documentation has a shortcomings page for
InnoDB (but couldn't find
At 11:37 AM -0400 9/20/01, Kevin Slean wrote:
I have come across a flawed transaction counter in a mysql application that
I now support. I believe it is flawed because it does not use record
locking to deal with concurrency and was hoping someone could give me ideas
on how to correct.
The
Matthew Harting writes:
Which table type would you
recommend using for transaction support?
InnoDB, unless you have a small database and plenty of RAM.
At least that's what others who have actually tried it have
said. Since what I'm doing isn't really in need of transactions
I'm sticking
Willy,
people have written quite a lot of compiling MySQL on
OS X. It should be possible. Below is an ad of a CD
which contains the OS X version. Obviously the
producers of the CD have been able to compile.
Regards,
Heikki
http://www.innodb.com
Copied message:
Hi,
Are there
Date |Mon, 6 Aug 2001 13:44:28 +0200
From |Willy Faes [EMAIL PROTECTED]
Hello!
WF Hi,
WF Are there any transaction safe tables for Mac OS X you can use?
WF Thanks,
WF Willy Faes
You must use innodb or bdb tables for transaction safe.
Both may normaly compilled on Mac OS
Hi!
You can change the MySQL server program from
mysqld-nt.exe or any other mysqld*.exe to
mysqld-max.exe or mysqld-max-nt.exe (on NT and 2000)
without changing your MyISAM tables in any way.
The MyISAM part in these versions is identical.
To use InnoDB tables you have to add startup
On Wed, Jul 18, 2001 at 02:06:03PM -0700, Michael Tam wrote:
Hi all,
I am new using MySQL. I found out that the default table type used
in the binary isn't support transaction and would like to make
MySQL uses another table type which supports transaction. The
following are my
-max takes over??
Thank you very much.
Regards,
Michael
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Michael Tam [EMAIL PROTECTED]
Cc: mysql [EMAIL PROTECTED]
Sent: Saturday, July 21, 2001 2:57 AM
Subject: Re: Transaction for MySQL
On Wed, Jul 18, 2001 at 02:06
On Sat, Jul 21, 2001 at 03:46:58AM -0700, Michael Tam wrote:
Hi Jeremy,
In question 2), what I meant is not uninstall MySql from Windows 2000
but the service of it by calling mysqld-nt --remove. That will take off
the service of the mysql-nt from being the default mysql daemon and
Hi everyone,
Would someone help me out with these questions?
I know these may be something obvious/ in the manual .. etc but I would
like to have someone showing me if I am on the right track and maybe share
some of these in greater detail. Greatly appreciated.
Regards,
Michael
Would someone help me out with these questions?
I know these may be something obvious/ in the manual .. etc but I
would
like to have someone showing me if I am on the right track and maybe
share
some of these in greater detail. Greatly appreciated.
Since the experts are too busy,
MT 1) which one should I use InnoDB or BDB? what kind of advantages
MT given by each type?
I'm not expert but AFAIK BDB databases doesn't work well (i.e. fast)
if they don't fit fully in RAM. Another important thing: InnoDB
provides row-level locking while BDB only page-level locking. Thus it
On Fri, 22 Jun 2001 15:17:18 -0700, Alberni-dot-Net Tech Mailing Lists
[EMAIL PROTECTED] wrote:
What sort of support for transactions and table/record locking is there in MySQL
right now? I had heard that only table locking was supported, and limited support
for transactions.
we've had
1 - 100 of 106 matches
Mail list logo