in a transaction in a way I can store it and
rollback later?
James,
The way you describe it sounds like you have a modeling issue with your system.
Committed transactions are not supposed to be rolled back.
Your System Architect has to arrange things in such a way that all the
information
I have a large series of mysql changes(inserts/deletes/updates) taking
place in a transaction. After committing there may be some times where I
need to roll those changes back later on. Is there an easy way of
determining what was changed in a transaction in a way I can store it and
rollback
to design a master table
having more than 200 columns?
Have you ever read a book on database design normalization?
PART II:
Secondly, I am using PHP, Mysql, ADODB, APACHE on windows 7 platform. This
is my typical DML command:
I am not using any rollback statement to rollback the db if the DML
);
DispMsg(User Profile edited successfully);
}
I am not using any rollback statement to rollback the db if the DML command is
not completed successfully. Is it advisable to use rollback? If it is how
should I modify the above statement to include it ?
Thanks in advance for your help
()));
return 0;
}
else
{
// updatelog($id,users,$query,usrmgr.php,$ses_username,$myip);
DispMsg(User Profile edited successfully);
}
I am not using any rollback statement to rollback the db if the DML command is
not completed successfully. Is it advisable
That is correct. Many db interfaces off programmatic abstractions of
these facilities, but you may certainly just issue the statments.
START TRANSACTION
INSERT that
UPDATE that
on success: COMMIT
on error: ROLLBACK
- michael dykman
On Wed, Oct 28, 2009 at 12:07 AM, Mosaed AlZamil mosza
://www.databasedevelopmentforum.com
That is correct. Many db interfaces off programmatic abstractions of
these facilities, but you may certainly just issue the statments.
START TRANSACTION
INSERT that
UPDATE that
on success: COMMIT
on error: ROLLBACK
- michael dykman
On Wed, Oct 28, 2009 at 12:07 AM
of
these facilities, but you may certainly just issue the statments.
START TRANSACTION
INSERT that
UPDATE that
on success: COMMIT
on error: ROLLBACK
- michael dykman
On Wed, Oct 28, 2009 at 12:07 AM, Mosaed AlZamil mosza...@gmail.com
wrote:
Hello Everyone,
I am a newbie using innodb.
How can I
interfaces off programmatic abstractions of
these facilities, but you may certainly just issue the statments.
START TRANSACTION
INSERT that
UPDATE that
on success: COMMIT
on error: ROLLBACK
- michael dykman
On Wed, Oct 28, 2009 at 12:07 AM, Mosaed AlZamil mosza
that
UPDATE that
on success: COMMIT
on error: ROLLBACK
- michael dykman
On Wed, Oct 28, 2009 at 12:07 AM, Mosaed AlZamil mosza...@gmail.com
wrote:
Hello Everyone,
I am a newbie using innodb.
How can I implement START TRANSACTION COMMIT ROLLBACK when I
need
programmatic abstractions of
these facilities, but you may certainly just issue the statments.
START TRANSACTION
INSERT that
UPDATE that
on success: COMMIT
on error: ROLLBACK
- michael dykman
On Wed, Oct 28, 2009 at 12:07 AM, Mosaed AlZamil mosza...@gmail.com
wrote
There seems to be some confusion about 'multi-db'.Within a single
MySQL instance, assuming that all your tables are a transactional type
(InnoDB isn't the only one), you don't have to do anything special to
cross database boundaries. XA is required if you plan to spread your
transactions out
Hello Everyone,
I am a newbie using innodb.
How can I implement START TRANSACTION COMMIT ROLLBACK when I need to update
two tables
that are located in two different databases. Would a single START
TRANSACTION be sufficient ?
Any help would be appreciated.
TIA
Mos
name=bob;
Update users set visit_count=X where id=bobId and version=Y
Commit;
Set autocommit=1;
When this tx is executed about 100 times/sec, appserver latency is about
10-15 ms per http request (including db time). However, when instead of
commit a 'rollback' is issued, the latency spikes
and version=Y
Commit;
Set autocommit=1;
When this tx is executed about 100 times/sec, appserver latency is about 10-15
ms per http request (including db time). However, when instead of commit a
'rollback' is issued, the latency spikes to 600-1100 ms (nearly all of that
time in appserver appears
.
- Original Message
From: B. Keith Murphy [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Friday, November 16, 2007 10:29:17 AM
Subject: innodb rollback question
I have something to throw out. I just got done importing 140 million
rows from a myisam table to a innodb table. While it worked I had
in a single
transaction? How long would it take to rollback that transaction if it had
over 130 million rows?
Mike
On Nov 17, 2007 12:29 AM, B. Keith Murphy [EMAIL PROTECTED] wrote:
I have something to throw out. I just got done importing 140 million
rows from a myisam table to a innodb
.
The only way I know of to stop a rollback like that is to bring out the
sledgehammer and kill the mysql processes and then rip out the entire
database and re-import. Faster than the rollback granted - but not very
elegant. Not something you want to do on a production server either
(the only
: B. Keith Murphy [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Friday, November 16, 2007 10:29:17 AM
Subject: innodb rollback question
I have something to throw out. I just got done importing 140 million
rows from a myisam table to a innodb table. While it worked I had a
thought about 3
got done importing 140 million
rows from a myisam table to a innodb table. While it worked I had a
thought about 3/4ths of the way through. What if the transaction had
been canceled about 130 million rows in? It would have taken weeks to
roll back.
The only way I know of to stop a rollback
Robert DiFalco wrote:
Is there any difference between calling rollback or commit on a
transaction that did not alter data? For example, not a read-only
transaction but a transaction that only performed read-only selects. Any
difference in performance between calling rollback or commit? I know
]
Sent: Monday, September 17, 2007 2:56 PM
To: Robert DiFalco
Cc: Baron Schwartz; mysql@lists.mysql.com
Subject: Re: Rollback on a Transaction with No Updates
If your transaction are only 1 query deep, why use them at all? An
individual query is already atomic, regardless of table type/server
Well, assume a higher level abstraction that does not give clients to
that abstraction access to the raw connection. It only has methods like
update, search, commit, or rollback. What the connection is doing is a
kind of implementation detail.
-Original Message-
From: Michael Dykman
Robert DiFalco wrote:
Is there any difference between calling rollback or commit on a
transaction that did not alter data? For example, not a read-only
transaction but a transaction that only performed read-only selects. Any
difference in performance between calling rollback or commit? I know
While it is functionally equivalent I wonder if it the code paths taken
are the same. I suppose for both commit and rollback mysql would have to
look for any pending work, if there were none both would do nothing.
That's what makes me think that there is probably no performance
difference between
are the same. I suppose for both commit and rollback mysql would have to
look for any pending work, if there were none both would do nothing.
That's what makes me think that there is probably no performance
difference between the two. I ask this because my programmers like to do
this:
con
Is there any difference between calling rollback or commit on a
transaction that did not alter data? For example, not a read-only
transaction but a transaction that only performed read-only selects. Any
difference in performance between calling rollback or commit? I know
they are functionally
Sure, but that wasn't really the question.
-Original Message-
From: Michael Dykman [mailto:[EMAIL PROTECTED]
Sent: Monday, September 17, 2007 2:56 PM
To: Robert DiFalco
Cc: Baron Schwartz; mysql@lists.mysql.com
Subject: Re: Rollback on a Transaction with No Updates
If your transaction
Hi,
In my stored procedures, i want to ROLLBACK when I encounter any
invalid values. However, as it happens, I cannot because MySQL does
not support COMMIT/ROLLBACK functionality right now (as of ver. 5.0.22
on WinXP Pro). I am setting session variables (Set @XX=Error
Message') according ot
Dear Sir,
How to know MySQL enable for ROLLBACK ?
Thanks you and best regards,
--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
How to know MySQL enable for ROLLBACK ?
Use InnoDB tables.
Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http
|
+---+--+
222 rows in set (0.00 sec)
Please check what is wrong and teach me.
Thanks you,
- Original Message -
From: Pooly [EMAIL PROTECTED]
To: MySQL General mysql@lists.mysql.com
Sent: Tuesday, March 14, 2006 2:53 PM
Subject: Re: Rollback is not take effect
2006/3/11, Truong Tan Son [EMAIL PROTECTED]:
Dear Sir,
On RedHat Enterprise 4, and MySQL 5.0.18, I did :
mysql set autocommit=0;
mysql savepoint abc;
mysql insert something
mysql rollback to save point abc;
Query OK, 0 rows affected, 1 warning (0.00 sec
|
+--+
I set innodb_table_locks=0 in my.cnf , but ROLLBACK is still not effect.
Could you teach me more ?
Thanks and best regards,
- Original Message -
From: Pooly [EMAIL PROTECTED]
To: MySQL General mysql@lists.mysql.com
Sent: Monday, March
=0 in my.cnf , but ROLLBACK is still not effect.
Could you teach me more ?
Thanks and best regards,
- Original Message -
From: Pooly [EMAIL PROTECTED]
To: MySQL General mysql@lists.mysql.com
Sent: Monday, March 13, 2006 5:13 PM
Subject: Re: Rollback is not take effect on MySQL
Dear Sir,
On RedHat Enterprise 4, and MySQL 5.0.18, I did :
mysql set autocommit=0;
mysql savepoint abc;
mysql insert something
mysql rollback to save point abc;
Query OK, 0 rows affected, 1 warning (0.00 sec)
^^
RollBack
Hi everybody!
Martijn Tonies wrote:
I execute follow procedure:
---
create procedure test_transation_rollback()
begin
start transaction;
create table t_34d (c1 int,c2 char(30));
rollback;
end
I execute follow procedure:
---
create procedure test_transation_rollback()
begin
start transaction;
create table t_34d (c1 int,c2 char(30));
rollback;
end
After
I execute follow procedure:
---
create procedure test_transation_rollback()
begin
start transaction;
create table t_34d (c1 int,c2 char(30));
rollback;
end
Hello,
Something weird happened on Wednesday: My Mac OSX Server unexpectedly
restarted itself around 7PM. Everything seemed to be functional after
that. However, I just noticed that basically a week worth of changes
to a MySQL database have disappeared. Gone. Vanished. Objects that
were
8:07 PM
Subject: rollback after crash on OS X
Hello,
Something weird happened on Wednesday: My Mac OSX Server unexpectedly
restarted itself around 7PM. Everything seemed to be functional after
that. However, I just noticed that basically a week worth of changes
to a MySQL database have
Hi All,
I have just started using My-sql 4.1.9 mysql Ver 14.7 Distrib 4.1.9,
for pc-linux-gnu (i686)
Is there a way I could rollback my changes , i tried to go through the
documentation but it wasn't of much help.
regards
Digvijoy
Hello,
I have just started using My-sql 4.1.9 mysql Ver 14.7 Distrib 4.1.9,
for pc-linux-gnu (i686)
Is there a way I could rollback my changes , i tried to go through the
documentation but it wasn't of much help.
Transactions are only used when you use the InnoDB or BDB table
types
John,
Marko will add a commit at every 10 000 rows to CREATE INDEX in 4.1.11. Then
this kind of a runaway rollback can not happen any more.
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which
Hi,
We have a large InnoDB table to which we recently added an index. That
index creation thread was issued a kill yesterday due to length of
time, unfortunately according to 'show innodb status' the rollback is
now 162 hrs away from completion (1 every 5 secs).
We are not using per-table
John,
- Original Message -
From: John Taylor [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Saturday, February 26, 2005 6:54 PM
Subject: InnoDB Rollback - 162 hrs remaining!?
Hi,
We have a large InnoDB table to which we recently added an index. That
index creation thread
: mailing.database.myodbc
Sent: Saturday, February 26, 2005 6:54 PM
Subject: InnoDB Rollback - 162 hrs remaining!?
Hi,
We have a large InnoDB table to which we recently added an index. That
index creation thread was issued a kill yesterday due to length of
time, unfortunately according
John,
- Original Message -
From: John Taylor [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Saturday, February 26, 2005 11:37 PM
Subject: Re: InnoDB Rollback - 162 hrs remaining!?
Thanks for the quick response. I note within the database directory a
#sql- file but it has
Devananda,
the ALTER TABLE creates a temporary table #sql... The rollback is running in
that table. The manual contains instructions on how to rename and drop such
table.
You should upgrade to 4.1.9. That version commits ALTER TABLE at every 10
000 rows, and a runaway rollback can no longer
On Tue, 8 Feb 2005, Heikki Tuuri wrote:
You should upgrade to 4.1.9. That version commits ALTER TABLE at every 10
000 rows, and a runaway rollback can no longer happen.
This is very nice!
Are there any plans for the same with INSERT ... SELECT -type statements?
--
MySQL General Mailing List
Tobias,
- Alkuperäinen viesti -
Lähettäjä: Tobias Asplund [EMAIL PROTECTED]
Vastaanottaja: Heikki Tuuri [EMAIL PROTECTED]
Kopio: mysql@lists.mysql.com
Lähetetty: Tuesday, February 08, 2005 7:46 PM
Aihe: Re: InnoDB crash and runaway rollback - help pls
On Tue, 8 Feb 2005, Heikki Tuuri
, I restarted mysqld, which of
course caused a rollback of the alter table. The roll back is progressing at about 1% every 12
minutes, which equates to about 20hrs before the server can be back up - not a good thing. Reading
through the mysql documentation, we found this...
http://dev.mysql.com
in such a way that
they need not rollback (only do so if the whole system stops).
One way that comes to my mind is to accumulate all data in some
temporary table, using some other value as ID (or in application
variables), and only after the final yes, do it confirmation transfer
them to the true tables
Andre,
I would recommend a table for recovering id's that are lost due to rollback.
Before you actually rollback, take the generated ID and push it into this
table. Then change the way you acquire id's on insert. You will want to
check to see if this table has an ID before you auto_increment
Hi List,
I have a field in one of my tables that uses auto-increment from MySQL
4.1.8-nt (Windows XP).
My problem is to get the last insert ID when the insert fails and I use
rollback. The MySQL is still incrementing the field. How can I avoid this if
it is possible? I am trying to avoid to use
that uses auto-increment from MySQL
4.1.8-nt (Windows XP).
My problem is to get the last insert ID when the insert fails and I use
rollback. The MySQL is still incrementing the field. How can I avoid this if
it is possible? I am trying to avoid to use the function MAX() to get the
last ID
the last insert ID when the insert fails and I use
rollback. The MySQL is still incrementing the field. How can I avoid this if
it is possible? I am trying to avoid to use the function MAX() to get the
last ID inserted.
Thanks for any help.
Andre
--
Andre Matos
[EMAIL PROTECTED
Matos
[EMAIL PROTECTED] wrote:
Hi List,
I have a field in one of my tables that uses auto-increment from MySQL
4.1.8-nt (Windows XP).
My problem is to get the last insert ID when the insert fails and I use
rollback. The MySQL is still incrementing the field. How can I
avoid
XP).
My problem is to get the last insert ID when the insert fails and I use
rollback. The MySQL is still incrementing the field. How can I
avoid this if
it is possible? I am trying to avoid to use the function MAX() to get the
last ID inserted.
Thanks for any help.
Andre
different tables to different table spaces?.
Actually if we set autocommit=0, we are able to do the perform rollback
and commit and is working as expected in different sessions. I think
rollback segments are creating internally. Is there any facility to
mention the rollback segment size?. Shall we
Lakshmi,
- Original Message -
From: [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Thursday, November 18, 2004 1:07 PM
Subject: Reg Table spaces and Rollback segments in MySQL 4.0.21
Hi ALL,
We are using MySQL 4.0.21 with InnoDB. For creating the
tablespace mentioned
;
At this point I'd like to say, in sql,
if no errors then
commit;
else
rollback
end
From what I read in the manual I can do one or the other (commit or
rollback) but there didn't seem to be a way of conditionally doing one
or the other of them.
Thanks in advance
I'm relatively new to all of this but just about
finished setting up a transaction myself.
I'm doing something like this:
this is in php:( i also have functions set up for
begin, rollback and committ.
You should also set autocommitt to 0 .
Hope this helps!
Stuart
function run_query($sql
Colm G. Connolly wrote:
Hi all,
I'm working with tables stored by the InnoDB engine and would like to
be able to commit only if there are no errors generated by a group of
statements like this.
/* -*- sql -*- */
SET AUTOCOMMIT=0;
use db1;
begin work;
If you specify Begin or Start Transaction, set
statement 2;
.
.
.
sql statement n;
At this point I'd like to say, in sql,
if no errors then
commit;
else
rollback
end
From what I read in the manual I can do one or the other (commit or
rollback) but there didn't seem to be a way of conditionally doing one
or the other of them.
That's correct
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
Does it make sense to use a transaction just for the row locking properties,
and then not needing to error check?
I have a situation where I have seperate files that are being run very often
in realtime by many different users. One is calling a list of 12 football
players. The other is updating
Possibly veering off topic, but I have a strong urge to comment on this,
and
shall!
I am a M$ .NET developer (primarily ASP.NET with SQL Server), and have
recently embarked on a project at home, and wished to apply the same sort
of
principles that I use at work - for example, keeping all
(most common) and
BDB table types. MyISAM doesn't.
Hope that helps.
Matt
- Original Message -
From: Laphan
Sent: Thursday, March 18, 2004 5:19 PM
Subject: Stored Procs and Commit/Rollback Transactions
Hi All
OK I admit it I'm a complete MSV (MySQL Virgin), so I might be asking
and Commit/Rollback Transactions
Hi Laphan,
(I'm sending this to the general list too, since this isn't Windows
specific and more people will see it.)
MySQL 5.0, which is an early Alpha, does now support stored procedures.
http://www.mysql.com/doc/en/Stored_Procedures.html
And MySQL also
I just had a script fail unexpectedly and now I've got a couple
hundred thousand undo entries rolling back. Yes, I realize that
I should be committing smaller groups--my bad.
I was really hoping to restart my server tonight to change some
server parameters, but a rollback like this will take
Hi,
I posted this question in MySQL mailing list and got no reply.
The basic problem is that I have committed the transaction and then
replicated to another DB. Now I want to rollback the committed transaction.
Is there a way to rollback to a particular point. This requirement is very
]
Subject: Rollback
Hi,
I posted this question in MySQL mailing list and got no reply.
The basic problem is that I have committed the transaction and then
replicated to another DB. Now I want to rollback the committed transaction.
Is there a way to rollback to a particular point
PROTECTED]
Sent: Friday, January 02, 2004 1:33 PM
Subject: RE: Rollback
I'm fairly sure there is *no* way to do it. COMMIT says 'I want this data
in
the database' not 'I think I want this data in the database'
Chris
-Original Message-
From: karthikeyan.balasubramanian
[mailto:[EMAIL
Am Fr, den 02.01.2004 schrieb karthikeyan.balasubramanian um 09:28:
Is there any alternative way to get back to the old state of the database?
The only way I can think of is to dump the respective tables (e.g. every
night) and re-import them when needed.
Note that this can't be done by mysql
.
The basic problem is that I have committed the transaction and then
replicated to another DB. Now I want to rollback the committed
transaction.
Is there a way to rollback to a particular point. This requirement is
very
similar to rolling back using save points. I guess an option would
I run update on the database which by my mistake updated all rows. Is it
possible somehow go back to previous state before the update?
_
Have fun customizing MSN Messenger learn how here!
Hello everybody.
I have a clarification/solution to request. I am currently in the
process of designing a web application with JBoss 3.2.2 and MySQL 4.0.16.
The application is a data centric application with huge list of products
(tens of thousands). Sets of products are grouped into
: mailing.database.myodbc
Sent: Monday, December 22, 2003 7:37 PM
Subject: Replication Rollback
Hello everybody.
I have a clarification/solution to request. I am currently in the
process of designing a web application with JBoss 3.2.2 and MySQL 4.0.16.
The application is a data centric application
which also backs up MyISAM
tables
Order MySQL technical support from https://order.mysql.com/
- Original Message -
From: [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Friday, December 19, 2003 6:30 PM
Subject: Database rollback doesn't work
Hi!
I have a simple webapp
Hi Heikki,
The basic problem is that I have committed the transaction and then
replicated to another DB. Now I want to rollback the committed transaction.
Is there a way to rollback to a particular point. This requirement is very
similar to rolling back using save points. I guess an option would
Hi!
I have a simple webapp that allows users to register. The user is inserted
in the DB and a confirmation mail is sent to the user.
If the mail fails I'd like the DB to rollback the transaction, but it
doesn't do it. The new user entry is kept in the DB.
I'm using Tomcat 4.1 and mySQL 2.3.2.
I
Subject: Re: rollback error
Fernando [EMAIL PROTECTED] wrote:
In version 3.23.57 when i do a rollback i get this error message and the
changes are not undone, why?
This is what i typed: (NOTE: 'insert.sql' insert a row correctly in an
InnoDB table)
mysql SET AUTOCOMMIT=0;
Query OK, 0
questions. I had the honour to
review one of those preprints, all I can say so far is Very impressive,
you will see for yourself..
On Friday 14 November 2003 00:58, nm wrote:
Do you know how to test a crash and a rollback?
--
kind regards
Nils Valentin
Tokyo/Japan
http://www.be-known
Fernando [EMAIL PROTECTED] wrote:
In version 3.23.57 when i do a rollback i get this error message and the changes are
not undone, why?
This is what i typed: (NOTE: 'insert.sql' insert a row correctly in an InnoDB table)
mysql SET AUTOCOMMIT=0;
Query OK, 0 rows affected (0.00 sec
Do you know how to test a crash and a rollback?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
Do you know how to test a crash and a rollback?
You mean a client app crashing on you?
How about disabling/unplugging the network?
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL MS SQL
Server.
Upscene Productions
http://www.upscene.com
to
review one of those preprints, all I can say so far is Very impressive, you
will see for yourself..
On Friday 14 November 2003 00:58, nm wrote:
Do you know how to test a crash and a rollback?
--
kind regards
Nils Valentin
Tokyo/Japan
http://www.be-known-online.com/mysql/
--
MySQL General
Hi
In version 3.23.57 when i do a rollback i get this error message and the changes are
not undone, why?
This is what i typed: (NOTE: 'insert.sql' insert a row correctly in an InnoDB table)
mysql SET AUTOCOMMIT=0;
Query OK, 0 rows affected (0.00 sec)
mysql BEGIN;
Query OK, 0 rows affected
Fareeda,
- Original Message -
From: fareeda [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Thursday, September 25, 2003 5:32 PM
Subject: Question on rollback segment equivalent
What is the equivalent of rollback segments (from Oracle) on MySQL?
And if something is being
Bill,
- Original Message -
From: Bill Todd [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Tuesday, September 09, 2003 4:27 AM
Subject: Do InnoDB rollback segments expand dynamically?
Using InnoDB with an autoextend tablespace, if I start a transaction that
results
: Heikki Tuuri [mailto:[EMAIL PROTECTED]
Sent: Monday, September 08, 2003 10:44 PM
To: [EMAIL PROTECTED]
Subject: Re: Do InnoDB rollback segments expand dynamically?
Bill,
- Original Message -
From: Bill Todd [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Tuesday
At 12:43 AM 9/9/2003, you wrote:
Bill,
- Original Message -
From: Bill Todd [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Tuesday, September 09, 2003 4:27 AM
Subject: Do InnoDB rollback segments expand dynamically?
Using InnoDB with an autoextend tablespace, if I start
Using InnoDB with an autoextend tablespace, if I start a transaction that
results in many record versions, will the rollback segments grow dynamically
and force the tablespace to grow dynamically to provide the required room
for record versions in the rollback segments?
Bill
--
MySQL General
Chris,
please send your messages to [EMAIL PROTECTED] The newsgroup
mailing.database.mysql is only a mirror.
- Original Message -
From: Chris [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Tuesday, September 02, 2003 9:31 PM
Subject: lock in share mode/rollback question
Susan,
you had posted your message to the newsgroup mailing.database.mysql. That is
only a mirror of the mailing list [EMAIL PROTECTED], where you should
send your postings for them to be readable for all.
InnoDB has a data structure which is equivalent to the 'rollback segment' of
Oracle
Bruce,
- Original Message -
From: bruce [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Sunday, July 13, 2003 11:32 PM
Subject: MySql Rollback in PHP within a website
Hey...
I have a question. I need to be able to try to perform a database update,
but if it doesn't
Hey...
I have a question. I need to be able to try to perform a database update,
but if it doesn't succeed, I need to be able to rollback the changes, and to
inform the user that the changes didn't succeed.
I've looked at the MySql site, and can see somewhat how the Commit/RollBack
functions
-Original Message-
From: Mark [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 27, 2003 11:14 PM
To: [EMAIL PROTECTED]
Subject: rollback a table?
Hi,
Something bad happened the other day, a query hosed all the data in
my table, but luckily I had an original dump of the table from 4
Hi,
Something bad happened the other day, a query hosed all the data in
my table, but luckily I had an original dump of the table from 4
months ago and binlogs from then on. I had to load the original table
into a separate db and then grep through the binlogs for queries to
update it with,
1 - 100 of 133 matches
Mail list logo