David T. Ashley wrote:
I'm sending this again, because the server seems to have been down for
several hours, and I'm not sure if it went out.
Yes, I've been getting messages from yesterday, too. But I did get both
of your messages. I don't know what's up.
I'd like to do full text search on some fields of some tables, but I'm a
bit
confused by the documentation. Questions:
a)How do I set that up (i.e. do I need to use a specific storage engine for
a table)?
Yes, MyISAM only.
b)What storage engine(s) are required?
c)Are there any restrictions on "mixing and matching" tables that use
different storage engines in the same database?
d)Do table locking and transactions work the same (for example, some of the
storage engines are described as "not transaction safe"--unclear what this
means)?
Since it only applies to MyISAM, you have no transactions, and you get
table-level locks.
See http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html for more
details.
cheers
Baron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
