Hi! >>>>> "Wynne" == Wynne Crisman <[EMAIL PROTECTED]> writes:
Wynne> I am trying to determine what would cause my needing to rebuild an Wynne> MyISAM table in MySQL 4.0.x? You should not have to rebuild any tables just to upgrade to MySQL 4.0 from 3.23. The MyISAM format has not changed in any way between releases. Wynne> I also would like to know how I can minimize the time necessary to get Wynne> the MyISAM table up and running under MySQL 4.0.x? zero time for tables without fulltext. Some time for tables with fulltext indexes. Wynne> I have read the http://www.mysql.com/newsletter/2002-12/a0000000091.html Wynne> document which states that tables with lots of data can be difficult to Wynne> rebuild and would be better served using InnoDB, but InnoDB does not Wynne> support fulltext searches. I don't know of any problems in rebuilding an MyISAM table: Just do: OPTIMIZE TABLE table_name; or ALTER TABLE table_name type=myisam; It's true that MySQL 4.0 has better fulltext capabilities and to get these activated for a table you need to rebuild the tables that has fulltext support. The old tables will however work as before even if you don't rebuild them (but in this case you will probably not be able to use boolan search on them until you have rebuilt them). Note that fulltext rebuilds are MUCH faster in 4.0 so it should not take long to do the rebuilds. Wynne> Thank you for any assistence, Wynne> Wynne Crisman Wynne> patternWare Systems, Inc. Regards, Monty -- MySQL 2003 Users Conference -> http://www.mysql.com/events/uc2003/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
