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 parameters

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 a

Re: Transaction for MySQL

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

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 q

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

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 b

Re: Transaction for MySQL

2001-07-18 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 -