MySQL Forums
Forum List  »  General

InnoDB Transaction,Commit,Rollback
Posted by: Plutarco Gonzalez
Date: October 08, 2004 11:35AM

Hi Everybody,

I have a application with invoice and invoice_items, but i need used transaction to save records.

If only user save data this fine. But if two users save data same time, one users save correctly and another user go to rollback directly, if second user save data again this ok.

InnodBd Documentation have a timeOut transaction = 50 Secs.
But, the application save all records in about 2 secs.

The sintax is the next:

Insert, update, deletion records
Showmessage('Table busy');

¿ InnoDB transaction must be wait to another transaction ?
¿ What is wrong?

InnodB start up options = = = =

innodb_data_file_path = ibdata1:10M:autoextend
innodb_buffer_pool_size = 256M
innodb_additional_mem_pool_size = 20M
innodb_log_file_size = 64M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 120

- Settings -
Netware 6.0 SP5 (HD:70 GB/RAM:768 MB) Mysql 4.0.21 and InnoDB Tables
Borland Delphi 6.0 with MySQLDAC.

Any comments are Welcome,

Thx and regards

Plutarco G.

Options: ReplyQuote

Written By
InnoDB Transaction,Commit,Rollback
October 08, 2004 11:35AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.