ViSolve DB Team
- Original Message -
From: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Monday, September 25, 2006 11:42 AM
Subject: Transactions in MySQL.
Hi All,
How transactions and locking are handled in MYSQL?
Is it a part of configuration? Or a query (lock tables
Hi All,
How transactions and locking are handled in MYSQL?
Is it a part of configuration? Or a query (lock tables, Unlock tables)
for each set of queries?
Regards,
Ravi K
The information contained in this electronic message and any attachments to
this message are intended
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
I have been pulling my hair out trying to get a solution to something,
assuming idiotically that in a transaction scenario I would not be able to
get the insert it back out. It seems to work, I am wondering how and if it
is reliable.
Give the scenario where I have 2 inserts I want to make, since
MySQL doesn't guarantee that there will be no gaps in sequence values.
Assigment of the id is always atomic because innodb uses an AUTO_INC
lock that lasts for the time of the insert, not the life of the
transaction.
lets say your highest order number is 10
transaction begins for client 1
on 7/22/04 3:54 PM, Justin Swanhart at [EMAIL PROTECTED] wrote:
MySQL doesn't guarantee that there will be no gaps in sequence values.
Assigment of the id is always atomic because innodb uses an AUTO_INC
lock that lasts for the time of the insert, not the life of the
transaction.
lets say
To: [EMAIL PROTECTED]
Subject: Re: high level: enabling transactions in mysql-max with
WebLogic TX datasource?
Bert == Bert VdB [EMAIL PROTECTED] writes:
Bert Hi,
Bert all you have to do use a transaction enabled data-source and use
the
Bert Mm-MysqlDriver
Bert for your JDBC
-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Sunday, June 30, 2002 22:33
To: [EMAIL PROTECTED]
Subject: high level: enabling transactions in mysql-max with WebLogic TX
datasource?
One thing that I find a little confusing is the notion of transactional
behavior in mySQL. I read
Bert == Bert VdB [EMAIL PROTECTED] writes:
Bert Hi,
Bert all you have to do use a transaction enabled data-source and use the
Bert Mm-MysqlDriver
Bert for your JDBC connections. (http://mmmysql.sourceforge.net/)
Bert Best is to read the InnoDB documentation carefully
One thing that I find a little confusing is the notion of transactional
behavior in mySQL. I read that it's possible to enable transactions in
mySQL-max, however, it's never really been clear to me exactly what I'm
supposed to do, or whether I have to do anything. If I'm using a transactional
Hello
I can't create innoDB tables in db MySQL to do
rollback and commit
transactions.
I try to modify the my.cnf file with the instructions
that I find in manuel.pdf but it don't work.
Can you help me please ?
Thanks.
Ps : i'm french. :-)
please let us know the SQL query you are trying, and a DESCRIBE TABLENAME so we can
see how your table(s) are laid out. also, please tell us what you actually changed
in your my.cnf file
by the way, before you can do transactions, you must set the AUTOCOMMIT variable to
0
-Ryan Hatch
a a
First question: did you set autocommit=0?
--Walt Weaver
Bozeman, Montana
-Original Message-
From: a a [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 22, 2002 9:27 AM
To: [EMAIL PROTECTED]
Subject: transactions on MySQL (innoDB)
Hello
I can't create innoDB tables in db MySQL to do
Hi,
I'm working on a payment system that uses an e-wallet. I intend for the
system to provide payment services to other merchants on their sites as well
and I'm worried about scalability and correctly tracking transactions.
Incidentally, I'm very familiar with SQL Server getting MySQL to do
And if they don't read the manual, how do they know which table types
they will need?
Nobody who has not read the manual should expect to be able to post
without
geting a reminder to RTFM.
He obviously did not read about how to properly post a problem.
He asked if MySql supports transactions
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 type
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 the method
t's coming soon, but is still in process..).
So telling them to RTFM doesn't help, because even if they do, it won't give
them transactions. MySQL seems to ignore TABLE TYPE specifications if it
isn't compiled for that table type (i.e. if you take the default
distribution and create a table wit
MySql support transactions?
The OLE-DB provider support transactions?
Call the method Begintrans on a connection object (ADO) return an error!!!
19 matches
Mail list logo