Ahh yes, but I canceled it before all the tables/databases were checked. But I guess, you're saying, it'll "work" but, I might get bad results. How when you mean certain queries, is there like some type? scans? or the ones that key off that index? or a subset of them?
Thanks! On Feb 16, 2008 9:09 PM, Paul DuBois <[EMAIL PROTECTED]> wrote: > At 9:01 PM -0600 2/16/08, Hayden Livingston wrote: > >We're trying to upgrade from 4.1.20 to 5.0.54. The problem is running > >mysql_upgrade. It's turning out to be that about 70% of our tables > >(over 800GB) are being needing repair. > > > >The question is, will it be possible to "get by" without upgrading? > >Eventually we'll get to it, but will data be served from these tables > >if we don't? A lot of our tables DO have TEXT indexes, which > >apparently have gone under some padding related incompatible changes, > >what does this really mean, these tables can't be read or they will be > >inefficient? > > The server should be able to read them (if it couldn't, mysql_upgrade, > which uses mysqlcheck, a client, couldn't tell the server to repair > them!). But until those TEXT indexes are rebuilt, you might get > incorrect results for some queries. > > -- > Paul DuBois, MySQL Documentation Team > Madison, Wisconsin, USA > MySQL AB, www.mysql.com > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
