List:General Discussion« Previous MessageNext Message »
From:Pooly Date:September 29 2005 4:59pm
Subject:Re: MyISAM to InnoDB
View as plain text  
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/
Thread
MyISAM to InnoDBJeff22 Sep
  • Re: MyISAM to InnoDBBruce Dembecki22 Sep
RE: MyISAM to InnoDBJeff22 Sep
  • Re: MyISAM to InnoDBBruce Dembecki22 Sep
  • Re: MyISAM to InnoDBDevananda22 Sep
RE: MyISAM to InnoDBJeff22 Sep
  • Re: MyISAM to InnoDBDevananda23 Sep
    • RE: MyISAM to InnoDBJeff23 Sep
      • RE: MyISAM to InnoDBSGreen23 Sep
        • RE: MyISAM to InnoDBJeff23 Sep
          • RE: MyISAM to InnoDBSGreen23 Sep
            • RE: MyISAM to InnoDBJeff23 Sep
              • RE: MyISAM to InnoDBSGreen23 Sep
              • Re: MyISAM to InnoDBDevananda23 Sep
            • RE: MyISAM to InnoDBJeff28 Sep
              • Re: MyISAM to InnoDBDevananda28 Sep
            • Re: MyISAM to InnoDBPooly29 Sep
RE: MyISAM to InnoDBSujay Koduri28 Sep
RE: MyISAM to InnoDBJeff28 Sep
RE: MyISAM to InnoDBSujay Koduri28 Sep
RE: MyISAM to InnoDBJeff28 Sep
RE: MyISAM to InnoDBJeff28 Sep
  • RE: MyISAM to InnoDBSGreen28 Sep
  • Re: MyISAM to InnoDBDevananda29 Sep
    • Re: MyISAM to InnoDBBruce Dembecki29 Sep
RE: MyISAM to InnoDBJeff29 Sep
  • RE: MyISAM to InnoDBSGreen29 Sep
  • Re: MyISAM to InnoDBDevananda29 Sep
RE: MyISAM to InnoDBJeff McKeon29 Sep
RE: MyISAM to InnoDBJeff29 Sep