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 tab
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 b
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 subseque
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 nece
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 querie
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:
>
> B
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 sc
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
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 contstraint
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.
>
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.
F
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
Marc
Hi, here's my create table:
mysql> show create table parametrivaloriplc;
++-+
| Table | Create Table|
++-+
| parametrivaloriplc | CREATE
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 |
| m
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
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 i
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
propert
t;[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
PROTECTED]>
> > 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 suppor
uot; <[EMAIL PROTECTED]>
> 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?)
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
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 erro
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
http:
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: 14/2/200
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.
--
Dani
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 wrot
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 a
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
On Tuesday, January 06, 2004 2:54 PM, Patrick Shoaf wrote:
> At 09:37 PM 1/5/2004, Bryan Koschmann - GKT wrote:
> >Now, I know there are a few discrepancies there but I just don't know
> >enough to argue it. I * need* to use MySQL as the server because of
> >cost reasons. I *WANT* to use MySQL b
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
Morten Gulbrandsen wrote:
http://www.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&q=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 ca
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 u
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 requ
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 / newsgroups
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 ad
Bryan Koschmann - GKT <[EMAIL PROTECTED]> [2004:01:05:18:58:12-0800] scribed:
> 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 rol
Well,
I think this statement does it all,
http://www.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&q=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
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
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 ye
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. The
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 transactiona
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.
___
;
Sent: Friday, November 21, 2003 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 whol
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
s
- 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: Trans
"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 savepo
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=ens
# [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
# [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.s
[mailto:[EMAIL PROTECTED]
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.
S
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. MyIS
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
my
AIL PROTECTED]
Subject: 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
-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 "loa
<[EMAIL PROTECTED]>
Copies to: <[EMAIL PROTECTED]>,
<[EMAIL PROTECTED]>,
<[EMAIL PROTECTED]>
Subject:Re: Transaction problems using InnoDB, "not
locked with LOCKTABLES"
Date sent: Thu, 13 Feb 2003 21:59:22
7; AND SecondaryID = 'CKCBSBF2994311'
7 Query COMMIT
7 Query SET autocommit=1
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL
how to narrow the focus of our research
would 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 PROTECTE
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"
> Heik
: "Heikki Tuuri" <[EMAIL PROTECTED]>
To: "Mark Matthews" <[EMAIL PROTECTED]>,
<[EMAIL PROTECTED]>
Copies to: <[EMAIL PROTECTED]>
Subject:Re: Transaction problems using InnoDB, "not
lo
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 loc
hews wrote:
Date 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, &
-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 follows
>
To: "Nirmal Shah" <[EMAIL 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 Sha
-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 whi
-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,
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]>
S
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
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 My
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
-Jianliang
-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
S
--+
1 row in set (0.00 sec)
mysql>
- Original Message -
From: "Jianliang Zhao" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>; "Mark Matthews"
<[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, October 08,
i Tuuri [mailto:[EMAIL PROTECTED]]
Sent: 2002?10?8? 0:22
To: Mark Matthews
Cc: [EMAIL PROTECTED]
Subject: Re: transaction isolation level
Hi!
- Original Message -
From: "Mark Matthews" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Tuesday, October 08, 2002
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) w
o:[EMAIL PROTECTED]]
>Sent: 2002?10?7? 17: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(inn
ao
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 C
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.
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 f
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 https://order.my
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
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,
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 COMMIT/RO
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 multi-versioni
* 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.
http://www.mysql.com/doc/B/D/BDB.html >
http://www.mysql.com/doc/I/n/InnoDB.html >
--
Roger
--
> 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,
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 Message
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 f
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?
>
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
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 w
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
_
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
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
parameters
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 a
sqld-nt" will remain intact as
"mysql-max" takes over??
Thank you very much.
Regards,
Michael
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Michael Tam" <[EMAIL PROTECTED]>
Cc: "mysql" <[EMAIL PROTE
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 q
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
>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 b
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
-
1 - 100 of 108 matches
Mail list logo
