Re: InnoDB + fulltext + search + support

2002-11-18 Thread Paul DuBois
At 10:10 +0200 11/15/02, [EMAIL PROTECTED] wrote:

Hi all,

I'm working on design step for a new application and I'm interested about
fulltext indexes. I need a safe transaction tables also.


Does Mysql support this or is a feature?

In need a SOLUTION for a fulltext search on the InnoDB table.

Advices or alternative solutions on this topic are welcome.


P.S. I have to take this decision very fast.
Because I don't have time to search the mail list for this decision I need
quick and short well explanation.



FULLTEXT is supported for MyISAM tables only.

MyISAM tables are not transaction-safe.


-
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




InnoDB + fulltext + search + support

2002-11-15 Thread r . moldovan

Hi all,

I'm working on design step for a new application and I'm interested about
fulltext indexes. I need a safe transaction tables also.


Does Mysql support this or is a feature?

In need a SOLUTION for a fulltext search on the InnoDB table.

Advices or alternative solutions on this topic are welcome.


P.S. I have to take this decision very fast.
Because I don't have time to search the mail list for this decision I need
quick and short well explanation.

Thanx a lot

Have a good day







-
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




Re: InnoDB + fulltext + search + support

2002-11-15 Thread Vince LaMonica
On Fri, 15 Nov 2002 [EMAIL PROTECTED] wrote:

} P.S. I have to take this decision very fast.
} Because I don't have time to search the mail list for this decision I need
} quick and short well explanation.

You might want to check the MySQL documentation on transactions:

http://www.mysql.com/doc/en/ANSI_diff_Transactions.html

It's a well written explanation on how MySQL deals with transactions. For 
a more detailed look, check out:

http://www.mysql.com/doc/en/InnoDB_transaction_model.html

HTH,

/vjl/

-- 
Vince LaMonica   UC Irvine,  School  of  Social Ecology
 W3 Developer   *  116 Social Ecology I, Irvine, CA 92697
 [EMAIL PROTECTED]  http://www.seweb.uci.edu/techsupport

  Negotiations and love songs are often mistaken
for one and the same.  - Paul Simon


-
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