Hi,
2005/9/23, SGreen@stripped <SGreen@stripped>:
> "Jeff" <jsmforum@stripped> wrote on 09/23/2005 09:57:06 AM:
>
>
> Yes, I meant exactly that. Within each MySQL server is a "special"
> database called `mysql`. That is the database that contains the tables of
> all of the user login and permission information for the server (and
> several other important bits of system-wide metadata). None of the tables
> in that database can be converted to InnoDB. That would be a "bad thing".
>
> The tables of every OTHER database on the server (including yours) are
> eligible for InnoDB conversion so long as you do not want to use fulltext
> searching. If you need a FT index, you have to keep that table as MyISAM
> for now (they are working on enabling FT indexes in InnoDB but there is no
> release date yet)
>
And GIS as well, IIRC:
http://dev.mysql.com/doc/mysql/en/spatial-extensions-in-mysql.html
(just to be picky)
--
Pooly
Webzine Rock : http://www.w-fenec.org/