Hi Jeremy,
Thank you for your valuable info.
However, may be you can fill me with some more detail here....
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 then I'd
call "mysqld-max --install" to establish the max version of sqld which
supports the BDB and InnoDB.
This, then, leads to question 3), if I switch the daemon as mentioned in
2) then would the tables created under "mysqld-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 PROTECTED]>
Sent: Saturday, July 21, 2001 2:57 AM
Subject: Re: Transaction for MySQL
> 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 questions regarding the issue:
> >
> > 1) which one should I use InnoDB or BDB? what kind of advantages
> > given by each type?
>
> BDB tables have been around in MySQL longer. They provide page-level
> locking.
>
> InnoDB tables are newer but have row-level locking and are faster than
> BDB tables.
>
> > 2) currently, I am using the default type - MyISAM, where I am
> > running MySqld-nt. If I would like to switch to another table type.
> > Do I just uninstall the service of MySqld-nt from win2000 and
> > install MySqld-Max service??
>
> Hard to know. I've never installed or uninstalled MySQL on Windows.
> Does the uninstall remove the data files?
>
> > 3 what would happen to my existing MyISAM type tables which already
> > exists in MySQL if I do the switch over? and would I able to
> > use/create MyISAM type table uder MySqld-Max??
>
> You can convert any MyISAM tables to InnoDB that you'd like. It's
> just a matter of:
>
> ALTER TABLE <mytable> TYPE = InnoDB;
>
> for each one of them. Or you can use the mysql_convert_table_format
> script that comes with MySQL.
>
> Jeremy
> --
> Jeremy D. Zawodny, <[EMAIL PROTECTED]>
> Technical Yahoo - Yahoo Finance
> Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 <-- NEW
>
> MySQL 3.23.29: up 35 days, processed 269,914,242 queries (89/sec. avg)
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
