Re: transaction in mysql 5

2006-10-31 Thread George-Cristian Bîrzan
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

Re: transaction with MySQL

2002-04-17 Thread Heikki Tuuri
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

RE: transaction with MySQL

2002-04-17 Thread Craig Vincent
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,

RE: transaction with MySQL

2002-04-17 Thread Roger Baklund
* 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 --

Re: Transaction for MySQL

2001-07-22 Thread Heikki Tuuri
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

Re: Transaction for MySQL

2001-07-21 Thread Jeremy Zawodny
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

Re: Transaction for MySQL

2001-07-21 Thread Michael Tam
-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

Re: Transaction for MySQL

2001-07-21 Thread Jeremy Zawodny
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

Re: Transaction for MySQL

2001-07-19 Thread Michael Tam
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

Re: Transaction for MySQL

2001-07-19 Thread alec . cawley
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,

Re: Transaction for MySQL

2001-07-19 Thread Ilya Martynov
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