Re: InnoDB + fulltext + search + support
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
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
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